1. PowerPoint 365 now allows live transcript & translation as you present - wowerpoint!

    # vimeo.com/309806972 Uploaded 22 Plays 0 Comments
  2. Copy & paste queries, query groups and the query dependencies view

    # vimeo.com/302860015 Uploaded 13 Plays 0 Comments
  3. Now Office 365 supports svg graphics you can create infographics charts! Cool right? Here are the steps: 1 Set up data with a filled & total amount, all totals should be equal
    2 Insert chart (clustered column or bar)
    3 Find svg images (Insert>Icons or noun project)
    4 Duplicate each icon
    5 1 icon of each pair is black outline & transparent, 2nd is coloured
    6 Paste into charts, one by one
    7 For coloured ones, set each to be stack & scale with & type number
    8 Make overlap 100% and gap width 0%
    9 Add data labels for the total value
    10 Adjust so it uses "value from cells" and select cells with your data

    # vimeo.com/294421937 Uploaded 15 Plays 0 Comments
  4. This video explains how to combine multiple files in a folder into one large table. I don't like the way Microsoft wants you to do it as this alternative gives more flexibility. 2 small bits of Custom code are used here. Create a custom column and type (with the UPPER and lower case as shown) either:
    =Excel.Workbook([Content]) to combine Excel files
    =Csv.Document([Content]) to combine csv files

    # vimeo.com/228536168 Uploaded 191 Plays 0 Comments
  5. Survey data often has things that are hard to quantify, "Satisfied", "Unsatisfied" etc. could be converted to numbers, checkbox answers need to be converted into multiple rows & sometimes data in columns already needs to be unpivoted into rows. This video explains how.

    # vimeo.com/228759271 Uploaded 285 Plays 0 Comments

Office 365 only MS Office features

David Benaim PRO

Features not in Office 2016 and only in Office 365, although some are in the new Office 2019

Browse This Channel

Shout Box

Heads up: the shoutbox will be retiring soon. It’s tired of working, and can’t wait to relax. You can still send a message to the channel owner, though!

Channels are a simple, beautiful way to showcase and watch videos. Browse more Channels.