Skill Course By Satish Dhawale

The Ultimate Excel Mastery
Course (Basic to Advanced Level)

Learn Excel step by step with simple lessons on formulas, data sorting, filtering, Pivot Tables, and charts. Practice with real-life examples and hands-on assignments to build confidence. This course is perfect for students and professionals who wants to learn excel in detailed

4.9
4.9 out of 5 stars (based on 364 reviews)

Hinglish

47,230 Students

68% Discount Applied

₹799 ₹2,500/-

Here's What You'll Learn

Excel is a must-have skill for students, professionals, and anyone working with data. This course is designed to take you from beginner to advanced, with step-by-step lessons, hands-on practice, and real-world examples. Whether you’re organizing data, creating reports, or analyzing trends, you’ll gain the confidence to use Excel like a pro!

Master the Basics of Excel

Learn the essentials of Excel, including data entry, formatting, and basic formulas. Build a strong foundation to manage spreadsheets with ease.

Explore Advanced Excel Features

Dive into Flash Fill, Text to Columns, and Data Validation to automate and clean your data quickly. Master tools like Subtotal and What-If Analysis.

Master Lookup and Reference Formulas

Get hands-on with VLOOKUP, MATCH, INDEX, and XLOOKUP to fetch and analyze data. Simplify working with large datasets effectively.

Unlock the Power of Data Handling

Understand sorting, filtering, and advanced data tools like Paste Special and Find & Replace. Organize and analyze your data efficiently.

Become a Pivot Table Pro

Learn to create Pivot Tables, Pivot Charts, and use advanced features like Slicers and Calculated Fields. Turn complex data into easy-to-read reports.

Analyze Data with Powerful Formulas

Use COUNT, SUMIF, AVERAGEIF, and advanced formulas like FILTER and SORT. Gain insights and make data-driven decisions effortlessly.

Detailed Course Curriculum

Explore a step-by-step curriculum covering everything from Excel basics to advanced tools like Pivot Tables, VLOOKUP, and data analysis formulas. Each lesson is designed to build your skills with practical examples and assignments

Lesson 1 : Excel Introduction23:09 (Min.)
Lesson 2 : Data Entry in Excel19:37 (Min.)
Lesson 3 : Basic Formulas in Excel17:30 (Min.)
Lesson 4 : Conditional Formatting16:17 (Min.)
Lesson 5 : Advanced Conditional Formatting06:28 (Min.)
Lesson 6 : IF Condition Formulas25:45 (Min.)
Lesson 7 : Data Formatting Options09:49 (Min.)
Lesson 8 : Sheet Options of Excel07:44 (Min.)
Lesson 9 : Assignment on IF Formula09:07 (Min.)
Lesson 10 : Sorting Data in Excel10:11 (Min.)
Lesson 11 : Filtering Data in Excel09:49 (Min.)
Lesson 12 : Advanced Filter07:12 (Min.)
Lesson 13 : Paste Special in Excel18:34 (Min.)
Lesson 14 : Goto Special in Excel12:21 (Min.)
Lesson 15 : Find and Replace in Excel08:13 (Min.)
Lesson 16 : Assignment on Sort, Filter, and Replace in Excel08:05 (Min.)
Lesson 17 : Flash Fill05:40 (Min.)
Lesson 18 : Text to Columns and Remove Duplicates & Consolidate13:32 (Min.)
Lesson 19 : Data Validation21:55 (Min.)
Lesson 20 : What If Analysis (Scenario Manager, Goal Seek, Data Table)14:53 (Min.)
Lesson 21 : Group, Ungroup, and Subtotal06:45 (Min.)
Lesson 22 : Assignment on Subtotal and Data Table09:41 (Min.)
Lesson 23 : Introduction to Pivot Table16:38 (Min.)
Lesson 24 : Pivot Chart and Design09:38 (Min.)
Lesson 25 : Slicer in Pivot Table18:23 (Min.)
Lesson 26 : Timeline in Pivot Table07:04 (Min.)
Lesson 27 : Top Bottom Analysis07:09 (Min.)
Lesson 28 : Pivot Table Analyze Options43:21 (Min.)
Lesson 29 : Calculated Field22:03 (Min.)
Lesson 30 : Dynamic Range19:58 (Min.)
Lesson 31 : Auto Refresh12:33 (Min.)
Lesson 32 : Pivot on Multiple Sheets26:00 (Min.)
Lesson 33 : Show Values As in Pivot Table11:04 (Min.)
Lesson 34 : Recommended Pivot Table09:00 (Min.)
Lesson 35 : Pivot Table Assignment09:44 (Min.)
Lesson 36 : Power Pivot Masterclass09:44 (Min.)
Lesson 37 : Vlookup Formula Introduction23:29 (Min.)
Lesson 38 : Fetching Information from Large Data21:19 (Min.)
Lesson 39 : Vlookup with Match12:29 (Min.)
Lesson 40 : Use of Approx Match15:44 (Min.)
Lesson 41 : Vlookup Formula : Find Matching13:08 (Min.)
Lesson 42 : Double Vlookup08:23 (Min.)
Lesson 43 : Match and Index10:35 (Min.)
Lesson 44 : Assignment on Vlookup Formula01:43 (Min.)
Lesson 45 : Xlookup Formula Mastery13:28 (Min.)
Lesson 46 : Count, CountA, CountIF Formulas05:38 (Min.)
Lesson 47 : SumIF and SumIFS Formulas09:59 (Min.)
Lesson 48 : AverageIF, MAXIFS, MINIFS12:28 (Min.)
Lesson 49 : Formulas for Insights (SORT, FILTER, TAKE)21:44 (Min.)
Lesson 50 : Assignment on SORT, FILTER, TAKE08:41 (Min.)
Lesson 51 : Useful Text Formulas35:35 (Min.)
Lesson 52 : Date Formulas for Analysis01:29 (Min.)
Lesson 53 : Financial Formulas for Analysis18:42 (Min.)
Project 1 : Excel Project : End:to:End Dashboard01:51:41 (Hrs.)

Our Learners work at Top Companies

Our learners work at top companies around the world, using the skills they learned with us to succeed. They bring great results and make a real impact in their jobs.

Your Questions, Our Answers

Find answers to frequently asked questions about the course below. If you have any other questions, feel free to contact our support team at info@satishdhawale.com

This course is for anyone who wants to learn Excel. Whether you’re a student, a professional, or a beginner, it will help you build skills step by step.

No, you don’t need any prior knowledge. This course starts from the basics and takes you to advanced topics gradually.

Yes, every topic includes examples and assignments so you can practice and learn by doing.

You can complete the course at your own speed, but most people finish it in 30 to 45 days by studying a little each day.

Yes, we provide support to help you with any questions or doubts you may have during the course.

Absolutely! You’ll learn skills like data analysis, reporting, and advanced formulas, which are very useful in many jobs and industries.

Yes, you will receive an ISO Certificate after completing this course. You just need to pass an exam with a minimum score of 40% to get the certificate. You can also verify your certificate on our website.

Yes, we have 7-days refund policy. If you are not satisfied with this course. We will refund your money. You read the refund policy here => skillcourse.in/refund-policy/

No, you can see the course price very affordable. So we have no EMI option. You can pay using your credit card and convert it into EMIs from your end.

You will get lifetime course access or updates.

Enroll Now On Data Analytics Master Class

For Indian Users

For International Users

Send your doubt

“Please note: You will receive a reply from our team on your email ID within 24 to 48 hours.”