ALX Training / Excel / Excel: Super User

The Need:

From organising raw information to creating sophisticated data models, Excel is an essential application for most organisations.

Do you need to:

• Provide knowledge of Excel across multiple features and functions to support your fellow colleagues.
• Understand the best and most efficient ways to input, format, or manipulate data.
• Know effective ways to present data in dashboards, charts or pivot tables
• Know how to compare and pull data between sheets
• Clean data successfully
• Have a list of the most effective formulas and functions at your finger tips
• Have a toolbox of Excel knowledge that will prepare you for most situations in your work environment

By completing this Super User program, you will become confident in using and supporting colleagues in many areas of Excel, be it with formula’s and functions, analysing, presenting, cleaning data effectively or troubleshooting problems as they arise.

Course Objectives:

By the end of this program of lessons, you will learn:

How to use shortcuts, tips & tricks to maximise efficiency
How to use spreadsheet best practice principles
How to clean & manipulate data
How to analyse data
How to present data
How to use the top 15 most common formulas & functions

Course Audience:

This course has been designed specifically for individuals who are quite confident in their use of Microsoft Excel and wish to bring together a vast array of functions, formulas, and data analysis features for their multi-functional role and need to become confident in a wide array of Excel’s functionality.

It is also ideal for individuals within small/medium organisations who would benefit from having one or two colleagues possessing a comprehensive library of Microsoft Excel skills.

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 10-hour interactive workshop, broken into smaller modules.

Course Prerequisites:

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

1. That you are familiar with the content covered in Microsoft Excel Essentials, Presenting Data,
    Data Analysis and Financial Formulas courses.

Course Includes:

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

Course Cost:

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