Excel productivity booster
This course concentrates on a range of practical and simple techniques that can make spreadsheets quicker to set up, easier for the user to use, more automated, and guard against career-threatening errors.
Partner products listed exclude VAT. You will be directed to an external site to complete purchase and VAT will be applied at checkout.
For your AAT exclusive discount apply AAT101 at partner checkout for an exclusive 10% off.
Course Type
E-learning
Length
3 - 5 hours
What you’ll achieve
- Boost your productivity when working in Excel
- Make use of new, exciting Excel features and rediscover features that can make your spreadsheets more accurate and efficient
- Create dashboards and graphs that your colleagues can interpret quickly and easily.
- Make your spreadsheets more automated
- Guard against career-threatening errors.
About this course
It's easy to find yourself using Excel the same way for years at a time. This course concentrates on a range of practical and simple techniques that can make spreadsheets quicker to set up, easier for the user to use, more automated, and guard against career-threatening errors.
Overview
E-learning |
|
3 - 5 hours |
|
Excel |
Syllabus
Firm foundations
- Design principles
- Templates
- Efficient formulas
- Protection
- Tables
- How functions work
- Function fundamentals
Automation
- Letting Excel do the work
- AND, OR, and NOT
- IFS, SWITCH, and XLOOKUP
- MOD
- SUMPRODUCT
- Dynamic arrays
- LET
- LAMBDA
Presentation
- Perfect number formats
- Number formats
- Styles
- Charting with impact
- In-cell charts
Power tools
Power Query
PivotTables
Power BI
How to access
You will be directed to an external site to complete purchase and VAT will be applied at checkout.