Combining tables and data charts

Lining up a data chart and a table in PowerPoint or Keynote is very tricky. And that is a shame, because it is one of the most useful compositions to present data. Just tables, and you cannot really see the trends. Just data charts, and it all becomes cluttered.

I took the data from an earlier blog post and quickly turned it into a combined table/data chart. You can clone the slides I create in presentation app SlideMagic into your own SlideMagic account by clicking this link.

The user is always right

Sometimes I get the strangest support questions by users of my presentation app SlideMagic. Obviously, the user did not explore the help pages, or did not try out all the menu options, or did not understand the philosophy behind SlideMagic. Initially, I felt like pointing that out. Now I figured out that it is my problem, not the user's.

User interface is entering an interesting phase. Mobile/tablet apps all look very cute but it is often incredibly difficult to find the most obvious functions. Desktop/laptop applications have become so bloated that obvious functions are hard to find, or are still in places "because they have always been there for the past 10 years" to serve the large install base of users. Every time I set up a new presentation, or create a new slide in PowerPoint I find myself doing a large number of repeat clicks (by now at incredible speed) that basically do very simple things (creating and aligning a grid of boxes for example).

I keep on trying to get it right.

---

Art: Vladimir Makovsky, Teacher Visiting a Village, 1897

Convert SlideMagic presentations to PowerPoint

Many people have asked for this feature. I might have found a partially automated solution for this. Partially means, slides are converted automatically, but the overall workflow is still manual.

Before I start investing a lot of resources (time and money) in developing a fully automated solution, I want to test demand. Soon, I will be adding a "PowerPoint" button to SlideMagic, but in the interim, you can email to (ppt at slidemagic dot com) an editable link of your presentation (generate it via the SHARE menu in SlideMagic) and we will send you back a PowerPoint file.

It is important to send the link using the SHARE function, nobody but you can open the links in your browser for privacy/security reasons.

Make sure that you have the Roboto Condensed font installed on your machine. It is a free font provided by Google

1. Exit PowerPoint
2. Go to the Roboto Condensed download page
3. Tick the 400 and 700 boxes
4. Download using the "arrow down" icon at the top right
5. Double click the downloaded files to install the fonts
6. Re-open PowerPoint

Roboto Condensed cannot be installed on iOS devices. If you want to edit your converted SlideMagic presentation in PowerPoint for iOS consider replacing the Roboto Condensed font for Helvetica Neue Condensed. Here is how to swap fonts across an entire presentation on a Mac. But hey, SlideMagic runs pretty well in Safari on iPad, no need to convert to PowerPoint for this.

Some disclaimers:

• It is a partially manual solution, please be patient, delivery can be instant or take some time.
• A human will open your presentation, we are nice people and unlikely to read it all in detail and/or post things on the Internet though. Still some corporate compliance regulations might have an issue with this
• There might be glitches in the quality of the conversion, if so, we would like to hear about them.

You will see that the end result looks pretty decent and small text edits work great, but - and this is the reason I created SlideMagic - if you want to make fundamental edits to a SlideMagic slide in PowerPoint you will hit the limitations of PowerPoint. For example, adding a row or column to your grid and getting everything to line up nicely is a small operation. I suspect you will quickly go back into SlideMagic, do the edit there, and convert again. Hopefully, in the end you will just forget about the conversion and stay inside SlideMagic.

So, hopefully the option of converting your SlideMagic presentation to PowerPoint will give you increased confidence to try it out, there is nothing to lose, you can always fall back to good old PowerPoint.

Not a SlideMagic user yet? Sign up here.

---

Image credit

Presentations on mobile devices - taking stock

Five years after the iPad launch let's take a step back and see what is actually happening in the world of presentation software and the use of mobile devices. My observations are based on the people I see around me everyday: startup employees (mostly mid 30s to 40s) and staff in big corporates (a bit older).

