Microsoft Excel
Excel from Beginner to Advanced
Master Microsoft Excel from Beginner to Advanced.
Learn all about syntax, arguments and its logics.
How to create custom and nested functions.
Learn the fastest and smartest ways of cleaning the raw data
Create dynamic reports by mastering one of the most popular tools, PivotTables.
Learn which chart/graph to use when.
How to automate repetitive tasks in Excel using Macros.
Learn various 'must have' Excel shortcuts.
Learn how to manage heavy Excel files.
Amazing Bonus tricks that saves tons of time and efforts.
0101 Touring the interface
0102 Enter data & saving workbook
FREE PREVIEW0103 Applying Formulas
0104 Changing a worksheet's structure
0105 Find, Replace & Spell Check
0106 Applying fonts, background colors, and borders
0107 Formatting numbers and dates
0108 Making the pieces fit
0109 Inserting headers & footers and Repeating Rows
0110 Managing Large Workbooks
Quiz 1
0201 Formula Writing (Don't Miss This)
FREE PREVIEW0201 Exercise of Formula Writing (Don't Miss This)
Excel Files for practice(Please Download)
Quiz 2
0301 SumIf & SumIfs
FREE PREVIEW0301 Exercise of SumIf & SumIfs
0302 Count Functions
0302 Exercise of Count Functions
0303 AverageIf & AverageIfs
0303 Exercise of AverageIf & AverageIfs
Excel files for practice (Please Download)
0401 Change Case (Upper, Lower, Proper)
0401 Exercise of Change Case (Upper, Lower, Proper)
0402 Separating Text on Symmetrical Data
0402 Exercise of Separating Text on Symmetrical Data
0403 Separating Text on Non-Symmetrical Data
0403 Exercise of Separating Text on Non-Symmetrical Data
FREE PREVIEWExcel Files for Practice (Please Download)
0501 If Functionality
Ex 0501 IF Functionality
0502 If with AND
Ex 0502 If with AND
0503 If with OR
Ex 0503 If with OR
0504 If with AND & OR, IF with Countif
Ex 0504 If with AND & OR
0505 Nested If (A Genie with 3 wishes)
Ex 0505 Nested If
Excel Files for Practice(Please Download)
0601 Vlookup (Exact Match) # 1
Exercise 0601 Vlookup (Exact Match) # 1
0602 Type of References (Use of $ Sign)
0603 Vlookup (Exact Match) # 2
Exercise 0603 Vlookup (Exact Match) #2
0604 Double Vlookup
Exercise 0604 Double Vlookup
0605 Vlookup on Duplicate Values
Exercise 0605 Vlookup on Duplicate Values
0606 Vlookup (Approximate Match)
Exercise 0606 Vlookup (Approximate Match)
0607 Vlookup with IF (Conditional Vlookup)
Exercise 0607 Vlookup with IF (Conditional Vlookup)
0608 Hlookup (Exact Match)
Exercise 0608 Hlookup (Exact Match)
0609 Hlookup (Approximate Match)
Exercise 0609 Hlookup (Approximate Match)
0610 Lookup (Don't Use This)
Exercise 0610 Lookup (Don't Use This)
0611 Vlookup & Match (Create magical Vlookup)
Exercise 0611 Vlookup & Match ( Create a Magical Vlookup)
0612 Match (Gives us Column & Row Number)
Exercise 0612 Match (Gives us Column & Row Number)
0613 Index & Match (Made for each other)
Exercise number 1 of 0613 Index & Match (Made for each other)
Exercise number 2 of 0613 Index & Match (Made for each other)
Excel Files for Practice (Please Download)
0701 How Excel Records Date & Timer
0702 Now, Today & Autofill
0703 DateValue & TimeValue
0704 Calculate WorkingDays
0705 DatedIf
Excel Files for Practice (Please Download)
0801 Loan Calculation (PMT, PPMT, IPMT etc.)
Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.)
0802 Creating a Loan Table
Ex 0802 Creating a Loan Table
0803 Calculate Depriciation
Ex 0803 Calculate Depriciation
Excel Files for practice (Please Download)
0901 Basic Sorting & Shortcut keys
Ex 0901 Basic Sorting & Shortcut Keys
0902 Sorting Using Custom List
Ex 0902 Sorting Using Custom List
0903 Horizontal Sorting
Ex 0903 Horizontal Sorting
0904 Basic Filter & Shortcut Keys
Ex 0904 Basic Filter & Shortcut Keys
0905 Filter Problem # 1 (Copy Filtered Data without hidden rows)
Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden Rows)
0906 Filter Problem # 2 (Pasting Values on Filtered Data)
Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data)
0907 Filter Problem # 3 (Performing Calculation on Filtered Data)
Ex 0907 Filter Problem # 3 (Perform Claculation on Filtered Data)
0908 Advanced Filter (Using Complex Criteria's)
Ex 0908 Advanced Filter (Using Complex Criteria's)
Excel Files for Practice (Please Download)
1. Excel Charts Introduction
2 How to Creat a Chart
3 Link a Chart Title
4 How to Show Axis Title
5 How to Show Data Label
6 Column Chart
7 Bar Chart
8 Line Chart 1
9 Line Chart 2
10 Area Chart
11 Pie Chart
12 Pie of Pie or Bar of Pie
13 Line Chart with Log Scale
14 Bubble Chart
15 Selecting Chart Elements
16 Use of Format Dialog box
17 Modifying Chart & Plot Area
18 Modifying Data Series
19 How to handle Missing Data
20 Modifying 3-D Charts
21 Creating a Chart Templates
22 Creating Picture Charts
23 Creating Combination of upto 5 Different Charts
24 Show data with chart in Data Table
25 Play with Design & Layout of Chart
Excel Files for Practice (Please Download)
1101 Consolidate Data using Excel Inbuilt Function
Ex 1101 Consolidate data using Excel Inbuilt Function
Excel Files for Practice (Please Download)
1201 Applying Data Validation
Ex 1201 Applying Data validation
1202 Dependent Dropdown List
Ex 1202 Dependent Dropdown List
1203 Using Data Validation with Vlookup & Match
1204 Other Data Validation Examples
Excel Files for Practice (Please Download)
1301 Worksheet Level Protection
Ex 1301 Worksheet Level Protection
1302 Cell Level Protection
Ex 1302 Cell Level Protection
1303 Hiding Formulas from Formula Bar
Ex 1303 Hiding Formulas from Formula Bar
1304 Protecting Workbook Structure
Ex 1304 Protecting Workbook Structure
1305 Workbook Level Protection
Ex 1305 Workbook Level Protection
Excel Files for Practice (Please Download)
1401 Understanding pivot Table
1402 Using Pivot Table in Real Scenario
Ex 1402 Using Pivot Table in Real Scenario
1403 Grouping in Pivot Table
Ex 1403 Grouping in Pivot Table
1404 Using Slicers (A Visually attractive Filter)
Ex 1404 Using Slicers (A Visually attractive Filter)
Excel Files for Practice (Please Download)
1501 Goal Seek (A Reverse Approach)
Ex 1501 Goal Seek (A Reverse Approach)
1502 One Way Data Table
1503 Two Way Data Table
1504 Scenario Manager
1505 Solver Add-In
Excel Files for Practice (Please Download)
1601 Record your first Macro
1602 Record Another Macro
1603 Assigning Macros to a Shape, Button, Picture
1604 Editing or Deleting a Macro
1605 Security Settings of a Macro
Excel Files for Practice (Please Download)
1701 Highlight cells rules
1702 Top Bottom Rules
1703 Data Bars
1704 Color Scales
1705 Icon Sets
1706 Function based Conditional Formatting
Exercise files for practice (please download)
1801 How to create a Map Chart in Excel
1802 How to use Forecast sheet in Excel
Excel Files for Practice (Please Download)
1803 Analyze Data using Excel
Why my excel file size is huge and how to reduce Excel file size
Problem of unwanted names when we create a copy of the sheet in Excel
New chart types in Excel 2019/Office 365 || Map Chart || Funnel Chart
How do you change the number format in Excel?
6 Types of Errors in Excel and how to resolve them
Excel Files for Practice (Please Download)
Congrats! Here's what's next...
12 + hours on-demand video
Full lifetime access
One Live QnA Session every month with Mr. Lokesh Lalwani
Private Forum to clear all your doubts
Downloadable Excel Files for Practice
Access on Laptop, mobile and TV
Certificate of Completion
Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Yes, absolutely & that's one of the advantages of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos multiple times & so on.
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
You will get lifetime access to this course.
Lokesh Lalwani
I went through your course, it is very much valuable & me being a beginner was easily able to grab the things explained & understand it quickly. Than...
Read MoreI went through your course, it is very much valuable & me being a beginner was easily able to grab the things explained & understand it quickly. Thank you so much for this hard work done sir. This would be really helping in my new career now.
Read LessNice & Easy to understand
Nice & Easy to understand
Read LessHELLO MY SELF HEMANT DAYMA BEFORE BUY THIS COURSE I KNOW ABOUT EXCEL BUT NOT THAT MUCH AFTER SEE VIDEO OR PRACTISE IT NOW I AM CAPABLE TO DO ANY EXCEL RELATE...
Read MoreHELLO MY SELF HEMANT DAYMA BEFORE BUY THIS COURSE I KNOW ABOUT EXCEL BUT NOT THAT MUCH AFTER SEE VIDEO OR PRACTISE IT NOW I AM CAPABLE TO DO ANY EXCEL RELATED WORK EASILY. THANKS, LOKESH SIR
Read LessTraining is very elaborative and easy to understand.
Training is very elaborative and easy to understand.
Read LessI have watched a lot of videos to learn excel but finally, I got the best, and +point is in sequence and always replies back for needed. I appreciate your ha...
Read MoreI have watched a lot of videos to learn excel but finally, I got the best, and +point is in sequence and always replies back for needed. I appreciate your hard work to share your knowledge with us. and one more thing, thanks for making the videos shortly and useful topics for a fresher. God bless you...
Read LessThis is a good course to solidify your knowledge of excel. It has many tricks which you won't find anywhere.
This is a good course to solidify your knowledge of excel. It has many tricks which you won't find anywhere.
Read LessVery good content & ample valuable knowledge.
Very good content & ample valuable knowledge.
Read LessTopic-wise elaboration is very nice. The core thing is I am not getting bored while learning. Thank you.
Topic-wise elaboration is very nice. The core thing is I am not getting bored while learning. Thank you.
Read LessNice & Easy to understand
Nice & Easy to understand
Read Lessgood
good
Read LessAssessment helps us learn effectively.
Assessment helps us learn effectively.
Read LessI will recommend it to everyone who wants to learn excel in an easy way, Thanks Lokesh......!
I will recommend it to everyone who wants to learn excel in an easy way, Thanks Lokesh......!
Read Less