Creating PowerPoint Presentations from Excel Outlines

I have long used Excel to outline my presentations. I love the program’s ability to color code, hide, apply hierarchy, move things around and maybe most importantly, get an accurate sense of timing.

My outlines tend not to be as granular as one row per slide, and I don’t actually write slide content in Excel, but if you did want to do that (and I see no reason why not to use Excel for this), Indezine has put together a nice tutorial on the workflow for going from Excel straight to slides.

It has long been a little-known workflow to outline in Word using paragraph-styled headers and bullet point and then with a few clicks, converting the Word document into actual slides. Apparently, you can do pretty much the same thing with Excel.

It’s a two-parter from Indezine:

Setting up an Excel outline

Importing into PowerPoint

Categories: Visual Thinking.

Presentation Mistakes We Have Made: The Presentation Podcast Episode #40

The Presentation Podcast


Episode #40, Mistakes We Have Made is live!


We’re not perfect, not by a long shot. Join Sandy, Troy and I for a stumbling trip down memory lane as we discuss failures, mistakes, errors in judgment and flat out fiascos we’ve experienced in the the world of presentation.


Don’t forget to give us a rating on iTunes if you like the Podcast and want to help spread the word!

Subscribe on iTunes and check out the show notes for more info.

Categories: Design, PowerPoint.

Apple: What a Difference 16 Years Make

One of my favorite “Bumper Stickers” for a presentation was Apple’s “1,000 Songs in Your Pocket” for the original iPod introduction in 2001. It basically told you everything you needed to know about the iPod and encapsulated the entire talk.

This year that made a nice allusion and callback with “40 Million Songs on Your Wrist.” Give it another decade and a half and maybe we’ll have…?

Categories: Visual Thinking.

Not Your Father’s Presentation Remote: Logitech Spotlight

Earlier this year Logitech released Spotlight, a new remote for presenters, and let’s just say it’s not your father’s remote.

I’ve had the chance recently to use it in real world settings, and while it does have some drawbacks, it is simply overflowing with features and functionality.

I have long been a fan of their R400 Presenter which I’m happy to report Logitech plans to keep in their product lineup. I have used the R400 for years and love the simplicity and ergonomic design. To quote Apple, “it just works.” But enter Spotlight that not just overhauls the basic design, but adds over a dozen features and solutions to common presentation problems. It’s the swiss army knife of remotes, and there’s not another remote on the market that even comes close to what this offers.

No More Laser Pointer

The main thing about Spotlight that you will notice is a slick modern design of the unit itself with only 3 buttons, the built-in rechargeable battery (via included USB-C cable) and the missing laser pointer. In place of the laser pointer, Logitech has created 3 toggle-able modes for screen highlighting beginning with “Spotlight” which darkens the entire screen except for a circular highlight which you can move around the screen by waving the remote. Click the Spotlight button again and you get a circle that magnifies a point on the screen and then click again for a simple circle with a cursor in the middle with which you can click on your slide (think of starting a video or activating a trigger animation or navigating a website without being tied to your laptop.)

The Spotlight App

All of the above modes are customizable (for example the size of the spotlight circle and the degree of screen darkening) via an installed app on the target computer. Available for both Mac and PC on Logitech’s site, the small app also allows you to set buzzing timers (e.g. 5 minutes left in your talk) and to customize the 3 buttons if you so desire, including double-taps of those buttons. Essentially you have 6 customizable buttons that you can set to options like black screen or even key strokes. I’ve set my bottom button to exit slideshow mode on two taps (“Escape” key) and to return to slideshow mode from the current selected slide (“Shift-F5”). This is going to make demos much smoother.

Raise the Roof (on Sound)

Have you ever started a video in a presentation and realized the volume was either set to zero or blasting the room? Program one of the buttons for sound and then hold the remote horizontally and literally raise your hand to increase your computer’s volume or lower it to decrease. Now that’s pretty damn cool.

Connecting and Recharging

The remote will connect either via bluetooth or via the detachable USB dongle, so you don’t have to take up a valuable USB port if you don’t want. The battery is technically replaceable, but it is rechargeable and meant to be charged up through an included USB-C cord. It holds a charge for a long time (and the level is indicated on the app), but if you are worried it will die at the wrong time, Logitech swears that it will charge to 4-hours of capacity in just 60 seconds.

What’s Not to Like?

There are a few things I’m not thrilled about. Even though I did receive a remote for purposes of review (full disclosure), it’s pricey at $130 ($100 on Amazon). The biggest drawback is that while the physical design is slick, it is not ergonomic the way the R400 is. It is longer, and unless you have gigantic mitts, it will never disappear into your hand like the R400. The other big negative is that you do need to install the software in order to use most of the features. If you just use the USB dongle without the software installed, it will advance slides, but that’s about all. I’m glad they did that, but keep in mind that you may get to a conference or a client and not be allowed to install software or even have internet access to get to the software download page.

Perhaps a future version will run the software directly from the dongle and have the dongle double as a flash drive where you can transport your presentation. That would be a really nice all-in-one package.


  • Bluetooth and dongle connection
  • Spotlight feature and 3 toggle able modes including magnify and mouse
  • Slick design
  • Quick rechargeable
  • Simple software interface
  • Cross-platform
  • Works for webinars & multiple screens
  • Volume control (via gesture)
  • Programmable buttons including keyboard commands


  • Not ergonomic
  • Need to install software to use spotlight feature
  • Pricey
Categories: Visual Thinking.

PowerPoint for Rapid Social Media Video Creation

I’m just back from the recent Presentation Summit where I had a chance to hang out with many old and new friends including Tom Howell from Australia’s Synapsis Creative. Tom is the newest PowerPoint MVP, and one of the things I love about the MVPs is that each comes to the PowerPoint with a very different perspective and skillset.

Tom’s specialty is using PowerPoint to author professional videos exploiting the program’s powerful, but often overlooked animation and video output features. Tom did a session at the Summit breaking down exactly how his studio creates videos for brands such as Coca-Cola, P&G and Nestle. Occasionally, he will use live video mixed in with graphics, but usually these videos all make use of vector-based objects, illustrations and text. I won’t go through Tom’s whole process and workflow, but one of the advantages to working in PowerPoint that he stresses is the ability to storyboard and author all within the same program, saving a great deal of time. Synapsis is gaining more and more clients who want a social media video executed in under 48 hours, and apparently that’s something they can do.

Oh, and he also said that they rarely use Morph which I found fascinating.

Check out an example of their PowerPoint video work above, and see their whole portfolio here.

And check out their blog as well.

Categories: Animation, PowerPoint, Video.

Logos Drawn From Memory asked people to draw famous logos from memory. I love everything about this including the X-Y axis visualization of the results. Check them all out here.


Categories: Design, Visual Thinking.
visual training presentation