Microsoft Excel Masterclass
in Personal Development & Career Skills
Created by
Sapphital
About this course
Unlock the full potential of Microsoft Excel and elevate your spreadsheet skills to new heights with our comprehensive Microsoft Excel Masterclass. Whether you're a beginner looking to establish a solid foundation or an experienced user aiming to refine your expertise, this course offers a dynamic and engaging learning experience that covers a wide range of advanced Excel techniques.
Lesson Outcomes
- Understand the Excel interface and navigate workbooks with confidence.
- Apply formulas and functions to perform accurate calculations efficiently.
- Create and format professional spreadsheets for clear data presentation.
- Use charts and graphs to visualize data effectively.
Meet the Instructor
Sapphital Original

This is a Sapphital Original course. This course has been carefully developed and delivered engagingly to foster learning through a collaborative effort of a team of researchers, content developers, animators, videographers, graphic designers, voice-over artists, and the full weight of the Sapphital brand.
Comments (0)
Pre Assessment Test
1 Parts
Pre-Assessment Quiz
5 Questions
Min
Passed grade: 3/5
Attempts: 0/
Introduction to Microsoft Excel
17 Parts
Course Prerequisite
-
Introduction
-
Case Study
-
Bolaji and Executive Director's Conversation
-
Bolaji Narrates
-
Lesson 1 - Getting Started with Excel and your First Table
-
Lesson 2 - Inputting Data in tables and simple calculations
-
Lesson 3- Formatting tables and adding borders
-
Lesson 4 - Total, Average, Min and Max
-
Lesson 5 - Decimals, Amounts, Percentage and Currency
-
Lesson 6 - Format Painter
-
Lesson 7 - Working with Sheets - Copy, Move, Add, Delete, Rename
-
Lesson 8 - Creating Charts
-
Lesson 9 - Taking your Excel Work to other Platforms for Presentation
-
Lesson 10 - Autofill and Flash Fill
-
Lesson 11 - Importing Worksheet, Paste Special, Division Formula
-
Quiz
8 Questions
Min
Passed grade: 4/8
Attempts: 0/
Formulas and Simple Functions
5 Parts
Basic Math in Excel
-
Writing Simple Formulas
-
Multiplication and division
-
Using Formula auditing Tools
-
Quiz
4 Questions
Min
Passed grade: 2/4
Attempts: 0/
Formatting your Data in Excel
4 Parts
Formatting Fonts & Alignments in Excel
-
Working with numbers, amounts and currency
-
The Format Painter
-
Quiz
4 Questions
Min
Passed grade: 2/4
Attempts: 0/
Getting data in and out of Excel
3 Parts
Importing Data from other sources
-
Using Global Replacement
-
Quiz
4 Questions
Min
Passed grade: 2/4
Attempts: 0/
Worksheet Formatting and Presentation
3 Parts
Working with Templates
-
Protecting cell ranges and worksheets
-
Quiz
4 Questions
Min
Passed grade: 2/4
Attempts: 0/
Sorting, Selecting and Subtotaling
4 Parts
Using the Excel Subtotal Feature
-
Excel Table Functions
-
Filtering Tables with Slicers
-
Quiz
4 Questions
Min
Passed grade: 2/4
Attempts: 0/
Present data Visually
4 Parts
Creating Charts
-
Creating Charts part 2
-
Creating Charts part 3
-
Quiz
4 Questions
Min
Passed grade: 2/4
Attempts: 0/
Useful Excel formulas and functions
10 Parts
Excel Formulas and Functions_ The If Function
-
Introduction to SUMIF and SUMIFS Functions
-
Formula - IF Error
-
Excel Functions_ Left, Right, and Mid
-
Split Text into Columns - Functions
-
Concatenate Formula
-
Using the Filter Function in Excel
-
Rounding Numbers in Microsoft Excel
-
VLookup
-
Quiz
4 Questions
Min
Passed grade: 2/4
Attempts: 0/
Post-Course Assessment
1 Parts
Post-Assessment Quiz
30 Questions
Min
Passed grade: 20/30
Attempts: 0/
0
0 Reviews