Introduction


For those looking for some handy information regarding navigating and using Excel a little easier, please refer to the following documentation which includes some short demos, demonstrating how various tasks can be performed in Excel.


Click Here for Documentation


Should the above link not work, you can open the attached file instead.



Contents


  1. Fast jumping around + Select
  2. Discard formulas
  3. Repeating complex sorts
  4. Extracting last state
  5. Sort back into original order
  6. Pull headings into data
  7. Compare sheets
  8. Update a master sheet