Skill Course By Satish Dhawale

SkillCourse

Excel Beginners to Advance

Complete Microsoft Excel Course with Practice Files, Interview Questions & More
4.9 Rating
5/5

₹499

₹1999

80% off

Play Video

Course Description

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software.

In this course you will learn MS Excel from Beginners to Advance. (Courses by Satish Dhawale Sir) सभी कोर्सेस आसान हिंदी भाषा में |

Course Features
✅सभी कोर्सेस सरल हिंदी भाषा में
✅MS Excel बेसिक से एडवांस कोर्सेस
✅160 DETAIL वीडियोस
✅ कोर्स प्रैक्टिस फाइल्स उपलब्ध
✅कोर्स कम्पलीशन सर्टिफिकेट
✅इंस्टेंट एक्सेस –
⬇️ Download Video in APP

Free BONUSES-
✅ PDF शॉर्टकट्स
✅ MS Excel E-Book in हिन्दी

This course is Created by : Satish Dhawale
सतीश सर को कंप्यूटर के क्षेत्र में टीचिंग का लगभग 16 साल का अनुभव हैं जिसमे उन्होंने 14 साल तक ऑफलाइन कंप्यूटर संस्थान में 40000+ से अधिक स्टूडेंट्स को और अपने Online अपने Learn More Channel के माध्यम से लगभग 17,00,000+ से ज्यादा स्टूडेंट्स को कंप्युटर कि शिक्षा देने का कार्य किया हैं। YouTube : 7 Silver and 1 Gold Button Award Winner for their 7 YouTube Channels

Course Benefits

Materials Included

Course Curriculum

Excel Introduction and Basic Formulas: Module - 1

Preview

Play Video

01 - Excel Introduction

Preview

Play Video

02 - Basic Formulas

Preview

Play Video

03 - IF Formula in Excel

01 – Excel Introduction 13.55 Min
02 – Basic Formulas 20.13 Min
03 – IF Formula in Excel 8.15 Min
04 – If and If or Formula 9.02 Min
05 – Nested IF in Excel 10.30 Min

Excel Basic formula, Sort & Filter: Module - 2

01 – Nested if Calculate Discount 14.51 Min
02 – Salary Sheet Basic Formula 13.08 Min
03 – Salary Sheet Nested if 15.32 Min
04 – Attendance Sheet 14.02 Min
05 – Attendacne Sheet Countif Formula 12.06 Min
06 – Sort, Custom Sort & Filter 17.41 Min
07 – Conditional Formatting Basic 13.23 Min
08 – Conditional Formatting Advance 10.16 Min
09 – C F Higlight Alt Rows 8.38 Min
10 – Advance Filter 12.26 Min

Excel Data Tab: Module - 3

01 – Advance filter Macro 13.59 Min
02 – Auto Sort Macro 7.39 Min
03 – Text to Columns 4.59 Min
04 – Flash Fill in Excel 13.30 Min
05 – Remove Duplicate and Consolidate 8.39 Min
06 – 3D Formula 7.15 Min
07 – Data Validation 28.16 Min
08 – Scenario Managerl 6.21 Min
09- Goal Seekl 8.51 Min
10 – Data Table 12.24 Min

Excel Home Tab & Pivot: Module - 4

01 – Home Tab 1 12.24 Min
02 – Home Tab 2 11.10 Min
03- Home Tab 3 6.32 Min
04 – Home Tab 4 9.53 Min
05 – Find and Replace 12.40 Min
06 – Goto Special 20.14 Min
07 – Paste Special 17.32 Min
08 – Pivot Table Introduction 13.28 Min
09 – Pivot Table Filter User 8.23 Min
10 – Pivot Table Options 11.42 Min

Excel Insert Tab & Chart: Module - 5

