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

(1674 Verified ratings)
9339 Enrolled Learners

Last Updated: Jul 23, 2024 6:26 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

Excel: Mother of Business Intelligence
US$36

Created by:

Dhaval Patel & Hemanand Vadivel
Enroll Now
This course includes:
  • 09h:05m:26s on-demand video
  • 70 Lectures
  • 8 Exercises
  • 9 Quizzes
  • Access on any Device
  • Certificate of completion

Share With Friends

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

What you'll learn in our Excel course?

  • Excel Basics (Formulas, Tables, Charts)

  • Lookups (VLOOKUP, INDEX MATCH, XLOOKUP)

  • Business Math & Statistics concepts required for analysis

  • Pivot table (Creation and Optimization)

  • Power Query (Cleaning, Merging, and Transforming data)

  • Basics of VBA (Idea of how much of it is needed in a data analyst role)

  • Sales and Finance Functional Knowledge

  • Designing a report in Excel

  • Soft skills (being a problem solver, being in a growth zone)

  • Working Real dataset with >1 million records with industry-style project-based learning

  • Practicing via Exercises, Quizzes, and Certificate Upon Course Completion

Course Curriculum

70 Lectures   |   09h:05m:26s

1: Welcome to The Excel Experience

5 Lectures

What our learners experience

Our content is rated 4.9/5 from 9339+ Learners

testimonial-video-1593
Krish Das Dutta
Krish Das Dutta Krish Das Dutta

Aspiring Data Analyst @Codebasics

Landed a Job

testimonial-video-1094
Nishan Kapoor
Nishan Kapoor Nishan Kapoor

Senior Analyst

testimonial-video-1246
Soumya Rath
Soumya Rath Soumya Rath

Manager- Financial Planning & Analysis

testimonial-video-1480
Miguel Ángel Hernández
Miguel Ángel Hernández Miguel Ángel Hernández

testimonial-video-1520
Steffones Kaspari
Steffones Kaspari Steffones Kaspari

Budding data analyst!

View All

The best excel course that I had ever taken, The Videos are of optimum length with best information than ever, The Projects are of so good quality and we have worked so smoothly on them that I didn't even realize that I had just worked with data of over 1 million records.
Also making cinematic videos to make us feel like as if we are working as a data analyst in company kudos for that to all the codebasics team.
Also apart from just technical knowledge they taught us Real time Business skills like Project priority Matrix , Scenario planning etc which makes this course best among all.

Arun
Arun Arun

Landed a Job

Completing the Advanced Excel course was an absolute game-changer for me! From Power Query to DAX, each module was packed with exciting features that completely transformed the way I work with data. Learning to unleash Excel's full potential has been an exhilarating journey, and I feel equipped to tackle any data challenge with confidence. Highly recommend this course to anyone ready to take their Excel skills to the next level! A heartfelt thanks to Peter Pandey for his enthusiastic learning spirit and to Tony Sharma for his passionate business teachings.

Saurabh Hanwate
Saurabh Hanwate Saurabh Hanwate

Data Science Intern

🤯🤯🤯 This Course Blew My Mind! 🤯🤯🤯

I've taken a lot of online courses in my time, but I've never experienced anything quite like the Excel course from Codebasics. 💯
Forget dry lectures and endless slides. This course uses a unique cinematic approach, following the characters of Peter Pandey and Tony Sharma on their Excel journey. It's like watching a movie that teaches you Excel! 🍿

Pradeep M
Pradeep M Pradeep M

Data Analyst

Landed a Job

It has been a Incredible experience.The course is structured in a way that takes you from the basics to advanced levels.The content is comprehensive, well-explained, and the hands-on approach really helped to understand. What I appreciate most is that the course not only covers the fundamentals but also dives deep into advanced concepts. it is easy to understand because the dataset are very familiar to me(Ex: Movie data set) and engaging. Thank you very much to Tony Sharma(Dhaval & Hemanand Sir) from Peter

Nagasaravanan N
Nagasaravanan N Nagasaravanan N

Student

I recently completed the "Excel Mother of Business Intelligence" course offered by CodeBasics, and I must say that it has been an enlightening and empowering experience. As someone with a background in business and a keen interest in data analysis, this course exceeded my expectations in terms of content, clarity, and practical application.

The course is aptly named, as it delves deep into the capabilities of Excel, positioning it as the foundational tool for business intelligence. The instructor at CodeBasics demonstrates a mastery of the subject matter, breaking down complex concepts into digestible modules. The pacing of the course is well thought out, allowing for a gradual progression from fundamental Excel functions to more advanced business intelligence techniques.

One of the standout features of the course is its hands-on approach. Each module is accompanied by practical exercises and real-world examples that reinforce the theoretical concepts discussed. This not only solidifies understanding but also ensures that students are equipped with the skills to apply what they've learned in their professional endeavors.

The course covers a wide range of topics, including data cleaning, data visualization, and basic statistical analysis. I particularly appreciated the emphasis on dashboard creation and reporting, as these are crucial skills for anyone involved in business intelligence. The instructor provides valuable insights into best practices, tips, and tricks that go beyond the standard Excel knowledge found in many other courses.

The production quality of the course is commendable. The video and audio are clear, and the instructor's explanations are easy to follow. The supplementary materials, including downloadable datasets and sample files, add significant value to the overall learning experience.

Furthermore, the CodeBasics platform itself is user-friendly, making navigation and progress tracking straightforward. The discussion forums provide an opportunity to interact with other learners, share insights, and seek clarification on any challenging topics.

In conclusion, the "Excel Mother of Business Intelligence" course by CodeBasics is a comprehensive and well-designed program that equips learners with the skills needed to excel in the field of business intelligence. Whether you are a beginner looking to build a solid foundation or an experienced professional seeking to enhance your Excel and business intelligence skills, this course is an excellent investment in your professional development. I highly recommend it to anyone aiming to harness the power of Excel for effective business analysis and decision-making.

1227 Mikhil Vashi
1227 Mikhil Vashi 1227 Mikhil Vashi

Fresher

Landed a Job

View All

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, Founder of Codebasics and Course Instructor

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.

Read More →

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.

Read More →
Hemanand Vadivel, Co-Founder of Codebasics and Course Instructor

Get Certified

certificate
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! 😊

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.

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.

This Excel course is for absolute beginners hence you do not need any specific skills other than basic familiarity with computers.

Q.1 Once purchased, is this course available for lifetime access?

Yes

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

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

Paid
Python: Beginner to Advanced For Data Professionals
US$30

Python: Beginner to Advanced For Data Professionals

4.9 (363)
7097 Enrolled

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.
Paid
Get Job Ready: Power BI Data Analytics for All Levels 3.0
US$60

Get Job Ready: Power BI Data Analytics for All Levels 3.0

4.9 (803)
6887 Enrolled

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.
Paid
SQL Beginner to Advanced For Data Professionals
US$36

SQL Beginner to Advanced For Data Professionals

4.9 (1254)
8630 Enrolled

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.
Excel: Mother of Business Intelligence
US$36

Created by:

Dhaval Patel & Hemanand Vadivel
Enroll Now
This course includes:
  • 09h:05m:26s on-demand videos
  • 70 Lectures
  • 8 Exercises
  • 9 Quizzes
  • Access on any Device
  • Certificate of completion

Share With Friends

US$36

Learning knows no limits. Here’s to your journey of seamless learning. Pick your preferred course from the list of paid & free resources.

Quick Link

Help & Support

Course Topics

© 2025 Codebasics.io. All Rights Reserved | Product of LearnerX EdTech Private Limited
Our technology partner: AtliQ Technologies

Talk to us Chat with us