Expanding your functions toolbox
• Nesting formulas
• Using AND & OR
• VLOOKUP
• IFERROR/IFNA
• INDEX & MATCH
Reducing your audit risk
• Data validation
• Using Trace Precedents
• Using Trace Dependents
• Removing Arrows
• Error checking
• Evaluate Formula
Questions & answers
Effectively analysing your data
• Creating Pivot Tables
• Changing the look of your pivot
• Grouping your data
• Updating Pivot Tables with new data
• Filtering your data with a Slicer
• Linking slicers to more than one Pivot Table
• Using a timeline
• Creating a Pivot chart
What If Analysis
• Goal Seek
• Scenarios
Questions & answers
| Course Dates | Venue | Price | ||
|---|---|---|---|---|
| London Bridge | £129 + VAT save £170 | |||
| Online | £149 + VAT save £150 | |||
| London Bridge | £179 + VAT save £120 | |||
| Online | £199 + VAT save £100 | |||
| London Bridge | £229 + VAT save £70 | |||
| Online | £299 + VAT |
Tom works in Internal Communications for an NHS service provider. Listen to his experience about attending our online Adobe Premiere Intro course.
Meija works for the MOD, in marketing and communications and here tells us about attending her online Social Media Marketing course with Alice.
Katie works for the Ministry of Defence as a Digital Content Editor and here tells us about attending her online Social Media Marketing course with Kirsty.
"Kevin had a great tone of voice, which made him sound excited to be talking about Excel, and that helped make it interesting. We also had a good pace, moving fast so we learnt a lot in a short amount of time"