• Designing. Apple has made a big inroad in terms of hardware, but it is still PowerPoint that runs on a laptop machine that is the preferred set up to create slides. I have not encountered anyone who uses a mobile device to do this. Apple Keynote is pretty much still a niche application.
• Frankensteining / finding stuff. Cloud-based file systems can be confusing to use. I still do not understand exactly what happens when Keynote on iPad tells me it is converting a regular Keynote file. In practice, the file system that everyone is using is.... the email inbox and sent box. People with gmail can find stuff faster than Outlook users.
• Viewing. Yes, more and more, people use their mobile devices to view a presentation. And it is not the iPad, a tablet, it is the mobile phone, where people squint to see what is in the slides. These are investors looking at a pitch deck, these are managers/superiors proving input on a slide. Think about it, this might be a more important audience for your slides than the ones sitting in conference room.
• Emergency edits. Still laptop, although a tablet could work here, few people use it in a corporate setting.
• Coffee chat, 1 on 1. Mostly laptop, I see fewer iPad/tablets than I saw 1-2 years ago.
• Conference room. Laptop. The crappy VGA projector is being replaced by crappy LCD screens. Presentations that look beautiful on your retina display, look absolutely horrible on an LCD screen with poor resolution and overly bright settings. (Test, test, test). Advanced meeting rooms now allow you to airplay your presentations into the screen. People use their laptops to do this, not their mobile devices.
• Big keynote. Conference laptop with a memory stick plugged in.

So what is really changing? People are viewing decks on mobile phones, especially busy people that might not be overly motivated to see your pitch (investors in round 0 of the due diligence process for example).

Presentation gurus like me used to discourage dense bullet points because you can't (too small) and don't want (too boring) to read them in the back row. Now it is a bit more subtle. You can't read small text on a mobile screen. But, more and more desks are read without a presenter being present and you actually need some text to explain things properly.

In SlideMagic, I encourage big, bold, but extremely simple designs (that will come through nicely on a mobile device), plus I left space on the side for a regular explanation paragraph.

---

Image on WikiPedia

How to recover lost PowerPoint 2016 files after a crash

Note: this blog post discusses PowerPoint 2016 for Mac.

PowerPoint 2016 is great, but it still crashes left right and centre, all the time. Autorecovery does not always work, and when you forgot to hit SAVE every 5 minutes in the heat of a presentation design project, you are stuck.

The good news: you can often recover data, even when PowerPoint thinks it is lost.

PowerPoint autosaves your files in the background, without your realising it. Make sure you have switched this on, you can set the save interval in PowerPoint settings:

Normally after a crash, PowerPoint will automatically restart and present you with the last file that was auto saved. Normally... If not, try the following.

• In the Mac finder window, open the "Go" drop down, press ALT, to show the LIBRARY folder and click it.
• Once in Library, go to  Containers > com.microsoft.Powerpoint > Data > Library > Preferences > AutoRecovery
• Have a look at the files there and spot a file with a "_autorecover" ending to its name, taking into account the time it was saved.
• Copy this file just to make sure
• Rename this copied file with the ".pptm" extension at the end. Ignore all warnings you are presented with.
• Double click the file and cross your fingers

There is no 100% guarantee this will work, but it is worth a try

One more tip: as soon as you see the small "spiral of death" spinning across the PowerPoint screen develop the instant reaction to take a screen shot of the application. If you are lucky and you grab the slide sorter window, you have captured a miniature icon of all your slides, which should save a lot of time recreating them. Worst case, you just got the thumbnails on the left of your screen that are in the regular slide editing window.

My presentation design tool SlideMagic is a PowerPoint alternative that does not work with files in the classical way. Things get saved into the cloud instantly. Feel free to try it out.

---

Art: Letters "Whaam" inspired by Roy Lichentstein

SlideMagic on iPad

I have never been a big believer in focussed and productive presentation design on tablets, but presenting documents (mostly in 1-on-1 meetings) and making last minutes edits are important on mobile devices.

We are not making tablets a design priority, but have deployed some changes to the code that makes SlideMagic run pretty smoothly on an iPad (iPhone is still not optimal). Try it out and report back any bugs. Android tablet users, let me know what happens (I have not tried things out there yet).

With the large iPad Pro coming out later this year, there could be a brighter future for SlideMagic on iPad given the very simple menu structure we use.

Screen shot of SlideMagic on my iPad Mini 2

Thoughts on user interfaces

As I am making progress with my presentation design app SlideMagic, I spend a lot of time thinking about user interfaces (UI) for office applications.

Part of the reason that it is so hard to wean people of Microsoft Office applications is that they have gotten used to the mouse/click/dropdown user interface. Spreadsheets, word processors (who uses them still?) and presentation design software all basically have that same UI.

