Microsoft Excel: Notes

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

VMware Workstation: vmrun.exe

Using vmrun.exe to manage VMs on VMware Workstation

Linux command: lspci - list pci devices tuyendq@ubuntu001:~$ man lspci NAME lspci - list all PCI devices SYNOPSIS lspci [options] DESCRIPTION lspci is a utility for displaying information about PCI buses in the system and devices connected to them. By default, it shows a brief list of devices. Use the options described below to request either a more verbose output or output intended for parsing by other programs. If you are going to report bugs in PCI device drivers or in lspci itself, please include output of "lspci -vvx" or even better "lspci -vvxxx" (however, see below for possible caveats). Some parts of the output, especially in the highly verbose modes, are probably intelligible only to experienced PCI hac...

nmap - The Network Mapper

WARNING : It is ILLEGAL to scan hosts without permission.

luyện

Search This Blog