Shorts
46 videos • 284 views • by ExcelMoments
1
Fill blanks with value from cell above in excel #shorts
ExcelMoments
Download
2
How to replace a Tilde(~) in Excel #shorts
ExcelMoments
Download
3
Custom formatting to make a cell to display nothing #shorts
ExcelMoments
Download
4
Mouse tricks to Swap 2 columns in Excel #shorts
ExcelMoments
Download
5
TOCOL to combine multiple columns into one #shorts
ExcelMoments
Download
6
count how many times a character appears in a string excel #shorts
ExcelMoments
Download
7
last word in a cell Excel -Multiple Delimiters #Shorts
ExcelMoments
Download
8
Concatenate with ARRAYTOTEXT Excel Function | #shorts
ExcelMoments
Download
9
Get first and last name in Excel-one formula #shorts
ExcelMoments
Download
10
Get first n items from range - TAKE Function #Shorts
ExcelMoments
Download
11
MROUND and RANDBETWEEN for "relatable" numbers - Excel #shorts
ExcelMoments
Download
12
Excel Xlookup to return first and last instance-one formula #shorts
ExcelMoments
Download
13
FIELDVALUE function -Dynamic array Data types #shorts
ExcelMoments
Download
14
Formula for Nth day of the year #shorts
ExcelMoments
Download
15
Reverse strings/list in Python Excel #shorts
ExcelMoments
Download
16
Get the NTH working day of the year Excel #shorts
ExcelMoments
Download
17
MROUND for "relatable" random numbers #shorts
ExcelMoments
Download
18
Get the nth Name from multiple names #shorts
ExcelMoments
Download
19
Reverse/Flip an excel range -Excel Formula #Shorts
ExcelMoments
Download
20
Text Function Multiple formats #shorts
ExcelMoments
Download
21
Custom format Data Labels #shorts
ExcelMoments
Download
22
WRAPROWS Function-Quickly convert 1 column to multiple in Excel #shorts
ExcelMoments
Download
23
Hyperlink Function to link Sheets (# symbol magic) #shorts
ExcelMoments
Download
24
Hyperlink to a named macro in VBE #shorts
ExcelMoments
Download
25
Stop hyperlinks changing colour when clicked Excel #shorts
ExcelMoments
Download
26
SUM TILL SELECTED ITEM+XLOOKUP #shorts
ExcelMoments
Download
27
Return to location after hyperlink click #shorts
ExcelMoments
Download
28
GROUPBY function-dynamic subtotals in excel #shorts
ExcelMoments
Download
29
Waterfall Charts in Excel - Fix Totals
ExcelMoments
Download
30
Adjusting Min and Max dates for Excel Chart Axis #shorts
ExcelMoments
Download
31
Random Dates using RANDBETWEEN in Excel #shorts
ExcelMoments
Download
32
GROUPBY Function with Images in Excel #shorts
ExcelMoments
Download
33
GROUPBY images in PIVOT TABLE Excel #shorts
ExcelMoments
Download
34
Extract Data from Picture/Image-Excel #shorts
ExcelMoments
Download
35
Shorter running totals with SCAN in Excel #shorts
ExcelMoments
Download
36
Formatting hours above 24 in Excel #shorts
ExcelMoments
Download
37
Using Wildcards to Filter in Excel #shorts
ExcelMoments
Download
38
Optional Arguments in Excel Lambda #shorts
ExcelMoments
Download
39
Enter Key+Shift/CTRL behaviour in excel #shorts
ExcelMoments
Download
40
Find Previous using "FIND" dialog in Excel #shorts
ExcelMoments
Download
41
Wildcard Match - what column contains an "@" #shorts
ExcelMoments
Download
42
GROUPBY with PERCENTOF Function (% sales per person) #ahorts
ExcelMoments
Download
43
ALT+Function keys shortcuts in Excel #shorts
ExcelMoments
Download
44
Extract All dates (dd-mmm-yy) from a string /paragraph with REGEX
ExcelMoments
Download
45
Case (In)sensitive Sort in Excel -sort UPPER, then LOWERcase
ExcelMoments
Download
46
Sort data first by Month and then Year #shorts
ExcelMoments
Download