Notes of Microsoft Excel tips used in real life situations.
CTRL + SHIFT + HOME CTRL + SHIFT + END CTRL + SHIFT + UP ARROW CTRL + SHIFT + DOWN ARROW
Get the value between character(s) or strings
Get the string between "(" and " bytes)", convert to number.
1 A B
2 41.06 GB (44,086,534,500 bytes) =VALUE(MID(A2,SEARCH("(",A2)+1, SEARCH(" bytes)",A2)-SEARCH("(",A2)-1))
XLOOKUP function
XLOOKUP can replace both HLOOKUP and VLOOKUP functions.
>>> XLOOKUP function
Create custom list to sort data
CANNOT create custom list on Excel 365
>>> Create or delete a custom list for sorting and filling data
LAMBDA function
Use LAMBDA function to create your own function
Courses
Excel for Everyone: Core Foundations | University of British Columbia | edX