The drop down UI started out pretty simple. File, edit, help menus. Over the years ribbons and tool bars have complicated things. Most people now use a fraction of the functionality that is available to them. As soon as a program does not have that familiar dropdown UI, people are in trouble. I had a hard time understanding the new Adobe Acrobat UI. It is beautifully simple, but it takes time to figure out how to do very basic operations (zooming in and out, combining multiple files into one, rotating mixed up pages of a scan).

Over the past years, user have gotten to know a second UI: the mobile device. The solution for office apps is super simple functionality that draws heavily on icons, UI elements that we have learned from mobile devices.

See how it can work in SlideMagic.

How to format a spreadsheet

A few simple rules to keep your spreadsheet readable and error-free.

• Use one set of column headings through the entire worksheet and freeze the panes to the top of the sheet. If you need a completely different table, create a new worksheet in your workbook
• Avoid using too many colours, use shades of grey instead
• Round data by dividing by thousands, millions so that they are readable. Round to 1-2 digits behind the comma. Excel will continue to calculate things with the highest precision, even if you do not see it
• No underlines, italics, but use bold, uppercase, and bold upper case
• Use long, descriptive row headings
• Write your formulas top down, a lower row depends on a result that was calculated the line above. Keep formulas as simple as possible. A spreadsheet is a form of computer code: it should be readable the week after you created it. One formula with 15 cell references is the equivalent of code spaghetti.
• Add totals where ever you can to check for formula errors and to keep things readable. The brain often memorises a number quicker than a description (35.4 instead of "North Africa sales 2014 H1")
• If you need to source data out of a "data dump" keep that data in a separate worksheet and pull the numbers via links into your analysis. It creates a nice clean separation between your data source and the analysis, and makes it possible to over write your source data with new information and have the analysis updated instantly (always double check)

SlideMagic versus PowerPoint

Some interesting feedback from SlideMagic beta testers:

• I promised some SlideMagic beta testers to convert the presentation to PowerPoint in the end (there is not yet an automated feature that does that), and it is encouraging to see that these users are postponing that conversion again and again. 
• For some clients I quickly re-do a short presentation in SlideMagic. Client response: the SlideMagic one looks better, why can't you do that in PowerPoint? Answer 1): SlideMagic uses a pretty font, not Arial, and 2) the corporate PowerPoint template has a slightly less elegant composition of the slide (position of titles, margins etc.)
• Some clients want the templates that ship with SlideMagic in PowerPoint. After sending them, there are issues with modifying the template in PowerPoint, adjustments that take a second in SlideMagic
• Some users ask where you can upload PowerPoint slides to convert them instantly to SlideMagic, that will not be possible I am afraid.

Most users are hesitant to switch because 1) it requires changing 20 years of presentation design habits, and 2) yes I admit, SlideMagic had a few bugs that need sorting out. As we make progress with the app, that second excuse becomes less relevant. SlideMagic is slowly reaching the production release.

If you have not tried SlideMagic, you should, Try it here.

---

Art: Gulliver Exhibited to the Brobdingnag Farmer (painting by Richard Redgrave)

SlideMagic as a sketch board

Some of you out there are probably still afraid of using a new presentation design tool that is still in beta for live presentations. Here is another way to get started: use SlideMagic as your sketch board.

Many of you use bullet points to sketch out the content of a presentation. Maybe in a word processor, maybe in PowerPoint. The problem is that once you have iterated those bullets and everyone agrees to them, it is hard to turn those lists into visual designs.

Here is where SlideMagic could come in handy. It is very easy to set up charts that are not lists: a quick table, a quick contrast between two options, a quick 2x2. Jot your ideas down, and if you set your accent colour and logo, the whole sketch board will probably look better than a finished end product in PowerPoint.

Use SlideMagic to form your first ideas of your presentation, until the moment has arrived when you "have to" translate the designs to PowerPoint or Keynote. You can of course, but I think many of you will find that it is much easier to stick to SlideMagic after trying a few pages.  

---

Art: an unfinished painting by William Berryman, created between 1808 and 1816

Designing presentations for print

In some industry sectors, especially financial services, people still insist on printing the presentation slides and handing out booklets at the start of the meeting. You can have groups of 10-20 people sitting around a conference table flicking through pages.

It is great for taking notes, analysing detailed financials, but it is not that great for a close connection between speaker and audience, and that last minute typo in the name of the CEO cannot be corrected once on paper.

Sometimes you have to pick your battles and if print is the way to go, think about these issues when starting the design of your slides. The bottom line, get a slide to look good on paper on day 1 of the design project, not at 3AM the night before the meeting.

