Back
Responsive image

Microsoft Excel Adv | Training Course

Gain the confidence to tackle complex challenges and scenarios in Excel.
Learn time-saving hints and tips from professional Microsoft Excel experts.

SMALL COURSE SIZES | EXCEL EXPERTS | PROFESSIONAL TRAINING | LONDON LOCATION

  Course Dates Venue   Price  
London Bridge £299 + VAT
London Bridge £179 + VAT save £120
Online £199 + VAT save £100
London Bridge £199 + VAT save £100
Online £229 + VAT save £70
Online £249 + VAT save £50
London Bridge £249 + VAT save £50
Online £279 + VAT save £20
London Bridge £279 + VAT save £20
Online £299 + VAT
London Bridge £299 + VAT
Online £299 + VAT
London Bridge £299 + VAT
Online £299 + VAT
London Bridge £299 + VAT
Online £299 + VAT
London Bridge £299 + VAT
Online £299 + VAT
London Bridge £299 + VAT
Online £299 + VAT

Microsoft Excel Adv | Training Course

Course Takeaways
Course Info

Course Offering

Course Takeaways
Takeaways

What will I learn?

  • Expanded functions for advanced calculations
  • Minimise audit risk with data validation
  • Analyse data efficiently with Pivot Tables
  • What If Analysis with Goal Seek and Scenarios
  • Clever time saving techniques
  • Free digital course assets
  • Free post-course helpdesk support
Course Takeaways
Learner Reviews

How good is the course?

  • Average Score 4.8 out of 5
  • Delicious lunch provided
  • Certificate of Achievement
  • 538 reviews

Expanding your functions toolbox

• Using Nesting formulas

• Using AND & OR

• VLOOKUP

• IFERROR/IFNA

• INDEX & MATCH


Reducing your audit risk

• Data validation

• Using Trace Precedents

• Using Trace Dependents

• Removing Arrows

• Error checking

• Evaluate Formula


Effectively analysing your data

• Creating Pivot Tables

• Changing the look of your pivot

• Grouping your data

• Updating Pivot Tables with new data

• Filtering your data with a Slicer

• Linking slicers to more than one Pivot Table

• Using a timeline

• Creating a Pivot chart


Using What If Analysis

• Goal Seek

• Scenarios


Questions and answers


This course is also available as a private course. If you wish we can tailor the content for your team. Please contact us for more details.

You Might Like These Too

Microsoft Excel VBA

Price on quotation

2 day course
Harness the power of VBA to manage large and variable amounts of data.

Learn best practice for writing and editing VBA code and improve your data's usability.

  • Automate tasks with Macros
    Create custom functions and procedures
    Manipulate objects and properties
    Expressions, variables, and functions
    Working with forms and controls

Power BI Business Analytics

from £429 + VAT

2 day course
Learn to present and visualise data like a pro on this Power Bi course.

Master how to create interactive and visually appealing dashboards and reports.

  • Understand Power BI concepts and features
    Connect to various data sources easily
    Create visually appealing and interactive visuals
    Query and shape your data for analysis
    Generate comprehensive reports

Microsoft Powerpoint Intro

from £179 + VAT

1 day course
Quickly and easily create professional, engaging presentations using PowerPoint.

Learn tips and tricks from experts to make your presentations shine.

  • PowerPoint interface and navigation
    Layouts and slide design
    Making text look great
    Using images, charts and graphs
    Mastering transitions and animations


"Concise and effective coverage of content by knowledgeable tutor."
AEG Presents
14th January - Microsoft Excel : Advanced

Latest Reviews
Microsoft Excel : Advanced
"Explaining and breaking downt he advance skills on excel really clearly"
AEG Presents
  • 14th January
Microsoft Excel : Advanced
"Monica was very clear and explained everything we were going through. It was very useful having exercises then running through the solution rather than just being told how to do things. Really insightful course."
AEG Presents
  • 20th December
Microsoft Excel : Advanced
"There is a variety of amount of excel training that is covered and the is a template we can use in the future as reference too"
AEG PRESENTS
  • 20th December