1. Advanced formula
   1. Evaluate formula
2. Copy Paste
   1. Copy cell contents as values
   2. Find and Select -CTRL F or G
   3. GO TO Special
   4. Multiply cell contents with paste special
   5. Dragging numbers down in consecutive order or repeating
   6. Go to visible cells - ALT ;
3. Simple Formula
   1. Copy formula and retain relative reference
   2. Enter today's date Today()
   3. View Formula - Tild
   4. Hide explanatory text in cells - N
   5. Subtopic 6
   6. Subtopic 7
   7. Subtopic 5
4. Charting
   1. Using combo box to create dynamic charts
   2. waterfall profit and loss
   3. 2 X axis
5. Data
   1. Sort horizontally
   2. Delete rows with blanks
   3. Data tables
   4. Data Validation
   5. Dynamic data validation