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.
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
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!
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.