Excel Productivity Booster

by

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.

£100 +VAT

4 CPD hours

120 days’ access

Use ACPD101 for 10% off any purchase.

Excel Productivity Booster

£100 +VAT

4 CPD hours 120 days’ access
Use ACPD101 for 10% off any purchase.

Excel Productivity Booster

This course is not currently available. To find out more, please get in touch.

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.

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

Power tools

Power Query
PivotTables
Power BI

How it works

Author

Simon Hurst

Simon Hurst is a chartered accountant who has been involved in computer software for the accountancy profession for the past 30 years. He is the proprietor of The Knowledge Base, an organisation that provides IT training and consultancy to practising accountants. Simon has lectured on Excel and other Microsoft applications for organisations such as the ICAEW and the ACCA, and contributed to several significant spreadsheet-related ICAEW publications. He has also had a book published on the use of Excel for working with financial data.