Data Validation, Filter and Conditional Formatting
Mastery in Data organising Tools in Excel
Mastery in Data creation and Data Manipulation in Excel
Managing data protection and data sharing in Excel
Work with Macro Recording
Basic of Computer
This is an Excel training program with an effort to put live practicals experience in the form of videos. This course will taught you thoroughly on how to manage important tools in Excel and how to apply various functions with nested methodology. it is advisable that you must follow the structure pattern for better understanding.
What can be expected?
At the end of the course you will be able to handle data in excel, also will be able to apply text, logical, math, lookup & reference functions very easily. you will find it easy to manage organizing tools in Excel like charts, pivot table etc.
Who should do this?
If you work on Excel and found it difficult to apply advance functions and tools then this is must course for you. Candidate must have basic computer knowledge and should be aware of Excel environment.
Even though the course which is up right now will be sufficient but every week I will keep on adding more videos.
Who this course is for:
11 sections • 55 lectures • 8h 23m total length
Equation in Excel - Function based
Cell Properties and Autofill
Cell Reference in Excel
Text Function 1 - Introduction
Text Function 2 - LEFT, RIGHT & MID Function
Text Function 3 - Nested FIND, LEFT & RIGHT
Text Function 4 - MID Function
Text Function 5 - Concatenate
Text Function 6 - REPLACE
Text Function 7 - Substitute, Rept & Len
Text to Column
Use of Filter 1
Use of Filter 2
Hyperlink in Excel
If Function - Nested
IF Function - Advance
AND() & OR() Function
Advance Math Function 1 - SUMIF, COUNTIF, AVERAGEIF
Advance Math Function 2 - SUMIFS, COUNTIFS, AVERAGEIFS
EMI Calculator - PMT Function
What if Analysis 1 - Data Table
What if Analysis 2 - Goal Seek
What if Analysis 3 - Scenario Manager
Lookup & Reference 1 - VLOOKUP & HLOOKUP
Lookup & Reference 2 - MATCH, INDEX, OFFSET
Lookup & Reference 3 - OFFSET
Lookup & Reference 4 - VLOOKUP TRUE
Lookup & Reference 5 - LOOKUP()
Lookup & Reference 6 - Tricks 1
Lookup & Reference 7 - Tricks 2
Conditional Formatting 1
Conditional Formatting 2 - Customize
Conditional Formatting 3
Chart Preparation 1 - Introduction
Chart Preparation 2 - Format, Design, Axis & Series
Chart Preparation 3 - Customize
Pivot Table 1 - Starts with
Pivot Table 2 - Exploring Features & Functionality
My Name is Himanshu Dhar. I am a MIS trainer associated with I Turn Institute. I am having more then 14 years of experience in different projects in Excel and Macros. I do take care of freelancing projects as well and brings that practical touch into teaching. I have successfully trained more then 25000 students from various backgrounds and have conducted many corporate training and seminars.