Understanding the Basic of Excel
Basic Data Entry in Excel06:52
Create Basic Data Table05:44
Selection and Movement Tips in Excel09:22
Alignment05:50
Formatting Table08:19
Employee Time Sheet Table08:56
Form Design Advance12:06
Spreadsheet Management
Data Types in Excel03:27
Insert Special Characters03:07
Autocorrect in Excel03:31
Auto Suggetions for Data Entry02:30
Autofill06:34
Flashfill03:27
Insert and Delete Rows and Column05:01
Hide Unhide Rows Column03:02
Spreadsheet Management05:03
Find and Replace05:09
Understand Functions
Introduction of Calculation03:58
Use of Inbuilt Function04:13
Cell Absolute Reference07:43
Error in Formula03:41
Circular References02:00
Value Paste02:05
Named Range,Beyond Basics
Define Name of Cell and Cell Range05:26
Define Name Using Name Manager02:39
Retrieve Value from other Workbook02:27
Naming Convention in Define Names04:17
Intersection02:42
Text Functions with Real Life Problem
Determine Cell Values are Text or Not05:33
Determine Cell Values are Identical or Not06:02
Joining Multiple Text in Single cell with Real Life Practical Examples06:00
Removing Excess Space and Non Printing Characters02:47
Counting Characters Using Len Function04:20
Padding a Number05:17
Changing Case of Text01:18
Extract Characters from String05:53
Extracting First Word using Find Function04:19
Date Functions with Real Life Problems
Understanding the Dates in Excel04:00
Today Function in Excel07:01
Date Function in Excel04:37
Convert Non Date String to a Date in Excel03:06
Calculate Days between Two Dates03:24
Days and Days 360 Functions in Excel04:51
Network Days Calculate Work Days03:52
Network Day INTL02:39
Workday and Workday INTL Function03:53
DateDIF03:43
Calculate Last Day of the Year02:08
Time Functions with Real Life Practical Examples
Understand Time Functionality in Excel08:42
Summing of the Time Values04:01
Calculate Working Hours in Excel02:12
Convert Integer Values into Time Value02:26
Round Up Time Values02:43
Manage Images and Shapes in Excel
How to use Images and Shapes in Excel13:57
Data Validation in Excel
Data Validation07:44
Logical Comparison
Logical Functions08:54
Lookup Functions
Vlookup Function05:34
Advance use of Vlookup and Hlookup Function05:33
Create New File and Save
