Course Outline

Certified Microsoft Excel Expert Level One – Course Outline

📊 Certified Microsoft Excel Expert Level One – Course Outline

📖 Course Introduction

Welcome to the Certified Microsoft Excel Expert Level One course!

Have you ever seen someone use Excel and wondered how they make those amazing tables, charts, and calculations? Have you ever wanted to organize information like a pro? Excel is the tool that makes all of that possible.

What is Microsoft Excel?

Microsoft Excel is a computer program that helps you organize, calculate, and analyze information. It is like a giant digital spreadsheet that can do math for you, create beautiful charts, and help you make sense of data.

Why is Excel important?

Excel is used all over the world – in schools, businesses, government offices, and even at home. People use Excel to:

Create budgets and track spending.
Organize lists of information (like student grades or customer contacts).
Calculate totals, averages, and other math problems automatically.
Create charts and graphs to visualize data.
Analyze data to make better decisions.

What will you learn in this course?

This course is designed for beginners. You don't need any prior experience with Excel. We will start from the very beginning and guide you step by step. By the end of this course, you will be able to:

Open and save Excel workbooks.
Navigate the Excel window and understand its parts.
Enter and edit data in cells.
Use basic formulas and functions (like SUM and AVERAGE).
Format cells to make your data look beautiful.
Create and format charts.
Sort and filter data.
Print your workbooks.
And much more!

Who is this course for?

This course is for anyone who wants to learn Excel – from students to professionals, from beginners to those who want to refresh their skills. The teaching style is simple and friendly, making it perfect for a curious 10-year-old or anyone who wants to learn in a fun, easy way.

How is this course structured?

This course is divided into 12 modules. Each module builds on the previous one. You will learn one new concept at a time, with lots of examples, stories, and practice exercises. There are also quizzes, projects, and challenges to help you remember what you have learned.

Let's begin our Excel adventure!

🎯 Overall Learning Objectives

By the end of this course, you will be able to:

Understand the Excel interface: Navigate the ribbon, cells, columns, rows, and sheets.
Enter and edit data: Type, edit, and delete data in cells.
Use basic formulas: Write formulas to add, subtract, multiply, and divide.
Use basic functions: Use SUM, AVERAGE, COUNT, MIN, MAX, and more.
Format cells: Change font, size, colour, alignment, and number formats.
Create and format charts: Make bar charts, pie charts, and line charts.
Sort and filter data: Organize and find information quickly.
Print workbooks: Set print areas, adjust margins, and preview before printing.
Use absolute references: Lock cells so formulas don't change when copied.
Work with multiple sheets: Create, rename, and move sheets.
Apply conditional formatting: Highlight cells based on rules.
Protect workbooks: Add passwords and protect sheets.

📚 Warm-up Story: Tunde's Bakery Adventure

Let's meet Tunde. Tunde is a 10-year-old boy who lives in Lagos, Nigeria. He loves helping his mother at her bakery. Every day, his mother sells bread, cakes, and pastries.

One day, Tunde's mother said, "Tunde, I need help keeping track of our sales. We sell many items, and I want to know how much we earn each day. Can you help me?"

Tunde thought about it. He could write everything down in a notebook, but that would take a long time. And it would be hard to add up all the numbers.

Then Tunde remembered his uncle, Mr. Obi. Mr. Obi is an accountant who uses a program called Microsoft Excel. He uses it to organize numbers and do calculations quickly.

Tunde called his uncle and asked for help. Mr. Obi said, "Excel is perfect for tracking sales! You can list all your items, enter the prices, and Excel will calculate the totals for you. It can even create charts to show which items sell the most."

Tunde was excited. He learned how to use Excel. He created a sales tracker for his mother's bakery. He listed all the items, entered the prices, and used formulas to calculate the daily totals. He even created a chart to show which items were the most popular.

His mother was amazed. "Tunde, this is wonderful! Now I can see exactly how we are doing every day."

Tunde felt proud. He had used Excel to solve a real problem. He learned that Excel is not just a computer program – it's a tool that can help people in many ways.

Now, it's your turn to learn Excel. You will learn all the skills Tunde used and many more. Let's begin!

📋 Course Modules

