Next course begins July 22nd

Excel Essentials

Our Excel essentials course is designed for complete beginners who want to learn Microsoft Excel. Our certified Excel trainer will train you in the key skills to create and develop worksheets, implement formulas and functions. You will also learn techniques for managing data in Excel including how to use calculations, applying formatting and creating charts. The course will enable you to practice and apply the skills you learn. This 3-day course will give delegates a thorough study on using Microsoft Excel.

Course Content

Starting Out

  • About Workbooks
  • Exploring your Workbook
  • Getting Help with Excel


Getting to grips with the basics

  • The Excel Interface
  • Using Backstage View
  • Understanding the Ribbon
  • Using & customising the Quick Access toolbar
  • The Home Tab
  • The Insert Tab
  • The Page Layout Tab
  • The Formulas Tab
  • The Data Tab
  • The Review Tab
  • Using shortcuts


Organising Your Workbooks effectively

  • Create, save & open a new Workbook
  • Entering numbers & text in a Workbook
  • Adding, deleting & naming sheets


Entering Data into Spreadsheets

  • Inserting Cells, Columns & Rows
  • Deleting Cells, Columns & Rows
  • AutoFill & using SmartTags


Presenting Your Data

  • Font formatting
  • Borders & Shading
  • Number formatting (currency etc)
  • Alignment options
  • Clearing formats
  • Applying cell styles
  • Formatting shortcut


Defining & Creating Calculations

  • Writing a basic formula
  • Understanding the order of BODMA
  • The Sum function & AutoSum
  • Creating statistical functions (Average, Max and Min)
  • An introduction to the Function Wizard


Advanced File Tasks

  • Saving and File Management
  • Converting and Encrypting Files
  • File Properties and Digital Signatures
  • File Accessibility and Compatibility


Working with Functions and Formulas

  • Formulas with Absolute References
  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Text Functions


Managing Tables in Microsoft Excel

  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters


Data Tools in Excel

  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate


How to do more with Charts in Excel

  • Trendlines
  • Error Bars
  • Working with Axis Options
  • Advanced Chart Formatting

Creating Sparklines

  • Editing Sparklines


Grouping & Outlining and Subtotals

  • Outlining and Grouping Data
  • Using the Subtotals Tool


What-If Analysis

  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver



  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Slicers


Charting Pivoted Data

  • Getting Started with Pivot Charts
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart


Advanced Excel Tasks

  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks


Creating HLOOKUP and VLOOKUP Functions

  • Using the VLOOKUP Function
  • Using the LOOKUP Function


Introduction to Macros in Excel

  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros


Advanced Conditional Formatting

  • Editing Standard Formatting Rules
  • Using Formulas in Conditional Formatting


Using Form Controls and Templates

  • Using Form Controls
  • Creating Templates


Advanced Lookup Functions

  • Index Function
  • Using the Match Function
  • Using Index and Match Together
  • Using Index and Match with Array Formula
  • Using the Indirect Function


Advanced Functions in Excel

  • Using Error Functions
  • Using Logical Functions
  • Using Array Formulas
  • Using Rounding Functions


Advanced Pivot Table Tools

  • Importing Pivot Table Data
  • Calculated Fields in Pivot Tables
  • Showing Pivot Data as a Percentage
  • Creating Custom Pivot Tables Styles


Introduction to User Defined Functions Using VBAs

  • Creating a User Defined Function
  • Creating an Interactive Procedure
  • Create and Share a Function Add-in

Setting Excel Macro Options

  • Record and Run Simple Macros
  • Assign Macros to the Quick Access Toolba


Introduction to User Defined Functions Using VBAs

  • Creating a User Defined Function
  • Creating an Interactive Procedure
  • Create and Share a Function Add-in


Recording and Running Macros in ExcelVBAs

  • Setting Excel Macro Options
  • Record and Run Simple Macros
  • Assign Macros to the Quick Access Toolbar


Introduction to the Excel VBA Editor

  • Starting the Visual Basic Editor
  • Using the Project Explorer
  • Using the Properties Window
  • Creating, Importing and Exporting Modules
  • Explore Recorded Macros


Creating Procedures and Functions

  • Creating Sub and Function Procedures
  • Declare and Use Variables
  • Displaying Message to the User
  • Getting Input from the User


Working with the Excel Object Model

  • Understanding Objects, Properties and Methods
  • Referencing Cells and Ranges
  • Gathering Cell and Range Information
  • Using the Offset Method
  • Using the Resize Method
  • Using With Blocks
  • Referencing Workbooks and Worksheets


Controlling Program Flow

  • Using the IF Statement
  • Using the Select Case Statement
  • Using For Next Loops
  • Using Do Loops
  • Using For Next Loops


Advanced Procedures

  • Calling Procedures
  • Passing Values to Procedures


Advanced Variables

  • Understanding Variable Scope
  • Understanding Object Variables
  • Creating Array Variables
  • Creating Dynamic Array Variables


Interacting with Office Applications

  • Setting References to other Applications
  • Setting References using Late Binding
  • Create a PowerPoint Presentation
  • Create a Letter in Word


Debugging and Error Traps

  • Review of Error Types
  • Debugging tools
  • Setting Error Traps


Creating Custom User Forms

  • Creating a Custom Form
  • Adding Form Controls
  • Creating Event Procedures


Workbook and Worksheet Events

  • Create Workbook Events
  • Create WorkSheet Events

Upcoming Dates

LagosJuly 22nd, 2024 ₦200,000
LagosAugust 5th, 2024 ₦200,000

Delivery Methods

Classroom Training

Unlock your potential with our classroom training courses. Our portfolio of business intelligence training courses are delivered by BI experts across Africa.

Online Training

Our online trainings (live instructor-led) are delivered by certified instructors and are designed to replicate a classroom experience which enables full interactions.

Onsite Training

Our onsite training team allows us to bring our skills and expertise to you. Onsite courses are developed in conjunction with you, ensuring your expectations are exceeded.

1-to-1 Training

With our one-to-one training you’ll not only receive the undivided attention of the trainer, but one-to-one training allows you to tailor the training to your specific needs.

From ₦200,000
RF250,000 | ₵2500



Training multiple people?

Empower your teams with business intelligence training courses delivered by subject matter experts.

Apply for Excel Essentials

Which date are you interested in?

Apply for Excel Essentials

Which date are you interested in?