Learn Excel

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

https://support.office.com/en-us/article/VLOOKUP-When-and-how-to-use-it-9a86157a-5542-4148-a536-724823014785

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

https://support.office.com/en-US/article/Video-Apply-conditional-formatting-f72dd508-6d88-4218-bf74-cee95b42ecb6

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

https://support.office.com/en-us/article/Define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64

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

https://support.office.com/en-us/article/Use-AutoFill-and-Flash-Fill-2e79a709-c814-4b27-8bc2-c4dc84d49464?ui=en-US&rs=en-US&ad=US

CREATING A DATA TABLE IN EXCEL