Here is a quick introduction OneDrive for Business. In this 5-minute video, you will learn:
- What’s wrong with My Documents.
- Why store documents on OneDrive
- How does OneDrive work without Internet Connection
- Benefits of storing files on OneDrive
- Sharing on OneDrive
- Sharing from Office
- Outlook tip: Send links instead of email attachments
- Edit together on same document
- Versioning on OneDrive
- OneDrive file type supports
- How to use Onedrive for the first time
Interested in more details? Read these articles.
We have seen many methods of using Excel and related Power BI tools for analyzing data. Now, all that can be done WITHOUT using Excel – using a stand-alone tool called Power BI Desktop. Here is how you do it.
Continue reading Power BI Desktop – new method of making amazing reports – without Excel – for FREE
We misuse the the Follow up flag in Outlook. Most of us think of it as a method of marking mails which actually are Tasks. Read this article to know why it is NOT a good idea.
In today’s world, this flag has a much more important use. Read on to find out how to use it to your advantage.
Continue reading The Real use of Follow Up Flag in Outlook
In the earlier article, we saw how Power BI Desktop can help us create complex, interactive and useful reports from various sources of data. Here is a detailed walk-through of how exactly to use this tool. In this video we will use the simplest possible scenario: Start with a simple CSV file, create a report, publish it on Power BI site and share it with a colleague. We will also see the Power BI mobile app in action. Download this sample CSV file (ZIP) if you want to follow along. 12 min video. Watch it in full screen mode at highest resolution.
In brief, this video will walk you through the following:
- How to create a FREE Power BI account
- Overview of the steps required for creating your first Power Bi Desktop dashboard
- Download Power BI desktop
- Import Data to Power BI Desktop
- Create a Power BI desktop Report
- Power BI Amazing Filter capability: Anything which is plotted is a Filter
- Ctrl + Click to select multiple fields
- Publish a Power BI desktop report to Power BI site
- Power BI report browser view
- Create a Power BI dashboard
- Share a Power BI dashboard
- Power BI natural Language Q&A tool: Ask a question in simple English and get answered instantly
- Power BI app on mobile
I am very happy that Scott Hanselman and team have recreated the Windows Live Writer 2012 as an open source project. You can Download Open Live Writer 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!
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 doomed for an imcomplete presentation dilemma.
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 incomplete 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.
Continue reading How to finish an incomplete presentation in style
This is a special post for avide Adobe users. Adobe products have dark gray menus. It reduces the eye-strain. Office UI 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.
Paste as text 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 to paste as 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.
Continue reading How to paste as text in OneNote
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.