Microsoft Excel

You Will Learn How To:

who should attend?

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