• Colours appear different on screen than on paper, especially on cheaper, older, or almost-out-of-toner printers. Bright blue can turn into faded grey, lively orange can become girly pink, subtle grey shadings turn into bright white, just to name a few potential problems.
• Hole punchers for binding machines require extra space at the top of your page, test it.
• Dark back grounds empty toner cartridges and make make the fingers of your audience black.
• You can get away with low res images on a 15 year old VGA overhead projector, on paper though, you will get caught. Use high resolution images.
• A monitor frame, or the light rectangle on a projection screen provide an implicit frame for your slide. Paper should do the same in theory, but A4/letter/4:3 and other issues makes it highly unpredictable how your slides are scaled on paper. In the worst case you might have draw a tiny grey line around your slides to anchor things (yes really).

Professional print designers will laugh at all this, this is design 101, and these issues have long been solved with Adobe InDesign, and printer driver software. A whole industry has been built around this, you are unlikely to see page scaling issues in your print newspaper. The problem is, these designs are hard to maintain/change in a corporate environment.

The one good thing about print though is that it shows that your slides are as fresh as the croissants in the bakery down stairs if the pages are still warm from the printer. A compliment I got many times in my previous life as a management consultant.

---

Art: Vincent van Gogh, The Bakery in Noordstraat

Hopefully Microsoft reads this: small change to PPT 2016

I have been working with the PowerPoint 2016 preview for a while now, and overall my feedback is very positive (see my PowerPoint 2016 review here). 

There is one small thing that keeps me going back to PowerPoint 2011 though: the ability to customise the toolbar at the top of the screen. My set up has not really changed since this blog post from 2008. When working in PowerPoint I constantly need to access buttons that align/distribute/crop/flip and send objects to the back (and the drop shadow button to kill drop shadows). With my custom toolbar, I basically circumvented the majority of the PowerPoint user interface and created my own.

Hopefully Microsoft will include this feature in the final release of PowerPoint 2016.

---

Image credit: Kate on Flickr

PowerPoint template weirdness

A technical post about PowerPoint templates today.

When you copy the slides of one PowerPoint presentation into another one, the copied slides get formatted according to the template of the presentation your are copying in. Colours and fonts get adjusted. But the most surprising things happen with text placeholders.

The template I typically use is pretty simple: a blank page with text placeholders for the slide title and footnote to make sure they are anchored in a consistent place across slides. Now the strange thing happens. Because the footnote is the only text placeholder available, PowerPoint starts copying text into the footnote.

To accommodate clients who want to use my template after the presentation design project is over, I now add a plain text box to my template slides. Here is the key thing, make sure that plain text box is the first text place holder you create, that's where copied text will go. (In other words, remove the footnote, put the text box in, recreate the footnote place holder after that).

---

If you often experience problems with inconsistent formatting of presentations and the issues with copying slides across you will appreciate the way I designed my presentation app SlideMagic (sign up for the beta here).

• One slide layout grid for all presentations, everything lines up perfectly, always
• No need for template programming
• It is not possible to corrupt a template and having it slowly propagate throughout your company
• Changing the look & feel of a presentation is easy: change your logo and accent colour and you are done (including bar and column charts, try that in PowerPoint)

---

Art: The Storm on the Sea of Galilee, 1633. The painting is still missing after the robbery from the Isabella Stewart Gardner Museum in 1990.

Photoshop alternatives?

Adobe is moving to a subscription pricing model for its major software products (Photoshop, InDesign, Illustrator, etc.). I signed up for a $20 or so monthly introduction offer but then forgot that I got upgraded to around $55 charge after one year. This is probably good value if you use many Adobe products, and use them frequently.

As a presentation designer, I fall in between the typical user segments. Here is how I use Adobe products:

• Acrobat:
  • Stitching together multiple PDFs into one
  • Reducing file sizes of image-heavy PDF files
• Photoshop:
  • Removing backgrounds from images
  • Compressing, re-sizing large image files
  • Putting text on blank 3D objects
• Illustrator: opening, selecting groups, re-coloring of stock vector files before saving them as PNGs.

Is there a combination of alternative software packages that could do these basic functions?

Some responses to an earlier tweet:

@ideatransplant Highly recommended!

— Timo Sorri (@SorsiusMaximus) June 2, 2015

@ideatransplant Best one I've seen in a free online tool is @fotoflexer Great tool for PS-like background removal!

