Microsoft Excel Advanced

This course exposes many advanced features of Excel including protecting your workbooks and restricting data entry, building calculations using advanced functions and how to import, clean up, and analyse data sets.

1 day course
4.61  (1843 reviews)
What you will learn:
  • Build complex calculations with advanced functions
  • Link, export and consolidate data
  • Limit data entry using data validation and restrict changes by protecting workbooks and worksheets.
  • Analyse data with simple Tables, PivotTables and PivotCharts.
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Post Course Support
What you will learn:
  • Build complex calculations with advanced functions
  • Link, export and consolidate data
  • Limit data entry using data validation and restrict changes by protecting workbooks and worksheets.
  • Analyse data with simple Tables, PivotTables and PivotCharts.
What you'll get:
Courseware and Handouts
Live Recorded Session copy
Capped Class Sizes
e-Certificate
Post Course Support
Course prerequisites

Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Intermediate course.

In-Person Training

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

Online Training

Please ensure you have downloaded the latest version of the software Microsoft Excel Desktop for use within the session. We also require a working computer with a microphone and speaker installed, and an up-to-date web browser for this training. For the best experience, we recommend downloading the latest Google Chrome browser.

It is also recommended that you have a second screen attached to your computer.  This will allow you to watch the online training session and complete the course activities at the same time.

What's covered?
  • Workbook protection
  • Protecting cells
  • Protecting structure
  • Defining range names
  • Using names in formulas
  • Navigating with names
  • Documenting range names
  • Limiting cell values
  • Creating drop-down cell lists
  • Validation error messages
  • The IF function
  • Nested IF functions
  • The IFS Function
  • The AND function
  • The OR function
  • Concatenation
  •  Text functions
  • VLOOKUP function
  • The IFERROR function
  • Workbook linking
  • Dealing with broken links
  • Creating a table from a list
  • Naming a table
  • Auto expanding a table
  • Formatting a table
  • The totals row
  • Create PivotTable from table
  • Formulas in tables
  • Referring to tables in external formulas
  • Create a PivotTable
  • Rearrange data
  • Applying filters
  • Adding fields
  • Modify field settings
  • Refreshing data
  • Formatting a PivotTable
  • Creating a PivotChart
  • Filtering a PivotChart
    Reset options
- +

Need your training approved? Get a quote

Need your training approved? Get a quote
4.61
4.61
from 1843 reviews
5/5
“Loved that Jane went off book to show us functions that may help us”
Anita, Mar 2021
5/5
“Michael is engaging and very knowledgeable. ”
Kristina, Aug 2020
4/5
“Course was very good.”
Karyn, Aug 2020
5/5
“Opened my eyes to a lot of new things.”
Kim, Aug 2020