Tag Archives: Knowledge Pack

Knowledge Pack: Track Changes in Word

Track Changes in Word is useful but also confusing – and can even be very dangerous. Read these articles to understand how to use it effectively and safely.

Too many Track Changes? Confused? Here is the solution!
Office Politics: How to enable Track Changes without the other party knowing it!
Office Politics Secrets: Practical use of Track Changes
Legal: You can be cheated using Track Changes
Comparing Compare and Combine!
Document Protection: Quick Reference

Knowledge Pack: Word Tables

A collection of articles covering nuances and usage scenarios of Word Tables.

The curious case of Column Widths in Word tables
Using Formulas in Word tables
Efficiency Test 2: Word
Efficiency Test 4: Word and Efficiency Test 4 : Word : Solution
Create complex tables in seconds
Frustration = Feature Guarantee! (Table Row breaking across pages)
Reorder Word table rows instantly
How to convert multiple column data to a simple list
Building Blocks in Word – The ultimate reuse engine
How to sort a comma separated list in alphabetical order
Table going outside the page? Three click solution.

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

 

Zoom Knowledge Pack for High Impact Demos and Presentations

I wrote many articles recently about using ZOOM while presenting. I originally thought I will write only one article, but ended up writing 6.

This Zoom KNOWLEDGE PACK will guide you to the right article, depending upon what you need.

Continue reading Zoom Knowledge Pack for High Impact Demos and Presentations