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.
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.
You are required to analyse company data and create accurate professional reports.
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.
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.
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]
To use a range of creative Excel techniques to Analyse and Report business data.
Use data from a 3rd party system in a CSV format.
Import CSV data into Excel format.
Change data orientation using Transpose.
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
Logical & Conditional functions | Array formulas – multi-cell and single-cell arrays
Using lookup functions | Using MATCH and INDEX | Creating data tables
Range Names | Validating cell entries | Advanced filtering
Chart formatting options | Combination charts | Graphical objects | Sparkline’s | Forecasting charts
Working with PivotTables | Modifying PivotTable data | Formatting PivotTables | Using PivotCharts | Create Slicers