01 – Slicer and Timeline 15.10 Min
02 – Pivot Chart in Excel 10.56 Min
03 – Auto Refresh Pivot Table 6.21 Min
04 – Table in Excel 10.56 Min
05 – Insert Tab1 8.48 Min
06 – Insert Tab2 8.05 Min
07 – Excel Chart 12.21 Min
08 – Excel Chart and Formatting 8.16 Min
09 – Excel Sparkline Chart 5.30 Min
10 – Hyperlink in Excel 4.32 Min

Excel Page Layout and Formulas Tab: Module - 6

01 – Insert Tab 3 11.58 Min
02 – Watermark in Excel 5.40 Min
03 – Pagelayout Tab Themes and Margins 11.13 Min
04 – Pagelayout Tab Print Settings 11.24 Min
05 – Pagelayout Tab 2 7.03 Min
06 – Pagelayout Tab3 11.38 Min
07- Formula Tab Name Manager 11.24 Min
08 – Formula Tab Formula Auditing 9.01 Min
09 – Data Tab Get External Data 8.08 Min
10 – Data Tab Sub Total 7.22 Min

Excel Review & View Tab | VLOOKUP: Module - 7

01 – Data Tab Solver add ins 6.28 Min
02 – Reveiw Tab 9.38 Min
03 – View Tab 10.34 Min
04 – Macro Recording 12.12 Min
05 – Create your own Tab 5.57 Min
06 – Vlookup 1 Intro 16.38 Min
07 – Vlookup 2 Use of Range Lookup 13.02 Min
08 – Vlookup 3 Double Vlookupl 8.28 Min
09 – Vlookup 4 Nested Vlookup 7.46 Min
10 – Vlookup 5 Vlookup Project 9.24 Min

Excel Statistical & Lookup Formula: Module - 8

01 – Vlookup 6- Unique Example of Vlookup 5.39 Min
02 – CountA and Count Blank Formula 7.10 Min
03 – Countif Formula 5.59 Min
04 – Countifs Formula 11.33 Min
05 – Sumif and Sumifs 7.22 Min
06 – Averageif and Averageifs 6.57 Min
07 – Frequency Formula 7.25 Min
08 – Index and Match 7.10 Min
09 – Lookup Formula 5.06 Min
10 – SumProduct , Left and Find formula 7.13 Min

Excel Text, Financial & Date Formula: Module - 9

01 – Right and Find 5.01 Min
02 – Mid and Find Formula 9.57 Min
03 – Repeat and Substitute Formula 4.25 Min
04 – PMT, PV, FV Formula 10.51 Min
05 – IPMT AND PPMT 8.34 Min
06 – V lookup with Match 10.20 Min
07 – Text Formulas 6.46 Min
08 – Date in Quarter 6.19 Min
09 – Datedif Formula 6.43 Min
10 – Date Formula 5.13 Min

Excel Advance Excel Topics: Module - 10

01 – Switch Date 6.31 Min
02 – More Date Formulas 7.23 Min
03 – Ranking Formula 5.19 Min
04 – Concatenate and Vlookup 4.05 Min
05 – Sheet Tips 6.32 Min
06 – Excel To Powerpoint 6.14 Min
07 – Change Excel Icon 6.25 Min
08 – Number to Word 6.14 Min
09 – Custom Cells Tips 8.00 Min
10 – Picture Lookup 11.27 Min

Excel 2019 & 365 New Formula: Module - 11

01 – Picture Game 8.22 Min
02 – Data Entry form 4.22 Min
03 – Fiel Menu 6.06 Min
04 – Excel Settings 11.00 Min
05 – Short formulas 11.07 Min
06 – Database function DGET Formula of Excel 10.36 Min
07 – DSUM Formula in Excel 7.24 Min
08 – DAVERAGE Formula 2.41 Min
09 – DCOUNT, DCOUNTA Formula 4.11 Min
10 – DMAX Formula, DMIN Formula, DPRODUCT Formula 6.10 Min

Excel Real Job Problem: Module - 12

