Another video in the word best practices series. For Microsoft Channel 9. Have a look. This video shows what EVERYONE should know about Word. So please share it with everyone you work with as well as your loved ones. This is the best gift you can give a child: Knowledge!
Word Best Practices Video
View at http://bit.ly/nitinch9word, 35 minutes. View in FULL SCREEN mode at high resolution for maximum learning. Includes links to detailed articles and sample files.
Spend 30 minutes and save at least 10 minutes every day. Learn powerful time savers and amazing features which work across Word, Excel and PowerPoint. Have a look.
Post your comments. More videos coming up soon.
Office Usage Best Practices
Finally, here is a proven set of best practices to make your Excel usage simpler, faster and more accurate.
Continue reading Excel Tables 12 – Standard Operating Procedure
See any report – data comes first and then the grand total (or other summary calculations). What does the viewer of the report want to look at first? The Grand Total. Should that not be shown in the beginning? Obviously yes.
Resist that urge of putting summary after the data. Put it in the beginning.
Data should be tabular – headings followed by data. Convert it to an Excel table first. Select data – Insert – Table. Now you see Table Tools – Design menu on top. In that give the data a name (default name will be Table1, Table2, etc.). Let us say the name is mydata. Put a few blank rows BEFORE the data and add a formula on top to see the summary. That’s it!
||Today everything in IT is driven by hype, fashion, “cool”ness, social media popularity and so on…
But real, serious, efficient work still requires full Windows + Office!
Estimated reading time 6 min
Continue reading Real work requires full Windows and MS Office
The question is simple. How to delete notes across all the slides in the most efficient way? The answer will not only surprise you, it will protect your interests.
Estimated reading time 4 min
Continue reading Efficiency Test 5 Solution: PowerPoint : How to delete notes across all slides in 5 clicks
Green mark in top left corner of Excel cells is an indication that something is wrong with the data you see. Read this article first to understand the concept: Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!
In this article, we will discuss the most important and potentially dangerous error which is commonly ignored. Read on and share it with as many people as you can.
Continue reading Green Marks Part 2: Formulas showing wrong results!
This is a simple, useful but unknown feature available in Office. Documents containing passwords, important numbers should be protected from inadvertent changes using the Mark as Final feature.
Continue reading Prevent inadvertent changes in documents: Mark as Final
With the launch of Office for iPad, we have yet another method of viewing and editing Office documents. You may not have realized, but over time many different ways of viewing and editing Office documents.
There are two problems. Firstly, you may not be aware of ALL these options. Secondly, you may not have a clear cut understanding of which is suitable in which scenario.
In this article, I will address both these aspects.
Continue reading Editing Office Documents – which method when