Courses

Excel Data Analysis & Reporting

= Scheduled class    = Guaranteed to run    = Fully booked

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.

About this Course

This course is designed for regular users of Excel who work with large spreadsheet files that need effective analysing and reporting. Our aim is to provide you with the necessary skills that use the best methods to efficiently analyse data.

It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review this Course Guide once you are back at your workplace.

This course in conjunction with Excel Essential Skills, Excel Timesaving Features and Excel Optimising covers the material examined in the MOS exam: Using Microsoft Office Excel 2013

Prerequisites

We recommend that students:

• First complete our Essential Skills and Timesaving Features courses,

OR have:

• A thorough understanding of formulae including absolute references.
• A thorough understanding of using Excel’s common functions such as Average, Maximum, Count, If and the function wizard.
• The knowledge to create and use range names.

At Course Completion

This course is essential for anyone needing to analyse data and then report on that data. It explores the database features, which simplify the task of analysing large amount of information.

Course Outline

• Excel Databases & Tables
• Group and Outline Data
• Consolidating Workbooks
• Split & Combine Data in Columns
• Flash Fill
• Advanced Filters
• Database Functions
• Looking Up and Retrieving Data
• Importing and Exporting Data
• Retrieving External Data
• What If Analysis – Data Tables
• What If Analysis – Goal Seek
• What If Analysis – Scenarios
• Solver
• Summarising Data with Pivot Tables
• Creating Pivot Charts

 Print this page