29 March 2017

powerpoint: swap presenter view and demo

When presenting on windows, switching between a powerpoint (2016) presentation and a demo is problematic.

The goal

During a presentation I am projecting the slides in extended view behind my back to the audience and have the presenter view on my laptop in front of me.
When I switch to a demo I want to duplicate my laptop screen to the projector.
I want to swap easily between both modes.

The Problem

I set up my PC in extended view (F8 on my laptop)  and start the presentation: the full slide is projected and the presenter screen is on my laptop: fine.
When I start a demo, I duplicate my screen. The demo shows up in front of me and on the extended projected view: fine
When I switch back from demo view (duplicate screen) to extended view, the powerpoint presentation does not migrate back to the extended view.

The solution (sort of)

  1. Switch back to extended view
  2. right mouse menu in powerpoint presentation>duplicate slide show: the presentation is now shown in extended view (projector) and on my screen
  3. right mouse menu in powerpoint presenatation>show presnter view: the presenter view is on my laptop, the full slide is on the projector.
I reach the result I want. Only this takes three steps. Isn't there more fluent way to do such a common task?

9 February 2017

UK: insurance for self driving cars

UK plans to have a car insurance that does not care whether you or the car is driving. In both cases, an accident is an accident, and you are insured either way by a uniform car insurance.
This is a major step towards the general acceptance of self driving cars.
more...

24 January 2017

Excel 2016: this workbook contains links to one or more external sources that could be unsafe

I get this message sometimes when opening a workbook. Generally I have copied a formula from another workbook instead of a value, but i always want to check before breaking things.

I used a Microsoft support article (ignored the Edge promo):

  1. Type CTRL+F (opens Find and Replace Window)
  2. Click [Options >>]
  3. Fill in these values
    1. Find What: \[
      1. the MS article uses [, but I got some false positives from that
    2. Within: Workbook
    3. Look in: Formulas
  4. Click [Find Next] to search
If after verification you want to get rid of the warning, use the advice you get by clicking the Help button in the box:
  1. On the Data tab, in the Connections group, click Edit Links
    Here you can also update and break the links, but you do not see in which cells they are used.
  2. Click [Startup Prompt...]
  3. Select the option that you want