Full MS Excel Course | Call 09752003788 for Sales Support

Share
  • Ships within 1 day
₹ 2,950
Description

Combo of - MS Excel Beginner Course , MS Excel Intermediate Course & MS Excel Advanced Video Course In English

This course has been designed for those who want to learn MS Excel completely. After using this course you would be able to use MS Excel like a professional user!

All the videos in this has been categorized in 3 basic categories

• MS Excel Course For Beginners
• MS Excel Course For Intermediate Users
• MS Excel Course For Advanced Users

This course contains a total of 152 videos so that you can “Excel at Excel “ . Each videos has been created you in mind and each video as fun filled as it’s educative. Here’s a break up of the videos

• Beginner Course – 41 videos
• Intermediate – 42 videos
• Advanced course – 69 videos

MS Excel 2007 & 2013 has been used in the video tutorials and the functions shown in the tutorials would work with higher versions of excel too :)

The Videos in this course are the same which are available on my website and YouTube channel.

The training files for each video are also included in the package.

What will you get from this course

You will get
1. 152 world class videos
2. All the training files
3. And my love 

Videos Included In this Course

MS Excel Beginners Course

Chapter 1 Basics Of MS Excel
Chapter 2 Basics Of MS Excel 2
Chapter 3 Calculate Average In Excel
Chapter 4 Calculate Sum In Excel
Chapter 5 Count The Cells Containing Numbers In Excel
Chapter 6 Count The Not Empty Containing Numbers In Excel
Chapter 7 Join Content Of Multiple Cells In One Cell In Excel
Chapter 8 Calculate Running Total In Excel
Chapter 9 Do Addition Of Numbers In Excel
Chapter 10 Do Subtraction Of Numbers In Excel
Chapter 11 Do Division Of Numbers In Excel
Chapter 12 Do Multiplication In Excel
Chapter 13 Calculate Percentage In Excel
Chapter 14 Countblank Cells In Excel
Chapter 15 IF Formula In Excel
Chapter 16 CountIF Formula In Excel
Chapter 17 Vlookup Formula In Excel
Chapter 18 Sumif Formula In Excel
Chapter 19 Hlookup Formula In Excel
Chapter 20 Averageif Formula In Excel
Chapter 21 Pivot Table In Excel
Chapter 22 Insert Comment In Excel
Chapter 23 Edit Comment In Excel
Chapter 24 Delete Comment In Excel
Chapter 25 Create Border In Excel
Chapter 26 Wrap Text In Excel
Chapter 27 Merge Cells In Excel
Chapter 28 Number Formatting In Excel
Chapter 29 Paste Special In Excel
Chapter 30 Sort In Excel
Chapter 31 Convert Columns To Rows In Excel
Chapter 32 Conditional Formatting Cells Rules In Excel
Chapter 33 Conditional Formatting Top Bottom In Excel
Chapter 34 Excel Bar Graph
Chapter 35 Excel Column Graph
Chapter 36 Create Pie Chart In Excel
Chapter 37 Calculate Hour Minute Seconds In Excel
Chapter 38 Use Date In Excel In Excel
Chapter 39 Use Month Function In Excel
Chapter 40 Use Dictionary In Excel
Chapter 41 Use Hyperlink In Excel

MS Excel Intermediate Course

MS Excel ABS Function Chapter 1
MS Excel Sumif Function Chapter 2
MS Excel Hlookup Function Chapter 3
MS Excel Vlookup Function Chapter 4
MS Excel Countif Function Chapter 6
MS Excel AverageIf Function Chapter 7
MS Excel AverageIfs Function Chapter 8
MS Excel AverageA Function Chapter 9
Data Validation With Date Chapter 10
Data Validation With List Chapter 11
Data Validation With Time Chapter 12
Data Validation With Numbers Chapter 13
MS Excel Sumproduct Function Chapter 14
MS Excel Rank Function Chapter 15
MS Excel Min Function Chapter 16
MS Excel Max Function Chapter 17
MS Excel Cell Function Chapter 18
MS Excel N Function Chapter 19
MS Excel Char Function Chapter 20
MS Excel Clean Function Chapter 21
MS Excel Code Function Chapter 22
MS Excel Exact Function Chapter 23
MS Excel Round Function Chapter 24
MS Excel Large Function Chapter 25
MS Excel Mode Function Chapter 26
MS Excel Median Function Chapter 27
MS Excel Vlookup Exact Function Chapter 28
MS Excel Hlookup Exact Function Chapter 29
Remove Duplicates In Excel Chapter 30
Create Random Numbers In Excel Chapter 31
Change Text To Upper Case In Excel Chapter 32
Change Text To Lower Case In Excel Chapter 33
Change Text To Proper Case In Excel Chapter 34
Add Password To Excel File Chapter 35
Send Email From Excel File Chapter 36
Add Custom Background Image In Excel Chapter 37
Zoom In Zoom Out In Excel Chapter 38
Auto Fill Data In Excel Chapter 39
Add Special Characters In Excel Chapter 40
Change Color Of Border Line In Excel Chapter 41
Change Theme In Excel Chapter 42

