Excel Productivity Booster

by Simon Hurst

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.

price £75+vat
cpd hours 4 CPD hours
access 120 days' access

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

imac
slide-1
slide-2
slide-3
slide-4
slide-5
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

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

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.

Reviews

Recommended

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Pick n Mix

All you need for this year's CPD.

Licence

All you need for this year and more.

Team

Keep your whole team up to date.
Access to this course
Total CPD unitshourshours4 unitshourshours21 units20 hours21 hours800+ unitshourshours800+ unitshourshours
Access period120 days120 days12 months12+ 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 moreLearn moreLearn more
Recommended

Why not upgrade?

Find the best way to complete your CPD

Licence

All you need for this year and more.
Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 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

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?
Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
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

Why not upgrade?

Find the best way to complete your CPD

Pick n Mix

All you need for this year's CPD.
Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
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

Why not upgrade?

Find the best way to complete your CPD

Team

Keep your whole team up to date.
Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ 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

Why not upgrade?

Find the best way to complete your CPD

Licence

Recommended

All you need for this year and more.
Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 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

Course

Need just a few unitshourshours?
Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
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

Pick n Mix

All you need for this year's CPD.
Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
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

Team

Keep your whole team up to date.
Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ 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

You might also like

Take a look at some of our bestselling courses