As a general resource for information on EXCEL Functions and written step-by-step tutorials visit the official Microsoft Excel support channel here:
https://support.office.com/en-us/excel
Moving rows/columns
https://www.youtube.com/watch?v=3muaPPvZwzU
Help with specific functions
The following is list of the EXCEL functions that will be covered in this course, as well as links to videos that help illustrate how and when to use each function.
VLOOKUP
SORTING and FILTERING
https://support.office.com/en-us/article/Sort-and-filter-data-ffb9fcb0-b9cb-48bf-a15c-8bec9fd3a472
TEXT-TO-COLUMNS
https://www.youtube.com/watch?v=x78JR7XHTro
SUMPRODUCT
https://www.youtube.com/watch?v=9AEjLPH5nyA
CONDITIONAL FORMATTING
COMMENTS
How to create and edit comments
https://support.office.com/en-us/article/Add-a-comment-bdcc9f5d-38e2-45b4-9a92-0b2b5c7bf6f8
NAMED RANGES
How to define and use named ranges in formulas
IF, NESTED IF, COUNTIFS, SUMIFS
https://support.office.com/en-us/article/Advanced-IF-functions-17341cef-510d-4d60-a657-913f878fdacf
AND, OR
https://www.youtube.com/watch?v=HsWGsYA2Tzo
LEFT, RIGHT, MID
https://www.youtube.com/watch?v=P-6uoymwdzY
CONCATENATE
https://www.youtube.com/watch?v=kAXRRYls5uQ
LEN
https://www.youtube.com/watch?v=4ozBVDXjwi4
TRIM
https://www.youtube.com/watch?v=-yLezqRAeAs
SUBSTITUTE and REPLACE
https://www.youtube.com/watch?v=C1OOza2sqSk
FIND and SEARCH
https://www.youtube.com/watch?v=irg0z8VbiaI
INDEX/MATCH
https://www.youtube.com/watch?v=VSMJO4iXRvw
FLASH FILL
CREATING A DATA TABLE IN EXCEL
PIVOT TABLES FROM MULTIPLE SHEETS:
This is an excellent tutorial about how to make a PivotTable from multiple sheets of data: