E-learning

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.

Special Price £90.00 Regular Price £100.00

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.

Excel productivity booster
E-learning

Excel productivity booster

3 - 5 hours

Special Price £90.00 Regular Price £100.00
Book Online