ALX Training / Excel / Excel: Presenting Data

The Need:

Have you been asked to convert data in your Excel spreadsheets into clear visual insights? Do you need to pick out significant numbers that can affect business decisions?

Is there a necessity to display data as a chart or table tool to ensure the audience gains a clearer understanding?

When working on large data sets in Excel, it is easy to miss significant data, changes, or trends that are key and need to be actioned. Could your data benefit from Conditional Formatting, used to format cells whose content meets predefined criteria.

Key data is often spread across various sheets? Would a dashboard help you? by seeing that important data pulled across from those sheets in a summary view and in a visually engaging way?

This course is a great way to highlight your KPI’s, create charts effectively, present data visually, and highlight data that meets criteria.

Course Objectives:

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

How to format data using cell styles & format as a table functions
How to filter using Slicers
How to use conditional formatting
How to visualise data with charts, graphs & shapes
How to insert sparklines
How to add Headers & Footers

Course Audience:

Designed for individuals who are confident in the essentials of Microsoft Excel and wish to explore the data visualisation tools and features Excel.

Ideal for those who need to present data, create presentations, or create visuals within Excel to interpret the data quickly and efficiently.

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)