Be a DataChamp in Digital World. This is a learning platform for Microsoft Excel, Advance Excel, Powerapps, Power Automate, Power Bi, SharePoint etc.

How to add months / years to date in Excel
1:17
How to add months / years to date in Excel
How to add business days to date with or without holidays in Excel
1:13
How to add business days to date with or without holidays in Excel
How to add decimal hours / minutes to time in Excel
0:31
How to add decimal hours / minutes to time in Excel
How to round time to a specific period using MROUND, CEILING and FLOOR excel formulas
1:01
How to round time to a specific period using MROUND, CEILING and FLOOR excel formulas
How to round a number using MROUND, CEILING and FLOOR formulas
0:36
How to round a number using MROUND, CEILING and FLOOR formulas
How to use Round, RoundUp and RoundDown in Excel
0:30
How to use Round, RoundUp and RoundDown in Excel
How to get a number at place value in Excel
0:36
How to get a number at place value in Excel
How to get an integer and decimal part of a number in Excel
0:36
How to get an integer and decimal part of a number in Excel
How to Rank numbers with or without ties in Excel
1:10
How to Rank numbers with or without ties in Excel
How to Group numbers in Excel
0:38
How to Group numbers in Excel
How to Group arbitrary text values in Excel
0:59
How to Group arbitrary text values in Excel
How to Categorize Text with keywords in Excel
0:58
How to Categorize Text with keywords in Excel
How to get a running count group by n size in Excel
1:05
How to get a running count group by n size in Excel
How to Group times into 3 hours bucket in Excel
0:20
How to Group times into 3 hours bucket in Excel
How to identify Excel cell if it contains specific text
0:24
How to identify Excel cell if it contains specific text
How to validate Excel cell data format using IF and wildcard characters
1:29
How to validate Excel cell data format using IF and wildcard characters
How to identify Excel cell if it contains multiple texts
1:21
How to identify Excel cell if it contains multiple texts
How to assign grades in Excel using IF Function
2:43
How to assign grades in Excel using IF Function
How to assign sales commission or discount rate percentage based on number of sales
2:40
How to assign sales commission or discount rate percentage based on number of sales
How to Identify Excel cell if it begins with x , y or z
1:14
How to Identify Excel cell if it begins with x , y or z
How to get multiple matches into separate Excel rows
0:49
How to get multiple matches into separate Excel rows
How to get nearest location with XMATCH Excel function
0:44
How to get nearest location with XMATCH Excel function
How to get next largest match using MATCH Excel function
0:28
How to get next largest match using MATCH Excel function
How to get partial match with numbers and wildcard character in Excel
0:48
How to get partial match with numbers and wildcard character in Excel
How to get partial match with VLOOKUP Excel function
1:03
How to get partial match with VLOOKUP Excel function
How to get Position of first partial match using wildcard character
0:24
How to get Position of first partial match using wildcard character
How to calculate Rank and Score in Excel with INDEX and MATCH
0:53
How to calculate Rank and Score in Excel with INDEX and MATCH
How to get Position of Max value in a list
0:26
How to get Position of Max value in a list
How to apply VLOOKUP Excel function with self-contained array
1:00
How to apply VLOOKUP Excel function with self-contained array
How to calculate Sum using SUMIF Excel function
1:03
How to calculate Sum using SUMIF Excel function