Module	Title	Description
1	Getting Started with Excel	Open Excel, understand the interface, and create your first workbook.
2	Entering and Editing Data	Type, edit, and delete data. Navigate through cells and sheets.
3	Basic Formulas	Add, subtract, multiply, and divide with simple formulas.
4	Basic Functions	Use SUM, AVERAGE, COUNT, MIN, MAX, and more.
5	Formatting Cells	Change fonts, colours, alignment, and number formats.
6	Working with Charts	Create and format bar charts, pie charts, and line charts.
7	Sorting and Filtering Data	Organize and find information quickly.
8	Printing Workbooks	Set print areas, adjust margins, and preview before printing.
9	Absolute and Relative References	Understand when to lock cells in formulas.
10	Working with Multiple Sheets	Create, rename, and move sheets.
11	Conditional Formatting	Highlight cells based on rules.
12	Protecting Workbooks	Add passwords and protect sheets.

📘 Module 1: Getting Started with Excel

🎯 Learning Objectives

Open and close Microsoft Excel.
Identify the main parts of the Excel window.
Understand the concept of workbooks and worksheets.
Create a new workbook.
Save and open workbooks.

📝 Key Lessons

Lesson 1: What is Excel?

Definition: Microsoft Excel is a spreadsheet program that helps you organize, calculate, and analyze data.

Why it is important: Excel is used in almost every industry. It helps people make better decisions with data.

Simple explanation: Think of Excel like a giant digital notebook with rows and columns. You can write numbers and text, and Excel can do math for you.

Real-life example: A teacher uses Excel to track student grades. A business owner uses Excel to track sales. A parent uses Excel to create a household budget.

Illustration:

    +------------------------------------------------------------------+
    |  📊 Microsoft Excel - Book1                                      |
    |  +------------------------------------------------------------+ |
    |  | [File] [Home] [Insert] [Page Layout] [Formulas] [Data]     | |
    |  | [Review] [View]                                            | |
    |  +------------------------------------------------------------+ |
    |  | A  | B  | C  | D  | E  | F  | G  | H  | I  | J  |         | |
    |  |------------------------------------------------------------+ |
    |  | 1  |    |    |    |    |    |    |    |    |    |         | |
    |  | 2  |    |    |    |    |    |    |    |    |    |         | |
    |  | 3  |    |    |    |    |    |    |    |    |    |         | |
    |  | 4  |    |    |    |    |    |    |    |    |    |         | |
    |  | 5  |    |    |    |    |    |    |    |    |    |         | |
    |  | 6  |    |    |    |    |    |    |    |    |    |         | |
    |  +------------------------------------------------------------+ |
    |  Sheet1  Sheet2  Sheet3                                         |
    +------------------------------------------------------------------+

Lesson 2: The Excel Window

Parts of the Excel window:

Title Bar: Shows the name of your workbook (e.g., "Book1 – Excel").
Ribbon: The strip at the top with tabs like Home, Insert, and Formulas.
Formula Bar: Shows the contents of the selected cell.
Column Headers: Letters at the top (A, B, C, ...).
Row Headers: Numbers on the left (1, 2, 3, ...).
Cells: The boxes where you enter data. Each cell has an address like A1, B2, C3.
Sheets: Tabs at the bottom (Sheet1, Sheet2, Sheet3).
Status Bar: At the bottom, shows information about your workbook.

Lesson 3: Workbooks and Worksheets

Definition: A workbook is the entire Excel file. A worksheet is one page inside the workbook. You can have many worksheets in one workbook.

Simple explanation: Think of a workbook like a notebook. Each worksheet is a page in the notebook.

Lesson 4: Creating a New Workbook

Steps:

Open Excel.
Click Blank workbook.

Lesson 5: Saving a Workbook

Steps:

Click File -> Save As.
Choose a location (like your Documents folder).
Type a name (like "My First Workbook").
Click Save.

Lesson 6: Opening a Workbook

Steps:

Click File -> Open.
Find your file and double-click it.

Key Vocabulary:

Word	Definition
Workbook	The entire Excel file.
Worksheet	One page inside a workbook.
Cell	A box where you enter data.
Cell Address	The location of a cell (e.g., A1, B2).
Ribbon	The strip at the top with tabs and tools.
Formula Bar	Shows the contents of the selected cell.

