BASIC $149.00
Introduction to Excel
Editing In A Workbook
Basic formulas
Copying options in Excel
Borders and shading
Formatting Rows And Columns
INTERMEDIATE $199.00
Pivot Tables
Working with formulas
Look up functions (Vlookup, index, indirect, address, match)
Conditions on formulas (If, or, and, if-error, sum if, count if)
Data sorting and analysing
Conditional Formatting
ADVANCED $249.00
How to record Macros
How to read and navigate Macros
Understanding VBA
VBA Editor tour
Command and coding Techniques
Using Variables in VBA