ALX Training / Excel / Excel: Data Analysis I

The Need:

In the dynamic realm of business, data isn’t just raw numbers—it’s a strategic asset. Microsoft Excel, with its robust features, empowers professionals to transform data into actionable insights, and having the ability to analyse data, and present it visually to support communications is critical.

From organising raw information to creating sophisticated data models, it’s your go-to tool, and by the conclusion of this program, you will be able to confidently analyse your data faster than ever before, summarise your data using advanced formatting tools, and take advantage of slicers and subtotals to simplify the presentation of your data, taking you to the next level on your path to data mastery.

Course Objectives:

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

How to apply best practices associated with arranging data in a spreadsheet
How to find & fix input errors
How to use pivot tables to summarise & analyse data
How to use format, layout & design options
How to utilise the power of slicers & timelines
How to insert calculated fields using grouped dates
How to use the subtotal function to calculate subtotals
How to copy & paste visible cells

Course Audience:

This course has been designed specifically for individuals who are quite confident in their use of Microsoft Excel and wish to explore the vast array of data visualisation and data analysis tools that are present in Microsoft Excel a little further.  In this program, we will guide you through every feature step-by-step, transforming your day-to-day business practices while setting you up for business success.

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:

Contact a member of the ALX team for further details using the ‘Contact Form’ below.