Course Curriculum
-
1
Top Excel Formulas & Function
-
How to Convert Formulas to Values
-
PROPER - Fix Capitalization (Use for Titles)
-
LEN - Counts the number of characters in a cell (used for Titles)
-
TRIM - Remove Leading and Trailing Spaces in Excel
-
VLOOKUP
-
VLOOKUP in Multiple Excel Sheets
-
VLOOKUP with Multiple Criteria
-
How to Round Numbers in Excel
-
How to ectract text from a cell (LEFT + FIND)
-
Increase numbers by percentage
-
CONCATINATE - Add 2 text streams into new cell
-
* SUBSTITUTE - Replace one text with another
-
* How to replaces part of a text, based on the number of characters
-
KEYBORD SHORTKEYS
-
How to turn data from rows into columns and the opposite
-
Quick Tips
-