Welcome back after a long holiday. I am sure an overflowing Inbox is waiting for you. Here are some simple but useful ways to get a grip on it and handle it efficiently.
- Mails received earlier are waiting longer. Therefore, try to start from the day after you went on leave. If you went on leave from Christmas, go to the Search box and type received>25 dec 2015
- Now sort the results in descending order of time and check for important mails.
- Look for mails which are addressed ONLY TO YOU. This is easily done by creating a special rule.
- Think of important customers, boss, or other high priority senders. Create a rule which highlights mails from them using a color category. Group by that category and handle these mails first.
- One approach is to look at unread mails only. But nowadays, we often see the mails first on a mobile phone. This marks the mail as read. In spite of that action may still be pending. Therefore Unread mails is an unreliable indicator of pending work.
To avoid this confusion in the future, use the message flag when you read a mail on mobile but intend to act upon it later.
- Convert actionable mails to Tasks and put a deadline. DO NOT mark them with the follow up flag. Drag the mail using the right mouse button and drop it on to the Task icon. Choose the Move with Attachments option.
- Filter on Importance flag. Mind you, this flag is usually set by the sender. However, if it is important to the sender, there is a good chance that it is important to you as well. Type Importance: High in the Search box.
- Confidential mails are generally more important. Type Sensitivity: Confidential in the Search box to find such mails. There is no easy way to filter IRM protected mails. These mails are visually identifiable with this type of icon
If you use an Office 365 mailbox, use Clutter to automatically segregate less important mails.
That’s it for now. Happy New Year.
Often we get data which is distributed in multiple column sets. Here is how you can convert it to good tabular data using Power Query. Watch the video. Sample File download.
In the previous article, we saw a video of how the New Year progresses across time zones. This video shows you how to use Power Map to create the animated time zone video. Download this file and try it yourself.
Here is an animated globe showing the new year dawning across time zones. Created using Power Map. You can also create it using Excel 2013 onwards. In the next article, I will illustrate how it was done. Enjoy.
Here is the most efficient and painless method of making sure that Copy Paste always works the way you want it to. Copy, Right click at the destination, Choose the format you want. Use keyboard shortcuts as required. Watch this one minute video to learn this powerful concept.
This is a simple yet useful thing. If you copy paste from anywhere into OneNote it takes a little longer than usual, especially if it is from a browser page. It also shows progress bars like Contacting the server. In addition, OneNote automatically pastes the URL of the web page at the bottom of the content pasted.
In most cases this is a good thing. But in some cases, you KNOW that you just want the plain text. In such cases, you have to click Home tab – Paste Special and choose Keep Text Only. If you need this option often, you cannot add it to QAT. Adding the entire dropdown to the QAT defeats the purpose. It still remains a two click operation. But of course, there is a solution.
This is a special post for avide Adobe users. Adobe products have dark gray menus. It reduces the eye-strain. Office menus are white in color by default. And many people work on Office as well throughout the day… so how do you reduce the eye-strain? Simple.
Go to File – Options and choose Dark Gray theme. This theme was introduced in Office 2016. Office 2013 also has a gray theme but it is not as dark. See the difference for yourself.
Default Theme is white
Change it to Dark Gray theme
You can also try the Colorful theme. It changes color based upon the product.
Yours is the fifth presentation in a conference. You have a one hour time slot. By the time your turn comes, things are severely delayed. Just before you go on stage, you are told that you have only 30 minutes. Your presentation is already copied to a common laptop which is on the podium. You have absolutely no chance of editing the presentation on time. You try to speed up the presentation initially, but soon, you will fall back to your regular speed.
You are half way through the presentation. The time allotted (which is now 30 minutes) is getting over. The organizers are showing you placards like 5 min, 3 min, 0 min, end now…
At this point you are really in a fix. The audience knows that you are nowhere near the end of the presentation. But you must finish you now. Otherwise some bouncer is going to take you off the stage in few minutes.
You also know that you have not done justice to the presentation. It is a hopeless situation. But you still want to salvage it in a professional and elegant manner.
How do you do that? .. THAT is the real problem. Read on to find out the solution to this problem.
Let us say I want to create sample data for my analytics class for a customer. I dont have access to the actual customer data. But I want the data to look familiar to the participants. I want to use the names of their products in sample data containing 1000 rows. I could use Randbetween() with Vlookup but that gives me almost equal distribution for all products. I want to make the data look realistic. I want to use the market share values of their products to generate the sample data. Here is how you do it. 3.5 minute video.
I am very happy that Scott Hanselman and team have recreated the Windows Live Writer 2012 as an open source project. Download it from here and read Scott’s Blog. It works side-by-side with the old WLW application. It is still work in progress – but there will be progress – which is great news.
I like the new logo, which matches with the “modern” look of Microsoft icons and uses the Segoe UI Light font.
For those who want the source code, here is the GitHub link. Enjoy. I hope all the existing Plug-In creators are busy porting them to the new system. As of now there are no plug-ins available but watch out for more action here.
Needless to say, this blog post was written using Open Live Writer. Exactly same UI… still exploring. Will post more about OLW as I explore it in the next few days.
A very big thanks to Scott and his team of volunteers who have put so much effort in making this a reality. Cheers!