MS Excel Advanced Course

Chapter 1Multiple Vlookup In Excel
Chapter 3 Vlookup Highest Value In Excel
Chapter 2 Vlookup Lowest Value In Excel
Chapter 4 Vlookup Multiple Results In Excel
Chapter 5 Remove NA Error From Vlookup Results
Chapter 6 Vlookup With MID Formula In Excel
Chapter 7 Or Function In Excel
Chapter 8 And Function In Excel
Chapter 9 Choose Function In Excel
Chapter 10 Indirect Function In Excel
Chapter 11 Replace Function In Excel
Chapter 12 Mid Function In Excel
Chapter 13 Len Function In Excel
Chapter 14 Left Function In Excel
Chapter 15 Find Function In Excel
Chapter 16 Roundup Function In Excel
Chapter 17Ceiling Function In Excel
Chapter 18 Correl Function In Excel
Chapter 19 Forecast Function In Excel
Chapter 20 Frequency Function In Excel
Chapter 21 Subtotal Function In Excel
Chapter 22 Sumifs Function In Excel
Chapter 23 Whatif Analysis Function In Excel
Chapter 24Color A Column With A Formula In Excel
Chapter 25 Color A Row With A Formula In Excel
Chapter 26 Highlight A Cell With Formula
Chapter 27 Isodd Function In Excel
Chapter 28 Isnumber Function In Excel
Chapter 29 Istext Function In Excel
Chapter 30 Islogical Function In Excel
Chapter 31 Isnontext Function In Excel
Chapter 32 Iserror Function In Excel
Chapter 33 Iserr Function In Excel
Chapter 34 Isblank Function In Excel
Chapter 35 Dget Function In Excel
Chapter 36 Dmax Function In Excel
Chapter 37 Dproduct Function In Excel
Chapter 38 Dcounta Function In Excel
Chapter 39Dcount Function In Excel
Chapter 40 Dsum Function In Excel
Chapter 41 Daverage Function In Excel
Chapter 42 Calculate Depreciation In Excel
Chapter 43 SLN Depreciation In Excel
Chapter 44 SYD Depreciation In Excel
Chapter 45 PMT Function In Excel
Chapter 46 Calculate Loan EMI In Excel
Chapter 47 Datedif Function In Excel
Chapter 48 Datevalue Function In Excel
Chapter 49Edate Function In Excel
Chapter 50 Eomonth Function In Excel
Chapter 51 Match Function In Excel
Chapter 52 Match Function Approximate And Exact Match Part 1
Chapter 53 Match Function Approximate And Exact Match Part 2
Chapter 54 Index Function
Chapter 55 Index And Match Function Part 1
Chapter 56 Index And Match Function Part 2
Chapter 57 Index And Match Function Part 3
Chapter 58 Index And Match Function Part 4
Chapter 59 Index And Match Function Part 5
Chapter 60 Index And Match Function Part 6
Chapter 61 Index And Match Function Part 7
Chapter 62 Index And Match Function Part 8
Chapter 63 Index And Match Function Part 9
Chapter 64 Index And Match Function Part 10
Chapter 65 Index And Match Function Part 11
Chapter 66 Lookup Data From 3 Tables In Excel
Chapter 67 Only Select Cells With Comments In Excel
Chapter 68 Hide Formula In Excel
Chapter 69 Insert Serial Number Automatically In Excel

What will happen once I make the payment?
• Once you make the payment, you would be able to download the course in your pc or laptop or smartphone .

Requirements
1. Just your regular computer with earphones or speakers and a USB drive
2. Excel 2007 and above for using the practice files
3. You can also watch these videos on TV also which have a USB Drive

In case you have any issues at all , please email us

• For any assistance - account@myelesson.org

We are located in Indore , Madhya Pradesh and can be reached at 097-5200-3788
"Lets Share Knowledge "
Guru