Microsoft Excel Data Analysis Reporting Workshop

This data analysis reporting course is one of IPSO FACTO’s popular Microsoft courses. You will learn time saving techniques to analyse and report business data sets, using a wide range of invaluable formulas and 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 speed using Microsoft Excel’s latest toolkit.

This course is mainly delivered live online using Microsoft Teams where delegates can carry out their training from home or work. However, training can be carried out onsite where there are groups of 4 or more delegates. The data analysis reporting course is very interactive and you are encouraged to ask questions relating to your data.

Is this data analysis reporting course for you?

If you are required to analyse company data and create accurate professional reports then you will learn useful techniques to do this quickly.

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

• Microsoft Training Manual
• Data analysis reporting course training files
• Certificate on completion
• Post course support relating to course content

Aim

To use a range of creative Excel techniques for effective data analysis reporting.

Course Objectives

• 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

Microsoft Excel 365 App Data Analysis Reporting

Data

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