Apply Conditional Formatting................................................................................................ 13
Custom Number Formats....................................................................................................... 16
Split Text to Columns............................................................................................................. 18
Copy & Move Worksheets...................................................................................................... 20
Split a Window....................................................................................................................... 22
Hide & Unhide...................................................................................................................... 23
Save as a Template................................................................................................................. 25
Date & Time.......................................................................................................................... 30
Logical Functions................................................................................................................... 31
Mathematical Functions......................................................................................................... 34
Statistical Functions............................................................................................................... 37
Countif................................................................................................................................... 37
CountBlank............................................................................................................................ 38
Rank.Eq................................................................................................................................. 39
Text Functions....................................................................................................................... 40
Trim....................................................................................................................................... 44
Concatenate........................................................................................................................... 45
Financial Functions............................................................................................................... 46
PMT....................................................................................................................................... 46
PV.......................................................................................................................................... 48
FV.......................................................................................................................................... 49
LookUp Functions................................................................................................................. 50
VLookUp............................................................................................................................... 50
HLookUp............................................................................................................................... 51
