ALX Training / Excel / Excel: Formulas and Functions I

The Need:

Are you analysing a large amount of data in Excel? Do you feel you are spending large amounts of time doing repetitive tasks in Excel and would like to automate them and save time?

Do you feel confident using the most common functions used in Excel for calculations?

Many people use spreadsheets containing formulas daily – this course will help you learn the most common functions.

Do you need to take action depending on the content of certain cells in your data? Then you would you benefit from learning the IF function, which allows you to make logical tests on cell contents and display variable results or calculations.

We will help you to understand formulas you have probably already come across in your daily work and help troubleshoot logical and mathematical functions, taking you to the next level on your path to Excel excellence.

By the end of the session, you will feel confident writing and applying functions such as IF & nested IF formulas and be able to use common functions and formulas to summarise and calculate your data.

Course Objectives:

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

How to read, write & edit IF formulas
How to nest multiple IF functions together
How to nest IF formulas using AND, OR & TODAY functions
How to use the Sum, SUMIF, SUMIFS, MAX, MIN, MODE, AVERAGEIF, COUNT, COUNTA, COUNTIF & COUNTIFS functions

Course Audience:

This course has been designed specifically for individuals who are confident in Microsoft Excel and need to learn essential functions and formulas for their role.  This includes roles such as: Finance & Accounting Professionals, Administrators, Office Managers, HR Specialists and Financial Analysts, 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:

In Depth (Band B)