MS Excel Advanced Course

by PCWorkshops

Excel Advanced is for Excel Experts: you work daily with Excel and your work revolves around spreadsheets and Excel databases. This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications.

$290

Contact the Institutes

Fill this form

Advertisement

PCWorkshops Logo

img Duration

1 Day

Course Details

Excel Advanced is for Excel Experts: you work daily with Excel and your work revolves around spreadsheets and Excel databases. This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications.

 

Content:

  • General
    • Editing Standard Formatting Rules
    • Input Validate rules
    • Using Formulas in Conditional Formatting
    • Group and Outline
    • Filter and Sorting
  • Excel Tables and Advanced Filter
    • Working with Excel tables
    • Copy specific datasets from sheets, workbooks or external data
  • Consilidate
  • Goal seek, consolidate and scenarios
  • Using Form Templates
    • Creating Templates
  • Advanced Excel Lookup Functions
    • VLookup Function
    • Hlookup Function
    • Using the Index Function, Using the Match Function, Index and Match Together
    • Using the Indirect Function
  • Excel Advanced Functions
    • Using Error, Logical, Array, Rounding Functions
  • Advanced Excel Pivot Table Tools
    • Importing Pivot Table Data,
    • Calculated Fields in Pivot Tables,
    • Showing Pivot Data as a Percentage,
    • Creating Custom Pivot Tables Styles
    • Pivot Charts
  • Excel Macros
    • Creating, amending and deleting macros
    • Running macros
    • Macro menus, toolbars and shortcuts
  • WC2N Branch

    Golden Cross House, 8 Duncannon Street, WC2N, London
  • M2 Branch

    53 Fountain Street, M2, Manchester
  • MK9 Branch

    Exchange House, 494 Midsummer Boulevard, MK9 , Milton Keynes
  • City Centre Branch

    One Victoria Square, City Centre, Birmingham
  • Cosham Branch

    Ground Floor, Building 1000, Lakeside North Harbour, Western Road, Cosham, Portsmouth

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy