Skip to main content

Microsoft Excel: Notes

Microsoft Excel Logo

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

References

>>> Microsoft Support - Excel help & learning

Labels:

Popular posts from this blog

GNS3: Notes

As usual, notes is for myself and might be useful and also save time for beginners start using GNS3 .
Read more

Powershell: Test-NetConnection

PS C:\Users\tuyen> get-help Test-NetConnection NAME     Test-NetConnection SYNTAX     Test-NetConnection [[-ComputerName] <string>] [-TraceRoute] [-Hops <int>] [-InformationLevel {Quiet |     Detailed}]  [<CommonParameters>]     Test-NetConnection [[-ComputerName] <string>] [-CommonTCPPort] {HTTP | RDP | SMB | WINRM}     [-InformationLevel {Quiet | Detailed}]  [<CommonParameters>]     Test-NetConnection [[-ComputerName] <string>] -Port <int> [-InformationLevel {Quiet | Detailed}]     [<CommonParameters>]     Test-NetConnection [[-ComputerName] <string>] -DiagnoseRouting [-ConstrainSourceAddress <string>]     [-ConstrainInterface <uint32>] [-InformationLevel {Quiet | Detailed}]  [<CommonParameters>] ALIASES     TNC REMARKS     Get-Help cannot find the Help files fo...
Read more

Google Credential Provider for Windows: Notes

Google Credential Provider for Windows® (GCPW) lets users sign in to Windows® devices with the Google Account they use for work. GCPW provides users with a single sign-on experience to Google services and all the security features available with their Google Account.
Read more