Excel - Convert Seconds to Minutes and Seconds - Watch Chris Work!
Posted by Chris Menard on 01/14/2023
Frequently we have data in one format but need to convert it to another. Today's example is I have a column on seconds for the length of videos. I want to show minutes and seconds with a colon in between the minutes and seconds.
March 16, 2023 - 12 Tips to help you master OneDrive
Posted by Chris Menard on 01/12/2023
Microsoft OneDrive has tons of benefits. From 1 to 1:45 pm ET on March 16, we will look at versioning, syncing files, working with the sync icons, autosave feature, and co-authoring. OneDrive is integrated with the Microsoft apps. Teams Meetings recordings are stored in OneDrive. We will show how to share meeting recordings, change the expiration date, and view the transcript.
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.
2022 YouTube video published
Posted by Chris Menard on 01/02/2023
In 2022, we published 143 videos on YouTube. They range from Excel, Teams, Word, Outlook, and Zoom.
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.