Data Analytics with Excel and Power BI: From Beginner to Job Ready
What you'll learn
- Analyze and visualize data using Excel and Power BI
- Clean and prepare messy datasets for analysis
- Create interactive dashboards and reports
- Write basic formulas and perform data calculations
- Turn data into insights for business decision making
Prerequisites
- Basic computer knowledge
- Familiarity with Microsoft Excel (very basic level is fine)
- No prior data analytics experience required
- A laptop with Excel and Power BI Desktop installed
Curriculum
-
Introduction to Data Analytics
- What data analytics is and why it matters
- Types of data and real-world use cases
- Overview of tools used in data analytics
-
Excel for Data Analysis
- Basic Excel functions and formulas
- Sorting, filtering, and data cleaning
- Creating simple charts and tables
-
Data Cleaning and Preparation
- Handling missing and messy data
- Using Excel for data transformation
- Introduction to Power Query
-
Power BI Basics
- Installing and navigating Power BI Desktop
- Importing and connecting datasets
- Creating your first visuals
-
Data Visualization and Dashboards
- Building interactive dashboards
- Choosing the right charts for insights
- Adding filters and slicers
-
Final Project
- Building a complete analytics dashboard
- Analyzing a real-world dataset
- Presenting insights like a data analyst
Your instructor
Folake Bolarinwa
Data Scientist
Folake is a data analytics instructor with experience in helping learners turn raw data into clear, actionable insights. She focuses on practical, hands-on teaching, guiding students through real-world datasets and business scenarios. Her approach makes complex analytics concepts easy to understand, especially for beginners building a foundation in data analysis and reporting.
Enroll in Data Analytics with Excel and Power BI: From Beginner to Job Ready
Choose a class type, enter your details, then continue to secure payment.
