MICROSOFT EXCEL FUNDAMENTALS LIVE ONLINE CLASS & FREE SELF PACED CLASS

NEXT CLASS STARTS JANUARY 7TH 2026

Master Essential Excel Features and stand out in today's job market.

Live Class Schedules in January 2026

$850 TT ($125 US)

$1,200 TT ($177 US)

This course boosted my Excel skills and was worth every cent spent. Mr. Duncan is an expert professional and he made learning easy. The Instructions and guidance were clear and easy to follow. In-class exercises and homework further facilitated learning. I did both fundamentals and advanced classes and the knowledge gained was extensive. I am now ready to work smarter, not harder to analyze and deliver reports in record time. This has definitely improved productivity.-
Maureen Antoinette Hall

Mr. Duncan is an excellent Instructor. He speaks at a moderate pace and his diction is clear. Classes are interactive and the workbooks are both relatable and practical. Need to make robust business decisions in a timely manner? Connect with Mr. Duncan! -
Terry Schultz

Microsoft Excel Class was very informative. I was able to follow all the steps. Mr. Kerron Duncan was very clear in his explanation and points. Overall well explained. -
Michelle Felix-Solomon

HERE IS A SNEAK PEAK INTO WHAT YOU WILL LEARN:

  • Get familiar with the Excel interface and common features

  • Learn to write formulas and master core Excel functions the experts know to 10x your productivity

  • Quickly clean data using Flash Fill

  • Set up professional and stunning tables that people actually want to look at

  • Highlight important trends and figures with conditional formatting

  • Bring your data to life with eye-catching charts and graphs

CURRICULUM

SECTION 1: THE EXCEL INTERFACE & ENTERING DATA

  • Get to Know the Excel Interface

  • Understanding Cell References and Entering Data into Cells

  • Auto filling Data using Auto Fill

  • Modifying Your View in Excel

  • Finding and Replacing Data using the Find and Replace Menu

  • Finding Data using Go To Special

  • Finding Data using Hyperlinks

SECTION 2: APPLICATION OF ESSENTIAL FUNCTIONS

  • Understanding Formulas & Functions

  • Understanding the Structure of a Function

  • Extracting Parts of Text with RIGH, LEFT & MID

  • Fixing Text Case with UPPER, LOWER & PROPER

  • Remove Unwanted Spaces in Text Strings with TRIM

  • Joining Text with CONCATENATE or TEXTJOIN

  • LEN, SEARCH & FIND for Advance Text Manipulation

SECTION 3: PERORMING OPERATIONS WITH FORMULAS AND FUNCTIONS

  • Key Concept: Relative, Absolute and Mixed Referencing

  • Introduction Into using IF

  • Using Defined Names and Ranges in Formulas

  • Creating, Modifying, Sorting and Filtering Tables

SECTION 4: ANALYSING AND VISUALIZING DATA USING CONDITIONAL FORMATTING, CHARTS & GRAPHS

  • Using Top Bottom Rules to Highlight Key Data

  • Using Highlight Cell Rules to Highlight Key Data

  • Data Bars, Color Scales & Icon Sets for Visualizing Data

  • Managing Conditional Formatting Rules

  • When and Why Should We Use Charts and How to Create Them

  • How to Determine the Right Chart based on Your Data

  • Modifying Chart Elements

  • Modifying Chart Design

WHAT STUDENTS SAY

MEET YOUR INSTRUCTOR

Hey, I'm Kerron Duncan!

Kerron has trained State and Corporate organisations globally.

LogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogoLogo

I founded Excel Galaxy as I wanted a way to make a living while sharing knowledge I'm passionate about. An added bonus to this is that I get the joy of enhancing the quality of my students' lives. Whether its helping them negotiate a better salary, get the promotion they've wanted or just significantly boost their productivity I'm glad I founded Excel Galaxy.

I am certified by Microsoft as a Microsoft Excel Expert and possess extensive experience as a teacher and presenter. I've had the pleasure of teaching people all over the world to master Microsoft Excel.

Hope to see you in one of my classes!

Class Requirements

For this class you will need:

  • Microsoft Excel on a laptop or desktop computer. Microsoft Excel version 2013 and above is best suited. You can do the course with older versions of Excel but some features may not be available.

  • Zoom installed on a laptop or desktop computer.

Frequently Asked Questions

Is this class for beginners?

Yes, this class is designed specifically for beginners. If you have ever opened Excel and you know what rows and columns are you are a good fit for this class.

Will I get a certificate?

Yes, participants that complete the course receive a certificate of achievement verifying their accomplishment.

Class Schedule Options:

We Respect Your Privacy & Information.