Excel hack , unprotect sheet without password in excel
Study content
Excel hack , unprotect sheet without password in excel
6:09
Picture vlookup (index+match )
Study content
Picture vlookup (index+match )
4:25
Dashboard creation (pivot table ) ,,, easy way to careate chats and slicers in excel
Study content
Dashboard creation (pivot table ) ,,, easy way to careate chats and slicers in excel
5:07
Vlookup function # powerfull excel function #Vlookup+columns
Study content
Vlookup function # powerfull excel function #Vlookup+columns
6:33
Numbers group (4rth part) (number format, increase decimal ,decrease decimal etc.)
Study content
Numbers group (4rth part) (number format, increase decimal ,decrease decimal etc.)
4:01
Home tab (part 3) Alignment group all tools, Wrap text and Merge & Center etc
Study content
Home tab (part 3) Alignment group all tools, Wrap text and Merge & Center etc
4:48
Home tab (part 2) Font group all tools
Study content
Home tab (part 2) Font group all tools
5:19
Home tab part 1 (clipboard group)cut, copy, paste and format painter
Study content
Home tab part 1 (clipboard group)cut, copy, paste and format painter
2:57
DATABSE FUNCTION(DSUM AND DCOUNT)
Study content
DATABSE FUNCTION(DSUM AND DCOUNT)
5:27
Difference between two dates (Datedif formula)
Study content
Difference between two dates (Datedif formula)
3:09
how we add number with text
Study content
how we add number with text
4:38
INSERT BARCODE IN EXCEL
Study content
INSERT BARCODE IN EXCEL
2:18
QR code in excel IN only 1 minutes
Study content
QR code in excel IN only 1 minutes
2:20
AUTOMATIC FILL DATA SERIES BY IF
Study content
AUTOMATIC FILL DATA SERIES BY IF
6:06
Hlookup formula in excel basic to advance
Study content
Hlookup formula in excel basic to advance
3:36
Vlookup formula basic to advance
Study content
Vlookup formula basic to advance
6:24
Change cases in excel by formula (upper,lower,proper),concatenate,repet
Study content
Change cases in excel by formula (upper,lower,proper),concatenate,repet
4:01
First name and last name .....this is the actual use of left right formula
Study content
First name and last name .....this is the actual use of left right formula
3:12
text function (left, right and mid function) with example on text and numbers
Study content
text function (left, right and mid function) with example on text and numbers
4:44
Transpose function, Transpose Tool with example and short trick
Study content
Transpose function, Transpose Tool with example and short trick
3:22
sum series all formulas (sum, sumproduct, sumsq, sumif and sumifs)
Study content
sum series all formulas (sum, sumproduct, sumsq, sumif and sumifs)
4:22
count series of excel(count,counta,countblank, countif and countifs)..........
Study content
count series of excel(count,counta,countblank, countif and countifs)..........
4:44
logical formulas of excel (excel k important if , and ,or ,not formulas)
Study content
logical formulas of excel (excel k important if , and ,or ,not formulas)
6:52
excel important 10 formulas for beginners
Study content
excel important 10 formulas for beginners
4:26
Introduction to excel( Excel interface)
Study content
Introduction to excel( Excel interface)
6:37
pmt ,ipmt and ppmt powerful formulas of excel
Study content
pmt ,ipmt and ppmt powerful formulas of excel
6:49
sumif and sumifs function explanation with example
Study content
sumif and sumifs function explanation with example
3:58
countif and countifs function in excel
Study content
countif and countifs function in excel
4:03
Sorting(Expand the selection & continue with the current selection)...............................
Study content
Sorting(Expand the selection & continue with the current selection)...............................
2:09
Workday.intl and Networkdays.intl (excel important formula)
Study content
Workday.intl and Networkdays.intl (excel important formula)
3:10
workdays and networkday function of excel
Study content
workdays and networkday function of excel
4:18
Time function (Hour , Minute , Second ) in Excel
Study content
Time function (Hour , Minute , Second ) in Excel
3:27