This Excel course by Codebasics is highly recommended to those who wants to start career in Data analyst or Excel analyst. It covers a wide range of topics including Power Query, Power Pivot, and real-world examples. The course focuses on building problem-solving skills and applies Excel tools to solve business problems. The course is well-structured, engaging, and easy to understand, making it suitable for beginners and intermediate learners. The instructors, Dhaval Patel and Hemanand Vadivel, provide practical knowledge, technical and soft skills, which are valuable in the data analytics industry. The assignments after every chapter help to reinforce the concepts and make the course more interactive.
Data Research Analyst
The course material is well-structured and easy to follow. I learned a lot of new skills and tricks that have already made my work more efficient and productive. Highly recommended!
Senior Analyst
Want to say big thanks to codebasics team to provide such wonderful module for excel, I have learned a lot from it however I was aware of advance excel since 10 years but still I learned lot of new concepts and this course upgrade your knowledge because Dhaval Sir has put his industry experience in it, during the course I felt that I am getting training in an organization not at home, so It is just not a course but a mixture of knowledge and industry experience. Loved it. :)
Senior Mortgage Underwriter
Recommended to anyone who is trying to learn data analytics and data science. DHAVAL PATEL teaching technique is awesome. The perfect combination of flexibility, affordability and supportiveness. I am grateful to the CODEBASICS team for providing an excellent platform that enhanced my professional growth. thank you very much CODEBASICS.
The course was very good and it helped refresh me with the power query and power pivot. The most important was pivot table how to use it with power query and power pivot. How to design beautiful reports in a simple and nice manner through your videos. Thank you for making such courses.
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 course is for absolute beginners hence you do not need any specific skills other than basic familiarity with computers
Most of the courses available on the internet 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 into 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 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.
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 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 the resume ad you work on end-to-end implementation. Total beginners, as well as people familiar with Python, will benefit from this course.
A practical beginner’s course that will prepare you for the data analyst, business analyst, or Power BI developer job market through a true end-to-end Power BI project carefully curated to provide you with real organizational experience & business context.