— Mike Taylor (@tmiket) June 2, 2015

---

Art: Typesetter at the Enschede printing factory (was located behind the St. Bavochurch) in 1884, painting by the American artist Charles Frederic Ulrich.

New SlideMagic video tutorials

I am in the process of creating a library of video tutorials for SlideMagic. Here are the first three, you can expand them to full screen size for more detail.

---

From the 3x3 grid to a basic slide composition

---

How to clone a template

---

How to import individual slides from another presentation/template

---

Art: William Merritt Chase, A Friendly Call, 1895.

Adding structure to text

Sentences or titles never have the same length, so putting them on a page without some form of framing makes the whole slide look unbalanced. My solution: a light grey background  creates a box that gives structure to the text. You can also use images to reinforce the slide's grid layout. Many people use an outline, a frame around text for the same purpose. I think a light box fill looks a lot better.  

The light grey box is one of the key structuring elements in my presentation design app SlideMagic. Traditional presentation design software is not very well set up to changing grids of text boxes and images. Try doing it in PowerPoint, then try to do the same thing in SlideMagic.

---

Art: Piet Mondriaan, Broadway Boogie Woogie, 1942

Makeover of the Buffer pitch deck that landed them $500k

When Googling for examples of VC pitch decks, the on that Buffer used to raise $500k in 2013 ranks high. I decided to give it the SlideMagic treatment: how would the deck have looked when the slides would have been created in SlideMagic.

• I changed the slide design to fit SlideMagic
• I did not change the slide content
• I did not change the story flow

I have a few comments on the slides that I have put in the SlideMagic explanation boxes.

Here is the original:

The slide deck we used to raise half a million dollars from Buffer

Here is the same deck in SlideMagic. You can clone this presentation to your own SlideMagic account by clicking this link and use some of the slide concepts in your own presentations. I have also added this presentation as a template in SlideMagic's template library.

---

Art: Johann Zoffany paints a group of Englishmen in Rome for the Grand Tour, united only by their wealth and love of art; unlike most conversation pieces, this was not a commissioned work

SlideMagic bugs fixed

Presentation software needs to be absolutely bug free. Unlike a social media mobile app, where you can wait with grazing your news feed for a few hours, the presentation app needs to be ready for that critical 20 minute slot for the all-or-nothing presentation.

That is the reason I am keeping SlideMagic still in beta as I iron out all possible glitches. Here are some we fixed recently. If one of these caused you to stop using the app, give it another try.

• Fixed: small (but annoying) differences in font size rendering between what you see in PDF and what you see on screen, causing words to drop to the next line when you don't want them to.
• Fixed: erratic font size behaviour when rapidly increasing or decreasing font sizes
• Fixed: enabling multi-edit of cells to manage colours, font sizes of more than one cell in one go.
• Fixed: no need to leave and re-enter the shape format menu to work on another cell
• Fixed: Windows/Firefox UI freezes
• Fixed: story mode drag and drop issues

SlideMagic is moving closer to production stability.

B.t.w, I updated the SlideMagic marketing site yesterday, making the positioning plain and simple: it is easy to make business presentations. Easy, that's it. Also made the images a bit more daring.

---

Art: Scène d'été, or Summer Scene, is an oil on canvas painting by Frédéric Bazille, completed in 1869

SlideMagic example

Ramzi Mrad is entrepreneur in residence at INSEAD and used SlideMagic prepare his presentation of business case: how Roche Pharmaceuticals set the price for its Avastin cancer drug in Europe. This type of presentation is exactly how I envisioned SlideMagic being used. Without any professional support, a layman designer can come up with something pretty decent. You can see his presentation here.

---

Art: Pierre-Denis Martin (1663–1742), Vue du Château de Fontainebleau (1718-1723)

Little productivity hacks in SlideMagic

Recently, I have focussed most of the development work for SlideMagic on improving the workflow. It is the small differences that can make a big difference. Here are two features that you might not have discovered yet:

You can select multiple boxes and edit their design (colours, font size, etc.) at the same time. Great for creating tables quickly or clean up inconsistent font sizes.

In the shape change menu you can tackle multiple shapes in one go. Click another shape and you can adjust its perimeter as well without leaving and re-entering the menu.

You can give SlideMagic a try yourself, the beta version is free to use. Sign up here.

---

Art: Rabbits by Johann Georg Seitz, subscribe to this blog, follow on Twitter