Category Archives: Knowledge Pack

How to deliver high-impact demos: Knowledge Pack

Cloud and water mixed animation using transparency with video - illustration for how to deliver high-impact demos knowledge pack

Here is a list of articles I have written about delivering great and high-impact demos.

  1. How to deliver high-impact demos – Part 1
    Talks about the concepts, creating sample files selection and presentation approaches.
  2. How to deliver high-impact demos – Part 2
    Explains the tools and techniques, using the right language, customizing the content to user needs and converting features to business value.
  3. How to deliver high-impact demos – Part 3
    Covers AV technical aspects, common causes of failures and how to manage them and presenter view.
  4. Using Zoom effectively
    1. High Impact Demos : Use Zoom
    2. PowerPoint 2013: How to use Zoom to show details
    3. More about Zoom
    4. What did I learn today: Great feature in Windows Magnifier
    5. Windows Magnifier (Zoom) and Surface Pro
    6. The amazing ZoomIt utility

Enjoy.

Office 365 Groups: Knowledge Pack

This is a list of articles about Office 365 Groups. Managing teamwork becomes extremely easy and intuitive if you use Groups. These articles explain the details of how to create, use and manage groups. Remember that groups can be used with external parties like consultants, marketing agencies, vendors, suppliers, etc.

This list will be updated as more articles are added.

  1. Office 365 Groups
  2. Modern Teamwork using Office 365 Groups – Quick Introduction (5 minute video)
  3. Office 365 Groups: Automatic Sync between personal and group calendar
  4. Office 365 Groups: Practical Usage Guidelines
  5. Office 365 Groups vs. Team Sites

more articles coming soon…

Knowledge Pack: Google Docs vs. Microsoft Office 365

Here is a series of articles about this commonly performed comparison.
It offers an unconventional yet practical perspective.

  1. Google Docs vs. MS Office: Want vs. Need – the concept with few examples
  2. We are doing a feature comparison. So we should know the quantification as well.
    How many features does Microsoft Office have?
  3. Google Docs vs. MS Office: “I don’t need all these features”
    This post discusses the commonest response to feature explosion in Microsoft Office

more articles coming soon …

Outlook Knowledge Pack

Outlook is great. But our outlook towards Outlook is not! That is why we waste lot of our precious time in doing the wrong things in and around Outlook. I have covered many aspects of effective Outlook usage. Here is a comprehensive list, in recommended order of reading. The complete Outlook Knowledge Pack.

Outlook Knowledge Pack

Photo credit: simondavies57 / Foter / CC BY-SA

Continue reading Outlook Knowledge Pack

List of Knowledge Packs

Knowledge Pack is like a live book. I write articles in random order. But later I put combine them in the recommended reading order by topic. This list is called a Knowledge Pack. Whenever I write another relevant article, the corresponding Knowledge Pack is updated. This is what makes the Knowledge Pack a Live Book!

I have created many knowledge packs. But there was no list of Knowledge Packs. So here it is… it is like a Knowledge Pack of Knowledge Packs School

image

Continue reading List of Knowledge Packs

Knowledge Pack: Office 365 Worst Practices

While working with hundreds of customers globally, I see lot of mistakes being done. This leads to poor ROI and business value. Best Practices get all the limelight. But mistakes are never documented publicly. Hence I am writing this series – Office 365 Worst Practices

Some mistakes are strategic, some technical, some operational. The worst practices article list is growing! Here is a list of all articles I have written on this topic so far. Future articles will also be added to keep this knowledge pack current. Your comments and suggestions are welcome.

Office 365 Worst Practices - KP

Continue reading Knowledge Pack: Office 365 Worst Practices

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