Microsoft Excel Advanced – Business Performance Advanced

  • Select Location
  • Online Live Classroom
Select a location then date
  • Select Date
Price (ex vat): £175

    PrintDURATION: 1 day
    TIME: 09:00 to 16:00 GMT

    We guarantee to improve your efficiency when dealing with company data. Many delegates have reported an average time saving of "60 minutes per day on average", or 5 hours per week. So a potential return on your investment well within 1 month.

    About Microsoft Excel Advanced – Business Performance Advanced

    Microsoft Excel Advanced Business Performance Workshop

    Time is one of your most valuable resources and the cost relating to the inefficient use of your time can be enormous. Excel is a widely used Microsoft App that many workers use on a regular basis, and can without training be a major Time waster.  During this Advanced Excel course you will learn techniques to significantly improve your efficiency when dealing with data. The course covers a wide range of useful business tools, techniques and formulas that will enable you to protect, control, analyse and manipulate company data. You don’t have to be an expert to attend this course, but you will find some of the topics easier to understand if you use Excel on a regular basis. The course is structured but informal, and you will be encouraged to ask and answer questions throughout.

    Is this course for you?

    If you use Excel on a regular basis and want to learn new time saving techniques but want to explore some of the more advanced features useful in a business environment then this course is suitable for you. Perfect for Managers, IT Support, Supervisors, Executives, Business owners and those who want to explore advanced techniques.

    Related courses

    You must also consider Microsoft PowerBI (Business Intelligence) as another data tool for your armoury. The PowerBI desktop app is free to download and is perfect to manage your company data. Contact us for more details.

    Training options

    Virtual classroom: £850+VAT for up to 8 delegates

    Classroom/on-site: £700+VAT for up to 4 delegates on the course

    Classroom/on-site: £895+VAT for up to 8 delegates on the course

    Live Virtual Classroom schedule

    Session 1: 09:00 to 10:00 [break 10:00 to 10:15]
    Session 2: 10:15 to 11:15 [break 11:15 to 11:30]
    Session 3: 11:30 to 12:30 [lunch 12:30 to 13:30]
    Session 4: 13:30 to 14:30 [break 14:30 to 14:45]
    Session 5: 14:45 to 15:45 [summarise and close 15:45 to 16:00]

    Course Includes

    • Course Handbook (PDF Handbook for virtual courses)
    • Post course training downloads
    • Certificate on completion (PDF certificate for virtual courses)
    • Post course support relating to course content

    Aim & Objectives


    To improve your business efficiency using a range of advanced Excel tools and techniques.

    Course Objectives

    By the end of this course you will be able to:
    • Employ Formula Auditing techniques to understand complex spreadsheets and search for errors
    • Use Formulas to quickly update, extract and join large sets of data
    • Use Validation and Protection techniques to control spreadsheets
    • Explore What IF Analysis tools to answer business questions
    • Analyse and explore data using powerful Pivot Tables and Slicers
    • Connect to or import data, Combine data, Transform and shape data, Load and complete data into a spreadsheet

    Course Content

    Formula Auditing (Test and understand your spreadsheets)

    Precedents and Dependents – Tracking all formula relationships on a worksheet – Evaluate Nested Formulas

    “A very useful technique to help understand the structure and accuracy of a complex spreadsheet”.

    Update, Extract and Join data (Manipulate your data)

    “You will be able to extract and join together various elements of data from a large list”.

    Validation techniques (Control data input)

    Control – Options – Business uses – Working with Validation
    “We explore various validation techniques to control a users experience with a spreadsheet”.

    Protection (Protect company data)

    Overview of Protection – Securing a workbook – Worksheet element protection – Remove protection – Allow users to edit ranges of cells – Protection of worksheet and workbook elements – Workbook Structure and Windows protection – Mark as Final options
    “The ability to protect elements of a spreadsheet using different techniques will allow you to control how users interact with it”.

    What IF Analysis (Analyse company data)

    Using Goal Seek – Solver – Scenario – Business uses
    “A fantastic set of business tools that will allow you to quickly ask a wide range of business questions”.

    Pivot Table Reports (Report company data)

    Create – Edit – Update – Delete reports – Calculated Fields
    “We explore the ability to create detailed Pivot tables using calculated fields and Slicers”.

    Slicers with Pivot Tables (Create interactive visualisation reports)

    Creating – Using – Formatting – Disconnect and Delete Slicers
    “Slicers are a useful visual filters with lists of data”.

    Excel Power Query (Connect, Import, Transform, Refresh and Report data)

    Create a data type using Power Query
    Import, Connect and Transform data using Microsoft Power Query

    Video Testimonials

    Client Testimonials

    • Name: 386 + reviewsCompany: Via

      View all testimonials