01 – Vlookup on Multiple Tables 6.54 Min
02 – Offset Formula Introduction 11.01 Min
03 – Offset Formula Calculate Sum of Last 6 Days 9.37 Min
04 – Offset Formula Real Job Use 5.21 Min
05 – Sumifs, Index, Match Real Job Use 8.24 Min
06 – Practical use of Isblank and Istext Formula 4.35 Min
07 – Counting Words in Excel Interview Question 8.54 Min
08 – Build Login in Excel Formula 5.55 Min
09 – Create Dynamic List Using Index, Match Formula 4.07 Min
10 – Conditional Formatting with Text and Or Formula 4.33 Min

Excel Hidden Feature & Practical Problem: Module - 13

01 – Unique Example of Conditional Formatting 5.53 Min
02- Auto Sort data using Countif, Match and Index Formula 9.02 Min
03 – Condition Inside Rank using CountIFS Formula 5.40 Min
04 – Camera, Autofilter, Form 3 Hidden Features 6.55 Min
05 – Max IF and Min IF Formula using Array 5.39 Min
06- Choose Formula in Excel 7.14 Min
07- Swap range in Excel 4.18 Min
08 – Reverse Lookup Using Choose Formula 5.37 Min
09 – Reverse Lookup using Match and Index 6.40 Min
10 – Find & Vlookup Real Job Query 9.41 Min

Excel Complex Problem: Module - 14

01 – Vlookup Duplicate Names Issue 4.09 Min
02 – Vlookup with Chooze formula and array 9.09 Min
03 – Text Join Formula in Excel 2019 5.02 Min
04 – IFS Formula in Excel 2019 4.47 Min
05 – MaxIFS and MinIFS in Excel 2019 4.36 Min
06 – Filter Formula of Office 365 5.20 Min
07 – Sort Formula of Office 365 6.56 Min
08 – Real Job use of Aggregate Formula in Excel 10.34 Min

Excel Xlookup in Office 365 : Module - 15

01 – Xlookup in Office 365 1 6.37 Min
02 – Xlookup in Office 365 2 6.42 Min
03 – Xlooup Work Reverse 3 9.47 Min
04 – Xlooup in Office 365 4 5.40 Min
05 – Xlooup in Office 365 5 9.56 Min
06 – Xlookup in Office 365 – 6 8.38 Min
07 – Xlookup in Office 365 7 6.22 Min
08 – Xlookup in Office 365 5.06 Min
09 – Excel Xlookup in Office 365 9 5.36 Min
10 – Excel Xlookup in Office 365 10 5.20 Min
11 – XMATCH Formula office 365 13.07 Min
12- Create Searchable Drop Down List In Office 365 1 9.45 Min

Excel 365 Feature and Formula : Module - 16

01 – Analyze Data and Get IDEAS Office 365 6.31 Min
02 – Map Chart in Office 365 8.04 Min
03 – Dynamic Conditional Formatting 9.53 Min
04 – EXCEL Unique Formula in Office 365 5.14 Min
05 – EXCEL Sequence and Random Array Formula in Office 365 4.34 Min

Excel Assignment & Interview : Module - 17

01 – Assignment 1 With Answer 365 13.17 Min
02 – Assignment 2 With Answer 365 6.40 Min
03 – Assignment 3 With Answer 365 4.37 Min
04 – Assignment 4 With Answer 365 3.14 Min
05 – Excel interview questions -1mp4 41.51 Min
06 – Excel – Interview Questions 26.12 Min
07 – Use your Brain – Interview Question 35.50 Min
08 – Interview Question – Mode Function 11.54 Min
09 – Interview Question – Goto and Conditional Formatting 8.02 Min

Course Instructor

Satish Dhawale

Founder & CEO of CoursePe

Satish Dhawale has over 15 years of experience in the field of computer education, he has been promoting computer education through his blog www.learnmoreindia.in and YouTube channel Learn More with 1.5 M+ subscribers for more than 5 years now. 1 Gold Play and 5 Silver Play Awards have been awarded by YouTube. Learn More YouTube channel provides tutorials related to computer and technology in the Hindi language to Learn and improve your life. 

