ALX Training / Excel / Excel: Data Analysis I

The Need:

Having the ability to analyse data and present it visually is significant in organisations.

Excel holds powerful analysis tools to break down complex data and present it in a visually compelling way?

When working with large data sets, would you benefit from creating Pivot Tables? Designed to pick out specific content from your data set and allow you to manipulate and display it in a variety of ways.

Have Pivot Tables and Pivot Charts always been a mystery to you? Do you lack confidence in using them effectively? Have you tried to create them and struggled when the data didn’t come across and display as expected?

Pivot tables and charts help you display data effectively on shared spreadsheets; using charts, slicers, timelines and added calculated fields is an efficient way of helping others to draw out the data they need?

By the end of the session, you will be able to confidently check for data entry issues, analyse your data faster than ever before, take advantage of pivot tables to simplify the presentation of your data, and use subtotals to summarise complex sheets.

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 inputting errors
How to create pivot tables to summarise & analyse data
How to use format, layout & design options within pivot tables and charts
How to utilise the power of slicers & timeline filters
How to insert a calculated fields in to a pivot table
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 confident in Microsoft Excel and need to learn data analysis tools within their role.  Positions include but are not limited to: Accountants, Administrators, Office Managers, 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:

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