Learn to use Excel’s most powerful features.
This hands-on course includes plenty of time to try things out and ask questions.
By the time you finish, you’ll be an expert Excel user.
✔ A complete course that covers all of Excel’s most advanced functions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ Ongoing support & CPD certification.
CPD Accreditation
This course has been CPD certified by The CPD Standards Office.
This course qualifies for 11.5 hours of CPD training.
We issue all attendees who complete this course a full CPD certificate.
What Will I Learn?
By the end of this course you’ll be very comfortable using Excel’s most advanced features.
- Working with logical functions in Excel.
- Using the full range of Excel’s lookup and reference functions.
- Creating and editing PivotTables.
- Using the Data Consolidation feature to combine data from several workbooks.
- Using Solver to solve complex scenario problems.
- Creating macros to automate repetitive tasks in Excel.
Watch one of our trainers give a taster on what you’ll cover:
Download full course detailsNamed ranges and logical functions make your formulas easier to understand, manage and maintain.
- Creating, documenting and scoping defined names across workbooks and worksheets
- Using names in formulas, constants and ranges, and applying them to existing formulas
- Keeping your names organised with the Name Manager
- Using IF with text and numeric data, and nesting IF statements to handle multiple conditions
- Combining TRUE, FALSE, AND, OR and NOT for more powerful calculations, and handling errors with IFERROR
Data entered in the wrong format and lookups that don’t work are Excel’s most common problems.
We tackle both. First we control what goes into your spreadsheet, then we retrieve and summarise it reliably.
- Setting validation rules, input messages, error messages and drop-down lists to control data entry
- Using formulas as validation criteria and identifying invalid data
- Retrieving data with VLOOKUP, HLOOKUP, INDEX, MATCH and CHOOSE
- Using ROW, COLUMN, ADDRESS, INDIRECT, OFFSET and other reference functions
- Understanding which lookup and reference technique to use when
- Creating nested subtotals and using relative names to simplify subtotal analysis
PivotTables turn large datasets into clear summary reports.
Add scenarios and Solver and Excel becomes a tool for modelling and decision-making.
- Building PivotTables from source data, then filtering, formatting and reorganising them
- Adding calculated fields, calculated items, running totals and percentage calculations
- Using slicers and timeline filters to analyse large datasets interactively
- Consolidating data from multiple worksheets and workbooks into summary reports, whether linked or unlinked, with identical or differing layouts
- Creating, comparing and combining scenarios, and generating scenario summary reports
- Using Solver to define objectives, variables and constraints, then interpreting its reports
A lot of real-world Excel work involves importing data and repeating the same tasks.
This session covers both. It also shows you how to build worksheets other people can interact with.
- Building interactive worksheets with combo boxes, list boxes, scroll bars, check boxes and other form controls
- Managing control properties and protecting worksheets that contain controls
- Importing data from text files, earlier Excel versions and Microsoft Access, and managing data connections
- Exporting information to Microsoft Word and text-based formats
- Recording, running, viewing, editing and copying macros, and understanding macro security settings
- Assigning macros to the Quick Access Toolbar, Ribbon and keyboard shortcuts
Online Training Requirements
To attend this Excel course online, you will need:
✔ MS Excel on your Windows PC with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom
If you have access to a second screen, we would encourage you to use it as it improves the experience.
- Facebook: https://www.facebook.com/profile.php?id=100066814899655
- X (Twitter): https://twitter.com/AcuityTraining
- LinkedIn: https://www.linkedin.com/company/acuity-training/