Skill Course By Satish Dhawale

SkillCourse

E-learning Platform By Satish Dhawale

Menu
Login

SkillCourse

E-learning Platform By Satish Dhawale

Menu
  • Home
  • Courses
  • Excel Beginners to Advance

Excel Beginners to Advance

Complete Microsoft Excel Course with Practice Files, Interview Questions & More
4.9 Rating
★★★★★ 5/5
  • 6201 Students Enrolled
  • Satish Dhawale
  • In Hindi
  • 162 Lessons

₹599

₹1999

80% Discount Applied

Enroll Now
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

  • Introduction to MS Excel
  • Basic Formulas
  • Formatting Cell and workbook
  • Filter Data
  • Draw Symbol and Insert Pictures
  • Text to Column

Materials Included

  • 160 Video tutorial
  • 30 Hours on demand duration
  • Real Job Problem scenario
  • Downloadable Practice file available
  • Course completion ISO certificate
  • WhatsApp and Call Support

Course Curriculum

Excel Introduction and Basic Formulas: Module - 1

Play Video

01 - Excel Introduction

Play Video

02 - Basic Formulas

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

₹599

₹1999

80% Discount Applied

Enroll Now

Course Rating By Summary

5.0
5.0 out of 5 stars (based on 51 reviews)
Excellent96%
Very good4%
Average0%
Poor0%
Terrible0%

Submit Your Feedback

​

Super

September 5, 2024

Super se bhi uper…mi ne is cours ko enroll kiya hai… mashallah sir ne Bahot accha padha rahe hai….Thanks 👍

Abdur Rahman

Excellent teaching techniques by Satish sir

August 23, 2024

It has been explained in a very simple and easy language so that even complex matters can be understood easily.

Shubham Dixit

Excel ka Badshaha.... Thanks for all satish sir....

August 7, 2024

Affordable for all student.

No compromise with good content.

Easy way of learning…

Pawan Dhankasar

Very Good Teaching Technique

July 17, 2024

Effective teaching techniques

Clear and well-structured lessons

Ganesh Aware

Reply

July 16, 2024

Lena hai

Tirth vasoya

Thank You So Much Sir

July 3, 2024

Aaj Tak Nhi dhekha Maine Kayi bhi

Aapne Bahut Deeply Content Cover kiya Hai

NITESH KUMAR SAINI

i want my course session back

June 25, 2024

it is nice and very good affordable crash course

vikram chauhan

advance excel course review

June 24, 2024

i personally experience this website. i purchased excel advance course and i tell you its very nice and cheap price. This course help me in my interview and i get job . his teaching technology is very simpal . thank you satish sir

NAMDEV BHAU NIRGUN

Excelent

June 18, 2024

Simple and easy language

Pravin bhoyar

Excellent teach you sir....

June 15, 2024

sir humane to kai tutorials ka video deka per un logo me se Apke teaching skills se Jayda Samha Aaya

VINAY KUMAR MAURYA

Send your doubt

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