What did I learn today: Audio Clipart Preview and Function Key Lock

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

Custom Ribbon and Toolbar for PowerPoint

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.

image_thumb[2]
Continue reading Custom Ribbon and Toolbar for PowerPoint

How to evaluate Office 365

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.

image

Continue reading How to evaluate Office 365

Copy formulas automatically and accurately (even with blanks)

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!

image

Continue reading Copy formulas automatically and accurately (even with blanks)