Excel - Combine the SORT, UNIQUE, and COUNT functions
Posted on 01/27/2023
Excel has dynamic array functions. Two of the dynamic array function are SORT and UNIQUE. I will combine SORT and UNIQUE and also combine them with COUNT and the COUNTA functions. This came from a user that asked how many unique zip codes were in a spreadsheet.
OneDrive sync icons explained
Posted by Chris Menard on 01/22/2023
OneDrive is great for syncing your files. OneDrive has a great feature called Files on Demand. Your files on your computer could have three possible status icons with Files on Demand running.
Teams - How to Manage Files and Folders in a Channel
Posted by Chris Menard on 01/20/2023
Microsoft Teams Channels is a great way to communicate and collaborate. I love group chat also, but one HUGE advantage a Team has over a group chat is the ability to manage files and folders.
Excel Import Data from the Web
Posted by Chris Menard on 01/18/2023
Excel allows you to pull data on a webpage into Excel. This is a great time-saving feature. Getting data from a webpage is done in Excel on the Data Tab using Get and Transform Data group, From Web command.
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.