Summary: Excel is a spreadsheet program. Workbooks contain worksheets. Cells are where you enter data.

📘 Module 2: Entering and Editing Data

🎯 Learning Objectives

Enter data into cells.
Edit and delete data.
Navigate between cells using the mouse and keyboard.
Understand the different types of data (text, numbers, dates).

📝 Key Lessons

Lesson 1: Entering Data

Steps:

Click on a cell (e.g., A1).
Type your data (e.g., "Apples").
Press Enter to confirm.

Lesson 2: Types of Data

Text: Words and letters (e.g., "Bananas").
Numbers: Numeric values (e.g., 10, 25.5).
Dates: Dates like 01/01/2025.

Lesson 3: Editing Data

Double-click a cell to edit its content.
Or click the cell and edit in the Formula Bar.
Press Delete or Backspace to remove content.

Lesson 4: Navigating Cells

Mouse: Click on any cell.
Arrow Keys: Move up, down, left, or right.
Enter: Move down.
Tab: Move right.
Ctrl + Home: Go to cell A1.
Ctrl + End: Go to the last cell with data.

Key Vocabulary:

Word	Definition
Text	Letters and words entered into a cell.
Number	Numeric values entered into a cell.
Date	A date entered into a cell.
Formula Bar	The bar where you can see and edit cell content.

Summary: You can enter text, numbers, and dates into cells. You can edit and delete data. Use arrow keys and shortcuts to navigate.

📘 Module 3: Basic Formulas

🎯 Learning Objectives

Write formulas to add, subtract, multiply, and divide.
Understand cell references in formulas.
Use the order of operations.

📝 Key Lessons

Lesson 1: What is a Formula?

Definition: A formula is an equation that performs calculations in Excel. All formulas start with an equals sign (=).

Simple explanation: Think of a formula like a math problem. You tell Excel what numbers to use and what to do with them.

Lesson 2: Addition Formula

Example: =A1 + A2

This adds the values in cells A1 and A2.

Lesson 3: Subtraction Formula

Example: =A1 - A2

This subtracts the value in A2 from A1.

Lesson 4: Multiplication Formula

Example: =A1 * A2

This multiplies the values in A1 and A2. The asterisk (*) is the multiplication symbol in Excel.

Lesson 5: Division Formula

Example: =A1 / A2

This divides the value in A1 by A2. The forward slash (/) is the division symbol in Excel.

Lesson 6: Order of Operations

Excel follows the same order of operations as math:

Parentheses ( )
Exponents ^
Multiplication * and Division /
Addition + and Subtraction -

Example: = (A1 + A2) * A3

This adds A1 and A2 first, then multiplies the result by A3.

Key Vocabulary:

Word	Definition
Formula	An equation that performs a calculation.
Cell Reference	The address of a cell (e.g., A1).
Operator	A symbol like +, -, *, or /.
Order of Operations	The order in which calculations are performed.

Summary: Formulas start with =. You can add (+), subtract (-), multiply (*), and divide (/). Excel follows the order of operations.

📘 Module 4: Basic Functions

🎯 Learning Objectives

Use the SUM function to add numbers.
Use the AVERAGE function to find the mean.
Use the COUNT function to count numbers.
Use the MIN function to find the smallest number.
Use the MAX function to find the largest number.

📝 Key Lessons

Lesson 1: What is a Function?

Definition: A function is a pre-built formula in Excel. It does a specific calculation for you. Functions start with an equals sign and a name (like SUM).

Simple explanation: Think of a function like a shortcut. Instead of writing a long formula, you use a function.

Lesson 2: SUM Function

Example: =SUM(A1:A10)

This adds all the numbers in cells A1 through A10.

Lesson 3: AVERAGE Function

Example: =AVERAGE(A1:A10)

This calculates the average of numbers in cells A1 through A10.

Lesson 4: COUNT Function

Example: =COUNT(A1:A10)

This counts how many cells in A1 through A10 contain numbers.

Lesson 5: MIN Function

Example: =MIN(A1:A10)

This finds the smallest number in cells A1 through A10.

Lesson 6: MAX Function

Example: =MAX(A1:A10)

