ICAEW.com works better with JavaScript enabled.

Excel, Teams, Zoom, Google Workspace, Power BI++: New tech features for Jun-Aug 21

Author: David Benaim

Published: 08 Sep 2021

Our quarterly digest of new features across Microsoft 365 & other business tech products in written, images & video format.

My top 5

a) Focus mode in Zoom
b) Import data from PDF to Excel
c) Filter for only unresolved comments in Google Sheets
d) Practice your presentation & get AI feedback on PowerPoint
e) Be on the slides or side by side with presenter mode in Teams

Teams

Microsoft Teams’ updates are fewer this time round but significant, most in the meeting space:

1. Pin & spotlight multiple: Previously only with one, now you can focus on just some (but not all) people using pin (for yourself only), or spotlight (all other participants will see them)

2. Track call quality: Click … Call health to track sending & receiving voice, video & shared screens

3. Auto record: From the 3 dots click “Meeting options” and select “Record automatically”, then all new meetings will save recordings in the recording folder of your OneDrive (if it’s a general call), or the recordings subfolder of a channel (for channel calls) and the call will appear in the meeting chat.

4. Mic sensitivity: Click … Device settings for this new option

5. Choose presenter mode: When you share your screen, get your audience to see your video on top of your content/slides in different ways. Options include just content, overlay on lower right, below & to the right of the content or side by side. For the latter two you can customise a background to appear too. After selecting, a new window screen opens just for you to show how you look, although I personally find it distracting having a duplicate of your screen (which you control) and what they see (view only) so I usually minimise it, sadly you cannot adjust your video’s size like you can in Zoom.

Excel screenshot

6. Chat bubbles: When someone types into the chat, see their text appear in real time, particularly useful during presented content. It can be disabled from the 3 dots menu

7. Message to task: Right click any message → More actions → Create a task which syncs to either Microsoft To Do or Planner

8. Lower all raised hands: A one click method if many people have used the raised hand feature

9. Paging on large gallery: If more than 49 people are present, navigate to another page of videos

10. Search participant list: From participants tab type to search

11. Colour code meetings: Colour code meetings using categories as you can in Outlook

12. Breakout rooms updates: It’s easier to assign participants and reassign them during the sessions or choose a timer, by September they announced non organisers can manage the rooms & preassigning participants.

13. Lock meeting: From participants tab, click the 3 dots then “Lock”

Excel screenshot

14. Annotate shared slides: Available options on the bottom left if you share screen & choose “PowerPoint Live” bottom option

15. Slide translations: If you have shared slides using “PowerPoint live,” attendees can change the language of all text on the slides

16. Present from PowerPoint: Start your screen share from PowerPoint (online or Desktop) from either the “Present in Teams” on top left or on slideshow tab

Core Office Apps

New features are only available to the subscription version e.g., Excel 365. Within that there are a few release cadences with the monthly channel and semi-annual channels being the most common. To see or update your version, click File> Account. The monthly channel should now be on version 2109 (2021 month 09 with 10 coming soon) whilst the semi-annual channel received an update in Aug to version 2102 (all updates until Feb 2021). All updates listed for Excel, PowerPoint, Word, or Outlook relate to the monthly channel unless otherwise stated. Certain updates are for semi-annual subscribers and other updates are mentioned in previous blog posts here and here.

PowerPoint

17. Present to Teams: If your file is saved on OneDrive/SharePoint, you will see a Teams icon on the top right, click this and it will be shared with presenter view in your Teams meeting, Monthly

18. Rehearse with coach: Practice your slides with this feature on the Slideshow tab, and get real time feedback on speaking pace, pitch, whether you read the slides, inclusive language, repeated & filler words etc. When you finish you get a summary report too. Although it’s been on PowerPoint Online for a while, PowerPoint Desktop recently added it. Monthly

Excel screenshot
24. Excel encyclopaedia for companies: Previously only for consumer users, now install the add in by clicking Insert> Get add ins> & search Wolfram. Look up key data across over 100 data types without leaving Excel, using Wolfram linked data types as shown in the video below. Semi-annual
25. Zoom apps: Following the lead of Teams & Slack, you can now use 3rd party apps with Zoom
25. Zoom apps: Following the lead of Teams & Slack, you can now use 3rd party apps with Zoom
Excel screenshot

26. Share to rooms: Share screen to all breakout rooms simultaneously

27. Post meeting survey: Paid zoom accounts can create a multi question survey that pops up when participants leave the meeting (or it ends) then hosts download results as a csv file. Alternatively you can create the form using other tools like Google Forms, or Survey monkey.

28. Focus mode: When a host turns on focus mode, participants cannot see other videos besides their own and the host’s video. Plus shared screens can be set so that only the host sees them.

Excel screenshot

Google meets

29. Meets noise cancellation: Automatic reduction in background noise, now on automatically

30. Co-hosting: Have up to 25 co-hosts per meeting who can do most of what hosts can do

31. New host controls: Mute all, end meeting, limit who shares screen & send chat messages 32. Change background enhancements: Use a video background & replace background from a mobile device

Google Sheets

33. Themes in Sheets & Slides: Choose between a premade colour/font pack or create your own

34. Multi select sheets: Whilst you cannot do edit cells in identical ways across sheets, you can now recolour, hide, or do other sheet level actions to multiple at once

35. Filter comments: Filter the comments pane to show only open comments or only comments for you.

Excel screenshot

Power BI

  1. Shape format improvements: But still not as much flexibility as PowerPoint, Excel etc.
  2. Data bind more properties: You can now data bind more chart aspects, most notably are legend colour, data label colours and axis titles. Note Power BI calls this “conditional formatting” and is accessible when you see the fx button.
  3. New model view: This is now generally available, covered in previous blog posts
  4. New default visuals: Paginated report & Power Automate are now on by default.
  5. Small multiples: This is now generally available, covered in previous blog posts with added sorting enhancements, learn more here
  6. Constant line improvements: X & Y constant lines can now be either a fixed value or a measure (the fx button), plus you can also shade the area either before or after the X axis line, on the analytics pane.
excel screenshot

Forms

42. Forms text formatting: Double click text in Forms to open a format menu with colour, bold, bullets etc.

excel screenshot
That’s it for this quarter but tune in in December for another series of releases.