Excel Training Course

Table of Contents

Excel Advanced Training Courses, Microsoft Excel Advanced Training Course

Excel Course Overview

Our Microsoft Excel advanced training course are aimed at experienced Excel users wishing to further their Excel skills. Majoring on Pivot Tables and recorded macros we explore many other of Excel’s great productivity features like auditing, protecting and linking workbooks and What-If analysis.

Delegates will leave feeling a new confidence in their Excel experience and ready to take on challenges summarising data working with Excel advanced features such as Pivot Tables and Macros

Excel Advanced Training Courses, Microsoft Excel Advanced Training Course

Five Excel Key Topics

Use the formulas auditing tools to troubleshoot errors 
Summarise data using Pivot tables & Pivot Charts
Importing & exporting data into Excel
Linking Workbooks and worksheets
Working with Excel Macros

Excel Advanced Training Courses, Microsoft Excel Advanced Training Course

Excel Advanced Course Details

Course Duration: 1 day
Course Availability: Monday – Saturday
Course Types: Group booking, 1-2-1 sessions, Bespoke & Public Courses
Course Availability: Monday – Saturday

Excel Advanced Training Courses, Microsoft Excel Advanced Training Course

Course Location: This Microsoft Excel intermediate training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Tailored Courses: We offer a free consultant service to help tailor your course to meet your requirements.

Rate: £200 + VAT

Next Public Course: 24 January 2020 

Days
Hours
Minutes
Seconds

Back to Contents

Centre and Services

Comfortable & modern facilities
Unlimited access to out online trining manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft & CPD courses available

At Course Completion

Excel Advanced Course Outline

  • Audit a worksheet
  • Link worksheets and workbooks
  • Perform What if Analysis
  • Protect and Outline Excel documents
  • Collaborate with other Excel users
  • Import and Export Data
  • Filter and summarise worksheet data
  • Analyse worksheet data with Pivot Tables
  • Record macros
  • Tracing precedents and dependents
  • Tracing errors in the worksheet
  • Error checking
  • Watch window
  • Setting up related worksheets within a workbook
  • Entering a formula to link related worksheets and workbooks
  • Creating a workspace
  • Consolidate worksheets and workbooks
  • Goal seek
  • 1 way and 2 way Data Tables
  • Scenario Manager
  • Protecting worksheets and workbooks
  • Grouping and outlining a worksheet
  • Create a shared workbook
  • Tracking changes in a shared workbook
  • Responding to proposed changes and comments in a shared workbook
  • Working with version History 
  • Importing data from a text or web based file
  • Working with other applications such as Access
  • Get and Transform
  • Use the Quick analysis tool
  • Autofilter and advanced filter
  • Adding a criteria range with advanced filter
  • Database functions
  • Using subtotals and nested subtotals
  • One click forecasting
  • 3D Maps
  • Ink Equations
  • What is a Pivot Table?
  • Best practice on setting up Pivot Tables
  • Creating a Pivot Table
  • Resetting the summary function in a Pivot Table report
  • Grouping Pivot Table data
  • Search in the Pivot Table
  • Formatting a Pivot Table
  • Charting a Pivot Table
  • Printing the Pivot Table
  • Normalising Pivot Table data sources
  • Convert Ranges to Tables
  • Using other Microsoft data sources with Pivot Tables
  • Using Slicers and TimeLines to filter Pivot Table data
  • Power Pivot and Power View 
  • Macro guidelines
  • 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
  • Using AutoFill
  • Using absolute and relative references

Back to Contents

Related Excel Courses

 

What is Power Bi – Business intelligence like never before

Excel Advanced Training Courses in London, either held at your workplace or at our Excel training London centre or Nationwide.

 

Excel Advanced Training Courses, Microsoft Excel Advanced Training Course
Excel Advanced Training Courses, Microsoft Excel Advanced Training Course
Excel Advanced Training Courses, Microsoft Excel Advanced Training Course