MICROSOFT EXCEL FUNDAMENTALS ONLINE CLASS

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

Vimeo Video Embed
Vimeo Video Embed

$549 TT ($81 US)

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

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

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:

  • Turn raw data into polished, professional-grade documents effortlessly.

  • Learn beginner to intermediate formulas and techniques to boost your productivity.

  • Grasp critical skills like relative and absolute referencing to make your spreadsheets smarter.

  • Highlight important trends and figures with powerful visual tools.

  • Bring your numbers 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!

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.

Excel Galaxy is an accredited member of The CPD Certification Service.

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

Are You Accredited?

Yes, Excel Galaxy is an accredited member of The CPD Certification Services.

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.

Will I get a certificate?

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