How to finish an incomplete presentation professionally

The Scenario

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.

The Problem

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.

Continue reading

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.

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. 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.

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!

Simple CSV to Interactive Dashboard – Power BI Desktop walk-through

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.

 

Photo credit: kevin dooley via Foter.com / CC BY

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.

Boring bullets to Exciting Visuals using SmartArt

  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.