I am sure this has happened to you before. You were on BCC, you did not realize it and did a REPLY ALL. That exposes you and the sender .
Well, if you use Outlook 2010 and Exchange server 2010 (or above), it is a simple matter of LOOKING at what Outlook is telling you. Outlook detects this problem AUTOMATICALLY and shows you a warning in RED color – just above the TO box. Notice it and act on it. Cancel the mail and just use REPLY – so that only the sender gets the mail.
If you don’t know which version of Exchange Server you are using, talk to your IT team.
Since Office 2013, you will often see a yellow bar at the top asking you to Enable Editing. Unless you press this button, you cannot type anything or format any content. This may sound irritating, but it is a very useful feature. It safeguards your interests.
The reason is simple. Even today, many viruses travel through Office documents – as macros. These files arrive either through email, downloaded from Internet or copied from USB drives. In these cases, there is a great danger of the file infecting your PC. To prevent this from happening, these files are now opened in a special way. Here you can read the file but not edit it.
If you trust the source, you will have to click the Enable Editing button. Unless you want to edit it, don’t Enable Editing. Just read and take the required action.
You may not have even realized this. But there is a very high chance that you have leaked out confidential information before – not once, but many times. How does this happen? and How does Outlook help you protect yourself and prevent inadvertent leakage… read on to find out.
Continue reading How Outlook helps you prevent inadvertent leakage of sensitive information
I am sure you have noticed. But just in case. Outlook 2013 is smarter. It analyzes what you are writing in the mail (NO. It does not send that information to Microsoft nor use it for advertising!). It uses that information to warn you if you have forgotten to attach a file. Usually, we realize the mistake AFTER sending the mail and then we send an “oops” mail with the attached file. It makes you look sloppy and unprofessional. Here is the solution:
Continue reading Outlook 2013: Prevents “oops” mails with Attachment Reminder
This is applicable only if you have installed Office 365 Pro Plus version of Office 2013. It is a great new feature which will help you create annotated, self running presentations – which can be used as training material. Here is how you do it.
Continue reading Ink Play in PowerPoint
In an earlier article, I discussed the benefits of a new Outlook feature called Clutter. Here is an update of how nicely the feature works…
Continue reading Inbox Clutter Update
Refer to the previous post. We saw how Filter fields can be exploded into individual sheets and files. In this article, I am releasing a macro – which does all the hard work for you. Of course, you must use it at your own risk. The source code is also included for you to view, learn from and modify. Created by Raj Chaudhuri and myself.
Continue reading Macro to Explode Pivot table by Filter Field Items
Suppose you have Products in Filter area and Pivot Table shows Regional Sales by Month. There are 5 products. You want five sheets for each product separately- this is called Explode Pivot Table. But not by doing this manually. Here is how you do it (Reading time 7 min)
Continue reading Unknown Gems: Explode Pivot Table by each filter item
Usually we select ENTIRE column rather than the data column. That leads to many side effects including applying unnecessary formatting to millions of rows or thousands of columns. Tables make it extremely easy to select only the data in a column. See for yourself.
Just hover the mouse cursor over the column name in a table and click. It selects only the data in the column – not the entire sheet column. Even if there are empty cells in the column, the entire data column will be selected. To select a table row, right click and choose Select – Table Row.
Now you NEVER need to select entire columns and rows across the sheet.
Often we need to poll the audience during a presentation, lecture or workshop. Usually we manage by asking the audience to raise hands. It is at best approximate. A more accurate method which works in an ad-hoc setting was always elusive. Now, with everyone having a smartphone and internet connection, there is a PowerPoint App which makes polling extremely easy. Read on to find out how you can use it. (5 min)
Continue reading Live Polling while presenting in PowerPoint