ALX Training / Excel: Data Analysis II

The Need:

Do you have the ability to analyse data and present it visually? Can you transform data into actionable insights?

Do you need consolidation tools to bring data currently spread across multiple spreadsheets together? This course can help you further your knowledge of Pivot Tables and teach you the Consolidation function in Excel to achieve this.

Organisations need to look ahead and try to predict what is coming in order to plan for business needs. If this is something you need to achieve, learn about Excel’s What If scenarios, which allow you to put goals and scenarios into Excel for future projections.

Do you have multiple people accessing and inputting data into shared spreadsheets? Is it difficult to control the content and format? Learn Data Validation practices to maintain data accuracy, ensuring fewer errors and better data integrity, in addition to advanced filtering and new data types

Course Objectives:

By the end of this program of learning, you will know:

How to use Pivot tables across multiple consolidation ranges
How to use the consolidate tool & group sheets
How to use further Slicer & Timeline options
How to use Goal Seek & Scenario Manager
How to use the Watch Window
How to use Data Validation
How to use the OR criteria to run advanced filters
How to use New Data Types

Course Audience:

Designed for individuals who are confident in Excel and need to learn data analysis tools within their role.  Positions include but are not limited to:  Accountants, Administrators, Office Managers, and HR Specialists, etc.

Course Delivery Options:

   This course can be delivered online, or
   Face-to-face in our training centre, or
   At your place of work.

If you would like to have this class online, you will need access to two screens, a webcam, speakers, and a microphone.

Course Duration:

   This highly engaging program of learning is a 3-hour interactive workshop.

Course Prerequisites:

Ahead of booking onto this program of learning, you must ensure:

1. That you are familiar with the content covered in the Microsoft Excel Essentials course.

Course Includes:

All training spreadsheets for future practice
A full colour booklet to accompany the lesson

Course Cost:

In Depth (Band B)