This finds the largest number in cells A1 through A10.

Key Vocabulary:

Word	Definition
Function	A pre-built formula in Excel.
SUM	Adds a range of cells.
AVERAGE	Calculates the mean of a range.
COUNT	Counts cells with numbers.
MIN	Finds the smallest value.
MAX	Finds the largest value.

Summary: Functions are shortcuts for common calculations. SUM adds, AVERAGE finds the mean, COUNT counts numbers, MIN finds the smallest, and MAX finds the largest.

📘 Module 5: Formatting Cells

🎯 Learning Objectives

Change font, size, and colour of text.
Apply bold, italic, and underline.
Align text left, centre, or right.
Change number formats (currency, percentage, decimal).
Add borders and fill colours to cells.

📝 Key Lessons

Lesson 1: Font Formatting

Select the cell(s) you want to format.
Go to the Home tab.
Use the Font group to change font, size, colour, bold (B), italic (I), and underline (U).

Lesson 2: Alignment

Select the cell(s).
In the Alignment group, click:
- Align Left
- Centre
- Align Right

Lesson 3: Number Formatting

Select the cell(s).
In the Number group, choose a format:
- General: Default format.
- Number: Shows numbers with decimals.
- Currency: Shows numbers with a currency symbol (like ₦).
- Percentage: Shows numbers as percentages.
- Date: Shows dates.

Lesson 4: Borders and Fill

Select the cell(s).
In the Font group, click the Borders button.
Choose a border style.
Click the Fill Color button to add a background colour.

Key Vocabulary:

Word	Definition
Font	The style of the letters.
Alignment	How text is positioned in a cell.
Number Format	How numbers are displayed (currency, percentage, etc.).
Border	A line around a cell or group of cells.
Fill Color	The background colour of a cell.

Summary: Formatting makes your data look good. You can change fonts, alignments, number formats, borders, and fill colours.

📘 Module 6: Working with Charts

🎯 Learning Objectives

Create bar charts, pie charts, and line charts.
Format charts with titles, labels, and colours.
Change chart types.

📝 Key Lessons

Lesson 1: What is a Chart?

Definition: A chart is a visual way to show data. Charts make it easier to see patterns and trends.

Simple explanation: Think of a chart like a picture of your data. It helps you see the story behind the numbers.

Lesson 2: Creating a Chart

Select the data you want to include in the chart.
Go to the Insert tab.
In the Charts group, choose a chart type:
- Bar Chart: Good for comparing values.
- Pie Chart: Good for showing parts of a whole.
- Line Chart: Good for showing trends over time.
Click on the chart type to insert it.

Lesson 3: Formatting a Chart

Click on the chart to select it.
The Chart Tools appear with two tabs: Design and Format.
Use these tabs to:
- Change chart style and colours.
- Add a chart title.
- Add axis labels.
- Change the chart type.

Lesson 4: Chart Types

Bar Chart: Compares categories.
Column Chart: Similar to bar but vertical.
Pie Chart: Shows proportions of a whole.
Line Chart: Shows trends over time.

Key Vocabulary:

Word	Definition
Chart	A visual representation of data.
Bar Chart	A chart with bars comparing categories.
Pie Chart	A circular chart showing parts of a whole.
Line Chart	A chart showing trends with lines.
Axis	The horizontal or vertical line in a chart.

Summary: Charts make data easier to understand. Bar charts compare, pie charts show proportions, and line charts show trends.

📘 Module 7: Sorting and Filtering Data

🎯 Learning Objectives

Sort data alphabetically or numerically.
Filter data to show only specific rows.
Use the Sort and Filter buttons.

📝 Key Lessons

Lesson 1: Sorting Data

Select the data you want to sort.
Go to the Data tab.
In the Sort & Filter group, click:
- Sort A to Z: Sorts text alphabetically (or numbers from smallest to largest).
- Sort Z to A: Sorts text reverse alphabetically (or numbers from largest to smallest).

Lesson 2: Filtering Data

Select the data you want to filter.
Go to the Data tab.
Click Filter.
Arrows appear on the headers. Click an arrow to filter the data.

Key Vocabulary:

Word	Definition
Sort	Arrange data in a specific order.
Filter	Show only rows that meet a condition.
Data	Information stored in cells.

