Microsoft Excel Data Analysis & Reporting Advanced

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

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

    Virtual Classroom Training option: Our Data Analysis & Reporting course begins with CSV data from a simulated 3rd party system. We convert, clean and manipulate the data ready for analysis. Our Excel Data Analysis & Reporting course is the perfect course to measure company performance and is designed for a wide range of business users.

    About Microsoft Excel Data Analysis & Reporting Advanced

    Microsoft Excel Data Analysis Reporting Workshop

    Learn time saving techniques to analyse and report business data sets, using a wide range of invaluable formulas and fairly simple techniques. We come across many people who waste so much time using old techniques and a limited portfolio of formulas. This course will bring you up to date using Excel 2016’s latest toolkit.

    The course is very interactive and you are encouraged to ask questions about your data.

    Is this course for you?

    You are required to analyse company data and create accurate professional reports.

    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: £900+VAT for up to 8 delegates
    Scheduled course: £195+VAT per delegate, discount for groups.
    Onsite: £925+VAT for up to 8 delegates. £75 for additional delegates up to a maximum of 10.
    Minimum charge: £795+VAT for 4 delegates.

    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

    • Computer and Microsoft 365 latest software for each classroom based delegate
    • Microsoft Training Manual
    • Post course training downloads
    • Certificate on completion
    • Post course support relating to course content

    Aim & Objectives


    To use a range of creative Excel techniques to Analyse and Report business data.

    Course Objectives

    By the end of the course you will be able to:
    • Import data from txt or csv
    • Transpose, split and automate data clean-up
    • Use a combination of formulas to manage, separate, combine data
    • Employ conditional formatting techniques to analyse data
    • Find and remove duplicate data
    • Interrogate data using Filters, Subtotals and Pivot tables
    • Use Slicers to quickly interrogate data
    • Use IF’s, Match, Index and VLOOKUP functions
    • Explore multi and single cell array formulas
    • Explore data Validation techniques
    • Chart Sheet, Objects, Sparkline’s and Forecasting charts
    • Use the Goal Seek tool to interrogate data

    Course Content

    Microsoft Excel 365 App Data Analysis and Reporting


    Use data from a 3rd party system in a CSV format.

    Import CSV data into Excel format.

    Change data orientation using Transpose.

    Clean and manipulate large sets of data

    Remove unwanted elements of data ‘ ; etc

    Split text into columns

    Learn how to use individual and combined formulas to edit, separate and join data.

    Automate data clean up using a simple macro

    Find and remove duplicate values

    Advanced functions and formulas

    Logical & Conditional functions | Array formulas – multi-cell and single-cell arrays

    Lookups and data tables

    Using lookup functions | Using MATCH and INDEX | Creating data tables

    Advanced data management

    Range Names | Validating cell entries | Advanced filtering

    Advanced charting

    Chart formatting options | Combination charts | Graphical objects | Sparkline’s | Forecasting charts

    PivotTables and PivotCharts and Slicers

    Working with PivotTables | Modifying PivotTable data | Formatting PivotTables | Using PivotCharts | Create Slicers

    Analytical tool

    Goal Seek

    Video Testimonials

    Client Testimonials

    • Name: 386 + reviewsCompany: Via

      View all testimonials