Microsoft Excel 2007 (Level 3)

Microsoft Excel Level 3 or Microsoft Excel ^Plus is designed to guide the user from using basic Excel to being able to use Excel at an advance (Level 3) level and includes the following:

 

Course Duration: 4 Day

Course Fee: R1865.00

 

Excel Screen and Layout

Excel Commands

Creating Spreadsheets

Creating Formulae

Creating and Using Functions

Copy, Pasting and Deleting Data

Sorting Data

Understanding Operator Precedence (Why Calculations do not work properly)

Troubleshooting Formulae

Using Relative and Absolute Cell References

Importing Data from other Documents

Linking Spreadsheets

Naming Cells

Conditional Formatting

Filtering a Spreadsheet

Using What if Scenario’s

Using Sub Totals

Creating Charts

Pivot Tables

Creating Macros

Using Templates

Testing and Validating Formulae

Protecting Spreadsheets

Viewing Spreadsheets

Header and Footers

Printing Spreadsheets