Summary: Sorting arranges data in order. Filtering shows only the data you want to see.

📘 Module 8: Printing Workbooks

🎯 Learning Objectives

Set print areas.
Adjust margins and orientation.
Preview before printing.
Use Page Layout view.

📝 Key Lessons

Lesson 1: Setting the Print Area

Select the cells you want to print.
Go to Page Layout -> Print Area -> Set Print Area.

Lesson 2: Adjusting Margins and Orientation

Go to Page Layout -> Margins.
Choose a margin setting or click Custom Margins.
For orientation, click Orientation and choose Portrait or Landscape.

Lesson 3: Print Preview

Click File -> Print.
You can see a preview of how your document will look.
Click Print to print.

Key Vocabulary:

Word	Definition
Print Area	The cells that will be printed.
Margin	The space between the text and the edge of the page.
Orientation	Portrait (vertical) or Landscape (horizontal).
Print Preview	A view of how the document will look when printed.

Summary: Set the print area, adjust margins and orientation, and preview before printing.

📘 Module 9: Absolute and Relative References

🎯 Learning Objectives

Understand relative references.
Understand absolute references.
Use the $ sign to lock cells.

📝 Key Lessons

Lesson 1: Relative References

When you copy a formula, Excel changes the cell references automatically. This is called a relative reference.

Example: If you copy =A1 + B1 from cell C1 to C2, it becomes =A2 + B2.

Lesson 2: Absolute References

If you don't want Excel to change a cell reference when you copy, use an absolute reference. You add a $ sign before the column letter and row number.

Example: =$A$1 + B1

When you copy this formula, $A$1 stays the same, but B1 changes relative to the new location.

Lesson 3: Mixed References

You can also lock just the row or just the column.

$A1: Locks the column, but the row can change.
A$1: Locks the row, but the column can change.

Key Vocabulary:

Word	Definition
Relative Reference	A cell reference that changes when copied.
Absolute Reference	A cell reference that does not change when copied.
Mixed Reference	A cell reference with one part locked and one part free.
$ (Dollar Sign)	Used to lock a reference.

Summary: Relative references change when copied. Absolute references stay the same. Use $ to lock a reference.

📘 Module 10: Working with Multiple Sheets

🎯 Learning Objectives

Create, rename, and delete sheets.
Move and copy sheets.
Use 3D references to refer to cells across sheets.

📝 Key Lessons

Lesson 1: Adding a New Sheet

Click the + button at the bottom of the Excel window.

Lesson 2: Renaming a Sheet

Double-click the sheet name (e.g., "Sheet1").
Type a new name (e.g., "Sales") and press Enter.

Lesson 3: Deleting a Sheet

Right-click the sheet tab.
Choose Delete.

Lesson 4: Moving and Copying Sheets

Right-click the sheet tab.
Choose Move or Copy.
Select where to move or copy the sheet.

Lesson 5: 3D References

You can refer to the same cell across multiple sheets.

Example: =SUM(Sheet1:Sheet3!A1)

This adds the value in cell A1 from Sheet1, Sheet2, and Sheet3.

Key Vocabulary:

Word	Definition
Sheet	A page in a workbook.
3D Reference	A reference to the same cell across multiple sheets.

Summary: You can add, rename, and delete sheets. You can move and copy sheets. 3D references refer to cells across sheets.

📘 Module 11: Conditional Formatting

🎯 Learning Objectives

Apply conditional formatting to highlight cells.
Use rules like greater than, less than, and equal to.
Use colour scales and icon sets.

📝 Key Lessons

Lesson 1: What is Conditional Formatting?

Definition: Conditional formatting changes the appearance of cells based on their values. It helps you see patterns and outliers.

Simple explanation: Think of conditional formatting like a traffic light. It highlights important information for you.

Lesson 2: Highlight Cells Rules

Select the cells you want to format.
Go to Home -> Conditional Formatting -> Highlight Cells Rules.
Choose a rule (e.g., Greater Than).
Enter a value and choose a formatting style.

Lesson 3: Colour Scales

Select the cells.
Go to Home -> Conditional Formatting -> Colour Scales.
Choose a colour scale. The highest values get one colour, and the lowest values get another.

