Beginner
Introduction to Data Analysis using Excel
This course helps you understand data and how to use Excel to work with it. You will learn step-by-step how to clean data, do simple calculations, and make charts that tell clear stories.
We start with the basics — What is data? Why do we analyze it? Then we move into hands-on Excel skills. You will practice entering data, using formulas and functions, making tables, creating charts, and using pivot tables.
By the end, you will use everything you learned to do a small project and tell a data story — just like a real data analyst!
No experience is needed. We explain everything in a clear and simple way.
Curriculum
- 9 Sections
- 28 Lessons
- 1 Assignment
- 0m Duration
Getting Started
2 Lessons
- Install and Download Excel.
- Join Ogo School Discord Community
Introduction to Data and Data Analysis
Introduction to Excel Spreadsheets
6 Lessons1 Assignment
- Get Module 2 Material
- Overview of Excel Interface (ribbon, sheets, cells)
- Viewing, Entering, and Editing Data in Excel
- Formatting Rows, Columns, and Fonts
- Key 5 Keyboard Shortcuts
- Get Excel for Free in the Web
- Assignmnet
Getting Started with Excel Formulas and Functions
8 Lessons
- Get Module 3 Material
- Excel Data Types
- Introduction to Formulas and Functions: Add, Subtract, Multiply, Divide - Part 1
- Introduction to Formulas and Functions: Add, Subtract, Multiply, Divide - Part 2
- Common Excel Functions: AVERAGE, MAX, MIN, COUNT, COUNTA
- Relative and Absolute Cell Referencing in Excel
- Number and Date Autofill
- 4 Excel Hacks that Will Save You a Lot of Time
Cleaning & Wrangling Data Using Excel Spreadsheets
12 Lessons
- Get Module 4 Material
- Understanding Data Quality and Data Cleaning
- Work with Data from .CSV, .TXT file formats
- Autofit Rows and Columns
- Clean up Formatting Issues
- Remove Blank Rows and Duplicates
- Convert Text-lookalike Numbers to Numbers
- Standardize Date Formats
- Tidying Text in Excel: TRIM(), PROPER(), UPPER(), and LOWER() Functions
- Automatic Data Clean Up with Excel Flash Fill
- Find and Replace in Excel
- Basic Data Validation in Excel