Created by
Shilpa Jain
12+ Years
Experience
10K +
Followers
About This Course
Our Microsoft Excel course has divided into 2 Easy Levels. Microsoft Excel Level 1- An introduction to excel with basic Formulas & Functions. Microsoft Excel Level 2- Advanced Level Of excel Includes advanced formulas & functions. Company Base expert level of excel includes- Data Analyst with Power pivot & many types of Dashboards. The material of Our Microsoft Excel Course recorded in 2016 but it will work in all 2007, 2010, 2013, 2016, and 2019 in all students, professionals, and office 365 versions. Enroll now!!!!! To get success with the most popular excel tool in the MIS Market, Microsoft excel spreadsheet. With my 14+ Years of excel corporate training experience, I have guided you in videos step by step from beginners to advance and advance to expert level of excel. If you Enroll in each level of our Microsoft excel course, you will get clear your all doubts and queries with your daily tasks which we have assigned in videos and with a different database. You will start fro
Skills You’ll Learn
Top 4 Benefits From This Course
Lessons
Lesson 1:
15:01 Minutes
Basic Excel Course Class 1 (Calculations)
In first-class, you learn the data entry in an excel spreadsheet. some shortcuts keys rela
Lesson 2:
9:19 Minutes
Basic Excel Course Class 2 (Number Formulas)
In this video, various types of basic formulas have introduced. First You will learn simpl
Lesson 3:
5:32 Minutes
Basic Excel Course Class 3 (Text Function)
In this video, various types of Text formulas have introduced. Various Types of Text for
Lesson 4:
6:21 Minutes
Basic Excel Course Class 4 (Date Functions)
In this video You will get all text and date related formulas, Text are very important dat
Lesson 5:
3:01 Minutes
Basic Excel Course Class 5 (Date Function) Part 2
In this video You will get all text and date related formulas, Text are very important dat
Lesson 6:
8:21 Minutes
Basic Excel Course Class 6 (Filter and Sort)
In this Class You will learn about how to apply a simple and advanced filter, filter is an
Lesson 7:
7:17 Minutes
Basic Excel Course Class 7 (Table)
In the video, you learn the excel feature (TABLE FORMAT). It is easier to use and replace
Lesson 8:
7:41 Minutes
Basic Excel Course Class 8 (Data validation)
This video contain two topics. 1. Data Validation 2. Paste special Data Validation is f
Lesson 9:
5:16 Minutes
Basic Excel Course Class 9 (Paste Special)
This video contain two topics. 1. Data Validation 2. Paste special Data Validation is f
Lesson 10:
9:46 Minutes
Basic Excel Course Class 10 (Conditional Formatting)
This class is based on formatting and giving colors and styles to your cells this option o
Lesson 11:
4:37 Minutes
Basic Excel Course Class 11 (Print Settings)
In this video page layout tab and view, the tab is explaining to you. Page layout tabs co
Lesson 12:
4:46 Minutes
Basic Excel Course Class 12 (Extra Features)
In this video, I have explained. Sorting, Name Manager, Text to columns, Formula Auditing
Lesson 13:
5:05 Minutes
Basic Excel Course Class 13 (Protections))
Protection is a very important part of excel which is required by every person to protect
Lesson 14:
8:50 Minutes
Advance Excel Course Class 1 (References)
Hi guys In this video of the Advance Excel Course, I am going to explain to you a topic R
Lesson 15:
8:15 Minutes
Advance Excel Course Class 2 (Sumif Countif Average If)
Hi guys, In this video of the Best Advance Excel Course, I am going to explain logical fu
Lesson 16:
6:09 Minutes
Advance Excel Course Class 3 (Sumifs Countifs Averageifs)
Hi guys, In this video of Best Advance Excel Course, I am going to explain Logical functi
Lesson 17:
7:24 Minutes
Advance Excel Course Class 4 ( If )
In this video of the Best Advance Excel Course, I am going to explain logical functions.
Lesson 18:
7:41 Minutes
Advance Excel Course Class 5 (IF and OR)
Hi guys, In this video of the Best Advance Excel Course, I am going to explain logical fu
Lesson 19:
10:10 Minutes
Advance Excel Course Class 6 (Vlookup Simple)
Hi guys, In this video of Best Advance Excel Course, I am going to explain Vlookups. VLO
Lesson 20:
5:47 Minutes
Advance Excel Course Class 7 (Match & IFError Vlookup)
Hi guys, In this video of Best Advance Excel Course, I am going to explain VLOOKUP’s with
Lesson 21:
5:16 Minutes
Advance Excel Course Class 8 (Index Match)
Hi guys, In this video of Best Advance Excel Course, I am going to explain Index Match Fu
Lesson 22:
5:38 Minutes
Advance Excel Course Class 9 (Advance Filter)
Use an Advanced Filter in Excel to create a list of unique items, or to extract specific i
Lesson 23:
10:04 Minutes
Advance Excel Course Class 10 (Pivot Table)
Hi guys, In this video of Best Advance Excel Course, I am going to explain PIVOT TABLES I
Lesson 24:
7:48 Minutes
Advance Excel Course Class 11 (Working with Charts)
Hi guys, In this video of Best Advance Excel Course, I am going to explain CHARTS AND PIV
Lesson 25:
5:27 Minutes
Advance Excel Course Class 12 (Forgot vlookup)
In this Video You will Lear About Power Pivot and relationships between two or more tables
Lesson 26:
7:38 Minutes
Advance Excel Course Class 13 (Advance Conditional Formatting)
Hi guys, In this video of Best Advance Excel Course, I am going to explain advanced condi
Lesson 27:
4:23 Minutes
Advance Excel Course Class 14 (Consolidate)
Consolidate Function To summarize and report results from separate worksheets, you can co
Lesson 28:
All Information About Shortcut Key
Please Check The Pdf For The All Shortcut Key in Excel
Lesson 29:
All Practice Assignments
Download Excel File For Practice Basic & Advance Excel Course
Lesson 30:
36:30 Minutes
First class (Live)
The first Class Include concepts of Moving around excel sheets and number formulas
Lesson 31:
32:39 Minutes
Text formulas
Learn Text Formulas
Lesson 32:
12:11 Minutes
Date function part 1
Learn Date formulas
Lesson 33:
36:34 Minutes
Date formulas part 2
Learn Date formulas
Lesson 34:
12:11 Minutes
Date formulas part 3
Learn Date formulas
Lesson 35:
8:36 Minutes
Conditional formatting
Learn Conditional formatting
Lesson 36:
37:10 Minutes
Data validation
All Tricks of data validation
Lesson 37:
8:27 Minutes
Pastespecial
Learn pastespecial in this video
Lesson 38:
35:36 Minutes
Extra features of excel
Learn Review and view tab whole from this video
Lesson 39:
36:26 Minutes
If formula
Learn logical functions
Lesson 40:
33:07 Minutes
AND OR Formulas
Learn logical functions with AND OR conditions
Lesson 41:
29:58 Minutes
VLOOKUP
Learn Basic VLOOKUP
Lesson 42:
34:42 Minutes
VLOOKUP And XLOOKUP
Learn Advance vlookup And Xlookup
Lesson 43:
9:25 Minutes
Advance conditional Formatting
Learn Formula based Advance conditional Formatting
Lesson 44:
36:24 Minutes
Pivot table basics
Learn various reports from Pivot table basics
Lesson 45:
30:40 Minutes
Dashboards
Learn dashboard by pivots
Lesson 46:
37:33 Minutes
Power Pivot dashboards
How to create Dashboards by link two sheets without vlookup?
Lesson 47:
33:18 Minutes
SUMIF,COUNTIF,AVERAGEIF
Learn Database Functions SUMIF,COUNTIF,AVERAGEIF