Lesson 4: Icon Sets

Select the cells.
Go to Home -> Conditional Formatting -> Icon Sets.
Choose an icon set (like arrows, flags, or traffic lights).

Key Vocabulary:

Word	Definition
Conditional Formatting	Formatting that changes based on cell values.
Highlight Cell Rules	Rules that highlight cells based on conditions.
Colour Scale	A gradient of colours based on values.
Icon Set	Icons that represent values.

Summary: Conditional formatting highlights cells based on rules. Use highlight rules, colour scales, and icon sets.

📘 Module 12: Protecting Workbooks

🎯 Learning Objectives

Protect a workbook with a password.
Protect a worksheet.
Allow users to edit specific cells.

📝 Key Lessons

Lesson 1: Protecting a Workbook

Go to File -> Info -> Protect Workbook.
Choose Encrypt with Password.
Type a password and click OK.

Lesson 2: Protecting a Worksheet

Go to Review -> Protect Sheet.
Enter a password.
Choose what users can do (e.g., select cells, format cells).
Click OK.

Lesson 3: Allowing Editing in Specific Cells

Select the cells you want to allow editing.
Right-click and choose Format Cells.
Go to the Protection tab.
Uncheck Locked.
Now protect the sheet. Users can edit the unlocked cells.

Key Vocabulary:

Word	Definition
Protect	To restrict access to a workbook or sheet.
Password	A secret word to unlock protection.
Encrypt	To secure data with a password.

Summary: You can protect workbooks and sheets with passwords. You can allow editing in specific cells.

📖 Overall Key Vocabulary

Word	Definition
Workbook	The entire Excel file.
Worksheet	One page inside a workbook.
Cell	A box where you enter data.
Cell Reference	The address of a cell (e.g., A1).
Formula	An equation that performs a calculation.
Function	A pre-built formula in Excel.
SUM	Adds a range of cells.
AVERAGE	Calculates the mean of a range.
COUNT	Counts cells with numbers.
MIN	Finds the smallest value.
MAX	Finds the largest value.
Chart	A visual representation of data.
Sort	Arrange data in a specific order.
Filter	Show only rows that meet a condition.
Relative Reference	A cell reference that changes when copied.
Absolute Reference	A cell reference that does not change when copied.
Conditional Formatting	Formatting that changes based on cell values.
Protect	To restrict access to a workbook or sheet.

💡 Important Concepts

Excel is a spreadsheet program: It helps you organize, calculate, and analyze data.
Workbooks contain worksheets: Think of a workbook as a notebook and worksheets as pages.
Cells are the building blocks: All data is entered into cells.
Formulas start with =: All formulas in Excel begin with an equals sign.
Functions are shortcuts: Functions like SUM and AVERAGE make calculations easier.
Formatting makes data readable: Use fonts, colours, and number formats to improve appearance.
Charts visualize data: Charts help you see patterns and trends.
Sorting and filtering help you find data: Organize and filter data to find what you need.
References can be relative or absolute: Use $ to lock a reference.
Protection keeps data safe: Use passwords to protect your workbooks.

🪜 Step-by-Step Explanations

Creating a Simple Budget in Excel

Step 1: Open Excel and create a new workbook.

Step 2: In cell A1, type "Item". In B1, type "Cost".

Step 3: In A2, type "Rent". In B2, type "500".

Step 4: In A3, type "Food". In B3, type "300".

Step 5: In A4, type "Transport". In B4, type "100".

Step 6: In B5, type the formula =SUM(B2:B4). This adds all the costs.

Step 7: Format the cells: make the headers bold, add borders, and apply currency format.

Creating a Chart

Step 1: Select the data you want to include (e.g., A1:B4).

Step 2: Go to Insert -> Charts -> Bar Chart.

Step 3: Choose a bar chart style.

Step 4: Click on the chart and use the Chart Tools to add a title and labels.

🌍 Real-Life Examples

Example 1: School Grade Book

A teacher uses Excel to track student grades. They list student names in column A and grades in columns B-D. They use SUM to calculate total scores and AVERAGE to find the class average.

Example 2: Household Budget

