Library

Course: Microsoft Excel - Advanced Training

Microsoft Excel - Advanced Training

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

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
Basic knowledge
  • You'll need Excel 2007, 2010, 2013 or 2016 installed and a desire to want to learn what Excel can really do for you!
What you will learn
  • 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
Curriculum
Lectures quantity: 22
Common duration: 03:06:54
Introduction to Excel Advanced
  • Introduction to Excel Advanced Outline  
Goal Seek
  • Using Goal Seek  
Scenarios
  • Scenarios  
Consolidate
  • Consolidate Data in a single Excel file  
  • Link data from multiple files  
Advanced Filtering
  • Advanced Filtering  
Working with Tables
  • Working with Tables - Part 1  
  • Working with Tables - Part 2  
  • Working with Tables - Bonus Tip  
Validation
  • Create a Drop Down List  
  • Validate Date Ranges  
Protection
  • Protect Sheet  
  • Protect Workbook  
  • Protect File  
Pivot Tables
  • Introduction to Pivot Tables  
  • Pivot Tables - Analysing Data  
  • PIvot Tables - Grouping  
  • Pivot Tables - Slicers  
  • Pivot Tables - Pivot Charts  
Macros
  • Introduction to Macros  
  • Recording Macros  
  • Recording Global Macros  
reviews (0)
Average rating
0
0 voices
Detailed rating
5 stars
0%
4 stars
0%
3 stars
0%
2 stars
0%
1 stars
0%