Need to squeeze the most out of Excel? The Advanced level takes you through some of Excel's less well known areas, as well as the development of more complex formulas using real life problems. Along the way you'll also learn how to record and edit simple macros, use the new and very cool conditional formatting in 2007/2010, and dig deeper into data management and analysis.
Who is this for?
Aimed at those who want to progress from the Intermediate level of Excel use, this course focuses on problem solving using Excel features and formulas. Any skill gaps (for example where the Intermediate course has not been undertaken) will be covered.
What does it cover?
The course initially focuses on more complex formula construction, typically using more complex logic formulas, the CountIf and SumIf and associated functions, an introduction to macro programming, databases and data analysis.
How long is it?
1 day or can be split into several sessions if required
Where is it run?
On your premises or via one of the training centres I use
Using named ranges with formula
Logic in depth – nesting the IF() function
Using the new SUMIFS, AVERAGEIFS & COUNTIFS[1]
Conditional formatting
Creating and manipulating a database
Using AutoFilter & Advanced Filtering
Using the data functions
Using cell notes
Customising charts
Creating Subtotals
Pivot Tables
Recording & running macros
Simple editing of macros
Assigning macros to toolbars