A parent uses Excel to track monthly expenses. They list expenses in one column and amounts in another. They use SUM to find total spending and create a pie chart to see where money goes.

Example 3: Business Sales Report

A business owner uses Excel to track sales. They list products, quantities sold, and prices. They use formulas to calculate total revenue and create a bar chart to compare product sales.

Example 4: Nigerian Market Data

A market trader in Lagos uses Excel to track prices of goods. They list items, prices, and quantities. They use Excel to calculate daily earnings and identify trends.

⚠️ Common Mistakes

Mistake 1: Forgetting the equals sign (=) in formulas. All formulas must start with =.
Mistake 2: Using the wrong cell reference. Make sure you are using the correct cells.
Mistake 3: Not using absolute references when needed. Use $ to lock references.
Mistake 4: Not formatting data. Make your data readable with fonts and colours.
Mistake 5: Forgetting to save your workbook. Save regularly.
Mistake 6: Not using functions when they would be helpful. Use SUM, AVERAGE, etc.

✅ Best Practices

Plan your spreadsheet: Think about what you want to achieve before you start.
Use clear labels: Label your columns and rows clearly.
Use formatting: Make your data easy to read.
Use functions: Let Excel do the math for you.
Save regularly: Press Ctrl+S often.
Check your formulas: Make sure they are correct.
Document your work: Add comments to explain complex formulas.

🚀 Preparation for Level Two

Congratulations! You have completed the Certified Microsoft Excel Expert Level One course outline. You have learned the fundamentals of Excel, including:

Opening, saving, and navigating workbooks.
Entering and editing data.
Using basic formulas and functions.
Formatting cells and creating charts.
Sorting and filtering data.
Using absolute and relative references.
Working with multiple sheets.
Applying conditional formatting.
Protecting workbooks.

What's next? Level Two!

In Level Two, you will learn more advanced Excel skills, including:

Advanced Functions: VLOOKUP, IF, CONCATENATE, and more.
PivotTables: Summarize and analyze large datasets.
Data Validation: Control what users can enter.
Advanced Charts: Create combination charts and dynamic charts.
Power Query: Import and transform data from external sources.
Macros: Automate repetitive tasks.
What-If Analysis: Use scenarios and goal seek.

How to prepare for Level Two:

Practice all the skills from Level One.
Create your own spreadsheets to track things you care about.
Explore Excel and try new features.

You are on your way to becoming an Excel expert. Keep learning and practicing!

2

Module One

Module 1: Getting Started with Microsoft Excel

📊 Module 1: Getting Started with Microsoft Excel

📖 Module Introduction

Welcome to Module 1 of our "Certified Microsoft Excel Expert Level One" course!

Have you ever seen a spreadsheet and wondered what it is? Have you ever wanted to organize information like a pro? Microsoft Excel is the tool that makes all of that possible. This is where your Excel journey begins!

What is Microsoft Excel?

Microsoft Excel is a computer program that helps you organize, calculate, and analyze information. It is like a giant digital grid made up of boxes called cells. You can put numbers, words, and formulas into these cells. Excel can do math for you, create beautiful charts, and help you make sense of data.

Why is Excel important?

Excel is used all over the world – in schools, businesses, government offices, and even at home. People use Excel to:

Create budgets and track spending.
Organize lists of information (like student grades or customer contacts).
Calculate totals, averages, and other math problems automatically.
Create charts and graphs to visualize data.
Analyze data to make better decisions.

What will you learn in this module?

In this module, we will start from the very beginning. We will learn what Excel is, how to open it, and how to find our way around. We will learn about workbooks, worksheets, cells, rows, and columns. We will learn how to enter data, save our work, and open it again. By the end of this module, you will be ready to create your very first spreadsheet!

So, are you ready to become an Excel expert? Let's begin!

🎯 Learning Objectives

By the end of this module, you will be able to:

Explain what Microsoft Excel is and what it is used for.
Open and close Microsoft Excel on a computer.
Identify and name the main parts of the Excel window.
Understand the difference between a workbook and a worksheet.
Understand the concept of cells, rows, and columns.
Select and navigate between cells.
Enter and edit data in cells.
Save a workbook with a name you choose.
Open a saved workbook again.
Create a new workbook.
Explain why saving your work is very important.