A handsâon introduction to using AI assistance for data cleaning, formula generation, analysis, and visualization â designed for Excel users who are new to Copilot.
Each handsâon exercise serves as formative assessment.
Given a raw dataset, learners complete a full cycle: clean â analyse â visualise â summarise.
In the capstone, assess whether learners validate Copilot output for reasonableness.
Hello, young explorer! Welcome to the very first module of your journey into the amazing world of CoPilot in Microsoft Excel.
Have you ever wished that your computer could understand what you want just by you telling it in normal words? Like saying, "Please add up all my pocket money," and the computer does it for you? Well, that is exactly what CoPilot does inside Microsoft Excel!
Microsoft Excel is a program that helps people work with numbers, lists, and information. It looks like a giant grid of boxes called cells. People use Excel to track money, keep scores, plan events, and do many other things.
CoPilot is like a friendly robot helper that lives inside Excel. You talk to it in plain English, and it does the hard work for you. It can write formulas, clean up messy data, make charts, and even explain what is happening in your spreadsheet.
In this module, you will learn what CoPilot is, why it is useful, and how to get it ready to work. You do not need to know anything about CoPilot before starting. Just bring your curiosity!
This module is written especially for beginners. Every big word will be explained in simple language. Every idea will come with examples you can understand. Let us begin this exciting adventure together!
By the end of this module, you will be able to:
Once upon a time, in the busy city of Lagos, Nigeria, there lived a clever girl named Ada. Ada was thirteen years old and loved helping her mother in their small shop.
Every evening, Ada's mother would write down all the sales from the day in a big notebook. Then she would use a calculator to add everything up. It took a very long time. Sometimes she made mistakes and had to start all over again.
One day, Ada's older cousin Chidi came to visit. Chidi worked in an office and knew a lot about computers.
"Ada," said Chidi, "why don't you use Microsoft Excel to keep your mother's sales records?"
Ada frowned. "I tried once. But there are so many buttons and formulas. It is confusing."
Chidi smiled. "Have you heard about CoPilot?"
"What is CoPilot?" asked Ada.
"It is like a magic helper inside Excel," said Chidi. "You just tell it what you want in normal words, and it does the work for you."
Ada's eyes grew wide. "Really? Like a genie?"
"Almost!" laughed Chidi. "But instead of three wishes, you can ask it as many things as you want. Let me show you."
Chidi opened Excel on his laptop. He typed some numbers into the cells. Then he clicked a button that said "CoPilot." A small panel opened on the right side of the screen.
"Watch this," said Chidi. He typed: "Add up all the numbers in column B."
A moment later, CoPilot showed the total. Then Chidi typed: "Make a chart showing these numbers."
Instantly, a beautiful bar chart appeared on the screen.
Ada could not believe her eyes. "This is amazing! Can it help my mother?"
"Of course," said Chidi. "It can add, subtract, make charts, clean up messy lists, and even explain what the numbers mean."
That night, Ada went home and told her mother all about CoPilot. Her mother was very happy. "Tomorrow," she said, "we will try this magic helper together."
And that is how Ada began her journey with CoPilot. Now it is your turn. Are you ready to meet your own magic helper?
Ada's Problem CoPilot's Help ----------------- ----------------- | Many numbers | | Just ask in | | to add up | -----------> | plain English | | Takes long | | CoPilot does | | Mistakes easy | | it fast! | ----------------- -----------------
Definition: Microsoft Excel is a computer program made by Microsoft. It helps you work with numbers, lists, and information using a grid of boxes called cells.
Why it is important: People all over the world use Excel to keep track of money, scores, plans, and much more. It is one of the most useful programs for school, work, and home.
Simple explanation: Imagine a giant sheet of paper with rows and columns. Each small box where a row and column meet is called a cell. You can type numbers, words, or dates into these cells. Excel can then do math with those numbers.
Real-life example: A shop owner uses Excel to record daily sales. A teacher uses Excel to record student scores. A football coach uses Excel to track player statistics.
School example: Your teacher might use Excel to calculate your class average. Each student's score goes in a cell, and Excel adds them up and divides by the number of students.
Home example: Your parents might use Excel to plan a family budget. They list all the money coming in and all the money going out.
Nigerian example: A trader at Balogun Market in Lagos uses Excel to track how many bags of rice she sells each day and how much profit she makes.
Illustration:
Microsoft Excel Window +-------------------------------------------+ | A B C D E | +-------------------------------------------+ | 1 Name Score Grade | | 2 Ada 85 A | | 3 Chidi 72 B | | 4 Ngozi 91 A | | 5 Emeka 68 C | +-------------------------------------------+
Mini summary: Excel is a grid of cells where you can store and work with information. It is used everywhere for tracking and calculating.
Definition: CoPilot is an artificial intelligence (AI) helper made by Microsoft. It lives inside programs like Excel and helps you do tasks by understanding your normal language.
Why it is important: CoPilot saves time and reduces mistakes. You do not need to memorise complicated formulas or menu locations. Just tell CoPilot what you want.
Simple explanation: Think of CoPilot as a smart friend who sits next to you while you work. You say, "Please add these numbers," and your friend does it. CoPilot is that friend, but inside your computer.
Real-life example: When you type a message on your phone and it suggests the next word, that is AI helping you. CoPilot is similar but much more powerful and works inside Excel.
School example: Imagine you have a list of your classmates' birthdays. You can ask CoPilot, "Which month has the most birthdays?" and it will tell you.
Home example: Your family is planning a party. You list all the items to buy in Excel. You can ask CoPilot, "What is the total cost?" and it will add everything up.
Nigerian example: A student in Abuja uses CoPilot to help track her WAEC study timetable. She asks, "How many hours am I studying each week?" and CoPilot calculates it.
Illustration:
You: "Add up column B"
|
V
+----------------+
| CoPilot |
| (AI Helper) |
+----------------+
|
V
Result: 316
Mini summary: CoPilot is an AI helper inside Excel. You talk to it in plain English, and it does tasks for you.
Definition: A search engine like Google helps you find information on the internet. CoPilot does not search the internet for you. Instead, it works with the data inside your Excel file.
Why it is important: Many people think CoPilot is like Google. It is not. CoPilot reads your spreadsheet and performs actions on your data.
Simple explanation: Google finds websites. CoPilot finds answers inside your own workbook. Google says, "Here are some links." CoPilot says, "Here is the total of your sales column."
Real-life example: If you ask Google, "What is the capital of Nigeria?" it will show you websites. If you ask CoPilot in Excel, "What is the total in column C?" it will calculate using your data.
School example: You would not ask Google to calculate your test average from your own marks. You would ask CoPilot because it can see your marks in the spreadsheet.
Home example: You would not ask Google how much money your family spent on food last month. You would ask CoPilot because it can read your family budget file.
Nigerian example: If you want to know how many customers visited your aunt's shop in December, you ask CoPilot in Excel, not Google. Google does not know your aunt's sales records.
Illustration:
+-------------------+ +-------------------+ | Search Engine | | CoPilot | +-------------------+ +-------------------+ | Finds websites | | Reads your data | | Needs internet | | Works in Excel | | Gives links | | Gives answers | +-------------------+ +-------------------+
Mini summary: Search engines find information online. CoPilot works with your own data inside Excel.
Definition: CoPilot in Excel can perform many tasks. It can create formulas, clean data, make charts, sort lists, create PivotTables, and explain what your data means.
Why it is important: Knowing what CoPilot can do helps you decide when to ask for help. It is like knowing what tools are in a toolbox.
Simple explanation: CoPilot is a multiâtalented helper. It can do maths, art (charts), cleaning (fixing messy data), and explaining (telling you what it sees).
Real-life example: A small business owner uses CoPilot to calculate total monthly profit. He simply says, "What is my total profit for January?" and CoPilot answers.
School example: A student uses CoPilot to create a pie chart showing how she spends her study time across different subjects.
Home example: Your family uses CoPilot to highlight all the expenses that are above âŚ5,000 in a budget spreadsheet.
Nigerian example: A youth corper in Enugu uses CoPilot to summarise the number of items donated during a community project.
Illustration:
CoPilot's Talents +---------------------------+ | 1. Create formulas | | 2. Clean messy data | | 3. Make charts | | 4. Sort and filter | | 5. Create PivotTables | | 6. Explain data | +---------------------------+
| Task | What You Say to CoPilot | What CoPilot Does |
|---|---|---|
| Add numbers | "Add up column D" | Calculates the total |
| Make a chart | "Create a bar chart of these scores" | Inserts a chart |
| Clean data | "Fix inconsistent spacing in column A" | Cleans the text |
| Explain | "What does this formula do?" | Describes the formula |
Mini summary: CoPilot can create formulas, clean data, make charts, sort lists, build PivotTables, and explain data.
Definition: CoPilot is powerful, but it has limits. It cannot think like a human. It cannot always know if its answer is correct. It cannot invent new features that Excel does not have.
Why it is important: Knowing the limits helps you use CoPilot safely. You must always check its work.
Simple explanation: CoPilot is like a calculator. It gives an answer, but you should check if the answer makes sense. If you type wrong numbers, the calculator gives a wrong answer. CoPilot is the same.
Real-life example: If your data has missing numbers, CoPilot might give a total that is too low. You need to notice that some cells are empty.
School example: If you ask CoPilot to find the average score, but one score is typed as text instead of a number, the average will be wrong. You must check.
Home example: If your budget list has a typo, CoPilot might calculate a wrong total. Always doubleâcheck.
Nigerian example: If a market trader enters "5000" in one row and "5,000" in another, CoPilot might treat them differently. The data must be consistent.
Illustration:
CoPilot says: "The total is âŚ45,000"
|
V
You check: "Wait, one cell is empty!"
|
V
You fix the data and ask again
|
V
CoPilot says: "The total is âŚ50,000" (correct)
Mini summary: CoPilot can be wrong if data is messy or missing. Always verify its output.
Definition: To use CoPilot in Excel, you need a few things: a Microsoft 365 account with CoPilot, an internet connection, and your file saved to OneDrive or SharePoint.
Why it is important: Without these, CoPilot will not appear or work. It is like needing fuel before driving a car.
Simple explanation: CoPilot is a special feature. Not every Excel has it. You need the right version and a proper account.
Real-life example: You cannot watch a video on a phone with no battery. You cannot use CoPilot without the right subscription.
School example: Some schools have a special computer lab with CoPilot enabled. Others do not. It depends on the school's Microsoft licence.
Home example: If your family uses the free version of Excel, CoPilot may not be available. You need Microsoft 365 with CoPilot.
Nigerian example: A small business in Port Harcourt subscribes to Microsoft 365 Business with CoPilot so their accountant can work faster.
Illustration:
Requirements Checklist +-------------------------------+ | [ ] Microsoft 365 account | | [ ] CoPilot licence | | [ ] Internet connection | | [ ] File saved to OneDrive | | [ ] AutoSave turned on | +-------------------------------+
| Requirement | Why You Need It |
|---|---|
| Microsoft 365 account | CoPilot only works with a valid subscription |
| CoPilot licence | Some plans include CoPilot, others need an addâon |
| Internet connection | CoPilot uses cloud AI, so it needs internet |
| File on OneDrive | CoPilot reads cloudâsaved files best |
| AutoSave on | Keeps your file synced so CoPilot sees changes |
Mini summary: You need Microsoft 365 with CoPilot, internet, and a OneDriveâsaved file with AutoSave.
Definition: Checking if you have CoPilot means looking for the CoPilot button or icon in Excel.
Why it is important: If you do not have CoPilot, you cannot use it. Knowing helps you ask a parent, teacher, or IT person for help.
Simple explanation: Open Excel. Look at the top ribbon. Do you see a button that says "CoPilot"? Or look at the bottomâright corner for a small icon. If you see it, you have CoPilot.
Real-life example: It is like checking if your phone has a particular app. You look for the icon.
School example: Your teacher can show you where the CoPilot button is on the class computer.
Home example: Ask your parents to help you check the Microsoft account settings to see if CoPilot is included.
Nigerian example: A student in Kano checks his school laptop and finds the CoPilot icon. He is excited to try it.
Illustration:
Excel Ribbon (top of screen)
+-------------------------------------------+
| Home | Insert | Draw | ... | CoPilot |
+-------------------------------------------+
^
|
Look for this button
Mini summary: Look for the CoPilot button on the Home tab or the icon at the bottomâright of Excel.
Definition: OneDrive is Microsoft's cloud storage. It is like a safe online folder where your files live. Saving to OneDrive means your file is stored on the internet, not just on your computer.
Why it is important: CoPilot works best with files saved on OneDrive. It can read the latest version and make changes that sync everywhere.
Simple explanation: Imagine your file is a book. If you keep it only on your desk, only you can read it. If you put it in a shared online library (OneDrive), CoPilot can also read it and help you.
Real-life example: When you save a photo to Google Photos, it is in the cloud. OneDrive is similar but for Microsoft files.
School example: Your teacher saves the class spreadsheet to OneDrive so all students can see it and CoPilot can help everyone.
Home example: Your family saves the monthly budget to OneDrive so everyone can access it from their phones.
Nigerian example: A Lagosâbased freelancer saves client invoices to OneDrive so she can work from any computer and use CoPilot.
Illustration:
Your Computer OneDrive Cloud
+--------------+ +--------------+
| Excel File | -- AutoSave -->| Excel File |
| (local) | | (online) |
+--------------+ +--------------+
|
V
CoPilot can
read and help
Stepâbyâstep:
Mini summary: Save your file to OneDrive and turn on AutoSave so CoPilot can help you.
Definition: The CoPilot panel is a side window inside Excel where you type your requests and see CoPilot's answers.
Why it is important: This is where all the magic happens. You must open the panel before you can talk to CoPilot.
Simple explanation: Think of the panel as a chat window. It is like WhatsApp, but instead of chatting with a friend, you chat with CoPilot.
Real-life example: When you open a chat app, you see a text box. The CoPilot panel also has a text box where you type.
School example: Your teacher opens the CoPilot panel on the projector and shows the whole class how to ask questions.
Home example: You open the CoPilot panel on your family laptop and ask it to add up the grocery costs.
Nigerian example: A student in Ibadan opens the CoPilot panel and asks, "How many students scored above 70?"
Illustration:
Excel Screen with CoPilot Panel Open +-----------------------------+-------------------+ | A B C | CoPilot | | 1 Name Score | +-------------+ | | 2 Ada 85 | | Type here: | | | 3 Chidi 72 | +-------------+ | | 4 Ngozi 91 | | | | CoPilot: Hello! | | | How can I help? | +-----------------------------+-------------------+
Stepâbyâstep:
Mini summary: Click the CoPilot button on the Home tab to open the chat panel on the right.
Definition: CoPilot has three modes: Edit, Chat, and Plan. Each mode does something different.
Why it is important: Choosing the right mode helps you work safely. Some modes change your data. Others do not.
Simple explanation: Think of a traffic light. Green means go (Edit). Yellow means caution (Plan). Red means stop and think (Chat).
Real-life example: When you take a photo, you can choose different camera modes: portrait, landscape, or night. CoPilot also has different modes for different jobs.
School example: In Chat mode, CoPilot answers your question without changing your marks. In Edit mode, it might add a new column.
Home example: In Plan mode, CoPilot tells you the steps it will take before doing anything. You can say "yes" or "no."
Nigerian example: A business owner uses Chat mode to ask, "What is my bestâselling product?" without changing the sales file.
Illustration:
+----------------+----------------+----------------+ | EDIT MODE | CHAT MODE | PLAN MODE | +----------------+----------------+----------------+ | Changes data | Only answers | Shows steps | | Adds columns | No changes | Waits for OK | | Makes charts | Safe to ask | Then acts | +----------------+----------------+----------------+
| Mode | What It Does | When to Use It |
|---|---|---|
| Edit | Makes changes to your workbook | When you want CoPilot to add or fix something |
| Chat | Answers questions only | When you want information without changes |
| Plan | Describes steps before acting | When you want to review before changes |
Mini summary: Edit changes data, Chat only answers, Plan shows steps first.
Definition: Knowing when to use each mode is a skill. It helps you avoid mistakes.
Why it is important: Using Edit mode when you only wanted an answer could change your data unexpectedly. Using Chat mode when you wanted a change means nothing happens.
Simple explanation: Use Chat when you are curious. Use Edit when you are ready for changes. Use Plan when you want to be careful.
Real-life example: Before you delete a file, your computer asks, "Are you sure?" Plan mode is like that question.
School example: Ask "How many students passed?" in Chat mode. Then say "Add a Pass/Fail column" in Edit mode.
Home example: Ask "What is the total?" in Chat mode. Then say "Highlight all amounts over âŚ10,000" in Edit mode.
Nigerian example: A trader asks in Chat mode, "Which day had the most sales?" Then uses Edit mode to add a "Profit" column.
Illustration:
Question: "How many sales?"
|
V
+-----------+
| CHAT | --> Answers only
+-----------+
Request: "Add a total row"
|
V
+-----------+
| EDIT | --> Changes file
+-----------+
Big task: "Create a full report"
|
V
+-----------+
| PLAN | --> Shows steps first
+-----------+
Mini summary: Chat for questions, Edit for changes, Plan for big tasks with review.
Definition: A prompt is the message you type to CoPilot. It is what you ask or tell CoPilot to do.
Why it is important: Good prompts get good results. Clear prompts help CoPilot understand you.
Simple explanation: A prompt is like giving instructions to a friend. If you say, "Do the thing," your friend is confused. If you say, "Please add column B," your friend knows what to do.
Real-life example: When you order food, you say, "I want rice and chicken." You do not say, "Give me food." Be specific.
School example: Instead of "Fix my marks," say, "Add a new column called Total that adds Math and English scores."
Home example: Instead of "Sort this," say, "Sort the list by price from highest to lowest."
Nigerian example: A student in Abuja says, "Create a pie chart showing how I spend my study time across five subjects."
Illustration:
Poor Prompt: "Do something"
|
V
CoPilot: "I don't understand."
Good Prompt: "Add up all numbers in column C"
|
V
CoPilot: "The total is 245."
| Poor Prompt | Better Prompt |
|---|---|
| "Fix it" | "Remove extra spaces from names in column A" |
| "Make a chart" | "Create a bar chart of scores in column B" |
| "Add numbers" | "Add up all values in the Sales column" |
Mini summary: A prompt is your instruction. Be clear and specific for best results.
Definition: CoPilot is a tool. It helps you but does not think for you. You are still the boss.
Why it is important: You must check CoPilot's work. You must decide if the answer makes sense. CoPilot can make mistakes.
Simple explanation: A calculator helps you do maths, but you still need to know which numbers to type. CoPilot helps you in Excel, but you still need to understand your data.
Real-life example: A GPS helps you drive, but you still watch the road. CoPilot helps you with Excel, but you still check the results.
School example: CoPilot can calculate your average, but you should check if all your scores were entered correctly.
Home example: CoPilot can total your budget, but you should confirm that every expense was listed.
Nigerian example: A trader uses CoPilot to total daily sales, but she still counts the cash to make sure it matches.
Illustration:
You -----> CoPilot -----> Answer
^ |
| |
+-------- Check --------------+
(You verify)
Mini summary: CoPilot is a helper, not the boss. Always check its work.
Definition: Data safety means protecting your information. It means not sharing private details with people who should not see them.
Why it is important: CoPilot reads your file. If your file has private information, you must be careful who can access it.
Simple explanation: Your OneDrive file can be shared. Only share with people you trust. Do not put passwords or private family details in a shared Excel file.
Real-life example: You would not write your ATM PIN on a piece of paper and leave it on a table. Do not put private data in a shared spreadsheet.
School example: The class spreadsheet should not contain students' home addresses unless the teacher says it is safe.
Home example: The family budget file should only be shared with family members.
Nigerian example: A business should not share its customer list with competitors. Keep CoPilot files in a secure OneDrive folder.
Illustration:
Safe: Not Safe: +----------------+ +----------------+ | Shared with | | Shared with | | family only | | everyone | +----------------+ +----------------+
Mini summary: Keep private data safe. Share your OneDrive files only with trusted people.
Definition: Getting ready means having everything in place: the right account, the file saved, the panel open, and a clear question in mind.
Why it is important: Preparation prevents frustration. When you are ready, using CoPilot is easy and fun.
Simple explanation: Before you cook, you gather your ingredients. Before you use CoPilot, you gather your data and open the right tools.
Real-life example: Before a football match, players warm up. Before using CoPilot, you warm up by checking your setup.
School example: Your teacher asks everyone to open Excel, save to OneDrive, and open CoPilot before the lesson begins.
Home example: You open the family budget file, turn on AutoSave, and click CoPilot. Now you are ready.
Nigerian example: A student in Kaduna prepares her study timetable in Excel, saves to OneDrive, and asks CoPilot to add up her study hours.
Illustration:
Ready Checklist +-------------------------------+ | [x] Microsoft 365 with CoPilot| | [x] File saved to OneDrive | | [x] AutoSave ON | | [x] CoPilot panel open | | [x] Clear question in mind | +-------------------------------+
Mini summary: Prepare your account, file, and question before starting. Then you are ready to go!
| Word | Simple Definition |
|---|---|
| Microsoft Excel | A computer program with a grid of cells for working with numbers and lists. |
| Cell | One small box in Excel where you type information. |
| CoPilot | An AI helper inside Microsoft programs that understands normal language. |
| Artificial Intelligence (AI) | Computer programs that can learn and make decisions like humans. |
| Prompt | The message you type to CoPilot to tell it what you want. |
| OneDrive | Microsoft's online storage where files are kept on the internet. |
| AutoSave | A feature that automatically saves your work as you type. |
| Formula | A mathematical instruction in Excel, like =A1+B1. |
| PivotTable | A tool in Excel that summarises large amounts of data quickly. |
| Chart | A picture that shows data, like a bar chart or pie chart. |
| Data | Information, such as numbers, names, or dates. |
| Mode | A way of working. CoPilot has three modes: Edit, Chat, and Plan. |
| Edit Mode | CoPilot changes your workbook directly. |
| Chat Mode | CoPilot answers questions without changing data. |
| Plan Mode | CoPilot shows steps before doing anything. |
| Subscription | A paid plan that gives you access to features like CoPilot. |
| Cloud | Online storage on the internet, not on your computer's hard drive. |
| Verify | To check if something is correct. |
| Ribbon | The bar at the top of Excel with tabs like Home, Insert, and Draw. |
| Panel | A side window inside Excel where you chat with CoPilot. |
CoPilot helps you work faster, but you are still in charge. You must check its work and make final decisions.
The clearer your prompt, the better CoPilot understands. Be specific about columns, rows, and what you want.
If your data is messy, CoPilot's answers will be messy. Clean data gives clean results. This is called "Garbage In, Garbage Out."
Edit mode changes data. Chat mode answers questions. Plan mode shows steps. Choose wisely.
Keep private data safe. Only share OneDrive files with people you trust.
Before using CoPilot, make sure you have the right account, the file is saved to OneDrive, and AutoSave is on.
Mrs. Okafor runs a small shop in Surulere, Lagos. She records daily sales in Excel. Every evening, she asks CoPilot, "What is my total sales for today?" CoPilot adds up the column and gives the answer. Mrs. Okafor saves time and avoids mistakes.
Emeka is preparing for his JAMB exam. He tracks his practice test scores in Excel. He asks CoPilot, "What is my average score?" CoPilot calculates it. Emeka can see if he is improving.
Coach Musa tracks his team's goals and assists in Excel. He asks CoPilot, "Which player scored the most goals?" CoPilot finds the answer quickly.
The Adeyemi family plans their monthly budget in Excel. They ask CoPilot, "How much did we spend on food?" CoPilot adds up the food expenses.
A trader sells fabrics at Balogun Market. She records each sale in Excel. She asks CoPilot, "How many yards of lace did I sell this week?" CoPilot calculates the total.
A student in Ibadan tracks her WAEC subject scores in Excel. She asks CoPilot, "What is my average score in the sciences?" CoPilot gives the answer.
A youth corper in Enugu plans a community project. He lists expenses in Excel. He asks CoPilot, "What is the total cost?" CoPilot adds everything up.
A small business owner in Abuja tracks customer orders in Excel. She asks CoPilot, "Which product sold the most last month?" CoPilot finds the bestâselling product.
You receive pocket money every week. You record it in Excel. You ask CoPilot, "How much have I saved this month?" CoPilot adds it up.
You and your friends play a video game. You record everyone's scores in Excel. You ask CoPilot, "Who has the highest score?" CoPilot tells you.
You collect football cards. You list them in Excel with their values. You ask CoPilot, "What is my collection worth?" CoPilot adds the values.
You plan your birthday party. You list all the items you need in Excel. You ask CoPilot, "What is the total cost?" CoPilot calculates it.
| Situation | What You Ask CoPilot |
|---|---|
| Tracking chores | "How many chores did I complete this week?" |
| Planning a trip | "What is the total cost of our trip?" |
| Recording exercise | "How many minutes did I exercise this month?" |
| Saving money | "How much have I saved so far?" |
| Tracking reading | "How many books did I read this year?" |
| Mistake | Why It Is a Problem | How to Avoid It |
|---|---|---|
| Using CoPilot without saving to OneDrive | CoPilot may not work properly | Save to OneDrive and turn on AutoSave first |
| Asking vague questions | CoPilot gives vague or wrong answers | Be specific about columns and what you want |
| Not checking CoPilot's answers | Mistakes go unnoticed | Always verify the output |
| Using Edit mode when you only want an answer | Data changes unexpectedly | Use Chat mode for questions |
| Putting private data in a shared file | Privacy is lost | Only share with trusted people |
| Giving up after one try | You miss the benefit | Rephrase and try again |
+-------+-------+-------+-------+ | A | B | C | D | +-------+-------+-------+-------+ | Name | Math | Eng | Total | +-------+-------+-------+-------+ | Ada | 85 | 90 | 175 | +-------+-------+-------+-------+ | Chidi | 72 | 68 | 140 | +-------+-------+-------+-------+ | Ngozi | 91 | 88 | 179 | +-------+-------+-------+-------+
You have a question
|
V
Open CoPilot panel
|
V
Type your prompt
|
V
CoPilot processes
|
V
CoPilot gives answer
|
V
You check the answer
|
V
Correct? --Yes--> Done!
|
No
|
V
Fix data or rephrase
|
V
Ask again
+----------------+----------------+----------------+ | EDIT MODE | CHAT MODE | PLAN MODE | +----------------+----------------+----------------+ | Changes data | Only answers | Shows steps | | Adds columns | No changes | Waits for OK | | Makes charts | Safe to ask | Then acts | +----------------+----------------+----------------+
Your Computer OneDrive Cloud
+--------------+ +--------------+
| Excel File | -- AutoSave -->| Excel File |
| (local) | | (online) |
+--------------+ +--------------+
|
V
CoPilot can
read and help
1979 - VisiCalc (first spreadsheet)
|
1985 - Microsoft Excel 1.0 released
|
1993 - Excel 5.0 with VBA
|
2007 - Excel 2007 with ribbon
|
2013 - Excel 2013 with cloud
|
2023 - CoPilot introduced
|
2024 - CoPilot improved
|
2025 - You are here!
| Feature | Edit Mode | Chat Mode | Plan Mode |
|---|---|---|---|
| Changes data? | Yes | No | Only after approval |
| Safe for questions? | No | Yes | Yes |
| Shows steps first? | No | No | Yes |
| Best for | Making changes | Getting answers | Big tasks |
| Can Do | Cannot Do |
|---|---|
| Create formulas | Think like a human |
| Clean data | Guarantee correct answers |
| Make charts | Invent new Excel features |
| Explain data | Replace your judgment |
| Sort and filter | Work without internet |
| Create PivotTables | Read your mind |
Excel is a grid of cells for working with numbers and lists. It is used everywhere.
CoPilot is an AI helper inside Excel. You talk to it in plain English.
Search engines find websites. CoPilot works with your own data in Excel.
CoPilot can create formulas, clean data, make charts, sort lists, create PivotTables, and explain data.
CoPilot can be wrong. Always check its work.
You need Microsoft 365 with CoPilot, internet, and a OneDrive file with AutoSave.
Look for the CoPilot button on the Home tab or the icon at the bottomâright.
Save your file to OneDrive and turn on AutoSave.
Click the CoPilot button to open the chat panel on the right.
Edit changes data. Chat only answers. Plan shows steps first.
Chat for questions, Edit for changes, Plan for big tasks.
A prompt is your instruction. Be clear and specific.
CoPilot is a helper, not the boss. Always check its work.
Keep private data safe. Share only with trusted people.
Prepare your account, file, and question before starting.
In this module, you learned what CoPilot in Microsoft Excel is. You learned that CoPilot is an AI helper that lives inside Excel. You talk to it in normal English, and it does tasks for you.
You learned that CoPilot can create formulas, clean messy data, make charts, sort lists, create PivotTables, and explain what your data means. You also learned that CoPilot is not always right, so you must check its work.
You learned the requirements for using CoPilot: Microsoft 365 with CoPilot, internet, a OneDrive file, and AutoSave turned on. You learned how to check if you have CoPilot, how to save to OneDrive, and how to open the CoPilot panel.
You learned about the three modes: Edit, Chat, and Plan. Edit changes data. Chat only answers questions. Plan shows steps before acting.
You learned how to write a good prompt. Be clear and specific. You learned that CoPilot is a helper, not a replacement. You are still in charge.
You learned about data safety. Keep private information safe. Share only with trusted people.
Finally, you learned how to get ready for your first task. Prepare your account, file, and question. Then you are ready to go!
Match the word on the left with the correct definition on the right.
| Word | Definition |
|---|---|
| 1. CoPilot | A. Online storage for files |
| 2. OneDrive | B. AI helper inside Excel |
| 3. Prompt | C. Changes data directly |
| 4. Edit Mode | D. The message you type to CoPilot |
| 5. Chat Mode | E. Shows steps before acting |
| 6. Plan Mode | F. Only answers questions |
Answers: 1âB, 2âA, 3âD, 4âC, 5âF, 6âE
You help run the school store. You record sales in Excel. You want to know the total sales for the week. What do you ask CoPilot? Which mode do you use?
You plan a birthday party. You list all items and costs in Excel. You want to know the total cost. What do you ask CoPilot? Which mode?
You track your football team's goals in Excel. You want to know who scored the most. What do you ask CoPilot? Which mode?
Your family lists monthly expenses in Excel. You want to highlight all expenses over âŚ10,000. What do you ask CoPilot? Which mode?
You track your study hours in Excel. You want a pie chart showing time per subject. What do you ask CoPilot? Which mode?
Goal: Work in groups of 3â4 to explore CoPilot features.
Steps:
Discussion: What did CoPilot do well? What did it get wrong? Why?
Goal: Practice using CoPilot on your own.
Steps:
Goal: Create a simple pocket money tracker using Excel and CoPilot.
Steps:
Deliverable: A working Excel file with a balance column, totals, and a chart.
Instructions: Complete the following tasks in Excel using CoPilot. Write down what you asked and what CoPilot did.
Submission: Share your Excel file and a short report of what you learned.
In the next module, you will learn how to use CoPilot to clean and prepare data. You will learn how to fix messy data, remove duplicates, and format your spreadsheet so CoPilot can work even better.
Before the next module, please make sure you can:
If you can do these things, you are ready for Module Two: Data Preparation and Cleaning with CoPilot.
See you in the next module, young explorer! Keep practicing and stay curious.
End of Module One
Welcome back, young explorer! In Module One, you met CoPilot, your friendly AI helper inside Microsoft Excel. You learned how to set it up and ask your first questions. Now it is time to roll up your sleeves and get to work.
In this module, you will learn how to prepare and clean data using CoPilot. Data is just another word for information. It can be names, numbers, dates, or anything else you store in Excel.
Have you ever seen a messy room? Clothes on the floor, books on the bed, and toys everywhere. It is hard to find anything. Messy data is the same. When your Excel sheet is messy, it is hard to work with. CoPilot can help you tidy it up.
Think of CoPilot as a superâfast cleaner. It can fix spelling mistakes, remove extra spaces, change how numbers look, find duplicates, and much more. All you have to do is ask.
By the end of this module, you will be able to take a messy spreadsheet and turn it into a clean, organised table. You will also learn why clean data is so important and how to avoid common mistakes.
Let us begin. Your data is waiting to be cleaned!
By the end of this module, you will be able to:
Chidi is a thirteenâyearâold boy who lives in Port Harcourt, Nigeria. His mother owns a small shop that sells drinks and snacks. Every day, Chidi helps his mother record what they sell.
One Saturday morning, Chidi's mother said, "Chidi, please use the computer to record today's sales. My notebook is full."
Chidi opened Excel and started typing. He typed the name of each item, the quantity sold, and the price. But he was in a hurry because his friends were waiting to play football.
He typed "coke" in one row and "Coke" in another. He typed "50" in one row and "50 " (with an extra space) in another. He even typed "05/03/2025" in one row and "March 5, 2025" in another.
The next day, Chidi's mother looked at the spreadsheet. She wanted to know how many bottles of Coke were sold. But when she searched for "Coke," she only found some of them. The others were hidden under "coke" or "COKE."
"Chidi," she said, "this data is messy. I cannot get the right answer."
Chidi felt bad. He wanted to help, but his messy typing made things worse.
Just then, Chidi's older sister Ngozi walked in. She was studying computer science at university. "Don't worry," she said. "I can show you how to use CoPilot to clean this up."
Ngozi opened the CoPilot panel and typed, "Fix inconsistent capitalisation in the Item column."
A moment later, CoPilot changed all the "coke" and "COKE" entries to "Coke." It also removed extra spaces from the numbers.
"Wow!" said Chidi. "It fixed everything in seconds!"
"CoPilot is great at cleaning data," said Ngozi. "But you must always check its work. And next time, try to type carefully."
Chidi learned two lessons that day. First, clean data is important. Second, CoPilot can help you clean it quickly.
Now it is your turn. Are you ready to learn how to clean data with CoPilot?
Messy Data CoPilot Cleaning +----------------+ +----------------+ | coke | | Coke | | Coke | -----> | Coke | | COKE | | Coke | | 50 | | 50 | | 50 (space) | | 50 | +----------------+ +----------------+
Definition: Data preparation means getting your information ready to be used. It includes typing it correctly, organising it in rows and columns, and making sure everything is in the right place.
Why it is important: If your data is not prepared properly, CoPilot and Excel cannot give you correct answers. Good preparation saves time and prevents mistakes.
Simple explanation: Imagine you are baking a cake. Before you start, you gather all your ingredients. You measure the flour. You crack the eggs. You preheat the oven. That is preparation. Data preparation is the same. You get your information ready before you analyse it.
Real-life example: A shop owner writes down every sale in a notebook. Before adding up the totals, she makes sure every price is written correctly.
School example: Your teacher collects test scores. Before calculating the class average, she checks that every student's score is entered in the right row.
Home example: Your family plans a budget. Before adding up expenses, you make sure every expense is listed in the correct column.
Nigerian example: A trader at Onitsha Main Market records the number of bags of rice sold each day. She makes sure the numbers are written clearly before calculating weekly totals.
Illustration:
Data Preparation Steps +---------------------------+ | 1. Gather information | | 2. Type it in correctly | | 3. Organise in rows/cols | | 4. Check for mistakes | | 5. Ready to use! | +---------------------------+
Mini summary: Data preparation is getting your information ready. It includes typing correctly and organising in rows and columns.
Definition: Data cleaning means fixing mistakes in your data. It includes removing extra spaces, fixing capital letters, correcting number formats, and removing duplicate rows.
Why it is important: Messy data gives wrong answers. If "Coke" and "coke" are treated as different items, your totals will be wrong. Cleaning fixes this.
Simple explanation: Imagine you have a pile of dirty clothes. Before you wear them, you wash them. Data cleaning is like washing your data. You remove the dirt (mistakes) so it is clean and ready to use.
Real-life example: A bank cleans its customer list to remove duplicate names. This prevents sending the same letter twice.
School example: A teacher cleans the attendance list to remove students who have left the school.
Home example: Your family cleans the shopping list to remove items you already bought.
Nigerian example: A business in Lagos cleans its customer database to remove old phone numbers and fix spelling mistakes in names.
Illustration:
Dirty Data Clean Data +----------------+ +----------------+ | Ada | | Ada | | ada (extra sp) | -----> | Ada | | ADA | | Ada | | Chidi | | Chidi | | Chidi (dupl) | | (removed) | +----------------+ +----------------+
Mini summary: Data cleaning means fixing mistakes in your data. It removes extra spaces, fixes capitals, and removes duplicates.
Definition: Clean data is data that is correct, consistent, and complete. It has no spelling mistakes, no extra spaces, no duplicates, and no missing values.
Why it is important: Clean data gives correct answers. Messy data gives wrong answers. This is called "Garbage In, Garbage Out."
Simple explanation: If you put dirty water into a clean cup, the cup becomes dirty. If you put messy data into Excel, the answers become messy. Clean data gives clean answers.
Real-life example: A doctor needs clean patient records. If a patient's blood type is recorded wrongly, it could be dangerous.
School example: If your exam scores are entered wrongly, your final grade will be wrong.
Home example: If your family budget has a wrong number, you might think you have more money than you really do.
Nigerian example: A market trader who records "âŚ500" and "500" in different rows will get a wrong total. The data must be consistent.
Illustration:
Garbage In, Garbage Out +----------------+ +----------------+ | Messy Data | -----> | Wrong Answers | +----------------+ +----------------+ +----------------+ +----------------+ | Clean Data | -----> | Right Answers | +----------------+ +----------------+
| Type of Data | Result |
|---|---|
| Messy | Wrong answers |
| Clean | Correct answers |
Mini summary: Clean data gives correct answers. Messy data gives wrong answers. Always keep your data clean.
Definition: An Excel Table is a special format that organises your data with headers and rows. It makes it easier for CoPilot to read and work with your data.
Why it is important: CoPilot works best with Tables. When your data is in a Table, CoPilot knows exactly where the columns start and end.
Simple explanation: Imagine your books are scattered on the floor. It is hard to find one. Now imagine they are arranged on a bookshelf with labels. It is easy to find any book. A Table is like a bookshelf for your data.
Real-life example: A library organises books by category. An Excel Table organises your data by column headers.
School example: Your class list is organised with columns for Name, Age, and Score. That is a Table.
Home example: Your family shopping list is organised with columns for Item, Quantity, and Price. That is a Table.
Nigerian example: A trader's inventory list has columns for Item, Quantity, Buying Price, and Selling Price. That is a Table.
Illustration:
Before Table Format: +-------+-------+-------+ | Name | Score | Grade | +-------+-------+-------+ | Ada | 85 | A | | Chidi | 72 | B | +-------+-------+-------+ After Table Format: +=======+=======+=======+ | Name | Score | Grade | +=======+=======+=======+ | Ada | 85 | A | +-------+-------+-------+ | Chidi | 72 | B | +-------+-------+-------+ (Table has special formatting and filter buttons)
Stepâbyâstep:
Mini summary: An Excel Table organises your data with headers. CoPilot reads Tables best. Use Insert â Table to create one.
Definition: Inconsistent capital letters means the same word is written in different ways. For example, "Coke," "coke," and "COKE" are the same item but written differently.
Why it is important: Excel treats "Coke" and "coke" as different items. This makes totals wrong.
Simple explanation: Imagine you have three friends named Ada, ada, and ADA. You might think they are three different people. But they are the same person. Excel thinks the same way about words.
Real-life example: A shop owner sells "Fanta," "fanta," and "FANTA." Excel counts them as three different products. The total sales for Fanta will be wrong.
School example: A teacher records "Maths," "maths," and "MATHS." The subject list looks like three different subjects.
Home example: Your shopping list has "Rice," "rice," and "RICE." You might buy three times as much as you need.
Nigerian example: A trader records "Garri," "garri," and "GARRI." The total bags of garri sold will be wrong.
Illustration:
Before Fix: +----------+ | Coke | | coke | | COKE | | cOkE | +----------+ After Fix: +----------+ | Coke | | Coke | | Coke | | Coke | +----------+
Stepâbyâstep:
Mini summary: Inconsistent capitals make Excel treat the same word as different. Use CoPilot to fix capitalisation.
Definition: Extra spaces are invisible characters before or after text. For example, "Ada " has a space at the end. " Ada" has a space at the beginning.
Why it is important: Excel treats "Ada" and "Ada " as different. Extra spaces cause wrong counts and wrong matches.
Simple explanation: Imagine you have two identical twins. One has a tiny dot on her hand. You might think they are different people. Extra spaces are like that tiny dot. They make Excel think the words are different.
Real-life example: A customer list has "John" and "John " (with a space). The same customer appears twice. You might send two letters to the same person.
School example: A class list has "Ngozi" and "Ngozi " (with a space). The teacher thinks there are two Ngozis.
Home example: A shopping list has "Bread" and "Bread " (with a space). You might buy two loaves.
Nigerian example: A trader records "Peak Milk" and "Peak Milk " (with a space). Excel counts them as two different products.
Illustration:
Extra Spaces (invisible): "Coke " --> has a space at the end " Coke" --> has a space at the beginning "Co ke" --> has a space in the middle Clean: "Coke" --> no extra spaces
Stepâbyâstep:
Mini summary: Extra spaces make Excel treat the same word as different. Use CoPilot to remove them.
Definition: Number format means how a number is written. For example, "5000," "5,000," and "âŚ5,000" are the same number but written differently.
Why it is important: Excel may treat "5000" as a number and "5,000" as text. This makes calculations wrong.
Simple explanation: Imagine you write "five thousand" in words and "5000" in numbers. They mean the same thing, but they look different. Excel needs numbers to be written in the same way.
Real-life example: A bank statement shows "1,000" and "1000." They are the same amount, but the computer might treat them differently.
School example: Test scores written as "85" and "85 " (with a space) may not add up correctly.
Home example: A budget shows "5000" and "5,000." Excel might not add them together.
Nigerian example: A trader records "âŚ500" and "500." Excel treats "âŚ500" as text and "500" as a number. The total will be wrong.
Illustration:
Number Formats: +----------+----------+ | 5000 | Number | | 5,000 | Text | | âŚ5,000 | Text | | 5000.00 | Number | +----------+----------+
| Format | Excel Sees It As |
|---|---|
| 5000 | Number |
| 5,000 | Text |
| âŚ5,000 | Text |
| 5000.00 | Number |
Stepâbyâstep:
Mini summary: Numbers must be in the same format for Excel to calculate correctly. Use CoPilot to fix number formats.
Definition: Date format means how a date is written. For example, "05/03/2025," "March 5, 2025," and "5âMarâ25" are the same date but written differently.
Why it is important: Excel may not understand different date formats. This makes sorting and calculating dates wrong.
Simple explanation: Imagine you write your birthday as "5 March" and your friend writes it as "March 5." They mean the same day, but they look different. Excel needs dates to be in the same format.
Real-life example: A hotel booking system needs all dates in the same format. Otherwise, it might book a room for the wrong day.
School example: A school timetable uses one date format for all events. This prevents confusion.
Home example: A family calendar uses the same date format for all birthdays and appointments.
Nigerian example: A business records invoices with different date formats. This makes it hard to track payments. CoPilot can fix them.
Illustration:
Date Formats: +----------------+----------------+ | 05/03/2025 | DD/MM/YYYY | | March 5, 2025 | Month DD, YYYY | | 5-Mar-25 | D-Mon-YY | +----------------+----------------+
Stepâbyâstep:
Mini summary: Dates must be in the same format for Excel to understand them. Use CoPilot to fix date formats.
Definition: A duplicate row is a row that appears more than once. It has the same information as another row.
Why it is important: Duplicates make totals wrong. If you count the same sale twice, your total is too high.
Simple explanation: Imagine you write your friend's name twice on a list. When you count the names, you count your friend twice. That is a duplicate. Excel can remove duplicates for you.
Real-life example: A customer list has the same customer twice. You might send two letters to the same person.
School example: A class list has the same student twice. The teacher thinks there are more students than there really are.
Home example: A shopping list has "Milk" twice. You might buy two cartons when you only need one.
Nigerian example: A trader's sales record has the same sale entered twice. The daily total is wrong.
Illustration:
Before Removing Duplicates: +-------+-------+ | Ada | 85 | | Chidi | 72 | | Ada | 85 | <-- duplicate | Ngozi | 91 | +-------+-------+ After Removing Duplicates: +-------+-------+ | Ada | 85 | | Chidi | 72 | | Ngozi | 91 | +-------+-------+
Stepâbyâstep:
Mini summary: Duplicate rows make totals wrong. Use CoPilot to remove them.
Definition: A missing value is a cell that is empty when it should have information. For example, a student's score is missing.
Why it is important: Missing values make totals and averages wrong. Excel cannot add an empty cell.
Simple explanation: Imagine you are counting your friends. You forget to count one friend. Your total is wrong. Missing values are like forgotten friends.
Real-life example: A bank statement has a missing transaction. The balance will be wrong.
School example: A class list has a missing score for one student. The class average will be wrong.
Home example: A budget has a missing expense. You might think you have more money than you really do.
Nigerian example: A trader's record has a missing price for one item. The total sales will be wrong.
Illustration:
Before Filling Missing Values: +-------+-------+ | Ada | 85 | | Chidi | | <-- missing | Ngozi | 91 | +-------+-------+ After Filling: +-------+-------+ | Ada | 85 | | Chidi | 0 | <-- filled with 0 | Ngozi | 91 | +-------+-------+
Stepâbyâstep:
Mini summary: Missing values make answers wrong. Use CoPilot to fill them in, but choose the right value.
Definition: Conditional formatting changes the colour of cells based on rules. For example, you can make all cells over 100 turn red.
Why it is important: Conditional formatting helps you see problems quickly. Blank cells, duplicates, and outliers stand out.
Simple explanation: Imagine you have a list of scores. You want to see who failed. You can make all failing scores turn red. That is conditional formatting.
Real-life example: A bank highlights all transactions over âŚ1,000,000 in red. This helps them spot large transactions quickly.
School example: A teacher highlights all scores below 50 in red. This shows which students need extra help.
Home example: A family budget highlights all expenses over âŚ10,000 in orange.
Nigerian example: A trader highlights all items with low stock in red. This reminds him to reorder.
Illustration:
Conditional Formatting: +-------+-------+ | Ada | 85 | (green) | Chidi | 45 | (red - below 50) | Ngozi | 91 | (green) | Emeka | 38 | (red - below 50) +-------+-------+
Stepâbyâstep:
Mini summary: Conditional formatting changes cell colours based on rules. Use it to spot problems quickly.
Definition: "Clean Data" is a feature in Excel that finds and fixes common data problems automatically.
Why it is important: It saves time and catches problems you might miss.
Simple explanation: Imagine you have a magic eraser that removes all the mistakes from your homework. Clean Data is like that eraser for your spreadsheet.
Real-life example: A company uses Clean Data to fix customer records before sending out a newsletter.
School example: A teacher uses Clean Data to fix the class list before calculating grades.
Home example: A family uses Clean Data to fix the budget before planning next month.
Nigerian example: A business in Abuja uses Clean Data to fix its inventory list before ordering new stock.
Illustration:
Clean Data Feature: +---------------------------+ | 1. Select your data | | 2. Click Data tab | | 3. Click Clean Data | | 4. CoPilot finds problems | | 5. Review and fix | +---------------------------+
Stepâbyâstep:
Mini summary: Clean Data is a feature that finds and fixes common problems automatically.
Definition: Checking means looking at what CoPilot did to make sure it is correct.
Why it is important: CoPilot can make mistakes. It might change something you did not want changed.
Simple explanation: Imagine your friend cleans your room. You still look around to make sure nothing is broken or missing. Checking CoPilot's work is the same.
Real-life example: A bank checks every transaction before approving it. You should check CoPilot's changes before saving.
School example: After CoPilot cleans the class list, the teacher checks that no student was removed by mistake.
Home example: After CoPilot cleans the shopping list, you check that no items were removed.
Nigerian example: After CoPilot cleans the sales record, the trader checks that no sales were deleted.
Illustration:
Check CoPilot's Work: +---------------------------+ | 1. Look at the changes | | 2. Ask: Is this correct? | | 3. If yes, save. | | 4. If no, undo and retry. | +---------------------------+
Mini summary: Always check CoPilot's cleaning work. Look at the changes and make sure they are correct.
Definition: Keeping data clean means preventing mistakes before they happen.
Why it is important: Prevention is better than cure. If you type carefully, you will not need to clean as often.
Simple explanation: Imagine you brush your teeth every day. You do not need to visit the dentist as often. Typing carefully is like brushing your teeth for data.
Real-life example: A shop owner types prices carefully. He does not need to fix them later.
School example: A student types scores carefully. The teacher does not need to correct them.
Home example: A family types the budget carefully. They do not need to fix mistakes later.
Nigerian example: A trader types item names carefully. She does not need to clean them later.
Illustration:
Prevent Mistakes: +---------------------------+ | 1. Type carefully | | 2. Use consistent formats | | 3. Check as you go | | 4. Save often | +---------------------------+
Mini summary: Prevent mistakes by typing carefully, using consistent formats, and checking as you go.
Definition: Putting it all together means following a complete process to clean your data from start to finish.
Why it is important: A stepâbyâstep process ensures you do not miss anything.
Simple explanation: Imagine you are baking a cake. You follow a recipe: gather ingredients, mix, bake, cool, decorate. Cleaning data has a recipe too.
Real-life example: A company follows a data cleaning checklist before every monthly report.
School example: A teacher follows a checklist before calculating final grades.
Home example: A family follows a checklist before planning the monthly budget.
Nigerian example: A business follows a checklist before submitting tax records.
Illustration:
Data Cleaning Recipe: +---------------------------+ | 1. Format as Table | | 2. Fix capital letters | | 3. Remove extra spaces | | 4. Fix number formats | | 5. Fix date formats | | 6. Remove duplicates | | 7. Fill missing values | | 8. Highlight problems | | 9. Check everything | | 10. Save and celebrate! | +---------------------------+
Mini summary: Follow a stepâbyâstep process to clean your data completely. Check everything before saving.
| Word | Simple Definition |
|---|---|
| Data | Information, such as names, numbers, or dates. |
| Data Preparation | Getting your information ready to be used. |
| Data Cleaning | Fixing mistakes in your data. |
| Table | A special Excel format with headers and rows. |
| Header | The top row of a table that names each column. |
| Duplicate | A row that appears more than once. |
| Missing Value | An empty cell that should have information. |
| Inconsistent | Not the same. For example, "Coke" and "coke." |
| Capitalisation | Using capital letters. For example, "A" vs "a." |
| Format | How something is written or displayed. |
| Conditional Formatting | Changing cell colours based on rules. |
| Outlier | A value that is very different from the others. |
| Clean Data | An Excel feature that finds and fixes problems. |
| Verify | To check if something is correct. |
| Garbage In, Garbage Out | Messy data gives wrong answers. |
If your data is clean, Excel and CoPilot give correct answers. If your data is messy, answers are wrong.
Format your data as a Table so CoPilot can read it easily.
Use the same format for all entries. "Coke" and "coke" should be "Coke."
CoPilot is helpful, but it can make mistakes. Always look at the changes.
Type carefully and use consistent formats. This reduces the need for cleaning.
Use a stepâbyâstep checklist to clean your data completely.
Mrs. Bello teaches at a secondary school in Kano. She records student scores in Excel. Some scores have extra spaces. Some names have inconsistent capitals. She uses CoPilot to clean the data before calculating grades. The grades are now correct.
Mr. Okafor runs a phone accessory shop in Lagos. He records sales in Excel. Some prices are written as "âŚ5,000" and others as "5000." CoPilot converts them all to numbers. The total sales are now correct.
Mrs. Adeyemi records patient names in Excel. Some names have extra spaces. Some have inconsistent capitals. CoPilot cleans the list. The hospital now sends letters to the correct patients.
Coach Musa records player goals in Excel. Two rows have the same player name twice. CoPilot removes the duplicate. The goal totals are now correct.
A trader sells fabrics at Balogun Market. She records each sale in Excel. Some items are written as "Lace," "lace," and "LACE." CoPilot fixes the capitalisation. The total yards of lace sold is now correct.
A student in Ibadan tracks her WAEC subject scores. Some scores are missing. She uses CoPilot to fill them in with 0. The average score is now correct.
A youth corper in Enugu plans a community project. He lists expenses in Excel. Some dates are written differently. CoPilot converts them all to one format. The project timeline is now clear.
A small business owner in Abuja tracks customer orders. Two orders are duplicates. CoPilot removes the duplicate. The total orders are now correct.
You record your pocket money in Excel. Some amounts are written as "500" and others as "500.00." CoPilot converts them all to numbers. Your total savings are now correct.
You record your friends' game scores. Two friends have the same name. CoPilot removes the duplicate. The leaderboard is now correct.
You list your football cards in Excel. Some card names have extra spaces. CoPilot removes them. Your collection list is now clean.
You list party items in Excel. Some items are written as "Cake," "cake," and "CAKE." CoPilot fixes the capitalisation. Your shopping list is now clean.
| Situation | What You Ask CoPilot |
|---|---|
| Chore list | "Remove duplicate chores from the list." |
| Trip planning | "Fix inconsistent capitalisation in the destination column." |
| Exercise log | "Fill missing exercise minutes with 0." |
| Savings tracker | "Convert the savings column to numbers." |
| Reading log | "Remove extra spaces from book titles." |
| Mistake | Why It Is a Problem | How to Avoid It |
|---|---|---|
| Not formatting as a Table | CoPilot may not read the data correctly | Use Insert â Table before asking CoPilot |
| Ignoring extra spaces | Excel treats the same word as different | Ask CoPilot to remove extra spaces |
| Using different number formats | Calculations become wrong | Convert all numbers to the same format |
| Using different date formats | Excel cannot sort or calculate dates | Convert all dates to one format |
| Forgetting to check CoPilot's work | Mistakes go unnoticed | Always review changes before saving |
| Filling missing values with wrong number | Answers become wrong | Choose the correct fill value (0 or average) |
| Removing duplicates without checking | Important data may be deleted | Review before removing |
Start
|
V
Format as Table
|
V
Fix Capital Letters
|
V
Remove Extra Spaces
|
V
Fix Number Formats
|
V
Fix Date Formats
|
V
Remove Duplicates
|
V
Fill Missing Values
|
V
Highlight Problems
|
V
Check Everything
|
V
Save and Celebrate! đ
Before Cleaning: +----------+----------+----------+ | Name | Score | Date | +----------+----------+----------+ | ada | 85 | 05/03/25 | | ADA | 85 | March 5 | | Ada | 85 | 5-Mar-25 | | chidi | 72 | 06/03/25 | | Chidi | 72 | 06/03/25 | +----------+----------+----------+ After Cleaning: +----------+----------+----------+ | Name | Score | Date | +----------+----------+----------+ | Ada | 85 | 05/03/25 | | Ada | 85 | 05/03/25 | | Ada | 85 | 05/03/25 | | Chidi | 72 | 06/03/25 | +----------+----------+----------+ (Duplicates removed, capitals fixed, dates consistent)
+----------+----------+ | Score | Colour | +----------+----------+ | 85 | Green | | 45 | Red | | 91 | Green | | 38 | Red | | 72 | Yellow | +----------+----------+ (Red = below 50, Yellow = 50-70, Green = above 70)
Clean Data Panel +-----------------------------------+ | Problems Found: | | | | 1. Inconsistent capitalisation | | in column A [Fix] [Skip] | | | | 2. Extra spaces in column B | | [Fix] [Skip] | | | | 3. Duplicate rows in table | | [Fix] [Skip] | | | | [Apply All Fixes] | +-----------------------------------+
Step 1: Format as Table
|
Step 2: Fix Capital Letters
|
Step 3: Remove Extra Spaces
|
Step 4: Fix Number Formats
|
Step 5: Fix Date Formats
|
Step 6: Remove Duplicates
|
Step 7: Fill Missing Values
|
Step 8: Highlight Problems
|
Step 9: Check Everything
|
Step 10: Save
| Problem | Example | Fix |
|---|---|---|
| Inconsistent capitals | "Coke," "coke," "COKE" | Fix capitalisation |
| Extra spaces | "Ada " (space at end) | Remove extra spaces |
| Number format | "5,000" vs "5000" | Convert to numbers |
| Date format | "05/03/25" vs "March 5" | Convert to one format |
| Duplicates | Same row twice | Remove duplicates |
| Missing values | Empty cell | Fill with 0 or average |
| Outliers | Score of 999 | Highlight and investigate |
| What You Want | What to Type |
|---|---|
| Fix capitals | "Fix inconsistent capitalisation in column A" |
| Remove spaces | "Remove extra spaces from column B" |
| Fix numbers | "Convert column C to numbers" |
| Fix dates | "Convert column D to a consistent date format" |
| Remove duplicates | "Remove duplicate rows from the table" |
| Fill missing values | "Fill missing values in column B with 0" |
| Highlight problems | "Highlight all cells in column B that are below 50 in red" |
Data preparation is getting your information ready. It includes typing correctly and organising in rows and columns.
Data cleaning means fixing mistakes. It removes extra spaces, fixes capitals, and removes duplicates.
Clean data gives correct answers. Messy data gives wrong answers.
An Excel Table organises data with headers. CoPilot reads Tables best.
Inconsistent capitals make Excel treat the same word as different. Use CoPilot to fix them.
Extra spaces make Excel treat the same word as different. Use CoPilot to remove them.
Numbers must be in the same format for Excel to calculate correctly.
Dates must be in the same format for Excel to understand them.
Duplicate rows make totals wrong. Use CoPilot to remove them.
Missing values make answers wrong. Use CoPilot to fill them in.
Conditional formatting changes cell colours based on rules. Use it to spot problems.
Clean Data is a feature that finds and fixes common problems automatically.
Always check CoPilot's cleaning work. Look at the changes and make sure they are correct.
Prevent mistakes by typing carefully and using consistent formats.
Follow a stepâbyâstep process to clean your data completely.
In this module, you learned how to prepare and clean data using CoPilot in Microsoft Excel. You learned that data preparation means getting your information ready, and data cleaning means fixing mistakes.
You learned why clean data matters. Clean data gives correct answers. Messy data gives wrong answers. This is called "Garbage In, Garbage Out."
You learned how to format data as an Excel Table. Tables have headers and rows. CoPilot reads Tables best.
You learned how to fix inconsistent capital letters. "Coke," "coke," and "COKE" should all be "Coke." You learned how to remove extra spaces. "Ada " and "Ada" should both be "Ada."
You learned how to fix number formats. "5,000" and "5000" should both be numbers. You learned how to fix date formats. "05/03/25" and "March 5" should both be the same format.
You learned how to remove duplicate rows. Duplicates make totals wrong. You learned how to fill missing values. Missing values also make totals wrong.
You learned how to use conditional formatting to highlight problems. You learned how to use the Clean Data feature to find and fix common problems automatically.
You learned to always check CoPilot's work. CoPilot can make mistakes. You must look at the changes and make sure they are correct.
You learned to prevent mistakes by typing carefully and using consistent formats. Prevention is better than cure.
Finally, you learned a stepâbyâstep process for cleaning data. Follow the process to make sure you do not miss anything.
Match the word on the left with the correct definition on the right.
| Word | Definition |
|---|---|
| 1. Data Cleaning | A. A row that appears more than once |
| 2. Table | B. Fixing mistakes in data |
| 3. Duplicate | C. Changing cell colours based on rules |
| 4. Missing Value | D. An empty cell that should have information |
| 5. Conditional Formatting | E. A special Excel format with headers |
| 6. Clean Data | F. An Excel feature that finds and fixes problems |
Answers: 1âB, 2âE, 3âA, 4âD, 5âC, 6âF
You help run the school store. Your sales list has "Coke," "coke," and "COKE." What do you ask CoPilot to do? Which column do you fix?
You plan a birthday party. Your guest list has "Ada" and "Ada " (with a space). What do you ask CoPilot to do?
You track your football team's goals. Two rows have the same player name twice. What do you ask CoPilot to do?
Your family lists monthly expenses. Some amounts are missing. What do you ask CoPilot to do? What value do you fill with?
You track your study hours. Some dates are written as "05/03/25" and others as "March 5." What do you ask CoPilot to do?
Goal: Work in groups of 3â4 to clean a messy dataset using CoPilot.
Steps:
Discussion: Which group cleaned the data fastest? Which group made the fewest mistakes? What did you learn?
Goal: Practice cleaning data on your own.
Steps:
Goal: Create a clean pocket money tracker using Excel and CoPilot.
Steps:
Deliverable: A clean Excel file with consistent data, no duplicates, no missing values, and conditional formatting.
Instructions: Complete the following tasks in Excel using CoPilot. Write down what you asked and what CoPilot did.
Submission: Share your Excel file and a short report of what you learned.
In the next module, you will learn how to use CoPilot to create formulas and understand them. You will learn how to ask CoPilot to add columns, calculate totals, and explain what formulas do.
Before the next module, please make sure you can:
If you can do these things, you are ready for Module Three: Formula Generation and Understanding with CoPilot.
See you in the next module, young explorer! Keep practising and stay curious.
End of Module Two
Welcome back, young explorer! In Module One, you met CoPilot, your friendly AI helper inside Microsoft Excel. You learned how to set it up and ask your first questions. Now it is time to roll up your sleeves and get to work.
In this module, you will learn how to prepare and clean data using CoPilot. Data is just another word for information. It can be names, numbers, dates, or anything else you store in Excel.
Have you ever seen a messy room? Clothes on the floor, books on the bed, and toys everywhere. It is hard to find anything. Messy data is the same. When your Excel sheet is messy, it is hard to work with. CoPilot can help you tidy it up.
Think of CoPilot as a superâfast cleaner. It can fix spelling mistakes, remove extra spaces, change how numbers look, find duplicates, and much more. All you have to do is ask.
By the end of this module, you will be able to take a messy spreadsheet and turn it into a clean, organised table. You will also learn why clean data is so important and how to avoid common mistakes.
Let us begin. Your data is waiting to be cleaned!
By the end of this module, you will be able to:
Chidi is a thirteenâyearâold boy who lives in Port Harcourt, Nigeria. His mother owns a small shop that sells drinks and snacks. Every day, Chidi helps his mother record what they sell.
One Saturday morning, Chidi's mother said, "Chidi, please use the computer to record today's sales. My notebook is full."
Chidi opened Excel and started typing. He typed the name of each item, the quantity sold, and the price. But he was in a hurry because his friends were waiting to play football.
He typed "coke" in one row and "Coke" in another. He typed "50" in one row and "50 " (with an extra space) in another. He even typed "05/03/2025" in one row and "March 5, 2025" in another.
The next day, Chidi's mother looked at the spreadsheet. She wanted to know how many bottles of Coke were sold. But when she searched for "Coke," she only found some of them. The others were hidden under "coke" or "COKE."
"Chidi," she said, "this data is messy. I cannot get the right answer."
Chidi felt bad. He wanted to help, but his messy typing made things worse.
Just then, Chidi's older sister Ngozi walked in. She was studying computer science at university. "Don't worry," she said. "I can show you how to use CoPilot to clean this up."
Ngozi opened the CoPilot panel and typed, "Fix inconsistent capitalisation in the Item column."
A moment later, CoPilot changed all the "coke" and "COKE" entries to "Coke." It also removed extra spaces from the numbers.
"Wow!" said Chidi. "It fixed everything in seconds!"
"CoPilot is great at cleaning data," said Ngozi. "But you must always check its work. And next time, try to type carefully."
Chidi learned two lessons that day. First, clean data is important. Second, CoPilot can help you clean it quickly.
Now it is your turn. Are you ready to learn how to clean data with CoPilot?
Messy Data CoPilot Cleaning +----------------+ +----------------+ | coke | | Coke | | Coke | -----> | Coke | | COKE | | Coke | | 50 | | 50 | | 50 (space) | | 50 | +----------------+ +----------------+
Definition: Data preparation means getting your information ready to be used. It includes typing it correctly, organising it in rows and columns, and making sure everything is in the right place.
Why it is important: If your data is not prepared properly, CoPilot and Excel cannot give you correct answers. Good preparation saves time and prevents mistakes.
Simple explanation: Imagine you are baking a cake. Before you start, you gather all your ingredients. You measure the flour. You crack the eggs. You preheat the oven. That is preparation. Data preparation is the same. You get your information ready before you analyse it.
Real-life example: A shop owner writes down every sale in a notebook. Before adding up the totals, she makes sure every price is written correctly.
School example: Your teacher collects test scores. Before calculating the class average, she checks that every student's score is entered in the right row.
Home example: Your family plans a budget. Before adding up expenses, you make sure every expense is listed in the correct column.
Nigerian example: A trader at Onitsha Main Market records the number of bags of rice sold each day. She makes sure the numbers are written clearly before calculating weekly totals.
Illustration:
Data Preparation Steps +---------------------------+ | 1. Gather information | | 2. Type it in correctly | | 3. Organise in rows/cols | | 4. Check for mistakes | | 5. Ready to use! | +---------------------------+
Mini summary: Data preparation is getting your information ready. It includes typing correctly and organising in rows and columns.
Definition: Data cleaning means fixing mistakes in your data. It includes removing extra spaces, fixing capital letters, correcting number formats, and removing duplicate rows.
Why it is important: Messy data gives wrong answers. If "Coke" and "coke" are treated as different items, your totals will be wrong. Cleaning fixes this.
Simple explanation: Imagine you have a pile of dirty clothes. Before you wear them, you wash them. Data cleaning is like washing your data. You remove the dirt (mistakes) so it is clean and ready to use.
Real-life example: A bank cleans its customer list to remove duplicate names. This prevents sending the same letter twice.
School example: A teacher cleans the attendance list to remove students who have left the school.
Home example: Your family cleans the shopping list to remove items you already bought.
Nigerian example: A business in Lagos cleans its customer database to remove old phone numbers and fix spelling mistakes in names.
Illustration:
Dirty Data Clean Data +----------------+ +----------------+ | Ada | | Ada | | ada (extra sp) | -----> | Ada | | ADA | | Ada | | Chidi | | Chidi | | Chidi (dupl) | | (removed) | +----------------+ +----------------+
Mini summary: Data cleaning means fixing mistakes in your data. It removes extra spaces, fixes capitals, and removes duplicates.
Definition: Clean data is data that is correct, consistent, and complete. It has no spelling mistakes, no extra spaces, no duplicates, and no missing values.
Why it is important: Clean data gives correct answers. Messy data gives wrong answers. This is called "Garbage In, Garbage Out."
Simple explanation: If you put dirty water into a clean cup, the cup becomes dirty. If you put messy data into Excel, the answers become messy. Clean data gives clean answers.
Real-life example: A doctor needs clean patient records. If a patient's blood type is recorded wrongly, it could be dangerous.
School example: If your exam scores are entered wrongly, your final grade will be wrong.
Home example: If your family budget has a wrong number, you might think you have more money than you really do.
Nigerian example: A market trader who records "âŚ500" and "500" in different rows will get a wrong total. The data must be consistent.
Illustration:
Garbage In, Garbage Out +----------------+ +----------------+ | Messy Data | -----> | Wrong Answers | +----------------+ +----------------+ +----------------+ +----------------+ | Clean Data | -----> | Right Answers | +----------------+ +----------------+
| Type of Data | Result |
|---|---|
| Messy | Wrong answers |
| Clean | Correct answers |
Mini summary: Clean data gives correct answers. Messy data gives wrong answers. Always keep your data clean.
Definition: An Excel Table is a special format that organises your data with headers and rows. It makes it easier for CoPilot to read and work with your data.
Why it is important: CoPilot works best with Tables. When your data is in a Table, CoPilot knows exactly where the columns start and end.
Simple explanation: Imagine your books are scattered on the floor. It is hard to find one. Now imagine they are arranged on a bookshelf with labels. It is easy to find any book. A Table is like a bookshelf for your data.
Real-life example: A library organises books by category. An Excel Table organises your data by column headers.
School example: Your class list is organised with columns for Name, Age, and Score. That is a Table.
Home example: Your family shopping list is organised with columns for Item, Quantity, and Price. That is a Table.
Nigerian example: A trader's inventory list has columns for Item, Quantity, Buying Price, and Selling Price. That is a Table.
Illustration:
Before Table Format: +-------+-------+-------+ | Name | Score | Grade | +-------+-------+-------+ | Ada | 85 | A | | Chidi | 72 | B | +-------+-------+-------+ After Table Format: +=======+=======+=======+ | Name | Score | Grade | +=======+=======+=======+ | Ada | 85 | A | +-------+-------+-------+ | Chidi | 72 | B | +-------+-------+-------+ (Table has special formatting and filter buttons)
Stepâbyâstep:
Mini summary: An Excel Table organises your data with headers. CoPilot reads Tables best. Use Insert â Table to create one.
Definition: Inconsistent capital letters means the same word is written in different ways. For example, "Coke," "coke," and "COKE" are the same item but written differently.
Why it is important: Excel treats "Coke" and "coke" as different items. This makes totals wrong.
Simple explanation: Imagine you have three friends named Ada, ada, and ADA. You might think they are three different people. But they are the same person. Excel thinks the same way about words.
Real-life example: A shop owner sells "Fanta," "fanta," and "FANTA." Excel counts them as three different products. The total sales for Fanta will be wrong.
School example: A teacher records "Maths," "maths," and "MATHS." The subject list looks like three different subjects.
Home example: Your shopping list has "Rice," "rice," and "RICE." You might buy three times as much as you need.
Nigerian example: A trader records "Garri," "garri," and "GARRI." The total bags of garri sold will be wrong.
Illustration:
Before Fix: +----------+ | Coke | | coke | | COKE | | cOkE | +----------+ After Fix: +----------+ | Coke | | Coke | | Coke | | Coke | +----------+
Stepâbyâstep:
Mini summary: Inconsistent capitals make Excel treat the same word as different. Use CoPilot to fix capitalisation.
Definition: Extra spaces are invisible characters before or after text. For example, "Ada " has a space at the end. " Ada" has a space at the beginning.
Why it is important: Excel treats "Ada" and "Ada " as different. Extra spaces cause wrong counts and wrong matches.
Simple explanation: Imagine you have two identical twins. One has a tiny dot on her hand. You might think they are different people. Extra spaces are like that tiny dot. They make Excel think the words are different.
Real-life example: A customer list has "John" and "John " (with a space). The same customer appears twice. You might send two letters to the same person.
School example: A class list has "Ngozi" and "Ngozi " (with a space). The teacher thinks there are two Ngozis.
Home example: A shopping list has "Bread" and "Bread " (with a space). You might buy two loaves.
Nigerian example: A trader records "Peak Milk" and "Peak Milk " (with a space). Excel counts them as two different products.
Illustration:
Extra Spaces (invisible): "Coke " --> has a space at the end " Coke" --> has a space at the beginning "Co ke" --> has a space in the middle Clean: "Coke" --> no extra spaces
Stepâbyâstep:
Mini summary: Extra spaces make Excel treat the same word as different. Use CoPilot to remove them.
Definition: Number format means how a number is written. For example, "5000," "5,000," and "âŚ5,000" are the same number but written differently.
Why it is important: Excel may treat "5000" as a number and "5,000" as text. This makes calculations wrong.
Simple explanation: Imagine you write "five thousand" in words and "5000" in numbers. They mean the same thing, but they look different. Excel needs numbers to be written in the same way.
Real-life example: A bank statement shows "1,000" and "1000." They are the same amount, but the computer might treat them differently.
School example: Test scores written as "85" and "85 " (with a space) may not add up correctly.
Home example: A budget shows "5000" and "5,000." Excel might not add them together.
Nigerian example: A trader records "âŚ500" and "500." Excel treats "âŚ500" as text and "500" as a number. The total will be wrong.
Illustration:
Number Formats: +----------+----------+ | 5000 | Number | | 5,000 | Text | | âŚ5,000 | Text | | 5000.00 | Number | +----------+----------+
| Format | Excel Sees It As |
|---|---|
| 5000 | Number |
| 5,000 | Text |
| âŚ5,000 | Text |
| 5000.00 | Number |
Stepâbyâstep:
Mini summary: Numbers must be in the same format for Excel to calculate correctly. Use CoPilot to fix number formats.
Definition: Date format means how a date is written. For example, "05/03/2025," "March 5, 2025," and "5âMarâ25" are the same date but written differently.
Why it is important: Excel may not understand different date formats. This makes sorting and calculating dates wrong.
Simple explanation: Imagine you write your birthday as "5 March" and your friend writes it as "March 5." They mean the same day, but they look different. Excel needs dates to be in the same format.
Real-life example: A hotel booking system needs all dates in the same format. Otherwise, it might book a room for the wrong day.
School example: A school timetable uses one date format for all events. This prevents confusion.
Home example: A family calendar uses the same date format for all birthdays and appointments.
Nigerian example: A business records invoices with different date formats. This makes it hard to track payments. CoPilot can fix them.
Illustration:
Date Formats: +----------------+----------------+ | 05/03/2025 | DD/MM/YYYY | | March 5, 2025 | Month DD, YYYY | | 5-Mar-25 | D-Mon-YY | +----------------+----------------+
Stepâbyâstep:
Mini summary: Dates must be in the same format for Excel to understand them. Use CoPilot to fix date formats.
Definition: A duplicate row is a row that appears more than once. It has the same information as another row.
Why it is important: Duplicates make totals wrong. If you count the same sale twice, your total is too high.
Simple explanation: Imagine you write your friend's name twice on a list. When you count the names, you count your friend twice. That is a duplicate. Excel can remove duplicates for you.
Real-life example: A customer list has the same customer twice. You might send two letters to the same person.
School example: A class list has the same student twice. The teacher thinks there are more students than there really are.
Home example: A shopping list has "Milk" twice. You might buy two cartons when you only need one.
Nigerian example: A trader's sales record has the same sale entered twice. The daily total is wrong.
Illustration:
Before Removing Duplicates: +-------+-------+ | Ada | 85 | | Chidi | 72 | | Ada | 85 | <-- duplicate | Ngozi | 91 | +-------+-------+ After Removing Duplicates: +-------+-------+ | Ada | 85 | | Chidi | 72 | | Ngozi | 91 | +-------+-------+
Stepâbyâstep:
Mini summary: Duplicate rows make totals wrong. Use CoPilot to remove them.
Definition: A missing value is a cell that is empty when it should have information. For example, a student's score is missing.
Why it is important: Missing values make totals and averages wrong. Excel cannot add an empty cell.
Simple explanation: Imagine you are counting your friends. You forget to count one friend. Your total is wrong. Missing values are like forgotten friends.
Real-life example: A bank statement has a missing transaction. The balance will be wrong.
School example: A class list has a missing score for one student. The class average will be wrong.
Home example: A budget has a missing expense. You might think you have more money than you really do.
Nigerian example: A trader's record has a missing price for one item. The total sales will be wrong.
Illustration:
Before Filling Missing Values: +-------+-------+ | Ada | 85 | | Chidi | | <-- missing | Ngozi | 91 | +-------+-------+ After Filling: +-------+-------+ | Ada | 85 | | Chidi | 0 | <-- filled with 0 | Ngozi | 91 | +-------+-------+
Stepâbyâstep:
Mini summary: Missing values make answers wrong. Use CoPilot to fill them in, but choose the right value.
Definition: Conditional formatting changes the colour of cells based on rules. For example, you can make all cells over 100 turn red.
Why it is important: Conditional formatting helps you see problems quickly. Blank cells, duplicates, and outliers stand out.
Simple explanation: Imagine you have a list of scores. You want to see who failed. You can make all failing scores turn red. That is conditional formatting.
Real-life example: A bank highlights all transactions over âŚ1,000,000 in red. This helps them spot large transactions quickly.
School example: A teacher highlights all scores below 50 in red. This shows which students need extra help.
Home example: A family budget highlights all expenses over âŚ10,000 in orange.
Nigerian example: A trader highlights all items with low stock in red. This reminds him to reorder.
Illustration:
Conditional Formatting: +-------+-------+ | Ada | 85 | (green) | Chidi | 45 | (red - below 50) | Ngozi | 91 | (green) | Emeka | 38 | (red - below 50) +-------+-------+
Stepâbyâstep:
Mini summary: Conditional formatting changes cell colours based on rules. Use it to spot problems quickly.
Definition: "Clean Data" is a feature in Excel that finds and fixes common data problems automatically.
Why it is important: It saves time and catches problems you might miss.
Simple explanation: Imagine you have a magic eraser that removes all the mistakes from your homework. Clean Data is like that eraser for your spreadsheet.
Real-life example: A company uses Clean Data to fix customer records before sending out a newsletter.
School example: A teacher uses Clean Data to fix the class list before calculating grades.
Home example: A family uses Clean Data to fix the budget before planning next month.
Nigerian example: A business in Abuja uses Clean Data to fix its inventory list before ordering new stock.
Illustration:
Clean Data Feature: +---------------------------+ | 1. Select your data | | 2. Click Data tab | | 3. Click Clean Data | | 4. CoPilot finds problems | | 5. Review and fix | +---------------------------+
Stepâbyâstep:
Mini summary: Clean Data is a feature that finds and fixes common problems automatically.
Definition: Checking means looking at what CoPilot did to make sure it is correct.
Why it is important: CoPilot can make mistakes. It might change something you did not want changed.
Simple explanation: Imagine your friend cleans your room. You still look around to make sure nothing is broken or missing. Checking CoPilot's work is the same.
Real-life example: A bank checks every transaction before approving it. You should check CoPilot's changes before saving.
School example: After CoPilot cleans the class list, the teacher checks that no student was removed by mistake.
Home example: After CoPilot cleans the shopping list, you check that no items were removed.
Nigerian example: After CoPilot cleans the sales record, the trader checks that no sales were deleted.
Illustration:
Check CoPilot's Work: +---------------------------+ | 1. Look at the changes | | 2. Ask: Is this correct? | | 3. If yes, save. | | 4. If no, undo and retry. | +---------------------------+
Mini summary: Always check CoPilot's cleaning work. Look at the changes and make sure they are correct.
Definition: Keeping data clean means preventing mistakes before they happen.
Why it is important: Prevention is better than cure. If you type carefully, you will not need to clean as often.
Simple explanation: Imagine you brush your teeth every day. You do not need to visit the dentist as often. Typing carefully is like brushing your teeth for data.
Real-life example: A shop owner types prices carefully. He does not need to fix them later.
School example: A student types scores carefully. The teacher does not need to correct them.
Home example: A family types the budget carefully. They do not need to fix mistakes later.
Nigerian example: A trader types item names carefully. She does not need to clean them later.
Illustration:
Prevent Mistakes: +---------------------------+ | 1. Type carefully | | 2. Use consistent formats | | 3. Check as you go | | 4. Save often | +---------------------------+
Mini summary: Prevent mistakes by typing carefully, using consistent formats, and checking as you go.
Definition: Putting it all together means following a complete process to clean your data from start to finish.
Why it is important: A stepâbyâstep process ensures you do not miss anything.
Simple explanation: Imagine you are baking a cake. You follow a recipe: gather ingredients, mix, bake, cool, decorate. Cleaning data has a recipe too.
Real-life example: A company follows a data cleaning checklist before every monthly report.
School example: A teacher follows a checklist before calculating final grades.
Home example: A family follows a checklist before planning the monthly budget.
Nigerian example: A business follows a checklist before submitting tax records.
Illustration:
Data Cleaning Recipe: +---------------------------+ | 1. Format as Table | | 2. Fix capital letters | | 3. Remove extra spaces | | 4. Fix number formats | | 5. Fix date formats | | 6. Remove duplicates | | 7. Fill missing values | | 8. Highlight problems | | 9. Check everything | | 10. Save and celebrate! | +---------------------------+
Mini summary: Follow a stepâbyâstep process to clean your data completely. Check everything before saving.
| Word | Simple Definition |
|---|---|
| Data | Information, such as names, numbers, or dates. |
| Data Preparation | Getting your information ready to be used. |
| Data Cleaning | Fixing mistakes in your data. |
| Table | A special Excel format with headers and rows. |
| Header | The top row of a table that names each column. |
| Duplicate | A row that appears more than once. |
| Missing Value | An empty cell that should have information. |
| Inconsistent | Not the same. For example, "Coke" and "coke." |
| Capitalisation | Using capital letters. For example, "A" vs "a." |
| Format | How something is written or displayed. |
| Conditional Formatting | Changing cell colours based on rules. |
| Outlier | A value that is very different from the others. |
| Clean Data | An Excel feature that finds and fixes problems. |
| Verify | To check if something is correct. |
| Garbage In, Garbage Out | Messy data gives wrong answers. |
If your data is clean, Excel and CoPilot give correct answers. If your data is messy, answers are wrong.
Format your data as a Table so CoPilot can read it easily.
Use the same format for all entries. "Coke" and "coke" should be "Coke."
CoPilot is helpful, but it can make mistakes. Always look at the changes.
Type carefully and use consistent formats. This reduces the need for cleaning.
Use a stepâbyâstep checklist to clean your data completely.
Mrs. Bello teaches at a secondary school in Kano. She records student scores in Excel. Some scores have extra spaces. Some names have inconsistent capitals. She uses CoPilot to clean the data before calculating grades. The grades are now correct.
Mr. Okafor runs a phone accessory shop in Lagos. He records sales in Excel. Some prices are written as "âŚ5,000" and others as "5000." CoPilot converts them all to numbers. The total sales are now correct.
Mrs. Adeyemi records patient names in Excel. Some names have extra spaces. Some have inconsistent capitals. CoPilot cleans the list. The hospital now sends letters to the correct patients.
Coach Musa records player goals in Excel. Two rows have the same player name twice. CoPilot removes the duplicate. The goal totals are now correct.
A trader sells fabrics at Balogun Market. She records each sale in Excel. Some items are written as "Lace," "lace," and "LACE." CoPilot fixes the capitalisation. The total yards of lace sold is now correct.
A student in Ibadan tracks her WAEC subject scores. Some scores are missing. She uses CoPilot to fill them in with 0. The average score is now correct.
A youth corper in Enugu plans a community project. He lists expenses in Excel. Some dates are written differently. CoPilot converts them all to one format. The project timeline is now clear.
A small business owner in Abuja tracks customer orders. Two orders are duplicates. CoPilot removes the duplicate. The total orders are now correct.
You record your pocket money in Excel. Some amounts are written as "500" and others as "500.00." CoPilot converts them all to numbers. Your total savings are now correct.
You record your friends' game scores. Two friends have the same name. CoPilot removes the duplicate. The leaderboard is now correct.
You list your football cards in Excel. Some card names have extra spaces. CoPilot removes them. Your collection list is now clean.
You list party items in Excel. Some items are written as "Cake," "cake," and "CAKE." CoPilot fixes the capitalisation. Your shopping list is now clean.
| Situation | What You Ask CoPilot |
|---|---|
| Chore list | "Remove duplicate chores from the list." |
| Trip planning | "Fix inconsistent capitalisation in the destination column." |
| Exercise log | "Fill missing exercise minutes with 0." |
| Savings tracker | "Convert the savings column to numbers." |
| Reading log | "Remove extra spaces from book titles." |
| Mistake | Why It Is a Problem | How to Avoid It |
|---|---|---|
| Not formatting as a Table | CoPilot may not read the data correctly | Use Insert â Table before asking CoPilot |
| Ignoring extra spaces | Excel treats the same word as different | Ask CoPilot to remove extra spaces |
| Using different number formats | Calculations become wrong | Convert all numbers to the same format |
| Using different date formats | Excel cannot sort or calculate dates | Convert all dates to one format |
| Forgetting to check CoPilot's work | Mistakes go unnoticed | Always review changes before saving |
| Filling missing values with wrong number | Answers become wrong | Choose the correct fill value (0 or average) |
| Removing duplicates without checking | Important data may be deleted | Review before removing |
Start
|
V
Format as Table
|
V
Fix Capital Letters
|
V
Remove Extra Spaces
|
V
Fix Number Formats
|
V
Fix Date Formats
|
V
Remove Duplicates
|
V
Fill Missing Values
|
V
Highlight Problems
|
V
Check Everything
|
V
Save and Celebrate! đ
Before Cleaning: +----------+----------+----------+ | Name | Score | Date | +----------+----------+----------+ | ada | 85 | 05/03/25 | | ADA | 85 | March 5 | | Ada | 85 | 5-Mar-25 | | chidi | 72 | 06/03/25 | | Chidi | 72 | 06/03/25 | +----------+----------+----------+ After Cleaning: +----------+----------+----------+ | Name | Score | Date | +----------+----------+----------+ | Ada | 85 | 05/03/25 | | Ada | 85 | 05/03/25 | | Ada | 85 | 05/03/25 | | Chidi | 72 | 06/03/25 | +----------+----------+----------+ (Duplicates removed, capitals fixed, dates consistent)
+----------+----------+ | Score | Colour | +----------+----------+ | 85 | Green | | 45 | Red | | 91 | Green | | 38 | Red | | 72 | Yellow | +----------+----------+ (Red = below 50, Yellow = 50-70, Green = above 70)
Clean Data Panel +-----------------------------------+ | Problems Found: | | | | 1. Inconsistent capitalisation | | in column A [Fix] [Skip] | | | | 2. Extra spaces in column B | | [Fix] [Skip] | | | | 3. Duplicate rows in table | | [Fix] [Skip] | | | | [Apply All Fixes] | +-----------------------------------+
Step 1: Format as Table
|
Step 2: Fix Capital Letters
|
Step 3: Remove Extra Spaces
|
Step 4: Fix Number Formats
|
Step 5: Fix Date Formats
|
Step 6: Remove Duplicates
|
Step 7: Fill Missing Values
|
Step 8: Highlight Problems
|
Step 9: Check Everything
|
Step 10: Save
| Problem | Example | Fix |
|---|---|---|
| Inconsistent capitals | "Coke," "coke," "COKE" | Fix capitalisation |
| Extra spaces | "Ada " (space at end) | Remove extra spaces |
| Number format | "5,000" vs "5000" | Convert to numbers |
| Date format | "05/03/25" vs "March 5" | Convert to one format |
| Duplicates | Same row twice | Remove duplicates |
| Missing values | Empty cell | Fill with 0 or average |
| Outliers | Score of 999 | Highlight and investigate |
| What You Want | What to Type |
|---|---|
| Fix capitals | "Fix inconsistent capitalisation in column A" |
| Remove spaces | "Remove extra spaces from column B" |
| Fix numbers | "Convert column C to numbers" |
| Fix dates | "Convert column D to a consistent date format" |
| Remove duplicates | "Remove duplicate rows from the table" |
| Fill missing values | "Fill missing values in column B with 0" |
| Highlight problems | "Highlight all cells in column B that are below 50 in red" |
Data preparation is getting your information ready. It includes typing correctly and organising in rows and columns.
Data cleaning means fixing mistakes. It removes extra spaces, fixes capitals, and removes duplicates.
Clean data gives correct answers. Messy data gives wrong answers.
An Excel Table organises data with headers. CoPilot reads Tables best.
Inconsistent capitals make Excel treat the same word as different. Use CoPilot to fix them.
Extra spaces make Excel treat the same word as different. Use CoPilot to remove them.
Numbers must be in the same format for Excel to calculate correctly.
Dates must be in the same format for Excel to understand them.
Duplicate rows make totals wrong. Use CoPilot to remove them.
Missing values make answers wrong. Use CoPilot to fill them in.
Conditional formatting changes cell colours based on rules. Use it to spot problems.
Clean Data is a feature that finds and fixes common problems automatically.
Always check CoPilot's cleaning work. Look at the changes and make sure they are correct.
Prevent mistakes by typing carefully and using consistent formats.
Follow a stepâbyâstep process to clean your data completely.
In this module, you learned how to prepare and clean data using CoPilot in Microsoft Excel. You learned that data preparation means getting your information ready, and data cleaning means fixing mistakes.
You learned why clean data matters. Clean data gives correct answers. Messy data gives wrong answers. This is called "Garbage In, Garbage Out."
You learned how to format data as an Excel Table. Tables have headers and rows. CoPilot reads Tables best.
You learned how to fix inconsistent capital letters. "Coke," "coke," and "COKE" should all be "Coke." You learned how to remove extra spaces. "Ada " and "Ada" should both be "Ada."
You learned how to fix number formats. "5,000" and "5000" should both be numbers. You learned how to fix date formats. "05/03/25" and "March 5" should both be the same format.
You learned how to remove duplicate rows. Duplicates make totals wrong. You learned how to fill missing values. Missing values also make totals wrong.
You learned how to use conditional formatting to highlight problems. You learned how to use the Clean Data feature to find and fix common problems automatically.
You learned to always check CoPilot's work. CoPilot can make mistakes. You must look at the changes and make sure they are correct.
You learned to prevent mistakes by typing carefully and using consistent formats. Prevention is better than cure.
Finally, you learned a stepâbyâstep process for cleaning data. Follow the process to make sure you do not miss anything.
Match the word on the left with the correct definition on the right.
| Word | Definition |
|---|---|
| 1. Data Cleaning | A. A row that appears more than once |
| 2. Table | B. Fixing mistakes in data |
| 3. Duplicate | C. Changing cell colours based on rules |
| 4. Missing Value | D. An empty cell that should have information |
| 5. Conditional Formatting | E. A special Excel format with headers |
| 6. Clean Data | F. An Excel feature that finds and fixes problems |
Answers: 1âB, 2âE, 3âA, 4âD, 5âC, 6âF
You help run the school store. Your sales list has "Coke," "coke," and "COKE." What do you ask CoPilot to do? Which column do you fix?
You plan a birthday party. Your guest list has "Ada" and "Ada " (with a space). What do you ask CoPilot to do?
You track your football team's goals. Two rows have the same player name twice. What do you ask CoPilot to do?
Your family lists monthly expenses. Some amounts are missing. What do you ask CoPilot to do? What value do you fill with?
You track your study hours. Some dates are written as "05/03/25" and others as "March 5." What do you ask CoPilot to do?
Goal: Work in groups of 3â4 to clean a messy dataset using CoPilot.
Steps:
Discussion: Which group cleaned the data fastest? Which group made the fewest mistakes? What did you learn?
Goal: Practice cleaning data on your own.
Steps:
Goal: Create a clean pocket money tracker using Excel and CoPilot.
Steps:
Deliverable: A clean Excel file with consistent data, no duplicates, no missing values, and conditional formatting.
Instructions: Complete the following tasks in Excel using CoPilot. Write down what you asked and what CoPilot did.
Submission: Share your Excel file and a short report of what you learned.
In the next module, you will learn how to use CoPilot to create formulas and understand them. You will learn how to ask CoPilot to add columns, calculate totals, and explain what formulas do.
Before the next module, please make sure you can:
If you can do these things, you are ready for Module Three: Formula Generation and Understanding with CoPilot.
See you in the next module, young explorer! Keep practising and stay curious.
End of Module Two
Welcome back, young explorer! In Module One, you met CoPilot. In Module Two, you learned to clean data. In Module Three, you learned to create formulas. Now it is time to explore your data and find answers.
Data exploration means looking at your information to see what it tells you. Data analysis means digging deeper to find patterns, trends, and interesting facts. Together, they help you understand what your numbers mean.
Have you ever looked at a pile of puzzle pieces and wondered what the picture would be? Data exploration is like looking at the pieces. Data analysis is putting them together to see the full picture.
CoPilot makes exploration and analysis easy. You can ask questions in plain English, and CoPilot will find the answers. You can ask for summaries, top values, trends, and more.
By the end of this module, you will be able to explore any dataset, ask smart questions, create PivotTables, and find insights that help you make decisions.
Let us begin. Your data has a story to tell!
By the end of this module, you will be able to:
Emeka is a thirteenâyearâold boy who lives in Abuja, Nigeria. His father owns a small business that sells phone accessories. Every day, Emeka's father records sales in an Excel file.
One Saturday morning, Emeka's father said, "Emeka, I have a problem. I have one year of sales data, but I do not know what it means. Which product sells best? Which month is busiest? I need answers."
Emeka looked at the spreadsheet. It had thousands of rows. Names, dates, quantities, prices. It was overwhelming.
"I do not know where to start," said Emeka.
Just then, Emeka's cousin Ada walked in. She was studying data science at university. "I can help," she said. "Have you tried asking CoPilot?"
"CoPilot can answer questions about data?" asked Emeka.
"Yes!" said Ada. "Watch this."
She opened the CoPilot panel and typed, "Which product sold the most units this year?"
A moment later, CoPilot answered: "Phone chargers sold the most units, with 1,250 units."
Emeka's eyes widened. "That was fast!"
Ada typed again: "Which month had the highest total sales?"
CoPilot answered: "December had the highest total sales, with âŚ450,000."
"Now let me show you something else," said Ada. She typed, "Create a PivotTable showing total sales by product and by month."
A moment later, a PivotTable appeared. It showed exactly which products sold well in which months.
"This is like finding hidden treasure!" said Emeka.
"Exactly," said Ada. "Your data has a story. CoPilot helps you read it."
Emeka's father was very happy. He used the insights to order more phone chargers before December and less of the slowâselling items. His business grew.
Now it is your turn. Are you ready to explore your data and find hidden treasure?
Raw Data CoPilot Analysis +----------------+ +----------------+ | Thousands of | | Top product | | rows of sales | -----> | Best month | | Hard to read | | Trends | | No clear story | | Clear insights | +----------------+ +----------------+
Definition: Data exploration means looking at your data to understand what it contains. It is like opening a treasure chest and seeing what is inside.
Why it is important: Before you can analyse data, you must understand it. Exploration helps you see what columns you have, what values are typical, and what might be unusual.
Simple explanation: Imagine you receive a box of mixed beads. Before you make a necklace, you look at all the beads. You sort them by colour and size. Data exploration is the same. You look at your data before you analyse it.
Real-life example: A shop owner looks at a year of sales data to see which products are popular.
School example: A teacher looks at test scores to see how the class performed overall.
Home example: A family looks at a year of expenses to see where money is going.
Nigerian example: A trader at Balogun Market looks at daily sales records to see which days are busiest.
Illustration:
Data Exploration Steps: +---------------------------+ | 1. Look at the columns | | 2. Check the rows | | 3. See the range of values| | 4. Spot anything unusual | | 5. Ask questions | +---------------------------+
Mini summary: Data exploration means looking at your data to understand what it contains.
Definition: Data analysis means digging deeper into your data to find patterns, trends, and answers to questions.
Why it is important: Analysis turns data into insights. Insights help you make better decisions.
Simple explanation: Imagine you have a pile of puzzle pieces. Exploration is looking at the pieces. Analysis is putting them together to see the picture. Analysis answers questions like "What is the trend?" and "Why did this happen?"
Real-life example: A business analyses sales data to find out which products are growing and which are declining.
School example: A teacher analyses test scores to find out which topics students struggle with.
Home example: A family analyses expenses to find out which months are most expensive.
Nigerian example: A business analyses customer data to find out which products are most popular in different regions.
Illustration:
Data Analysis Steps: +---------------------------+ | 1. Ask a question | | 2. Find the answer | | 3. Look for patterns | | 4. Check if it makes sense| | 5. Use the insight | +---------------------------+
Mini summary: Data analysis means digging deeper to find patterns and answers in your data.
Definition: Chat mode is one of CoPilot's three modes. In Chat mode, CoPilot answers your questions without changing your data.
Why it is important: Chat mode is safe for exploration. You can ask as many questions as you want without worrying about changing anything.
Simple explanation: Imagine you are in a library. You ask the librarian questions. The librarian answers but does not change any books. Chat mode is like that. CoPilot answers but does not change your data.
Real-life example: A business owner asks CoPilot, "What was my total sales last month?" CoPilot answers without changing the file.
School example: A student asks CoPilot, "What is the highest score in the class?" CoPilot answers without changing the marks.
Home example: A parent asks CoPilot, "What is our biggest expense?" CoPilot answers without changing the budget.
Nigerian example: A trader asks CoPilot, "Which day had the most sales?" CoPilot answers without changing the records.
Illustration:
Chat Mode: +---------------------------+ | You ask a question | | CoPilot answers | | Data is NOT changed | | Safe to ask anything | +---------------------------+
Stepâbyâstep:
Mini summary: Chat mode lets you ask questions without changing your data. It is safe for exploration.
Definition: Simple questions are questions that have a direct answer. For example, "What is the total?" or "How many rows?"
Why it is important: Simple questions help you understand the basics of your data before going deeper.
Simple explanation: Imagine you have a box of sweets. You ask, "How many sweets are in the box?" That is a simple question. You ask, "What colour are they?" That is another simple question. Simple questions help you understand what you have.
Real-life example: A shop owner asks, "How many products did I sell today?"
School example: A teacher asks, "How many students scored above 70?"
Home example: A family asks, "How much did we spend on food this month?"
Nigerian example: A trader asks, "How many bags of rice did I sell this week?"
Illustration:
Simple Questions: +---------------------------+ | "What is the total?" | | "How many rows?" | | "What is the average?" | | "What is the highest?" | | "What is the lowest?" | +---------------------------+
| What You Want to Know | What to Ask CoPilot |
|---|---|
| Total of a column | "What is the total of the Sales column?" |
| Number of rows | "How many rows are in the table?" |
| Average value | "What is the average price?" |
| Highest value | "What is the highest score?" |
| Lowest value | "What is the lowest score?" |
Mini summary: Simple questions help you understand the basics of your data.
Definition: Top values are the highest values in a column. Bottom values are the lowest values.
Why it is important: Top and bottom values help you spot the best and worst performers.
Simple explanation: Imagine you are a football coach. You want to know who scored the most goals. That is the top value. You also want to know who scored the least. That is the bottom value.
Real-life example: A business finds the topâselling product and the worstâselling product.
School example: A teacher finds the highest and lowest scores in the class.
Home example: A family finds the most expensive and least expensive months.
Nigerian example: A trader finds the bestâselling item and the slowestâselling item.
Illustration:
Top and Bottom Values: +----------+----------+ | Product | Sales | +----------+----------+ | Charger | 1250 | <-- Top | Cable | 980 | | Case | 750 | | Screen | 200 | <-- Bottom +----------+----------+
Stepâbyâstep:
Mini summary: Top values are the highest. Bottom values are the lowest. CoPilot can find both.
Definition: Sorting means arranging data in order. You can sort from smallest to largest (ascending) or largest to smallest (descending).
Why it is important: Sorting helps you see patterns. It makes it easy to find the highest and lowest values.
Simple explanation: Imagine you have a list of scores. Sorting them from highest to lowest shows you who is first and who is last. Sorting from lowest to highest shows the opposite.
Real-life example: A shop owner sorts products by sales to see which ones sell best.
School example: A teacher sorts students by score to create a ranking.
Home example: A family sorts expenses from largest to smallest to see where most money goes.
Nigerian example: A trader sorts items by profit to see which ones are most profitable.
Illustration:
Sorting: Before: After (Descending): +-------+ +-------+ | 72 | | 91 | | 85 | | 85 | | 91 | | 72 | | 68 | | 68 | +-------+ +-------+
Stepâbyâstep:
Mini summary: Sorting arranges data in order. CoPilot can sort from highest to lowest or lowest to highest.
Definition: Filtering means showing only the rows that meet a condition. Other rows are hidden.
Why it is important: Filtering helps you focus on specific data. You can see only the rows you care about.
Simple explanation: Imagine you have a list of all students. You want to see only those who scored above 70. Filtering hides the others and shows only the top students.
Real-life example: A business filters sales to show only transactions above âŚ100,000.
School example: A teacher filters the class list to show only students who passed.
Home example: A family filters expenses to show only food purchases.
Nigerian example: A trader filters sales to show only items sold in Lagos.
Illustration:
Filtering: Before: After (Score > 70): +-------+-------+ +-------+-------+ | Ada | 85 | | Ada | 85 | | Chidi | 65 | | Ngozi | 91 | | Ngozi | 91 | | Emeka | 78 | | Emeka | 78 | +-------+-------+ +-------+-------+
Stepâbyâstep:
Mini summary: Filtering shows only rows that meet a condition. CoPilot can filter your data.
Definition: A PivotTable is a tool that summarises large amounts of data quickly. It groups and counts, sums, or averages data.
Why it is important: PivotTables turn thousands of rows into a simple summary. They help you see patterns that are hard to spot otherwise.
Simple explanation: Imagine you have a huge box of coins. You want to know how many of each type you have. You sort them into piles. A PivotTable does this for data. It sorts and counts automatically.
Real-life example: A business creates a PivotTable to show total sales by product and by month.
School example: A teacher creates a PivotTable to show average scores by subject and by class.
Home example: A family creates a PivotTable to show total expenses by category.
Nigerian example: A trader creates a PivotTable to show total sales by item and by day of the week.
Illustration:
PivotTable: +----------+--------+--------+--------+ | Product | Jan | Feb | Mar | +----------+--------+--------+--------+ | Charger | 100 | 120 | 150 | | Cable | 80 | 90 | 85 | | Case | 50 | 60 | 70 | +----------+--------+--------+--------+ (Summarises sales by product and month)
Stepâbyâstep:
Mini summary: A PivotTable summarises large data quickly. CoPilot can create one for you.
Definition: A trend is a pattern that changes over time. For example, sales might increase every December.
Why it is important: Trends help you predict the future. If sales increase every December, you can prepare for it.
Simple explanation: Imagine you track your height every year. You notice you are getting taller each year. That is a trend. Data trends work the same way.
Real-life example: A business sees that sales increase every holiday season.
School example: A teacher sees that test scores improve as the year goes on.
Home example: A family sees that electricity bills are higher in hot months.
Nigerian example: A trader sees that sales of cold drinks increase in the dry season.
Illustration:
Trend Over Time:
Sales
|
500| *
| * *
400| * *
| * *
300| * *
|* *
200+---------------------+----> Month
Jan Feb Mar Apr May Jun
(Sales are increasing)
Stepâbyâstep:
Mini summary: A trend is a pattern that changes over time. CoPilot can find trends in your data.
Definition: An outlier is a value that is very different from the others. An anomaly is something unusual.
Why it is important: Outliers can be mistakes or important discoveries. They need to be checked.
Simple explanation: Imagine you have test scores: 85, 90, 88, 92, and 5. The score of 5 is very different. It is an outlier. It might be a mistake, or it might be important.
Real-life example: A bank finds an unusually large transaction. It might be fraud.
School example: A teacher finds a score of 999 in a list of scores out of 100. It is probably a mistake.
Home example: A family finds an electricity bill that is 10 times higher than normal. Something is wrong.
Nigerian example: A trader finds a sale of âŚ1,000,000 when most sales are under âŚ10,000. It needs checking.
Illustration:
Outlier: +----------+ | 85 | | 90 | | 88 | | 92 | | 5 | <-- Outlier! | 87 | +----------+
Stepâbyâstep:
Mini summary: An outlier is a value that is very different. CoPilot can find outliers in your data.
Definition: A data summary is a short description of what your data contains. It includes totals, averages, counts, and other key numbers.
Why it is important: A summary gives you a quick overview. It helps you understand your data without looking at every row.
Simple explanation: Imagine you read a long book. A summary tells you the main points in a few sentences. A data summary tells you the main points of your data.
Real-life example: A business asks for a summary of monthly sales.
School example: A teacher asks for a summary of class performance.
Home example: A family asks for a summary of monthly expenses.
Nigerian example: A trader asks for a summary of weekly sales.
Illustration:
Data Summary: +---------------------------+ | Total Sales: âŚ1,250,000 | | Average Sale: âŚ12,500 | | Highest Sale: âŚ85,000 | | Lowest Sale: âŚ500 | | Number of Sales: 100 | +---------------------------+
Stepâbyâstep:
Mini summary: A data summary gives a quick overview of your data. CoPilot can create one for you.
Definition: Comparing groups means looking at two or more sets of data side by side to see differences.
Why it is important: Comparisons help you see which group is doing better or worse.
Simple explanation: Imagine you have two football teams. You compare their goals. Team A scored 20, Team B scored 15. Team A is better. Comparing groups in data works the same way.
Real-life example: A business compares sales in Lagos and Abuja to see which city performs better.
School example: A teacher compares boys' and girls' average scores.
Home example: A family compares spending in January and February.
Nigerian example: A trader compares sales on weekdays and weekends.
Illustration:
Comparing Groups: +----------+----------+ | City | Sales | +----------+----------+ | Lagos | 500,000 | | Abuja | 350,000 | | Kano | 280,000 | +----------+----------+ (Lagos has the highest sales)
Stepâbyâstep:
Mini summary: Comparing groups helps you see differences. CoPilot can compare groups in your data.
Definition: Checking analysis means looking at CoPilot's answers to make sure they are correct.
Why it is important: CoPilot can make mistakes. It might count wrong, sum wrong, or miss data.
Simple explanation: Imagine your friend tells you the answer to a maths problem. You still check it. Checking CoPilot's analysis is the same.
Real-life example: A business checks CoPilot's total sales against its own records.
School example: A teacher checks CoPilot's average score against a calculator.
Home example: A family checks CoPilot's expense total against receipts.
Nigerian example: A trader checks CoPilot's profit total against cash in the drawer.
Illustration:
Check CoPilot's Analysis: +---------------------------+ | 1. Look at the answer | | 2. Ask: Does it make sense?| | 3. Check a few rows | | 4. Use a calculator | | 5. If correct, trust it | | 6. If wrong, investigate | +---------------------------+
Mini summary: Always check CoPilot's analysis. Look at the answer and make sure it makes sense.
Definition: An insight is a useful understanding you get from data. It helps you decide what to do next.
Why it is important: Insights turn data into action. They help you make better choices.
Simple explanation: Imagine you find out that chocolate ice cream sells best in December. That is an insight. You decide to order more chocolate ice cream in December. That is using the insight.
Real-life example: A business discovers that phone chargers sell best. It orders more chargers.
School example: A teacher discovers that students struggle with fractions. She spends more time on fractions.
Home example: A family discovers that food is their biggest expense. They plan meals to save money.
Nigerian example: A trader discovers that sales are highest on Saturdays. He opens earlier on Saturdays.
Illustration:
Insight to Action:
+---------------------------+
| Insight: |
| "Chargers sell best" |
+---------------------------+
|
V
+---------------------------+
| Decision: |
| "Order more chargers" |
+---------------------------+
|
V
+---------------------------+
| Result: |
| "More sales, more profit" |
+---------------------------+
Mini summary: Insights turn data into action. Use insights to make better decisions.
Definition: Putting it all together means using exploration, analysis, and insights to answer a real question.
Why it is important: Real tasks need more than one step. You explore, analyse, check, and decide.
Simple explanation: Imagine you are a detective. You look at clues (exploration). You put them together (analysis). You find the answer (insight). You solve the case (decision). Data analysis works the same way.
Real-life example: A business explores sales, analyses trends, finds insights, and decides what to stock.
School example: A teacher explores scores, analyses averages, finds insights, and decides what to teach next.
Home example: A family explores expenses, analyses categories, finds insights, and decides how to budget.
Nigerian example: A trader explores sales, analyses products, finds insights, and decides what to order.
Illustration:
Complete Analysis Process: +---------------------------+ | 1. Explore data | | 2. Ask simple questions | | 3. Find top/bottom values | | 4. Sort and filter | | 5. Create PivotTable | | 6. Find trends | | 7. Find outliers | | 8. Compare groups | | 9. Check everything | | 10. Use insights to decide| +---------------------------+
Mini summary: Real tasks need exploration, analysis, checking, and decision making.
| Word | Simple Definition |
|---|---|
| Data Exploration | Looking at data to understand what it contains. |
| Data Analysis | Digging deeper to find patterns and answers. |
| Insight | A useful understanding from data. |
| Trend | A pattern that changes over time. |
| Outlier | A value that is very different from the others. |
| Anomaly | Something unusual or unexpected. |
| PivotTable | A tool that summarises large data quickly. |
| Sorting | Arranging data in order. |
| Filtering | Showing only rows that meet a condition. |
| Summary | A short description of key numbers. |
| Comparison | Looking at two or more groups side by side. |
| Chat Mode | A CoPilot mode that answers questions without changing data. |
| Verify | To check if something is correct. |
| Decision | A choice you make based on information. |
| Top Values | The highest values in a column. |
| Bottom Values | The lowest values in a column. |
Look at your data first. Understand what columns and values you have.
Start with easy questions. Build up to harder ones.
Chat mode answers questions without changing your data.
PivotTables turn large data into simple summaries.
Trends help you predict what might happen next.
Outliers might be mistakes or important discoveries.
Check CoPilot's answers to make sure they are correct.
Use insights to make better choices.
Mrs. Bello uses CoPilot to explore test scores. She asks for the average, the highest score, and the lowest score. She finds that students struggle with fractions. She spends more time on fractions.
Mr. Okafor uses CoPilot to analyse sales. He asks which product sells best and which month is busiest. He finds that phone chargers sell best in December. He orders more chargers before December.
Mrs. Adeyemi uses CoPilot to analyse patient data. She asks which age group visits most often. She finds that children under 5 visit most. The hospital opens a new children's wing.
Coach Musa uses CoPilot to analyse player statistics. He asks who scored the most goals and who made the most assists. He uses the insights to choose the best team.
A trader at Balogun Market uses CoPilot to analyse sales. She asks which day of the week has the most sales. She finds that Saturdays are busiest. She opens earlier on Saturdays.
A student in Ibadan uses CoPilot to analyse practice test scores. She asks which subject has the lowest average. She finds that Chemistry is lowest. She studies Chemistry more.
A youth corper in Enugu uses CoPilot to analyse project expenses. He asks which category costs the most. He finds that transport costs the most. He plans to reduce transport costs.
A small business owner in Abuja uses CoPilot to analyse customer orders. She asks which product is ordered most. She finds that screen protectors are most popular. She orders more screen protectors.
You use CoPilot to analyse your pocket money. You ask which week you saved the most. You find that you saved the most in the week you did extra chores.
You use CoPilot to analyse your game scores. You ask which day you played best. You find that you play best on Saturdays.
You use CoPilot to analyse your card collection. You ask which team has the most cards. You find that you have the most Barcelona cards.
You use CoPilot to analyse party expenses. You ask which category costs the most. You find that food costs the most.
| Situation | What You Ask CoPilot |
|---|---|
| Chore list | "Which chore takes the most time?" |
| Trip planning | "What is the total trip cost?" |
| Exercise log | "Which exercise do I do most often?" |
| Savings tracker | "Which month did I save the most?" |
| Reading log | "Which author do I read most?" |
| Mistake | Why It Is a Problem | How to Avoid It |
|---|---|---|
| Jumping to analysis without exploring | You might miss important details | Explore first, then analyse |
| Using Edit mode for questions | Data changes unexpectedly | Use Chat mode for questions |
| Not checking CoPilot's answers | Mistakes go unnoticed | Always verify the analysis |
| Ignoring outliers | Mistakes stay in the data | Check outliers and fix if needed |
| Using the wrong PivotTable fields | The summary is wrong | Check the row and column labels |
| Asking vague questions | CoPilot gives vague answers | Be specific about columns and conditions |
Start
|
V
Explore Data
|
V
Ask Simple Questions
|
V
Find Top/Bottom Values
|
V
Sort and Filter
|
V
Create PivotTable
|
V
Find Trends
|
V
Find Outliers
|
V
Compare Groups
|
V
Check Everything
|
V
Use Insights to Decide
|
V
Celebrate đ
PivotTable: +----------+--------+--------+--------+ | Product | Jan | Feb | Mar | +----------+--------+--------+--------+ | Charger | 100 | 120 | 150 | | Cable | 80 | 90 | 85 | | Case | 50 | 60 | 70 | +----------+--------+--------+--------+ (Summarises sales by product and month)
Trend Over Time:
Sales
|
500| *
| * *
400| * *
| * *
300| * *
|* *
200+---------------------+----> Month
Jan Feb Mar Apr May Jun
(Sales are increasing)
Outlier: +----------+ | 85 | | 90 | | 88 | | 92 | | 5 | <-- Outlier! | 87 | +----------+
Step 1: Learn what exploration is
|
Step 2: Learn what analysis is
|
Step 3: Use Chat mode
|
Step 4: Ask simple questions
|
Step 5: Find top/bottom values
|
Step 6: Sort and filter
|
Step 7: Create PivotTable
|
Step 8: Find trends
|
Step 9: Find outliers
|
Step 10: Ask for summary
|
Step 11: Compare groups
|
Step 12: Check analysis
|
Step 13: Use insights
|
Step 14: Put it all together
| What You Want | What to Type |
|---|---|
| Total of a column | "What is the total of the Sales column?" |
| Top values | "What are the top 5 products by sales?" |
| Bottom values | "What are the bottom 5 products by sales?" |
| Sort data | "Sort the table by sales from highest to lowest" |
| Filter data | "Show only rows where score is above 70" |
| Create PivotTable | "Create a PivotTable showing total sales by product and by month" |
| Find trends | "What is the trend in sales over the last 12 months?" |
| Find outliers | "Are there any outliers in the Sales column?" |
| Data summary | "Give me a summary of the sales data" |
| Compare groups | "Compare total sales by city" |
Data exploration means looking at your data to understand what it contains.
Data analysis means digging deeper to find patterns and answers.
Chat mode lets you ask questions without changing your data. It is safe for exploration.
Simple questions help you understand the basics of your data.
Top values are the highest. Bottom values are the lowest. CoPilot can find both.
Sorting arranges data in order. CoPilot can sort from highest to lowest or lowest to highest.
Filtering shows only rows that meet a condition. CoPilot can filter your data.
A PivotTable summarises large data quickly. CoPilot can create one for you.
A trend is a pattern that changes over time. CoPilot can find trends in your data.
An outlier is a value that is very different. CoPilot can find outliers in your data.
A data summary gives a quick overview of your data. CoPilot can create one for you.
Comparing groups helps you see differences. CoPilot can compare groups in your data.
Always check CoPilot's analysis. Look at the answer and make sure it makes sense.
Insights turn data into action. Use insights to make better decisions.
Real tasks need exploration, analysis, checking, and decision making.
In this module, you learned how to explore and analyse data using CoPilot in Microsoft Excel. You learned that data exploration means looking at your data to understand what it contains, and data analysis means digging deeper to find patterns and answers.
You learned how to use Chat mode for safe exploration. Chat mode answers your questions without changing your data. You learned how to ask simple questions about your data, like totals, averages, and counts.
You learned how to find top and bottom values. Top values are the highest. Bottom values are the lowest. You learned how to sort data from highest to lowest or lowest to highest. You learned how to filter data to show only rows that meet a condition.
You learned how to create a PivotTable with CoPilot. A PivotTable summarises large data quickly. You learned how to find trends over time. Trends are patterns that change over time. You learned how to find outliers and anomalies. Outliers are values that are very different from the others.
You learned how to ask CoPilot for a data summary. A summary gives a quick overview of your data. You learned how to compare groups to see differences. You learned to always check CoPilot's analysis to make sure it is correct.
Finally, you learned how to use insights to make decisions. Insights turn data into action. They help you make better choices.
Match the word on the left with the correct definition on the right.
| Word | Definition |
|---|---|
| 1. Data Exploration | A. A pattern that changes over time |
| 2. Data Analysis | B. Looking at data to understand it |
| 3. Trend | C. A value that is very different |
| 4. Outlier | D. Digging deeper to find answers |
| 5. PivotTable | E. Showing only rows that meet a condition |
| 6. Filtering | F. A tool that summarises large data |
Answers: 1âB, 2âD, 3âA, 4âC, 5âF, 6âE
You help run the school store. You have a year of sales data. You want to know which product sells best and which month is busiest. What do you ask CoPilot?
You plan a birthday party. You have a list of expenses. You want to know which category costs the most. What do you ask CoPilot?
You coach a football team. You have goals scored by each player. You want to know the top scorer and the average goals per player. What do you ask CoPilot?
Your family has a year of expenses. You want to know which month is most expensive. What do you ask CoPilot?
You track your study hours for each subject. You want to know which subject you study most. What do you ask CoPilot?
Goal: Work in groups of 3â4 to explore and analyse a dataset using CoPilot.
Steps:
Discussion: Which group found the most interesting insight? Which group made the fewest mistakes? What did you learn?
Goal: Practice exploring and analysing data on your own.
Steps:
Goal: Create a complete sales analysis using Excel and CoPilot.
Steps:
Deliverable: A complete analysis with a PivotTable, insights, and a written report.
Instructions: Complete the following tasks in Excel using CoPilot. Write down what you asked and what CoPilot did.
Submission: Share your Excel file and a short report of what you learned.
In the next module, you will learn how to use CoPilot for visualisation and report presentation. You will learn how to create charts, format them, and build a complete report.
Before the next module, please make sure you can:
If you can do these things, you are ready for Module Five: Visualisation and Report Presentation with CoPilot.
See you in the next module, young explorer! Keep practising and stay curious.
End of Module Four
Welcome back, young explorer! In Module One, you met CoPilot. In Module Two, you learned to clean data. In Module Three, you learned to create formulas. In Module Four, you learned to explore and analyse data. Now it is time to show what you have found.
Visualisation means turning numbers into pictures. Charts, graphs, and diagrams are visualisations. They help people understand data quickly without reading every number.
Report presentation means putting your charts and insights together in a way that tells a story. A good report helps people make decisions.
Have you ever tried to explain something with only words, but nobody understood? Then you drew a picture, and suddenly everyone understood? That is the power of visualisation. A picture is worth a thousand words.
CoPilot makes visualisation easy. You describe the chart you want in plain English, and CoPilot creates it. You can also ask CoPilot to improve the chart, change colours, or add labels.
By the end of this module, you will be able to create charts, format them, and build a complete report that tells a clear story with your data.
Let us begin. It is time to turn your numbers into pictures!
By the end of this module, you will be able to:
Ada is a thirteenâyearâold girl who lives in Lagos, Nigeria. She loves helping her mother run a small food business. Every day, they sell jollof rice, fried rice, and beans.
One day, Ada's mother said, "Ada, I want to know which food sells best. Can you help me?"
Ada opened Excel and looked at the sales data. There were hundreds of rows. Numbers everywhere. She tried to explain it to her mother, but her mother's eyes glazed over.
"I do not understand," said her mother. "It is just numbers."
Ada felt frustrated. She knew the answer was in the data, but she could not explain it clearly.
Just then, Ada's cousin Chidi walked in. He was studying computer science at university.
"Why do not you use a chart?" said Chidi.
"A chart?" said Ada.
"Yes," said Chidi. "A picture. Let me show you."
He opened the CoPilot panel and typed, "Create a pie chart showing total sales by food type."
A moment later, a beautiful pie chart appeared. Jollof rice was the biggest slice. Beans was the smallest.
Ada's mother's eyes lit up. "Now I understand!" she said. "Jollof rice sells best. We should make more jollof rice."
Ada smiled. "Charts make data easy to understand."
"Exactly," said Chidi. "A picture is worth a thousand words."
From that day, Ada always used charts to show her mother the sales data. Her mother made better decisions, and the business grew.
Now it is your turn. Are you ready to turn your numbers into pictures?
Numbers Only Chart +----------------+ +----------------+ | 500 rows of | | [Pie Chart] | | numbers | -----> | Easy to see | | Hard to read | | Clear story | | No clear story | | Fast decisions| +----------------+ +----------------+
Definition: Visualisation means turning data into pictures. Charts, graphs, and diagrams are visualisations.
Why it is important: Pictures are easier to understand than numbers. They help you see patterns, trends, and differences quickly.
Simple explanation: Imagine you have a list of 100 test scores. Reading the list tells you little. But a chart shows you immediately who scored high and who scored low. A chart is a picture of your data.
Real-life example: A business uses a bar chart to show monthly sales. The tallest bar shows the best month.
School example: A teacher uses a pie chart to show how many students got A, B, C, D, and F.
Home example: A family uses a line chart to show how electricity bills change over the year.
Nigerian example: A trader uses a column chart to show daily sales for one week.
Illustration:
Data:
+-------+-------+
| Month | Sales |
+-------+-------+
| Jan | 100 |
| Feb | 150 |
| Mar | 200 |
+-------+-------+
Visualisation:
Sales
|
200| *
150| *
100| *
+----+----+----> Month
Jan Feb Mar
Mini summary: Visualisation means turning data into pictures. Charts help you understand data quickly.
Definition: Charts are important because they show patterns, trends, and differences at a glance.
Why it is important: The human brain understands pictures faster than numbers. Charts help you communicate your findings clearly.
Simple explanation: Imagine you are telling a friend about your holiday. You could describe every day in words. Or you could show a photo. The photo tells the story faster. Charts are photos of your data.
Real-life example: A news report uses charts to show election results. Viewers understand instantly.
School example: A science project uses a chart to show how plants grow over time.
Home example: A family uses a chart to plan next year's budget.
Nigerian example: A business uses a chart to show sales growth over five years.
Illustration:
Without Chart: With Chart: +----------------+ +----------------+ | Numbers only | | Picture shows | | Hard to see | | Clear pattern | | Slow to read | | Fast to read | | Easy to miss | | Easy to spot | +----------------+ +----------------+
Mini summary: Charts show patterns and trends at a glance. They help you communicate clearly.
Definition: A bar chart uses rectangular bars to show values. The length of each bar shows the value.
Why it is important: Bar charts are great for comparing values across categories.
Simple explanation: Imagine you want to compare the heights of your friends. You draw bars for each friend. The tallest friend has the tallest bar. A bar chart does this for data.
Real-life example: A shop uses a bar chart to compare sales of different products.
School example: A teacher uses a bar chart to compare average scores across subjects.
Home example: A family uses a bar chart to compare monthly expenses.
Nigerian example: A trader uses a bar chart to compare sales in different markets.
Illustration:
Bar Chart:
Sales
|
200| ââââ
150| ââââ ââââ
100| ââââ ââââ ââââ
50| ââââ ââââ ââââ
+--------------------> Product
Rice Beans Yam
Stepâbyâstep:
Mini summary: A bar chart uses bars to compare values. CoPilot can create one for you.
Definition: A line chart uses a line to show how values change over time. It is great for showing trends.
Why it is important: Line charts show growth, decline, and patterns over time.
Simple explanation: Imagine you track your height every year. You draw dots for each year and connect them with a line. The line goes up. That is a line chart.
Real-life example: A business uses a line chart to show sales over 12 months.
School example: A student uses a line chart to show test scores over the school year.
Home example: A family uses a line chart to show electricity bills over the year.
Nigerian example: A trader uses a line chart to show sales over the last 12 months.
Illustration:
Line Chart:
Sales
|
500| *
| * *
400| * *
| * *
300| * *
|* *
200+---------------------+----> Month
Jan Feb Mar Apr May Jun
Stepâbyâstep:
Mini summary: A line chart shows changes over time. CoPilot can create one for you.
Definition: A pie chart uses slices of a circle to show parts of a whole. Each slice represents a category.
Why it is important: Pie charts show how much each category contributes to the total.
Simple explanation: Imagine you have a pizza. You cut it into slices. Each slice is a different size. A pie chart is like a pizza where each slice shows a category.
Real-life example: A business uses a pie chart to show which products contribute most to total sales.
School example: A teacher uses a pie chart to show how students spend their study time.
Home example: A family uses a pie chart to show how the monthly budget is divided.
Nigerian example: A trader uses a pie chart to show which items contribute most to profit.
Illustration:
Pie Chart:
+-------+
/ | | \
/ | Jollof| \
| | 50% | |
| +-------+ |
\ | Beans | /
\ | 30% | /
\| Rice |/
| 20% |
+-------+
Stepâbyâstep:
Mini summary: A pie chart shows parts of a whole. CoPilot can create one for you.
Definition: A column chart is like a bar chart, but the bars go up and down instead of left to right.
Why it is important: Column charts are great for comparing categories. They are easy to read.
Simple explanation: Imagine a bar chart standing up. That is a column chart. The taller the column, the bigger the value.
Real-life example: A business uses a column chart to compare sales across regions.
School example: A teacher uses a column chart to compare class averages.
Home example: A family uses a column chart to compare expenses across months.
Nigerian example: A trader uses a column chart to compare sales on different days of the week.
Illustration:
Column Chart:
Sales
|
200| ââ
150| ââ ââ
100| ââ ââ ââ
50| ââ ââ ââ
+----------------> Day
Mon Tue Wed
Stepâbyâstep:
Mini summary: A column chart uses vertical bars to compare values. CoPilot can create one for you.
Definition: Choosing the right chart type means picking the chart that best shows your data.
Why it is important: The wrong chart type confuses people. The right chart type makes the story clear.
Simple explanation: Imagine you want to show how sales change over time. A line chart is best. If you want to show parts of a whole, a pie chart is best. If you want to compare categories, a bar chart is best.
Real-life example: A news report uses a line chart to show how prices changed over time.
School example: A student uses a pie chart to show how the class voted for class captain.
Home example: A family uses a bar chart to compare monthly expenses.
Nigerian example: A trader uses a line chart to show sales growth over the year.
Illustration:
Chart Selection: +----------------+----------------+ | What You Show | Best Chart | +----------------+----------------+ | Change over time| Line chart | | Parts of a whole| Pie chart | | Compare values | Bar/Column | | Relationship | Scatter chart | +----------------+----------------+
| What You Want to Show | Best Chart Type |
|---|---|
| Change over time | Line chart |
| Parts of a whole | Pie chart |
| Compare categories | Bar chart or column chart |
| Relationship between two things | Scatter chart |
Mini summary: Choose the right chart type for your data. Line for time, pie for parts, bar for comparison.
Definition: Changing the chart type means turning one type of chart into another. For example, turning a bar chart into a pie chart.
Why it is important: Sometimes you create a chart and realise another type would be better. CoPilot can change it instantly.
Simple explanation: Imagine you drew a picture with a pencil. You decide you want to use colour instead. You change it. Changing a chart type is the same.
Real-life example: A business creates a bar chart, then changes it to a line chart to show the trend better.
School example: A student creates a pie chart, then changes it to a bar chart for easier comparison.
Home example: A family creates a column chart, then changes it to a line chart to see the trend.
Nigerian example: A trader creates a bar chart, then changes it to a pie chart to show market share.
Illustration:
Change Chart Type: Bar Chart -----> Pie Chart +-------+ +-------+ | ââââ | | / \ | | ââââ | | | | | | ââââ | | \ / | +-------+ +-------+
Stepâbyâstep:
Mini summary: CoPilot can change a chart from one type to another. Just ask.
Definition: Titles and labels are words that explain what a chart shows. The title is at the top. Labels describe the axes and data points.
Why it is important: Without titles and labels, a chart is confusing. People do not know what they are looking at.
Simple explanation: Imagine a map without street names. You would not know where you are. A chart without titles and labels is like a map without names. CoPilot can add them.
Real-life example: A business chart has a title "Monthly Sales 2025" and labels "Month" and "Sales (âŚ)."
School example: A student chart has a title "Class Average Scores" and labels "Subject" and "Score."
Home example: A family chart has a title "Monthly Expenses" and labels "Month" and "Amount (âŚ)."
Nigerian example: A trader chart has a title "Weekly Sales" and labels "Day" and "Sales (âŚ)."
Illustration:
Chart with Title and Labels: +--------------------------------+ | Monthly Sales 2025 | +--------------------------------+ | Sales (âŚ) | | | | |500| * | |400| * * | |300| * * | |200| * * | |100| * * | | +---------------------+ | | Jan Feb Mar Apr May Jun | | Month | +--------------------------------+
Stepâbyâstep:
Mini summary: Titles and labels explain what a chart shows. CoPilot can add them.
Definition: Highlighting means making specific data points stand out. You can change their colour or size.
Why it is important: Highlighting draws attention to important data. It helps people see what matters.
Simple explanation: Imagine you are reading a book. You use a yellow marker to highlight important sentences. Highlighting in a chart is the same. CoPilot can highlight the highest value, the lowest value, or any point you choose.
Real-life example: A business highlights the bestâselling month in red.
School example: A teacher highlights scores below 50 in red.
Home example: A family highlights the most expensive month in orange.
Nigerian example: A trader highlights the bestâselling day in green.
Illustration:
Highlighting: +--------------------------------+ | Monthly Sales 2025 | +--------------------------------+ | Sales (âŚ) | | | | |500| * <-- Highlight | |400| * * | |300| * * | |200| * * | |100| * * | | +---------------------+ | | Jan Feb Mar Apr May Jun | +--------------------------------+
Stepâbyâstep:
Mini summary: Highlighting makes specific data points stand out. CoPilot can highlight them.
Definition: A report is a document that presents your findings. It can include multiple charts, tables, and text.
Why it is important: Reports tell a complete story. They help people understand your analysis and make decisions.
Simple explanation: Imagine you are telling a story. You use words, pictures, and maybe a map. A report uses charts, tables, and text to tell the story of your data.
Real-life example: A business report includes a line chart of sales trends, a pie chart of product share, and a table of top products.
School example: A student report includes a bar chart of scores and a pie chart of grade distribution.
Home example: A family report includes a line chart of expenses and a table of monthly totals.
Nigerian example: A trader report includes a column chart of daily sales and a pie chart of product share.
Illustration:
Report Layout: +-----------------------------------+ | Sales Report 2025 | +-----------------------------------+ | [Line Chart: Sales Over Time] | +-----------------------------------+ | [Pie Chart: Product Share] | +-----------------------------------+ | [Table: Top 5 Products] | +-----------------------------------+ | Summary: Jollof rice sells best. | +-----------------------------------+
Stepâbyâstep:
Mini summary: A report includes multiple charts, tables, and text. It tells a complete story.
Definition: Formatting means changing the look of a chart. You can change colours, fonts, sizes, and styles.
Why it is important: Good formatting makes a chart easy to read. Bad formatting makes it confusing.
Simple explanation: Imagine you write a letter. If you use neat handwriting and clear ink, people can read it. If you scribble, nobody can read it. Formatting a chart is like writing neatly.
Real-life example: A business uses blue for profit and red for loss in a chart.
School example: A student uses bright colours to make a chart stand out.
Home example: A family uses simple colours for easy reading.
Nigerian example: A trader uses green for good sales and red for poor sales.
Illustration:
Good Formatting: Bad Formatting: +----------------+ +----------------+ | Clear title | | No title | | Labelled axes | | No labels | | Readable font | | Tiny font | | Good colours | | Confusing | +----------------+ +----------------+
| Formatting Element | Good Practice |
|---|---|
| Title | Clear and descriptive |
| Labels | Show what axes mean |
| Colours | Use few, clear colours |
| Font | Readable size and style |
| Data labels | Show values on the chart |
Mini summary: Formatting makes charts easy to read. Use clear titles, labels, and colours.
Definition: A summary is a short paragraph that describes your main findings.
Why it is important: A summary tells people what the charts mean. It helps them understand your insights quickly.
Simple explanation: Imagine you watch a movie. A summary tells you what happened in a few sentences. A report summary tells you what your data shows.
Real-life example: A business report summary says, "Sales grew by 20% this year. Jollof rice was the top product."
School example: A student report summary says, "The class average was 75. Maths was the strongest subject."
Home example: A family report summary says, "Food was our biggest expense. We spent more in December."
Nigerian example: A trader report summary says, "Saturday was the best day. Chargers sold the most."
Illustration:
Report Summary: +-----------------------------------+ | Summary: | | | | - Sales grew by 20% this year | | - Jollof rice was top product | | - December was the best month | | - Saturdays are busiest | +-----------------------------------+
Stepâbyâstep:
Mini summary: A summary describes your main findings in a few sentences. It helps people understand your report.
Definition: Sharing means giving your report to others. You can share by email, OneDrive, or printing.
Why it is important: A report is only useful if others can see it. Sharing helps people make decisions.
Simple explanation: Imagine you bake a cake. If you keep it to yourself, nobody enjoys it. Sharing your report is like sharing the cake.
Real-life example: A business shares its monthly report with managers.
School example: A student shares a project report with the teacher.
Home example: A family shares a budget report with all members.
Nigerian example: A trader shares a sales report with her business partner.
Illustration:
Sharing Options: +-----------------------------------+ | 1. Email the file | | 2. Share via OneDrive | | 3. Print a copy | | 4. Present on screen | +-----------------------------------+
Stepâbyâstep:
Mini summary: Sharing your report helps others see your findings. Use email, OneDrive, or print.
Definition: Putting it all together means creating a complete report with charts, tables, and a summary.
Why it is important: A complete report tells a full story. It helps people understand and make decisions.
Simple explanation: Imagine you are making a sandwich. You need bread, filling, and sauce. A report needs charts, tables, and a summary. Put them together, and you have a complete report.
Real-life example: A business creates a monthly report with a line chart, pie chart, table, and summary.
School example: A student creates a project report with a bar chart, table, and summary.
Home example: A family creates a budget report with a line chart, pie chart, and summary.
Nigerian example: A trader creates a sales report with a column chart, pie chart, table, and summary.
Illustration:
Complete Report: +-----------------------------------+ | Sales Report 2025 | +-----------------------------------+ | Summary: | | - Sales grew by 20% | | - Jollof rice was top product | +-----------------------------------+ | [Line Chart: Sales Over Time] | +-----------------------------------+ | [Pie Chart: Product Share] | +-----------------------------------+ | [Table: Top 5 Products] | +-----------------------------------+
Stepâbyâstep:
Mini summary: A complete report includes charts, tables, and a summary. It tells a full story.
| Word | Simple Definition |
|---|---|
| Visualisation | Turning data into pictures like charts and graphs. |
| Chart | A picture that shows data. |
| Bar Chart | A chart with rectangular bars. |
| Line Chart | A chart with a line showing change over time. |
| Pie Chart | A circular chart with slices showing parts of a whole. |
| Column Chart | A chart with vertical bars. |
| Title | Words at the top of a chart explaining what it shows. |
| Label | Words on a chart describing axes or data. |
| Highlight | Making something stand out with colour or size. |
| Formatting | Changing the look of a chart. |
| Report | A document presenting findings with charts and text. |
| Summary | A short paragraph of main findings. |
| Sharing | Giving your report to others. |
| Trend | A pattern that changes over time. |
| Axis | The lines on a chart that show scale. |
Charts turn numbers into pictures. Pictures are easier to understand.
Line for time, pie for parts, bar for comparison.
Without titles and labels, charts are confusing.
Use highlighting to draw attention to important data.
A report includes charts, tables, and a summary.
A report is useful when shared with others.
Good formatting makes charts easy to read.
Always check your charts and summary before sharing.
Mrs. Bello uses CoPilot to create a bar chart of class averages. She adds a title and labels. She highlights the lowest score in red. She shares the chart with the class.
Mr. Okafor uses CoPilot to create a line chart of monthly sales. He adds a title and labels. He highlights the best month in green. He shares the report with his staff.
Mrs. Adeyemi uses CoPilot to create a pie chart of patient visits by age group. She adds a title and labels. She shares the report with the hospital director.
Coach Musa uses CoPilot to create a column chart of goals scored by each player. He adds a title and labels. He highlights the top scorer in yellow. He shares the chart with the team.
A trader at Balogun Market uses CoPilot to create a bar chart of daily sales. She adds a title "Weekly Sales" and labels. She highlights the best day in green. She shares the chart with her business partner.
A student in Ibadan uses CoPilot to create a line chart of practice test scores over time. He adds a title and labels. He highlights his best score in blue. He shares the chart with his study group.
A youth corper in Enugu uses CoPilot to create a pie chart of project expenses. He adds a title and labels. He shares the report with his supervisor.
A small business owner in Abuja uses CoPilot to create a column chart of sales by product. She adds a title and labels. She highlights the top product in orange. She shares the report with her team.
You use CoPilot to create a line chart of your pocket money savings over six months. You add a title and labels. You highlight your best month in green.
You use CoPilot to create a bar chart of your game scores. You add a title and labels. You highlight your highest score in gold.
You use CoPilot to create a pie chart of your cards by team. You add a title and labels. You share the chart with your friends.
You use CoPilot to create a column chart of party expenses. You add a title and labels. You highlight the biggest expense in red.
| Situation | What You Ask CoPilot |
|---|---|
| Chore list | "Create a bar chart of chores completed each week." |
| Trip planning | "Create a pie chart of trip expenses by category." |
| Exercise log | "Create a line chart of exercise minutes over time." |
| Savings tracker | "Create a column chart of monthly savings." |
| Reading log | "Create a pie chart of books read by genre." |
| Mistake | Why It Is a Problem | How to Avoid It |
|---|---|---|
| Using the wrong chart type | The story is unclear | Choose line for time, pie for parts, bar for comparison |
| No title or labels | People do not know what the chart shows | Always add a title and labels |
| Too many colours | The chart looks messy | Use few, clear colours |
| Too many pie slices | The chart is hard to read | Keep pie charts to 5â7 slices |
| Not checking the chart | Mistakes go unnoticed | Always check before sharing |
| Forgetting to save | Work is lost | Save to OneDrive often |
Start
|
V
Select Data
|
V
Open CoPilot
|
V
Type Chart Request
|
V
CoPilot Creates Chart
|
V
Add Title and Labels
|
V
Highlight Key Points
|
V
Check the Chart
|
V
Save and Share
|
V
Celebrate đ
Chart Types: +----------------+----------------+ | Type | Best For | +----------------+----------------+ | Bar Chart | Comparison | | Line Chart | Trends | | Pie Chart | Parts of whole | | Column Chart | Comparison | +----------------+----------------+
+-----------------------------------+ | Sales Report 2025 | +-----------------------------------+ | Summary: | | - Sales grew by 20% | | - Jollof rice was top product | +-----------------------------------+ | [Line Chart: Sales Over Time] | +-----------------------------------+ | [Pie Chart: Product Share] | +-----------------------------------+ | [Table: Top 5 Products] | +-----------------------------------+
Step 1: Learn what visualisation is
|
Step 2: Learn why charts matter
|
Step 3: Create a bar chart
|
Step 4: Create a line chart
|
Step 5: Create a pie chart
|
Step 6: Create a column chart
|
Step 7: Choose the right chart
|
Step 8: Change chart type
|
Step 9: Add titles and labels
|
Step 10: Highlight data points
|
Step 11: Create multiple charts
|
Step 12: Format charts
|
Step 13: Add a summary
|
Step 14: Share your report
|
Step 15: Put it all together
| What You Want | What to Type |
|---|---|
| Bar chart | "Create a bar chart showing sales by product" |
| Line chart | "Create a line chart showing sales over time" |
| Pie chart | "Create a pie chart showing total sales by product" |
| Column chart | "Create a column chart showing sales by day" |
| Change chart type | "Change this chart to a pie chart" |
| Add title | "Add a title 'Monthly Sales 2025'" |
| Add labels | "Label the axes 'Month' and 'Sales'" |
| Highlight | "Highlight the highest sales point in red" |
Visualisation means turning data into pictures. Charts help you understand data quickly.
Charts show patterns and trends at a glance. They help you communicate clearly.
A bar chart uses bars to compare values. CoPilot can create one for you.
A line chart shows changes over time. CoPilot can create one for you.
A pie chart shows parts of a whole. CoPilot can create one for you.
A column chart uses vertical bars to compare values. CoPilot can create one for you.
Choose the right chart type for your data. Line for time, pie for parts, bar for comparison.
CoPilot can change a chart from one type to another. Just ask.
Titles and labels explain what a chart shows. CoPilot can add them.
Highlighting makes specific data points stand out. CoPilot can highlight them.
A report includes multiple charts, tables, and text. It tells a complete story.
Formatting makes charts easy to read. Use clear titles, labels, and colours.
A summary describes your main findings in a few sentences.
Sharing your report helps others see your findings. Use email, OneDrive, or print.
A complete report includes charts, tables, and a summary. It tells a full story.
In this module, you learned how to visualise data and present reports using CoPilot in Microsoft Excel. You learned that visualisation means turning data into pictures like charts and graphs.
You learned why charts are important. They show patterns and trends at a glance. They help you communicate your findings clearly.
You learned how to create different types of charts with CoPilot. You learned how to create a bar chart, a line chart, a pie chart, and a column chart. You learned how to choose the right chart type for your data.
You learned how to change the chart type with CoPilot. You learned how to add titles and labels to a chart. You learned how to highlight specific data points.
You learned how to create a complete report with multiple charts, a table, and a summary. You learned how to format charts for clarity. You learned how to add a summary of your main findings.
You learned how to share your report with others. You learned to always check your charts before sharing.
Finally, you learned how to put it all together. A complete report includes charts, tables, and a summary. It tells a full story with your data.
Match the chart type on the left with the best use on the right.
| Chart Type | Best Use |
|---|---|
| 1. Bar Chart | A. Showing parts of a whole |
| 2. Line Chart | B. Comparing categories |
| 3. Pie Chart | C. Showing change over time |
| 4. Column Chart | D. Comparing categories (vertical) |
Answers: 1âB, 2âC, 3âA, 4âD
You have a year of sales data. You want to show which product sells best. What chart do you create? What do you ask CoPilot?
You have a list of party expenses. You want to show how much each category costs. What chart do you create? What do you ask CoPilot?
You have goals scored by each player. You want to show who scored the most. What chart do you create? What do you ask CoPilot?
You have monthly expenses for a year. You want to show how expenses changed. What chart do you create? What do you ask CoPilot?
You have study hours per subject. You want to show how your time is divided. What chart do you create? What do you ask CoPilot?
Goal: Work in groups of 3â4 to create charts and a report using CoPilot.
Steps:
Discussion: Which group created the clearest charts? Which group made the fewest mistakes? What did you learn?
Goal: Practice creating charts on your own.
Steps:
Goal: Create a complete sales report using Excel and CoPilot.
Steps:
Deliverable: A complete report with three charts, titles, labels, highlighting, and a summary.
Instructions: Complete the following tasks in Excel using CoPilot. Write down what you asked and what CoPilot did.
Submission: Share your Excel file and a short report of what you learned.
In the next module, you will learn how to verify CoPilot's work and follow best practices. You will learn how to check formulas, data, and charts to make sure everything is correct.
Before the next module, please make sure you can:
If you can do these things, you are ready for Module Six: Verification and Best Practices with CoPilot.
See you in the next module, young explorer! Keep practising and stay curious.
End of Module Five
Welcome back, young explorer! You have come a long way. In Module One, you met CoPilot. In Module Two, you cleaned data. In Module Three, you created formulas. In Module Four, you explored and analysed data. In Module Five, you made charts and reports. Now it is time to learn the most important skill of all: checking your work.
Verification means checking if something is correct. CoPilot is a powerful helper, but it is not perfect. It can make mistakes. It can count wrong. It can use the wrong cells. It can misunderstand your question.
Best practices are the habits that help you use CoPilot safely and effectively. They are like rules for the road. If you follow them, you will avoid accidents.
Have you ever copied a friend's homework and found out later that the answers were wrong? That is why you must always check. CoPilot is like that friend. It is smart, but you must verify its work.
By the end of this module, you will know how to check CoPilot's formulas, data, charts, and analysis. You will also learn the best habits for using CoPilot every day.
Let us begin. It is time to become a careful and confident CoPilot user!
By the end of this module, you will be able to:
Emeka is a thirteenâyearâold boy who lives in Abuja, Nigeria. He helps his father run a small shop that sells phone accessories. Every evening, Emeka uses Excel to record the day's sales.
One evening, Emeka's father said, "Emeka, please tell me the total sales for today."
Emeka opened the CoPilot panel and typed, "What is the total of the Sales column?"
CoPilot answered: "âŚ85,000."
Emeka told his father the total. His father looked surprised. "That seems too high," he said. "We did not sell that much today."
Emeka checked the data. He noticed that one sale was entered twice. CoPilot had counted it twice. The correct total was actually âŚ65,000.
"CoPilot made a mistake," said Emeka.
"No," said his father. "CoPilot did not make a mistake. The data had a duplicate. CoPilot just added what it saw. You must always check your data and check CoPilot's answers."
Emeka learned an important lesson that day. CoPilot is a helper, not a magician. It works with the data you give it. If the data is wrong, the answer is wrong. And even when the data is right, you should still verify.
From that day, Emeka always checked his data before asking CoPilot. He also checked CoPilot's answers. His totals were always correct.
Now it is your turn. Are you ready to learn how to verify CoPilot's work?
Data with Duplicate CoPilot's Answer +----------------+ +----------------+ | Sale 1: 20,000 | | Total: 85,000 | | Sale 2: 30,000 | -----> | (Wrong!) | | Sale 2: 30,000 | | | | Sale 3: 15,000 | | | +----------------+ +----------------+ After Removing Duplicate: +----------------+ | Total: 65,000 | | (Correct!) | +----------------+
Definition: Verification means checking if something is correct. It means looking at CoPilot's answer and asking, "Is this right?"
Why it is important: CoPilot can make mistakes. If you do not check, you might use wrong answers to make decisions.
Simple explanation: Imagine you ask a friend to add up some numbers. Your friend gives you an answer. Do you trust it without checking? No. You check it. Verification is the act of checking.
Real-life example: A bank checks every transaction before approving it. They do not trust the computer blindly.
School example: A teacher checks CoPilot's average before writing it in the report card.
Home example: A parent checks CoPilot's budget total before making spending decisions.
Nigerian example: A trader checks CoPilot's profit total before ordering new stock.
Illustration:
Verification Process: +---------------------------+ | 1. CoPilot gives answer | | 2. You look at the answer | | 3. You ask: Is this right?| | 4. You check the data | | 5. You check the formula | | 6. You check the result | | 7. If correct, trust it | | 8. If wrong, fix it | +---------------------------+
Mini summary: Verification means checking if CoPilot's answer is correct. Always verify before using the answer.
Definition: Verification is important because CoPilot is not perfect. It can make mistakes.
Why it is important: Wrong answers lead to wrong decisions. Wrong decisions can cost money, time, or trust.
Simple explanation: Imagine you are baking a cake. If you use the wrong amount of sugar, the cake tastes bad. If you use the wrong data, your answers are bad. Verification prevents bad answers.
Real-life example: A business used a wrong sales total to plan its budget. It ordered too much stock. The stock did not sell. The business lost money.
School example: A teacher used a wrong average to assign grades. Some students got the wrong grades. Parents were upset.
Home example: A family used a wrong budget total to plan a holiday. They ran out of money.
Nigerian example: A trader used a wrong profit total to set prices. He sold at a loss without knowing.
Illustration:
Without Verification: With Verification: +----------------+ +----------------+ | Wrong answer | | Correct answer | | Wrong decision | | Good decision | | Bad result | | Good result | +----------------+ +----------------+
Mini summary: Verification prevents wrong decisions. Always check CoPilot's answers.
Definition: Checking formulas means looking at the formula CoPilot created to make sure it is correct.
Why it is important: CoPilot might use the wrong cells, the wrong operation, or the wrong range.
Simple explanation: Imagine CoPilot writes a formula to add numbers from B2 to B10. You should check that it really says B2:B10 and not B2:B5. If it says B2:B5, some numbers are missing.
Real-life example: A business checks the SUM formula to make sure all sales are included.
School example: A teacher checks the AVERAGE formula to make sure all students are included.
Home example: A family checks the budget formula to make sure all expenses are included.
Nigerian example: A trader checks the profit formula to make sure it subtracts the right columns.
Illustration:
Check the Formula: +---------------------------+ | 1. Click the formula cell | | 2. Look at the formula bar| | 3. Check the cell range | | 4. Check the operation | | 5. Check the result | +---------------------------+
| What to Check | Example |
|---|---|
| Cell range | Does =SUM(B2:B10) include all rows? |
| Operation | Does it use SUM when you wanted AVERAGE? |
| Result | Does the answer make sense? |
Mini summary: Always check CoPilot's formulas. Look at the cell range, operation, and result.
Definition: Checking data cleaning means looking at what CoPilot changed to make sure it is correct.
Why it is important: CoPilot might remove something it should not. It might change a value incorrectly.
Simple explanation: Imagine CoPilot removes duplicate rows. But what if two rows look the same but are actually different sales? CoPilot might delete a real sale. You must check.
Real-life example: A business checks that CoPilot did not remove any real sales when removing duplicates.
School example: A teacher checks that CoPilot did not remove any student names when cleaning the class list.
Home example: A family checks that CoPilot did not remove any real expenses when cleaning the budget.
Nigerian example: A trader checks that CoPilot did not remove any real sales when cleaning the sales record.
Illustration:
Check Data Cleaning: +---------------------------+ | 1. Look at the changes | | 2. Ask: Is this correct? | | 3. Check a few rows | | 4. If correct, keep it | | 5. If wrong, undo | +---------------------------+
Mini summary: Always check CoPilot's data cleaning. Make sure it did not remove or change anything important.
Definition: Checking charts means looking at the chart to make sure it shows the right data.
Why it is important: CoPilot might use the wrong column, the wrong labels, or the wrong chart type.
Simple explanation: Imagine CoPilot creates a pie chart. You look at it and see that one slice is missing. You check the data and find that CoPilot missed a row. You fix it.
Real-life example: A business checks that the sales chart includes all months.
School example: A teacher checks that the grade chart includes all students.
Home example: A family checks that the budget chart includes all expenses.
Nigerian example: A trader checks that the sales chart includes all products.
Illustration:
Check the Chart: +---------------------------+ | 1. Look at the title | | 2. Look at the labels | | 3. Look at the data | | 4. Ask: Does this match? | | 5. If yes, keep it | | 6. If no, fix it | +---------------------------+
| What to Check | Example |
|---|---|
| Title | Does it describe the chart? |
| Labels | Do the axes make sense? |
| Data | Does the chart match the numbers? |
| Chart type | Is it the right type for the data? |
Mini summary: Always check CoPilot's charts. Make sure the title, labels, and data are correct.
Definition: Checking analysis means looking at CoPilot's answers to questions and making sure they are correct.
Why it is important: CoPilot might misunderstand the question or use the wrong data.
Simple explanation: Imagine you ask, "What is the average score?" CoPilot answers "75." You check the data and find that one score is missing. The real average is 80. CoPilot was wrong because the data was incomplete.
Real-life example: A business checks CoPilot's topâselling product by looking at the data directly.
School example: A teacher checks CoPilot's class average by using a calculator.
Home example: A family checks CoPilot's biggest expense by looking at receipts.
Nigerian example: A trader checks CoPilot's bestâselling day by reviewing the sales record.
Illustration:
Check Analysis: +---------------------------+ | 1. Read CoPilot's answer | | 2. Ask: Does it make sense?| | 3. Check a few rows | | 4. Use a calculator | | 5. If correct, trust it | | 6. If wrong, investigate | +---------------------------+
Mini summary: Always check CoPilot's analysis. Make sure the answer makes sense and matches the data.
Definition: Common mistakes are errors that CoPilot makes often.
Why it is important: Knowing common mistakes helps you spot them quickly.
Simple explanation: Imagine you know your friend often forgets to carry the one in addition. You check that first. Knowing CoPilot's common mistakes helps you check the right things.
Real-life example: A business knows CoPilot sometimes misses the last row. It always checks the last row.
School example: A teacher knows CoPilot sometimes treats text as numbers. She checks the data format.
Home example: A family knows CoPilot sometimes includes hidden rows. They check for hidden rows.
Nigerian example: A trader knows CoPilot sometimes counts duplicates. He checks for duplicates first.
Illustration:
Common CoPilot Mistakes: +---------------------------+ | 1. Wrong cell range | | 2. Missing last row | | 3. Counting duplicates | | 4. Treating text as number| | 5. Wrong chart type | | 6. Misunderstanding prompt| +---------------------------+
| Mistake | What to Check |
|---|---|
| Wrong cell range | Check the formula bar |
| Missing last row | Check if the last row is included |
| Counting duplicates | Check for duplicate rows |
| Text as number | Check cell format |
| Wrong chart type | Check if the chart matches the data |
| Misunderstanding prompt | Rephrase and try again |
Mini summary: Know CoPilot's common mistakes. Check for them every time.
Definition: Prompting best practices are the habits that help you write clear prompts.
Why it is important: Clear prompts get better answers. Vague prompts get vague answers.
Simple explanation: Imagine you ask a friend, "Do the thing." Your friend is confused. If you say, "Please add up column B," your friend knows what to do. Clear prompts work the same way.
Real-life example: A business says, "Add a column called Profit that subtracts Cost from Revenue." CoPilot understands.
School example: A teacher says, "Add a column called Grade. If score is 70 or more, write 'A'." CoPilot understands.
Home example: A family says, "Add a column called Balance that subtracts Expenses from Income." CoPilot understands.
Nigerian example: A trader says, "Add a column called Profit that subtracts Buying Price from Selling Price." CoPilot understands.
Illustration:
Prompting Best Practices: +---------------------------+ | 1. Be specific | | 2. Name the columns | | 3. State the condition | | 4. One task per prompt | | 5. Rephrase if needed | +---------------------------+
| Poor Prompt | Better Prompt |
|---|---|
| "Fix it" | "Remove extra spaces from column A" |
| "Make a chart" | "Create a bar chart of scores in column B" |
| "Add numbers" | "Add up all values in the Sales column" |
| "Do something" | "Add a column called Total that sums column B" |
Mini summary: Write clear, specific prompts. Name the columns and state the condition.
Definition: Data quality best practices are the habits that keep your data clean and correct.
Why it is important: Clean data gives correct answers. Messy data gives wrong answers. This is called "Garbage In, Garbage Out."
Simple explanation: Imagine you put dirty water into a clean cup. The cup becomes dirty. If you put messy data into CoPilot, the answers become messy. Keep your data clean.
Real-life example: A business checks for duplicates before analysing sales.
School example: A teacher checks for missing scores before calculating averages.
Home example: A family checks for missing expenses before creating a budget.
Nigerian example: A trader checks for extra spaces in product names before analysing sales.
Illustration:
Data Quality Best Practices: +---------------------------+ | 1. No duplicates | | 2. No missing values | | 3. Consistent formats | | 4. Clear headers | | 5. No merged cells | +---------------------------+
Mini summary: Keep your data clean. No duplicates, no missing values, consistent formats.
Definition: Safety best practices are the habits that protect your data and your privacy.
Why it is important: CoPilot reads your data. If your data is private, you must be careful who can access it.
Simple explanation: Imagine you write a secret in a notebook. You do not leave the notebook on a park bench. You keep it safe. Your data is like that secret. Keep it safe.
Real-life example: A business does not share customer data with competitors.
School example: A teacher does not share student grades with other students.
Home example: A family does not share the budget file with strangers.
Nigerian example: A trader does not share customer phone numbers with other traders.
Illustration:
Safety Best Practices: +---------------------------+ | 1. Share only with trusted| | 2. Do not put passwords | | 3. Do not put private data| | 4. Use OneDrive security | | 5. Check sharing settings | +---------------------------+
Mini summary: Keep your data safe. Share only with trusted people. Do not put private data in shared files.
Definition: Saving best practices are the habits that keep your work safe.
Why it is important: If you do not save, you lose your work. If you save often, you never lose much.
Simple explanation: Imagine you are writing a long essay. If you do not save and the power goes off, you lose everything. Saving often prevents this.
Real-life example: A business saves its reports to OneDrive every few minutes.
School example: A student saves homework to OneDrive after every paragraph.
Home example: A family saves the budget file to OneDrive after every change.
Nigerian example: A trader saves sales records to OneDrive every evening.
Illustration:
Saving Best Practices: +---------------------------+ | 1. Save to OneDrive | | 2. Turn on AutoSave | | 3. Save after big changes | | 4. Use clear file names | | 5. Keep backup copies | +---------------------------+
Mini summary: Save your work to OneDrive often. Turn on AutoSave.
Definition: Learning best practices are the habits that help you improve your CoPilot skills.
Why it is important: CoPilot is a tool. The better you use it, the more it helps you.
Simple explanation: Imagine you are learning to play football. You practise every day. You get better. Learning CoPilot is the same. Practise every day.
Real-life example: A business owner practises using CoPilot every week. She learns new tricks.
School example: A student practises CoPilot with homework. He gets faster.
Home example: A family practises CoPilot with budgets. They get better.
Nigerian example: A trader practises CoPilot with sales records. She learns new ways to analyse.
Illustration:
Learning Best Practices: +---------------------------+ | 1. Practise every day | | 2. Try new prompts | | 3. Ask CoPilot to explain | | 4. Learn from mistakes | | 5. Share with friends | +---------------------------+
Mini summary: Practise using CoPilot every day. Try new things. Learn from mistakes.
Definition: When CoPilot is wrong, you need to fix it.
Why it is important: Wrong answers lead to wrong decisions. Fixing them prevents problems.
Simple explanation: Imagine you ask for directions. Your friend gives you the wrong way. You do not follow it. You ask again. CoPilot is the same. If it is wrong, ask again.
Real-life example: A business finds CoPilot's total is wrong. It checks the data and fixes it.
School example: A teacher finds CoPilot's average is wrong. She checks the scores and fixes them.
Home example: A family finds CoPilot's budget total is wrong. They check the expenses and fix them.
Nigerian example: A trader finds CoPilot's profit is wrong. He checks the prices and fixes them.
Illustration:
When CoPilot is Wrong: +---------------------------+ | 1. Do not panic | | 2. Check the data | | 3. Check the formula | | 4. Fix the problem | | 5. Ask CoPilot again | | 6. Verify the new answer | +---------------------------+
Mini summary: When CoPilot is wrong, check the data, fix the problem, and ask again.
Definition: Building trust means learning when to trust CoPilot and when to check more carefully.
Why it is important: CoPilot is a tool. Trust grows when you verify and see that it is usually right. Trust shrinks when you find mistakes.
Simple explanation: Imagine you have a friend who is usually right. You trust your friend. But you still check important things. CoPilot is the same. Trust it for small things. Check it for big things.
Real-life example: A business trusts CoPilot for simple totals but checks important financial reports.
School example: A teacher trusts CoPilot for sorting but checks grades carefully.
Home example: A family trusts CoPilot for shopping lists but checks the budget carefully.
Nigerian example: A trader trusts CoPilot for daily sales but checks profit margins carefully.
Illustration:
Building Trust: +---------------------------+ | 1. Start with small tasks | | 2. Verify the answers | | 3. See if CoPilot is right| | 4. Trust more over time | | 5. Always check important | +---------------------------+
Mini summary: Build trust by verifying. Trust CoPilot for small things. Check it for big things.
Definition: Putting it all together means following a complete process for using CoPilot safely and effectively.
Why it is important: A complete process ensures you do not miss anything.
Simple explanation: Imagine you are a pilot. Before takeâoff, you follow a checklist. After landing, you follow another checklist. Using CoPilot has a checklist too.
Real-life example: A business follows a checklist before using CoPilot for important reports.
School example: A teacher follows a checklist before using CoPilot for grades.
Home example: A family follows a checklist before using CoPilot for budgets.
Nigerian example: A trader follows a checklist before using CoPilot for sales records.
Illustration:
Complete CoPilot Checklist: +---------------------------+ | 1. Clean the data | | 2. Format as a Table | | 3. Write a clear prompt | | 4. Check CoPilot's answer | | 5. Verify the result | | 6. Fix any mistakes | | 7. Save to OneDrive | | 8. Share with trusted | +---------------------------+
Mini summary: Follow a complete process: clean data, clear prompt, check answer, verify result, save.
| Word | Simple Definition |
|---|---|
| Verification | Checking if something is correct. |
| Best Practice | A habit that helps you do something well. |
| Common Mistake | An error that happens often. |
| Prompt | The message you type to CoPilot. |
| Data Quality | How clean and correct your data is. |
| Garbage In, Garbage Out | Messy data gives wrong answers. |
| Safety | Protecting your data and privacy. |
| Trust | Believing something is correct. |
| Checklist | A list of steps to follow. |
| Verify | To check if something is correct. |
| Cell Range | A group of cells, like B2:B10. |
| Duplicate | A row that appears more than once. |
| Outlier | A value that is very different. |
| Prompting | Writing messages to CoPilot. |
| AutoSave | A feature that saves your work automatically. |
CoPilot helps you work faster, but it can make mistakes. You must check its work.
Checking CoPilot's answers prevents wrong decisions and bad results.
If your data is messy, CoPilot's answers will be messy. Keep your data clean.
Be specific. Name the columns. State the condition. One task per prompt.
Know CoPilot's common mistakes. Check for them every time.
Keep your data safe. Share only with trusted people.
Save your work to OneDrive. Turn on AutoSave.
Use a checklist to make sure you do not miss anything.
Mrs. Bello uses CoPilot to calculate class averages. She always checks the AVERAGE formula to make sure all students are included. She also checks the result against a calculator.
Mr. Okafor uses CoPilot to analyse sales. He checks that no duplicates are counted. He verifies the topâselling product by looking at the data directly.
Mrs. Adeyemi uses CoPilot to analyse patient data. She checks that no patient records were removed during cleaning. She verifies the age calculations.
Coach Musa uses CoPilot to analyse player statistics. He checks that all players are included. He verifies the top scorer by counting manually.
A trader at Balogun Market uses CoPilot to analyse sales. She checks for duplicates before trusting the total. She verifies the bestâselling day by reviewing the records.
A student in Ibadan uses CoPilot to analyse practice test scores. He checks that no scores are missing. He verifies the average with a calculator.
A youth corper in Enugu uses CoPilot to analyse project expenses. He checks that all expenses are included. He verifies the total against receipts.
A small business owner in Abuja uses CoPilot to analyse customer orders. She checks that no orders are duplicated. She verifies the top product by reviewing the data.
You use CoPilot to calculate your total savings. You check that no deposits are duplicated. You verify the total by counting manually.
You use CoPilot to find your highest score. You check that all scores are included. You verify the highest score by looking at the list.
You use CoPilot to find the total value of your collection. You check that no cards are duplicated. You verify the total by adding a few values.
You use CoPilot to calculate the total party cost. You check that all expenses are included. You verify the total against your list.
| Situation | What to Verify |
|---|---|
| Chore list | Check that all chores are counted. |
| Trip planning | Check that all expenses are included. |
| Exercise log | Check that no days are missing. |
| Savings tracker | Check that no deposits are duplicated. |
| Reading log | Check that all books are counted. |
| Mistake | Why It Is a Problem | How to Avoid It |
|---|---|---|
| Not checking CoPilot's answers | Wrong answers go unnoticed | Always verify before using |
| Using messy data | CoPilot gives wrong answers | Clean data before using CoPilot |
| Writing vague prompts | CoPilot misunderstands | Be specific and clear |
| Not saving often | Work is lost | Save to OneDrive and turn on AutoSave |
| Sharing private data | Privacy is lost | Share only with trusted people |
| Trusting CoPilot blindly | Mistakes go unnoticed | Verify important results |
CoPilot Gives Answer
|
V
You Look at the Answer
|
V
You Ask: Is This Right?
|
V
You Check the Data
|
V
You Check the Formula
|
V
You Check the Result
|
V
Correct? --Yes--> Trust It
|
No
|
V
Fix and Retry
Common CoPilot Mistakes: +---------------------------+ | 1. Wrong cell range | | 2. Missing last row | | 3. Counting duplicates | | 4. Treating text as number| | 5. Wrong chart type | | 6. Misunderstanding prompt| +---------------------------+
Complete CoPilot Checklist: +---------------------------+ | [ ] Clean the data | | [ ] Format as a Table | | [ ] Write a clear prompt | | [ ] Check CoPilot's answer| | [ ] Verify the result | | [ ] Fix any mistakes | | [ ] Save to OneDrive | | [ ] Share with trusted | +---------------------------+
Step 1: Learn what verification is
|
Step 2: Learn why it matters
|
Step 3: Check formulas
|
Step 4: Check data cleaning
|
Step 5: Check charts
|
Step 6: Check analysis
|
Step 7: Know common mistakes
|
Step 8: Write clear prompts
|
Step 9: Keep data clean
|
Step 10: Keep data safe
|
Step 11: Save often
|
Step 12: Practise every day
|
Step 13: Fix mistakes
|
Step 14: Build trust
|
Step 15: Put it all together
| What CoPilot Does | What to Check |
|---|---|
| Creates a formula | Cell range, operation, result |
| Cleans data | No important rows removed |
| Creates a chart | Title, labels, data match |
| Answers a question | Makes sense, matches data |
| Summarises data | All rows included, no duplicates |
| Area | Best Practice |
|---|---|
| Prompting | Be specific, name columns |
| Data quality | No duplicates, no missing values |
| Safety | Share only with trusted people |
| Saving | Save to OneDrive, turn on AutoSave |
| Learning | Practise every day |
| Verification | Always check before using |
Verification means checking if CoPilot's answer is correct. Always verify before using the answer.
Verification prevents wrong decisions. Always check CoPilot's answers.
Always check CoPilot's formulas. Look at the cell range, operation, and result.
Always check CoPilot's data cleaning. Make sure it did not remove or change anything important.
Always check CoPilot's charts. Make sure the title, labels, and data are correct.
Always check CoPilot's analysis. Make sure the answer makes sense and matches the data.
Know CoPilot's common mistakes. Check for them every time.
Write clear, specific prompts. Name the columns and state the condition.
Keep your data clean. No duplicates, no missing values, consistent formats.
Keep your data safe. Share only with trusted people.
Save your work to OneDrive often. Turn on AutoSave.
Practise using CoPilot every day. Try new things. Learn from mistakes.
When CoPilot is wrong, check the data, fix the problem, and ask again.
Build trust by verifying. Trust CoPilot for small things. Check it for big things.
Follow a complete process: clean data, clear prompt, check answer, verify result, save.
In this module, you learned how to verify CoPilot's work and follow best practices. You learned that verification means checking if something is correct.
You learned why verification is important. CoPilot can make mistakes. Wrong answers lead to wrong decisions. Verification prevents problems.
You learned how to check CoPilot's formulas. Look at the cell range, operation, and result. You learned how to check data cleaning. Make sure no important rows were removed. You learned how to check charts. Make sure the title, labels, and data are correct. You learned how to check analysis. Make sure the answer makes sense.
You learned about common CoPilot mistakes. Wrong cell range, missing last row, counting duplicates, treating text as numbers, wrong chart type, and misunderstanding prompts.
You learned best practices for prompting. Be specific, name the columns, state the condition, one task per prompt.
You learned best practices for data quality. No duplicates, no missing values, consistent formats.
You learned best practices for safety. Share only with trusted people. Do not put private data in shared files.
You learned best practices for saving. Save to OneDrive often. Turn on AutoSave.
You learned best practices for learning. Practise every day. Try new things. Learn from mistakes.
You learned what to do when CoPilot is wrong. Check the data, fix the problem, and ask again.
You learned how to build trust with CoPilot. Trust it for small things. Check it for big things.
Finally, you learned how to put it all together. Follow a complete checklist: clean data, clear prompt, check answer, verify result, save.
Match the word on the left with the correct definition on the right.
| Word | Definition |
|---|---|
| 1. Verification | A. A habit that helps you do something well |
| 2. Best Practice | B. Checking if something is correct |
| 3. Common Mistake | C. Messy data gives wrong answers |
| 4. Garbage In, Garbage Out | D. An error that happens often |
| 5. Checklist | E. A list of steps to follow |
| 6. Trust | F. Believing something is correct |
Answers: 1âB, 2âA, 3âD, 4âC, 5âE, 6âF
You use CoPilot to calculate total sales. CoPilot says âŚ85,000. You know you only sold about âŚ65,000. What do you do? What do you check?
You use CoPilot to create a pie chart of party expenses. One slice looks too big. What do you check?
You use CoPilot to find the top scorer. CoPilot says a player who you know did not score much. What do you do?
You use CoPilot to calculate the total budget. CoPilot says you spent âŚ50,000. You thought it was âŚ45,000. What do you check?
You use CoPilot to find your average study hours. CoPilot says 2 hours. You thought it was 3 hours. What do you do?
Goal: Work in groups of 3â4 to verify CoPilot's work.
Steps:
Discussion: Which group found the most mistakes? Which group made the fewest mistakes? What did you learn?
Goal: Practice verifying CoPilot's work on your own.
Steps:
Goal: Create a report that shows how you verified CoPilot's work.
Steps:
Deliverable: A written report showing what you checked and what you found.
Instructions: Complete the following tasks in Excel using CoPilot. Write down what you asked, what CoPilot did, and how you verified it.
Submission: Share your Excel file and a short report of what you learned.
Congratulations! You have completed all six modules of the CoPilot in Microsoft Excel Level One course. You have learned how to meet CoPilot, clean data, create formulas, explore data, make charts, and verify results.
In the next level, you will learn more advanced skills:
Before the next level, please make sure you can:
If you can do these things, you are ready for CoPilot in Microsoft Excel Level Two.
See you in the next level, young explorer! Keep practising, keep verifying, and stay curious.
End of Module Six
Congratulations! You have completed the CoPilot in Microsoft Excel Level One course.
You have learned:
You are now a confident CoPilot user. Keep practising and keep learning.
Course Complete!
|
V
You Are Now a
CoPilot Explorer!
|
V
Celebrate đ
End of Course