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 | £149 + VAT save £150 | |||
| Online | £169 + VAT save £130 | |||
| London Bridge | £199 + VAT save £100 | |||
| Online | £199 + VAT save £100 | |||
| London Bridge | £229 + VAT save £70 | |||
| Online | £229 + VAT save £70 | |||
| London Bridge | £299 + VAT | |||
| Online | £299 + VAT | |||
| London Bridge | £299 + VAT | |||
| Online | £299 + VAT | |||
| London Bridge | £299 + VAT | |||
| Online | £299 + VAT | |||
| London Bridge | £299 + VAT | |||
| Online | £299 + VAT | |||
| London Bridge | £299 + VAT | |||
| 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.
"Answering Questions to all Excel Questions not just questions relevant to the course. Also answering questions on other systems which have Excel working behind the scenes such as Power BI"
