Microsoft Excel Course
Microsoft Excel Course Summary
1 – 3 days
Excel Course Summary
Spreadsheet concepts
Excel layout
Creating a worksheet
Entering and editing data
Moving and copying data
Creating formulae
Using functions
Absolute cell referencing
Formatting the worksheet
Printing and page setup
Date and IF functions
Worksheet management
Multiple worksheets and workbooks
Templates
Charts
Drawing shapes
Working with pictures
More Functions, validation and formatting
Outlining
Lookup Tables
Working with Lists
Using Databases
Pivot Tables and Pivot Charts
Analysis tools
Workbook management
Macros