The course is for students who would like to learn various functions in Excel. This course enables them to utilize the advance features taught in this course in an office environment with maximum efficiency.
Request Information
topics covered
Create and Define a Simple Worksheet
1
Define worksheet/workbook Access / Navigate / Exit the Program
2
SUM function/AutoSUM button
3
Save/Save as/Name a file
4
Formulas
5
Formatting numbers and text with the toolbar
Develop the Worksheet
1
Plan a worksheet
2
Split worksheet/box/bar
3
Display/move toolbars
4
Row and Column labels
5
Enhance worksheet Appearance
Formulas and Macros Formulas
1
Use the Function Wizard
2
Nested functions
3
Relative, Absolute, Mixed cell references
4
Logical functions using IF, AND, OR, NOT
5
Date and time functions
6
Correcting circular references
7
Common functions (AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND,INT)
8
Name cells /ranges /constants
9
>, <, = operators
10
The LOOKUP function
11
Annotating formulas
Macros
1
Definition and use
2
Run a macro
3
Record a macro
4
Store a macro
5
Assign a macro
6
Use the Personal Macro Workbook
Menu
Global Skill Hub (Pvt) Limited.
Plot No. 33. Street No. 22, I&T Center, G-8/4 Islamabad Pakistan.