Assumes an basic knowledge of Microsoft Excel (i.e. the majority of the course above). Takes you to Microsft Excel advanced level. Express your preference for Excel 2000, XP, 2003 or 2007 (Vista) when booking your course.
Course Content:
Review of existing knowledge
Advanced charts and graphs (including formatting)
Advanced functions (including IF)
Sorting data and subtotals
Conditional formatting
Using Excel as a basic database
Importing data from different sources
Finding solutions using Goal Seek
Use scenarios to look at a model
Recording and run Macros, writing simple Macro functions
