Many customers and participants ask me this question… Where did I learn all the technology when I am just a gynecologist by qualification… The answer is simple. I learnt things by exploring, trial and error, reading books, diving deeper. And that journey continues.
I keep learning new things every day. So I though of sharing what I learnt with all of you. Here is the first one in the series…
Continue reading What did I learn today: Audio Clipart Preview and Function Key Lock
Recently, (25th Feb 2014), Microsoft released the first Service Pack for Office 2013. If you have configured Windows Update to include Office, the update should be automatically available to you. Here are some more details about it.
Continue reading Office 2013 Service Pack 1 released
Office allows you to create your own set of menus. But this is rarely used. Ideally each one of us should create a menu for ourselves – because everyone’s way of working different.
However, I want to try a new approach. I have created a custom toolbar and a menu for PowerPoint. Download, try it out and let me know your feedback.
Continue reading Custom Ribbon and Toolbar for PowerPoint
Many users have this habit and it is counterproductive. The idea is that you create many rules to divert incoming mail into multiple folders – by the sender. Here is why you should NOT do it.
Continue reading DO NOT create sender specific rules in Outlook
Currently I am conducting a lot of sessions (and webinars) on Office 365. After I demonstrate the business benefits of this product, most participants get so excited that they want to try things out. Due to lack of time, I just tell them to sign up for a one month free trial of Office 365 and test drive it.
However, I realized that evaluating Office 365 is not as simple as downloading some test version of one application and trying it out. Therefore, I thought of writing this post which explains the whole process in brief.
Continue reading How to evaluate Office 365
This is a small but useful post.
Spreadsheets become large very quickly. Lot of scrolling is required to navigate it.
Scrolling vertically is easy.
This way you can scroll one screen of data at a time.
Continue reading Scrolling horizontally with Alt Page Down in Excel
Imagine that you have 50,000 rows of data. You want to add a new calculated column. Adding the formula is easy. But copying it to 50,000 rows is nothing but frustration.
Three methods are typically used: All of them are inefficient!
Copy and Paste, Drag and Double Click. Drag is lengthy – so is Copy Paste. Double Click is DANGEROUS because it stops if the column on the left has a blank cell. And usually we have lots of blank cells – at least we have to assume so!
Of course, there is a solution – a magical solution!
Continue reading Copy formulas automatically and accurately (even with blanks)