ALX Training / Excel / Excel: The Essentials

The Need:

Do you use Excel regularly in your role? Are you confident in your abilities? Have you been tasked with working on a large spreadsheet but are feeling overwhelmed? Have you been given a project that relies on a solid understanding of Excel? Do you need to input or organise large amounts of data accurately? Can you find key information from your data quickly?

If any of the above questions relate to you, then this popular course should be the starting point in your Excel journey.

Excel users often receive no formal instruction or training in Excel and learn knowledge from a colleague or by asking questions when necessary. This means they are potentially missing out on key beneficial techniques on how to navigate quickly, input data efficiently, organise data, and format it clearly.

In this course, we will boost your confidence using Excel by providing the core essentials that make day-to-day use of Excel quicker and more effective.

Course Objectives:

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

How to navigate & select data with keyboard shortcuts
How to sort & filter data
How to write SUM, COUNT, MAX, MIN & AVERAGE formulas
How to calculate percentages
How to link cells together
How to reformat a spreadsheet effortlessly

Course Audience:

This course is the ideal building block for individuals who have used Excel very little or have not had any formal training.  It covers the essentials of formatting, filtering & sorting, navigating, selecting, and writing basic formulas—all areas that Excel users require in their day-to-day activities.

Ideal for administrators, receptionists, managers, etc.—anyone who wants to learn quick and effective ways to use the essentials in Excel.

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.

Prerequisites:

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

1. That you have prior experience of using Excel
2. That you are able to carry out basic data input & formatting with Excel

Course Includes:

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

Course Cost:

In Depth (Band B)