Excel Advanced training course
Excel Advanced Training Course
Table of Contents
Excel Advanced Course Overview
Our Microsoft Excel Advanced training course is aimed at experienced Excel users wishing to further their Excel skills. Majoring on Pivot Tables, advanced formulas and recorded macros we explore Excel’s great productivity features like Power Query, Power Pivot and Dynamic Array functions.
Delegates will leave feeling a new confidence in their Excel experience and ready to take on new challenges using their data.
Five Excel Advanced Key Topics
- Advanced formulas
- Dynamic Array functions
- Power Query
- Power Pivot
- Recording Macros
Excel Advanced Course Details
Course Duration : 1 day
Course Availability : Monday – Saturday
Course Types : Group booking, 1-2-1 sessions, Bespoke & Public Courses
Training Times : Our courses run run from 09:30 to16:30, course registration 09:00 – 09:30, refreshments available throughout the day. A buffet lunch is available – please discuss with the team.
Facilities : A relaxed environment, air conditioned training rooms, note pads, pens and unlimited access to our online course materials.
Excel Advanced Training Course Details
Course Location : Face to face group / public & onsite training available. Virtual training courses available.
Class Size : As a guide we recommend class sizes to be no more than eight.
Virtual / Online training Format : Teams or Zoom.
Tailored Course Content : Our advanced Excel courses can be tailored to your requirements – Get In Touch
Tailored Courses : We offer a free consultancy service to help tailor the course to meet your requirements.
Centre and Services
Comfortable & modern facilities
Unlimited access to our online training manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft & CPD courses available
Our Trainers
Steve, one of our lead Excel trainers, has over 25 years of delivering Excel from basics to development levels. All our trainers are encouraged to become Microsoft Accredited within their first year of working at Mouse Training.
Our instructors are very approachable, making the driest subject matter fun.
Advanced Excel Course Video
On Completion of Excel Advanced
- Advanced formulas
- Dynamic Array functions
- Perform What If Analysis
- Protect Excel documents
- Analyse worksheet data with Pivot Tables
- Use Power Query to manage your data flow
- Use Power Pivot to analyse data from different sources
- Record macros
Excel Advanced training Course Outline
- Using the LET function to avoid repetition
- Handling errors in formulas
- Powerful worksheet functions that are often ignored: OFFSET and AGGREGATE
- Using SUMPRODUCT to calculate weighted averages and summaries with multiple criteria
- Creating complex multiple criteria for the FILTER function
- Manipulating arrays with CHOOSEROWS and CHOOSECOLS
- Using XLOOKUP to return multiple values and intersections
- VSTACK and HSTACK to append data
- TAKE and DROP to extract data
- Goal Seek
- Solver
- Creating Scenarios and using the Scenario Manager
- Protecting ranges and worksheets
- Workbook protection
- Using Tables as source data
- Creating Pivot Table reports
- Refreshing data
- Formatting Pivot tables
- Pivot Table calculations, Summarize By and Show Values As
- Grouping Data
- Using Timelines and Slicers
- Cleaning and manipulating data
- Append Queries to automate data gathering
- Merge Queries to combine and cross-match data
- Unpivot data into flat files
- The Data Model
- Creating table relationships
- Power Pivot calculations (Measures)
- Macro security settings
- Recording and deleting macros
- Running macros
- Assign a macro to the QAT, ribbon or shortcut keys
- Recording relative and absolute cell selection
Is this Excel Advanced training course for You?
An understanding of Excel functions and database tools is advantageous for this advanced Excel course
Give us a call, our admin team will be delighted to assist in making sure you are on the correct course level.
Related Excel Advanced training course
