Excel Productivity Booster
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.
SAVE 30% USING CODE ACPD30
This course will enable you to
- 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 the course
Accountants use Excel every day, but it can be easy to fall into a rut, using the same formulas and creating the same spreadsheets again and again.
This course concentrates on a range of practical, and often simple, techniques that can make spreadsheets quicker to set up, easier for the user to use, more automatic, and guard against career-threatening errors.
Look inside
Contents
- 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 it works
Reviews
Recommended | ||||
Why not upgrade?Find the best way to complete your CPD | CourseNeed just a few unitshourshours? | Pick n MixAll you need for this year's CPD. | LicenceAll you need for this year and more. | TeamKeep your whole team up to date. |
---|---|---|---|---|
Access to this course | ||||
Total CPD unitshourshours | 4 unitshourshours | 21 units20 hours21 hours | 800+ unitshourshours | 800+ unitshourshours |
Access period | 120 days | 120 days | 12 months | 12+ months |
Audit-proof CPD completion certificate | ||||
Immediate access to our entire CPD catalogue | ||||
Exclusive news and CPD every week plus monthly webinars, all year round | ||||
Account manager on hand to support your team’s needs | ||||
Learn more | Learn more | Learn more | ||
Why not upgrade?
Find the best way to complete your CPD
You might also like
Take a look at some of our bestselling courses
SAVE 30% USING CODE ACPD30