Course Completion Certificate

₹499

₹1999

80% off

Course Rating By Summary

4.9
Rated 4.9 out of 5
4.9 out of 5 stars (based on 38 reviews)
Excellent95%
Very good5%
Average0%
Poor0%
Terrible0%

Submit Your Feedback

Excel version

Rated 5.0 out of 5
February 26, 2024

Can I access this course in Excel 2007

Virin Gamit

OTP Not Working

Rated 5.0 out of 5
January 27, 2024

Hello Satish Sir, This is my second message on this Website☹️. I have been trying so many times but I didn’t receive OTP for confirmation i have a credit/debit cards and still didn’t received please Sir Emailed me the Solution.

Thank you

Muhidullah Khan

Buy Course

Rated 5.0 out of 5
January 26, 2024

Hello Satish Sur, i was try so many time to buy your Course of Excel from beginners to Advance but I don’t receive any OTP? Please can you help me?🙏

Muhidullah Khan

Website Error

Rated 5.0 out of 5
January 20, 2024

Please solve the my website error – my contact no. 62*******02

Fatal error: Uncaught Error: Call to undefined function create_function() in /home3/allonqey/public_html/wp-content/plugins/LayerSlider/wp/widgets.php:5 Stack trace: #0 /home3/allonqey/public_html/wp-content/plugins/LayerSlider/layerslider.php(55): include() #1 /home3/allonqey/public_html/wp-settings.php(447): include_once(‘/home3/allonqey…’) #2 /home3/allonqey/public_html/wp-config.php(82): require_once(‘/home3/allonqey…’) #3 /home3/allonqey/public_html/wp-load.php(50): require_once(‘/home3/allonqey…’) #4 /home3/allonqey/public_html/wp-blog-header.php(13): require_once(‘/home3/allonqey…’) #5 /home3/allonqey/public_html/index.php(17): require(‘/home3/allonqey…’) #6 {main} thrown in /home3/allonqey/public_html/wp-content/plugins/LayerSlider/wp/widgets.php on line 5

Bhola Singh Verma

Response from Skill Course By Satish Dhawale

We have answered your question on mail, please check. 😊

Want to buy course

Rated 5.0 out of 5
January 11, 2024

I am from Pakistan,I want to buy this course. But unable to receive phone number OTP that’s why payment can not be done. Any solution?

Syeda Ashal Fatima

Response from Skill Course By Satish Dhawale

Hello Syeda Ashal Fatima,

You can use the card to make a payment.

E

Rated 5.0 out of 5
January 8, 2024

Sir mai kuwait se ye course karna chahta hu-Aur sir me class 8th tak padhai kiya hu kiya mujhe ye course karne ke bad koi job milegi mai akpka video dekha hu mujhe lagta hai mai ye cours kar sakta hu aur mujhe apka padhane andaz bahut achcha laga sir please reply zarur dijyega thank you

Abullais

Response from Skill Course By Satish Dhawale

Hello Abullais,

Sir Course me aapko Basic to Advance full Knowledge milega.. Jisase aapki Skill upgrade ho jayegi 😊

Question

Rated 5.0 out of 5
January 3, 2024

Course Validity?

William

Response from Skill Course By Satish Dhawale

The validity of all courses will be for 2 years.

Excellent explanation, sir.

Rated 5.0 out of 5
December 26, 2023

Quite helpful.

Sanjaya Misra

Question

Rated 5.0 out of 5
November 24, 2023

Can you provide vba too in this course or not

Syed Ahsaan Ali Shah

buy your course

Rated 5.0 out of 5
November 18, 2023

sir,

i am from pakiatan and want to buy

how can i get it

payment method is possible

Muhammad Jamil Inam khan

Response from Skill Course By Satish Dhawale

You can make international payments, via Credit card

Send your doubt

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