TOP 5 Excel Features Released in 2022
Posted by Chris Menard on 01/12/2023
Microsoft keeps rolling out awesome new features for M365 users. Many of the new features hit Excel in 2022. This video covers my top five favorite features in Excel from 2022.
Teams - Delete an Entire Chat
Posted by Chris Menard on 11/29/2022
Teams Delete Entire Chat is available! You will be able to delete the entire chat for a one-on-one chat or group chat.
Excel - Turn on Multiple Filters in a PivotTable
Posted on 11/21/2022
Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on the PivotTable Option - Totals and Filters tab and check Allow multiple filters per field.
PivotTables - 3 Annoying Things FIXED!
Posted by Chris Menard on 11/16/2022
PivotTables are one of the best features in Excel. PivotTables allow you to summarize, analyze and chart complex data. There are 3 annoying things in PivotTables that users always ask me about.
Excel Chart Maps used with the Geography Data Type
Posted by Chris Menard on 11/13/2022
Combine the Geography Data type with a Chart Map. The Geography Data type is located on the Data tab, and Chart Map is on the Insert tab with the other chart types.
Excel Images - Two New Features - IMAGE function and Data from Image
Posted by Chris Menard on 10/28/2022
Excel has two new image-related features coming out. In this video, a preview of my teaching session at ASAP (American Society of Administrative Professionals) Virtual Event in November, I walk you through these two new Excel functions.
Teams Meetings - Captions in your preferred language
Posted by Chris Menard on 10/20/2022
Teams Meetings allows live translated captions in the language you are most comfortable with. By default, live captions are displayed in the language that’s spoken during the meeting, but you can change the language of the captions.