Excel: Mother of Business Intelligence
Beginners to Advanced Excel course for those who are preparing for a data career (especially Data Analysts). This course is carefully curated by industry experts to mimic real-world scenarios to prepare you to become a market fit. You will also get practical exercises to practice and get a simulated experience of a data analyst using Excel to solve problems.
4.9
(1922 Verified ratings)
Last Updated: Jan 23, 2026 8:56 AM
|English
Free Lifetime Access
No Experience
Needed
Start from scratch
and build up
Flexible
Schedule
Learn at your
own pace
Get
Job-Ready
Acquire essential
job skills
This course includes:
- 09h:05m:26s on-demand videos
- 71 Lectures
- 8 Exercises
- 9 Quizzes
- Access on any Device
- Certificate of completion
Free Lifetime Access
No Experience Needed
Start from scratch
and build up
Flexible Schedule
Learn at your
own pace
Get Job-Ready
Acquire essential
job skills
Course Curriculum
71 Lectures | 09h:05m:26s
3:
Excel Basics: Getting Started
13 Lectures
-
3.1: Peter Pandey’s Journey and Need to Learn Excel
-
3.2: Installing Excel: Windows / Mac
Free -
3.3: Getting Familiar With Excel
Free -
3.4: Getting More Familiar With Excel
Free -
3.5: Introduction to Formulas
Free -
3.6: Formula Behavior
Free -
3.7: Introduction to Tables
Free -
3.8: Introduction to Charts
Free -
3.9: Other Essential Features
Free -
3.10: Peter Gets His First Assignment From His Senior
Free -
3.11: Practice Exercise: Personal Expense Tracker
-
3.12: Quiz
-
3.13: Chapter Summary
5:
Excel Basics: Applying Business Maths & Statistics
9 Lectures
-
5.1: Basic Maths to Business Metrics (Bollywood movies revenue avg)
-
5.2: Commonly Used Business Metrics (P&L)
-
5.3: Commonly Used Statistic Concepts (Mean, Median, Mode)
-
5.4: Commonly Used Statistic Concepts (Variance, Standard Deviation)
-
5.5: Commonly Used Statistic Concepts (Correlation)
-
5.6: Peter Gets to Solve a Real Time Problem
-
5.7: Practice Exercise
-
5.8: Quiz
-
5.9: Chapter Summary
7:
Excel Basics+: Creating Business Reports Using Pivot Table & Power Pivot
14 Lectures
-
7.1: Pivot Table Introduction: Apple Product Sales
-
7.2: Pivot Table For Movie Analytics
-
7.3: Creating a Report Using Pivot Table
-
7.4: Pivot Table Options & Formatting
-
7.5: Using Power Pivot & DAX For Powerful Business Reports
-
7.6: Adding Targets Using Data Modelling in Power Pivot
-
7.7: Breaking Down Complex Problems: Thinking Process of a Highly Paid Data Analyst
-
7.8: More Business Metrics and Conditional Formatting
-
7.9: VBA Basics & How Much VBA You Should Learn
-
7.10: Peter Practices On His Own
-
7.11: Practice Exercise
-
7.12: Quiz
-
7.13: I Need a Favour
-
7.14: Chapter Summary
9:
Excel Advanced: Sales Analytics
12 Lectures
-
9.1: ETL (Extract, Transform and Load Data) in Excel I
-
9.2: ETL (Extract, Transform and Load Data) in Excel II
-
9.3: Business Report: Solution Design Thought Process
-
9.4: Creating Connections Among Tables Using Data Modelling
-
9.5: Adding a Date Table Using Power Query
-
9.6: Functional Knowledge: Sales
-
9.7: Sales Analytics: Creating Customer Performance Report
-
9.8: User Empathetic Report Design
-
9.9: Sales Analytics: Creating Market Performance vs Targets Reported
-
9.10: Practice Exercise
-
9.11: Quiz
-
9.12: Chapter Summary
10:
Excel Advanced: Finance Analytics
11 Lectures
-
10.1: Understanding P & L
-
10.2: Functional Knowledge: Finance
-
10.3: Adding the Finance Data to Data Model
-
10.4: Finance Analytics: P & L by Year Report
-
10.5: Fine Tuning P & L By Year Report
-
10.6: Adding Months & Quarters in Data Model
-
10.7: Finance Analytics: P & L by Months Report
-
10.8: Fine Tuning P & L By Month Report
-
10.9: Practice Exercise
-
10.10: Quiz
-
10.11: Chapter Summary
11:
Excel Advanced: Real-Time Business Applications
10 Lectures
-
11.1: Wanda’s Challenge With Prioritizing Projects
-
11.2: Peter & Tony Creates a Project Priority Matrix
-
11.3: Mentor Talk: Being A Problem Solver
-
11.4: Practice Exercise
-
11.5: Bruce Haryali Needs Help With Excel
-
11.6: Peter & Tony Creates a Scenario Planning Tool
-
11.7: Mentor Talk: Growth Zone
-
11.8: Practice Exercise
-
11.9: Quiz
-
11.10: Final Note: What’s Next?
What our learners experience
Our content is rated 4.9/5 from 10314+ Learners
Senior Analyst
Aspiring Data Analyst @Codebasics
Landed a Job
Budding data analyst!
Senior Data Executive
I recently completed the Excel course, and I must say it exceeded my expectations. As an aspiring to become a data analyst, this course provided me with invaluable skills and knowledge. From basic functions to advanced data analysis techniques, each module was well-structured and easy to follow. The hands-on exercises helped solidify my understanding, and I feel much more confident in using Excel for data analysis tasks now. Highly recommended for anyone looking to kickstart their journey into the world of data analysis.
Landed a Job
I recently completed the Excel: Mother of Business Intelligence course that was incredibly beneficial in enhancing my skills. The course was well-structured and covered a wide range of topics, from basic functions to advanced Excel techniques. Dhaval sir provided clear and concise explanations, making it easy to grasp even the most complex concepts. I particularly appreciated the practice exercises, quizzes, tips, and tricks shared throughout the course, which have significantly improved my efficiency and proficiency in Excel. Overall, this course has greatly boosted my confidence in using Excel, and I highly recommend it to anyone looking to deepen their understanding and capabilities with this powerful tool.
Data Aspirant
Landed a Job
As a data analyst enthusiast, I recently completed the first module of the Data Analyst Boot Camp 4.0, which focused on Excel. The course was comprehensive, structured, and engaging, covering a wide range of essential Excel features crucial for a data analyst's toolkit.
What I liked:
Clear and Concise Content: The lessons were well-organized, with clear explanations of complex concepts such as data cleaning, filtering, advanced formulas, and pivot tables.
Hands-On Learning: The course emphasized practical learning through exercises, which helped me apply the concepts and tools directly to real-world data analysis tasks.
Comprehensive Coverage: It covered Excel’s advanced features like Power Query, VLOOKUP, and Pivot Tables, which are vital for data analysis and reporting.
Expert Instructors: The instructors were knowledgeable and approachable, and they ensured that all queries were addressed.
Real-World Use Cases: I particularly appreciated the real-world examples and use cases that helped me understand how Excel is used in professional data analytics environments.
Areas for Improvement:
Pace of Learning: Although the pace was good for most learners, a bit more time could have been spent on some advanced Excel topics for deeper clarity.
Course Interactivity: Adding more interactive elements, such as live sessions or Q&A forums, would enhance the learning experience further.
Conclusion:
Overall, the Data Analyst Boot Camp 4.0 has been an excellent starting point for anyone looking to build a career in data analytics. The Excel module has strengthened my foundational skills, and I feel more confident in analyzing data efficiently. I highly recommend this course to aspiring data analysts who want to develop a solid understanding of Excel and its application in the data analysis field.
MCA - Final Sem Student from SRM university
Landed a Job
I recently completed the Codebasics Excel course, and as my first-ever online course, it was a really positive experience. The content is well-structured and designed especially for beginners, which made it easy to follow along without feeling overwhelmed.
The sessions are well planned, starting from the basics and gradually moving to more practical concepts. I especially liked how the course focuses on real-world examples, which helped me understand how Excel is actually used in professional scenarios.
Overall, I now have a solid foundation in Excel and feel much more confident using it. I would definitely recommend this course to anyone.
Totally worth the time invested. I gained valuable industry insights through this course with practical learning. I’ll definitely look forward to taking more courses in the future thank you for the excellent teaching!
System Requirements
- OS: Windows / MAC
- Memory: 4 GB or more (Recommended)
- Processor: 1 GHz or faster (Recommended)
- Display: 1440*900 or larger display resolution (Recommended)
- Web: Latest version of Safari, Chrome, Edge, or Firefox
- Note: Excel on MacBook has some limitations on features like Power Pivot, DAX, and Power Query. Due to this limitation, you might not be able to replicate all operations that are taught in the course.
Course Instructors/Creators
Dhaval Patel
Data Entrepreneur (17+ Years),
YouTuber,
Ex - Bloomberg, NVIDIA
I have 17 years of experience in Programming and Data Science working for big tech companies like NVIDIA and Bloomberg. I also run a famous YouTube channel called Codebasics where I pursue my passion for teaching.
Hemanand Vadivel
Ex- Data Analytics Manager, 8+ Years in Europe, Microsoft Certified, Certified Supply Chain Professional
I’m a Mechanical Engineer who transitioned to a full-time Data & Analytics Manager in the UK & Germany. I have delivered 30+ analytics projects over 15+ countries and trained professionals at different levels to equip them with valuable analytics skills.
Get Certified
When You Complete This Course
You receive a ‘Certificate of Completion’ signed and addressed personally by me, your guide and mentor. – Dhaval Patel
Add and share this certificate with your Resume/CV or on your LinkedIn profile.
Frequently Asked Questions
Q.1
What is different in this Excel course compared to hundreds of courses on the internet and free tutorials on YouTube?
Most of the Excel courses available online teach you how to build x & y without any business context and do not prepare you for real business world problem-solving. This course is rather an experience in which you will learn Excel by solving real-life use cases in an imaginary company called AtliQ Hardware. The tutorials are very easy to understand and also have a lot of fun elements in them so that you don’t get bored! 😊
Q.2
What dataset is used in this course? Is it some toy dataset or something that mimics a real-world problem?
For initial basics, we have used a toy dataset of movies but for advanced concepts, we used a dataset that is crafted to mimic the real business world by consolidating our years of experience and the FMCG industry. That dataset contains more than 1 million records.
Q.3
What is the duration of this Beginners to Advanced Excel course?
Our beginners to advanced Excel course comprises 9 hours of on-demand video content. This allows you to learn Excel at your own pace.
Q.1
I have zero knowledge of Excel and belong to a non-technical background. Can I take this Excel course?
Yes, this is the perfect course for anyone who has never worked on excel and wants to build a career in the IT/Data Analytics industry or just wants to perform better in their current job or business using data.
Q.2
What are the things I need to know before starting this Beginners to Advanced Excel course?
This Excel course is for absolute beginners hence you do not need any specific skills other than basic familiarity with computers.
Q.2
How can I get help if I have a doubt and need support?
We have an active discord server where you can post your question and most of the time you will get an answer in a reasonable time frame.
Q.1
Can I add this course to my resume?
Yes. Absolutely you can mention the AtliQ Hardware project experience in your resume with the relevant skills that you will learn from this course
Q.2
I’m not sure if this course is good enough for me to invest some money. What can I do?
Don’t worry. Many videos in this Excel course are free so watch them to get an idea of the quality of teaching. Dhaval Patel (the course instructor) runs a popular data science YouTube channel called Codebasics. On that, you can watch his videos and read comments to get an idea of his teaching style
More Courses
Python: Beginner to Advanced For Data Professionals
This project-based learning course will teach Python through hands-on experience with two real-world projects: (1) Data analysis in the hospitality domain and (2) Building an expense tracking system. It is designed for both complete beginners with no prior coding experience and those with some Python knowledge looking to enhance their skills. The course is taught by an industry expert with over 14 years of experience at leading tech companies such as Nvidia and Bloomberg.
Get Job Ready: Power BI Data Analytics for All Levels 3.0
This practical beginner’s course lets you learn Power BI from scratch, preparing you for the Data Analyst, Business Analyst, or Power BI Developer job market. The course provides an end-to-end Power BI project, carefully curated to offer you real organizational experience and business context.
SQL Beginner to Advanced For Data Professionals
Beginners to Advanced SQL course for those preparing for a data career (Data Analyst, Data Scientist, or Data Engineer). This course is carefully curated to simulate real-time organizational experience to prepare you for the current job market and at the same time provides you with an ultimate learning experience through a storytelling mode that you would see in movies.
This course includes:
- 09h:05m:26s on-demand videos
- 71 Lectures
- 8 Exercises
- 9 Quizzes
- Access on any Device
- Certificate of completion
Course Preview
/p>
Already Included in Your Bootcamp
You can keep the Bootcamp or replace it with this individual course.