I recently conducted a highly appreciated session at a CIO event in Mumbai. This 45 minute video is a MUST WATCH for every CIO and IT professional who is involved in effective utilization of Office and Office 365.
You can download it from HERE (46 MB WMV video).
When you click on this link, the video will try to play from OneDrive. But it WILL NOT PLAY. Click the Download button on that page, download it locally and then run it in full screen mode. If you like it, please share it with your colleagues and friends.
The recording resolution is intentionally low to keep the file size small. Some colors may show banding. But it is good enough resolution as a reference.
Do post your feedback as comments on this blog article.
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!
Next time, before habitually attaching the file – explore these sharing options.
Continue reading Have you noticed the new Sharing options for documents?
Earlier, the File menu was a humble drop-down menu. Since Office 2010, it suddenly occupies the whole screen. Scary! … is it not?
Think about it – why did Microsoft decide to give it so much space?
The answer is simple – because it is GOOD FOR YOU (as in – all of us – the users).
Find out the amazing facilities this menu provides us with. Reading time 4 minutes.
Continue reading The big and scary File menu
The official answer to finding the version of office is here. But it requires some trial and error. I found a very simple way. Rather than asking the user (or customer) to find out this information, it is simpler to detect it myself. I ask the customer to send the screenshot of File menu to me. That shows the version number easily.
2003 and before – File menu has a Page Setup menu option.
2007 – NO File menu. Instead there is a round, colorful button
2010 – File menu has Save and Send option
2013 – File menu has Share option
Simple and effective. Works all the time.
You need a tablet with stylus for this. Handwriting on OneNote is very natural and easy. Here are some guidelines which will help you be more effective.
Continue reading OneNote handwriting Practical Guidelines
Small but useful post. Since Office 2012, CTRL O or CTRL S do not open Open / Save dialogs. You must click CTRL O – Computer – Browse to get that dialog. This is a GOOD THING. Because Microsoft wants to change our bad habit of storing everything locally and help us move to internet storage (OneDrive, SharePoint, DropBox, etc.).
In some cases, you want to do some quick and repeated operations on local PC. Want the simple Open / Save dialog just with CTRL O and CTRL S. Wish granted!
File – Options – Save – Don’t show the Backstage when opening or saving files.
Use this option temporarily. When the job is done, go back to the Backstage view. I will write more articles about Why Backstage is important very soon.