Microsoft Excel - Advanced Training

Simpliv

Course

Online

£ 10 + VAT

The best Other Education courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

The Excel - Advanced Training session follows on from the Intermediate course, but now it's time to step up a gear from formulas and formatting and get into becoming an Advanced User. This course comprises of advanced tools such as Goal Seek, Scenarios, Advanced Filtering, Validating entries, Protection techniques, Pivot Tables and Macros. You'll be able to perform calculations for forecasting and predicting, generate reports from multiple sources and create structured, manageable Pivot Table reports for analysing big data sets. All the files used on the course are available to download and work alongside each video, or in your own time to try out yourself.  Who is the target audience?Anyone who wants to learn more than formulas and enhance their knowledge to become an Advanced user of Excel
Users should have a good understanding of the basics as this is not an introduction level course

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

You'll be able to learn the advanced tools and features from your desk from a Microsoft Trainer
Take your skills learnt to many different situations and roles
Pick up tips, techniques and shortcuts to make using Excel simple!
You'll learn great tools such as Consolidate, Advanced Filtering, Goal Seek for forecasting data, Pivot Tables, Protecting Sheets and Recording Macros

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • MS Excel
  • Microsoft excel training
  • Global
  • Microsoft Excel
  • Excel

Course programme

Introduction to Excel Advanced 1 lecture 01:58 Introduction to Excel Advanced Outline Introduction to Excel Advanced 1 lecture 01:58 Introduction to Excel Advanced Outline Introduction to Excel Advanced Outline Introduction to Excel Advanced Outline Introduction to Excel Advanced Outline Introduction to Excel Advanced Outline Goal Seek 1 lecture 07:16 Using Goal Seek Goal Seek 1 lecture 07:16 Using Goal Seek Using Goal Seek Using Goal Seek Using Goal Seek Using Goal Seek Scenarios 1 lecture 14:31 Scenarios Scenarios 1 lecture 14:31 Scenarios Scenarios Scenarios Scenarios Scenarios Consolidate 2 lectures 15:44 Consolidate Data in a single Excel file Link data from multiple files Consolidate 2 lectures 15:44 Consolidate Data in a single Excel file Link data from multiple files Consolidate Data in a single Excel file Consolidate Data in a single Excel file Consolidate Data in a single Excel file Consolidate Data in a single Excel file Link data from multiple files Link data from multiple files Link data from multiple files Link data from multiple files Advanced Filtering 1 lecture 14:08 Advanced Filtering Advanced Filtering 1 lecture 14:08 Advanced Filtering Advanced Filtering Advanced Filtering Advanced Filtering Advanced Filtering Working with Tables 3 lectures 26:44 Working with Tables - Part 1 Working with Tables - Part 2 Working with Tables - Bonus Tip Working with Tables 3 lectures 26:44 Working with Tables - Part 1 Working with Tables - Part 2 Working with Tables - Bonus Tip Working with Tables - Part 1 Working with Tables - Part 1 Working with Tables - Part 1 Working with Tables - Part 1 Working with Tables - Part 2 Working with Tables - Part 2 Working with Tables - Part 2 Working with Tables - Part 2 Working with Tables - Bonus Tip Working with Tables - Bonus Tip Working with Tables - Bonus Tip Working with Tables - Bonus Tip Validation 2 lectures 16:40 Create a Drop Down List Validate Date Ranges Validation 2 lectures 16:40 Create a Drop Down List Validate Date Ranges Create a Drop Down List Create a Drop Down List Create a Drop Down List Create a Drop Down List Validate Date Ranges Validate Date Ranges Validate Date Ranges Validate Date Ranges Protection 3 lectures 16:31 Protect Sheet Protect Workbook Protect File Protection 3 lectures 16:31 Protect Sheet Protect Workbook Protect File Protect Sheet Protect Sheet Protect Sheet Protect Sheet Protect Workbook Protect Workbook Protect Workbook Protect Workbook Protect File Protect File Protect File Protect File Pivot Tables 5 lectures 55:11 Introduction to Pivot Tables Pivot Tables - Analysing Data PIvot Tables - Grouping Pivot Tables - Slicers Pivot Tables - Pivot Charts Pivot Tables 5 lectures 55:11 Introduction to Pivot Tables Pivot Tables - Analysing Data PIvot Tables - Grouping Pivot Tables - Slicers Pivot Tables - Pivot Charts Introduction to Pivot Tables Introduction to Pivot Tables Introduction to Pivot Tables Introduction to Pivot Tables Pivot Tables - Analysing Data Pivot Tables - Analysing Data Pivot Tables - Analysing Data Pivot Tables - Analysing Data PIvot Tables - Grouping PIvot Tables - Grouping PIvot Tables - Grouping PIvot Tables - Grouping Pivot Tables - Slicers Pivot Tables - Slicers Pivot Tables - Slicers Pivot Tables - Slicers Pivot Tables - Pivot Charts Pivot Tables - Pivot Charts Pivot Tables - Pivot Charts Pivot Tables - Pivot Charts Macros 3 lectures 18:07 Introduction to Macros Recording Macros Recording Global Macros Macros 3 lectures 18:07 Introduction to Macros Recording Macros Recording Global Macros Introduction to Macros Introduction to Macros Introduction to Macros Introduction to Macros Recording Macros Recording Macros Recording Macros Recording Macros Recording Global Macros Recording Global Macros Recording Global Macros Recording Global Macros

Additional information

You'll need Excel 2007, 2010, 2013 or 2016 installed and a desire to want to learn what Excel can really do for you!

See related categories

Microsoft Excel - Advanced Training

£ 10 + VAT

The best Other Education courses

See all

See all