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.
Manager- Financial Planning & Analysis
Senior Analyst
Budding data analyst!
Aspiring Data Analyst @Codebasics
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.
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! 🍿
Data Analyst
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
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.
Fresher
I am very happy to announce that I have recently completed Microsoft excel course of codebasics and it really increased my confidence in excel. The course structure is really motivated which always makes you stay connected with mentors and it feels like we are really working with some experts, i have done one project of Atliq hardware where I learned very interesting function of excel Power query which helps us make our data presentable and readable.
Excel is really very vast before doing this course i was aware for some simple formula and functions but after doing this course i got to know that we can do as much as we can do in excel.
Overall, I highly recommend codebasiscs excel course to anyone looking to enhance their Excel proficiency. Whether you're a student, professional, or just someone wanting to improve your spreadsheet skills, this course provides a solid foundation and equips you with the tools to excel in your Excel endeavors. It's a worthwhile investment, and I'm already seeing the positive impact on my productivity and efficiency in handling data and analysis tasks.
Associate
70 Lectures | 9hr : 00min
12 Lectures
Peter Pandey’s Journey and Need to Learn Excel
Installing Excel: Windows / Mac
Getting Familiar With Excel
Getting More Familiar With Excel
Introduction to Formulas
Formula Behavior
Introduction to Tables
Introduction to Charts
Other Essential Features
Peter Gets His First Assignment From His Senior
Practice Exercise: Personal Expense Tracker
Quiz
8 Lectures
Basic Maths to Business Metrics (Bollywood movies revenue avg)
Commonly Used Business Metrics (P&L)
Commonly Used Statistic Concepts (Mean, Median, Mode)
Commonly Used Statistic Concepts (Variance, Standard Deviation)
Commonly Used Statistic Concepts (Correlation)
Peter Gets to Solve a Real Time Problem
Practice Exercise
Quiz
13 Lectures
Pivot Table Introduction: Apple Product Sales
Pivot Table For Movie Analytics
Creating a Report Using Pivot Table
Pivot Table Options & Formatting
Using Power Pivot & DAX For Powerful Business Reports
Adding Targets Using Data Modelling in Power Pivot
Breaking Down Complex Problems: Thinking Process of a Highly Paid Data Analyst
More Business Metrics and Conditional Formatting
VBA Basics & How Much VBA You Should Learn
Peter Practices On His Own
Practice Exercise
Quiz
I Need a Favour
11 Lectures
ETL (Extract, Transform and Load Data) in Excel I
ETL (Extract, Transform and Load Data) in Excel II
Business Report: Solution Design Thought Process
Creating Connections Among Tables Using Data Modelling
Adding a Date Table Using Power Query
Functional Knowledge: Sales
Sales Analytics: Creating Customer Performance Report
User Empathetic Report Design
Sales Analytics: Creating Market Performance vs Targets Reported
Practice Exercise
Quiz
10 Lectures
Wanda’s Challenge With Prioritizing Projects
Peter & Tony Creates a Project Priority Matrix
Mentor Talk: Being A Problem Solver
Practice Exercise
Bruce Haryali Needs Help With Excel
Peter & Tony Creates a Scenario Planning Tool
Mentor Talk: Growth Zone
Practice Exercise
Quiz
Final Note: What’s Next?
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.
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! 😊
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
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.
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.
Our beginners to advanced Excel course comprises 9 hours of on-demand video content. This allows you to learn Excel at your own pace.
The beginners to advanced Excel course fee is Rs. 900. This covers a comprehensive range of topics from the basics to the most advanced Excel concepts.
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
This course uses a project-based learning approach to teach you Python using two real-life projects (1) Hospitality domain data analysis and (2) Medical data extraction. Learning Python programming through projects helps you understand real-life applications of this awesome programming language. You will also have two solid projects that you can add to your resume and you work on end-to-end implementation. Total beginners, as well as people familiar with the language, will benefit from this Python course.
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.
/164231/Excel-Thumbnail_480.webp)
9hr : 00min on-demand video
70 Lectures
6 Practice Business Scenarios with Solution
9 Quizzes
Access on any Device
Certificate of completion
Free Lifetime Access
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
/images/1.1.419/courses/thumbnails/python-for-beginner-and-intermediate-learners.webp)
Log in with Google
Log in with Linkedin