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

lastlog command reports the most recent login of all users or of a given user. NAME lastlog - reports the most recent login of all users or of a given user SYNOPSIS lastlog [options] DESCRIPTION lastlog formats and prints the contents of the last login log /var/log/lastlog file. The login-name, port, and last login time will be printed. The default (no flags) causes lastlog entries to be printed, sorted by their order in /etc/passwd. OPTIONS The options which apply to the lastlog command are: -b, --before DAYS Print only lastlog records older than DAYS. -h, --help Display help message and exit. -R, --root CHROOT_DIR Apply changes in the CHROOT_DIR directory and use the configuration files from the CHROOT_DIR directory. -t, --time DAYS Print the lastlog records more recent than DAYS. -u, --user LOGIN|RANGE Print the ...

luyện

Search This Blog