Learn Computer With Savvy Niest

Excel Beginners to Advance

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

₹399

₹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

₹399

₹1999

80% off

Course Rating By Summary

5.0
5.0 out of 5 stars (based on 13 reviews)
Excellent100%
Very good0%
Average0%
Poor0%
Terrible0%

Submit Your Feedback

Best forever

March 12, 2023

What a sir!

Surya

RANJAN KUMAR NAYAK

February 9, 2023

excellent platform for computer student

RANJAN KUMAR NAYAK

Heera dhruw

February 9, 2023

learn this excel course to become expert excel

Heera dhruw

Siddlingappa J

February 9, 2023

Thank you so much Satish sir I have lot of Learn Today in very happy sir very interesting class sir I’m very very happy I’m learning

Siddlingappa J

Raja Kumar Singh

February 9, 2023

Very good Teaching techniques Sir

Raja Kumar Singh

Abdul Kadir Bhatkar

February 9, 2023

Excellent teaching methology , Thanks learned a lot for Nested formula, Thanks Sirji

Abdul Kadir Bhatkar

Fayjul Hoque

February 9, 2023

So Good Explaining Sir.. Lots Of Love

Fayjul Hoque

Rustam Ali

February 9, 2023

Best study platform for computer skill by Satish sir. Thanks for giving big opportunity in technical field.

Rustam Ali

Vijay Thakor

February 9, 2023

Thank you so much Satish sir for creating this Excel course.

Vijay Thakor

VIJAY PRASAD

February 9, 2023

best teaching with very high level material in excel , I like this job and god bless you sir , i love you my heart but i am a male

VIJAY PRASAD