• training@skillsforafrica.org
    info@skillsforafrica.org

Advanced Excel Formulas And Functions Training

INTRODUCTION

Master the advanced features of Excel with our Advanced Excel Formulas and Functions Training. This comprehensive course is tailored to cover essential aspects crucial for the efficient operation of organizations. Intermediate users will also benefit significantly from the in-depth topics, which include complex charts, PivotTables, Pivot Charts, and management dashboards. This training aims to equip participants with advanced skills to manage, analyze, and present data effectively, ensuring they can handle the demands of modern business environments.

DURATION

5 Days

WHO SHOULD ATTEND?

This course is ideal for Excel users aiming to elevate their skills to meet the advanced needs of today's organizations. Participants will learn to utilize complex functions within Excel, including powerful tools for analyzing, linking, and exporting data. It is particularly beneficial for professionals who need to work with large datasets, create dynamic dashboards, and automate complex tasks. Whether you are an analyst, manager, or anyone extensively working with Excel, this training will help you leverage Excel's full capabilities.

COURSE OBJECTIVES

By the end of this course, participants will be able to:

  • Utilize Excel functions commonly used in business.
  • Analyze large data sets efficiently.
  • Create and manage management dashboards.
  • Automate and customize data entry forms.
  • Apply multiple variable styles.
  • Develop custom formulas/functions.
  • Generate comprehensive reports.
  • Control forms using buttons and drop-down menus.
  • Execute special commands.
  • Use forms for data entry and report generation control.

COURSE CONTENT

Introduction

Excel Formulas

  • Conditional Statements & Logical Operators
  • Statistical Functions
  • Lookup/Reference Functions
  • Text Functions
  • Date & Time Functions
  • Formula-Based Formatting
  • Array Formulas

Functions

  • Advanced IF Statements
  • Advanced Lookup Functions
  • Complex Logical and Text Functions
  • Formula Auditing
  • What-If Analysis Tools
  • Worksheet and Workbook Protection
  • Advanced Use of PivotTables and Power Pivot

Automating with Macros

  • Working with Form Controls
  • Ensuring Data Integrity
  • Managing & Enriching Data
  • Data Analysis
  • Presentation
  • Custom Views in Excel
  • Scenario Planning
  • Auditing and Troubleshooting Formulas
  • Pivot Tables and Pivot Charts
  • Goal Seek and Solver and Data Tables
  • Macros and Basic Visual Basic

GENERAL NOTES

  • This course is delivered by seasoned trainers with extensive professional experience.
  • Training includes practical activities, theoretical knowledge, group work, and case studies.
  • Participants receive comprehensive training manuals and additional reference materials.
  • A certificate is awarded upon successful course completion.
  • Tailor-made courses to meet specific organizational needs are available. Contact us at training@skillsforafrica.org for more information.
  • The training will be conducted at the Skills for Africa Training Institute in Nairobi, Kenya.
  • The training fee covers tuition, materials, lunch, and the training venue. Accommodation and airport transfer can be arranged upon request.
  • Payment should be made to our bank account before the training starts, and proof of payment sent to: training@skillsforafrica.org.

Course Schedule
Dates Fees Location Apply
06/01/2025 - 10/01/2025 $1500 Nairobi
20/01/2025 - 24/01/2025 $1500 Nairobi
03/02/2025 - 07/02/2025 $1500 Nairobi
17/02/2025 - 21/02/2025 $1500 Nairobi
03/03/2025 - 07/03/2025 $1500 Nairobi
10/03/2025 - 14/03/2025 $3000 Kigali
17/03/2025 - 21/03/2025 $1500 Nairobi
07/04/2025 - 11/04/2025 $1500 Nairobi
14/04/2025 - 18/04/2025 $1750 Mombasa
21/04/2025 - 25/04/2025 $1500 Nairobi
05/05/2025 - 09/05/2025 $1500 Nairobi
12/05/2025 - 16/05/2025 $4500 Dubai
19/05/2025 - 23/05/2025 $1500 Nairobi
02/06/2025 - 06/06/2025 $1500 Nairobi
09/06/2025 - 13/06/2025 $1750 Mombasa
16/06/2025 - 20/06/2025 $1500 Nairobi
07/07/2025 - 11/07/2025 $1500 Nairobi
14/07/2025 - 18/07/2025 $3500 Johannesburg
21/07/2025 - 18/07/2025 $1500 Nairobi
04/08/2025 - 08/08/2025 $1500 Nairobi
11/08/2025 - 15/08/2025 $1750 Mombasa
18/08/2025 - 22/08/2025 $1500 Nairobi
01/09/2025 - 05/09/2025 $1500 Nairobi
08/09/2025 - 12/09/2025 $3500 Dar es Salaam
15/09/2025 - 19/09/2025 $1500 Nairobi
06/10/2025 - 10/10/2025 $1500 Nairobi
13/10/2025 - 17/10/2025 $3000 Kigali
20/10/2025 - 24/10/2025 $1500 Nairobi
03/11/2025 - 07/11/2025 $1500 Nairobi
10/11/2025 - 14/11/2025 $1750 Mombasa
17/11/2025 - 21/11/2025 $1500 Nairobi
01/12/2025 - 05/12/2025 $1500 Nairobi
15/12/2025 - 19/12/2025 $1500 Nairobi