Knowledge Pack – Excel Tables

Excel Table seems like a trivial feature. But if used correctly, it transforms and improves the way you use Excel dramatically. Here is a set of articles (the entire knowledge pack) which explain the concept and importance of Excel tables. Many practical usage scenarios are also explained in detail.

Knowledge pack - excel tables

Articles about Excel Tables

All you wanted to know about Tables. In a concise series of articles. Below is the Knowledge Pack.

  1. What are Excel Tables and Why should you use them?
  2. Converting regular data to Excel Tables
  3. Handling manual formatting while creating tables
  4. Merged Cells and Cross Tab – The Data Villains
  5. Good Data Checklist – Prerequisite to creating Excel Tables
  6. Miraculous Formula Auto-Copy with Excel Tables
  7. Excel Tables Formula Auto-copy not working
  8. Freeze “Pain”killer
  9. Automatic copying of everything!
  10. Unbelievable simplicity – Calculated Columns (Readable Formulas)
  11. Everything is in a name
  12. Auto Update Dependent Formulas and References
  13. Standard Operating Procedure for using tables across the organization

 

16 thoughts on “Knowledge Pack – Excel Tables”

Comments? Suggestions? Wish list?