All posts by Dr Nitin Paranjape

New outlook towards Outlook

New Outlook towards outlook

Things have changed. We have to look at Outlook differently. Otherwise we will continue to misuse it. Spend just five minutes to understand the new role of Outlook:

  • Use Clutter to clear out less relevant mails
  • Identify important mails
  • Avoid excessive mail attachments by using links
  • Manage your work better with Task Folder
  • Use Skype for Business and Skype FB for faster, more secured teamwork
  • Use Yammer to faciliate discussion, ideas and progress
  • Recap: Which one to use when

 

Read related articles here.

Powerpoint: Agenda slide from any slide

Agenda slide is usually the second or third slide. During the course of the PowerPoint presentation, we may have to refer to that slide frequently, especially when the next agenda item is taken up. Most of us copy paste that slide multiple times. This may work, but if the agenda slide changes, we may forget to update other slides.

Agenda Slide

The same method can be used to refer to any key slide or slides during the presentation. The key thing expectation is that you may show this slide at any point during the presentation. After showing the slide, how do you come back to the slide where you were? Here is how you do it.

View the video in full screen mode. Download this Sample File which illustrates the method shown in the video.

How to generate random data based upon known percentage distribution using Excel

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.

Migration Done

Thank you all for your patience. This blog is now migrated to a self-hosted WordPress site. You will get new post notifications as usual. I am still customizing things and migrating content. But I will be back to my regular rhythm of one daily post within a few days. I appreciate your support and participation. If you notice any problems, please drop a mail to nitin@maxoffice.biz. Cheers!

OneDrive is the new My Documents

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 on a browser 
  • 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.

PowerPoint SmartArt: Knowledge Pack

Here is a list of all the articles I have written about PowerPoint SmartArt. This is a LIVE list. I will update it whenever I write more articles about SmartArt.

PowerPoint SmartArt Knowledge Pack - boring bullets to exciting visuals

  1. Boring to Exciting ppt – in few clicks!
  2. Marketing: Arranging multiple pictures in few clicks
  3. Show Off and Learn: Picture Organization Chart in 2 minutes
  4. Video Tutorial: How to show collaboration in PowerPoint (4 min)
  5. Marketing: How to create “Our Customers” Slide in seconds
  6. Applied Knowledge: SWOT and PEST analysis (PowerPoint)
  7. Applied Knowledge: Show an Iterative Process using SmartArt
  8. What did I learn today: Dual SmartArt
  9. SmartArt Animation: Part 1
  10. SmartArt Animation: Part 2: Multi-level diagrams
  11. Bottom-Up approach using SmartArt

Enjoy.

Power BI Desktop tutorial for Beginners

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
Photo credit: kevin dooley via Foter.com / CC BY

Bloggers: use Open Live Writer, the reincarnation of WLW

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.

Open Live Writer Logo

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!