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

Linux command: top

NAME        top - display Linux processes SYNOPSIS        top -hv|-bcHiOSs -d secs -n max -u|U user -p pid -o fld -w [cols]        The traditional switches `-' and whitespace are optional. DESCRIPTION        The  top program provides a dynamic real-time view of a running system.  It can display        system summary information as well as a list of processes or  threads  currently  being        managed  by  the  Linux  kernel.  The types of system summary information shown and the        types, order and size of information displayed for processes are all user  configurable        and that configuration can be made persistent across restarts.        The  program  provides a limited interactive interface for process manipulation ...
Read more

Linux command: printenv

printenv - print all or part of environment NAME        printenv - print all or part of environment SYNOPSIS        printenv [OPTION]... [VARIABLE]... DESCRIPTION        Print  the  values  of the specified environment VARIABLE(s).  If no VARIABLE is speci‐        fied, print name and value pairs for them all.        -0, --null               end each output line with NUL, not newline        --help display this help and exit        --version               output version information and exit        NOTE: your shell may have its own version of printenv,  which  usually  supersedes  the        version  described  here.  Please refer to your shell's documentation for d...
Read more

Linux command: tail

tail - output the last part of files
Read more