Microsoft Tutorials

Excel - Easily Break Up Data using Subtotals and Conditional Formatting

After sorting in Excel, we will look at two great methods for separating blocks of data or showing a clean separator between our groups.

Microsoft Teams - Virtual Appointment - No app required!

Microsoft Teams is rolling out Virtual Appointments. Virtual Appointments make it easy to schedule meetings, and the meeting attendees do not need to install Teams. Even joining from an Android or iPhone, there is no need to install Teams.

Teams Video Call or Meeting - Toggle View - Teams Tip

When you are in a Teams Meeting, or Video call, you can toggle between the shared screen and the presenter. This is a great tip when someone is sharing but then starts a discussion. You want to see the person and not the shared screen.

Outlook - Manage your Inbox using Ignore, Archive, Block, Delete, and Clean Up

Your inbox in Microsoft Outlook can become overwhelming to manage. The average office worker receives around 121 emails every workday. Microsoft Outlook has some easy commands located on the Home tab to help manage your inbox.

Excel - Combine the SORT, UNIQUE, and COUNT functions

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.

Excel Sorting Tips with Chris Menard on January 24, 2023

Chris Menard will be live on YouTube and Linked showing Sorting Tips in Excel on January 24, 2023.

OneDrive sync icons explained

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

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

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!

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.

Microsoft Teams - Collect immediate feedback with an Instant Poll

Teams now allows you to launch an Instant Poll in a meeting. This is a great feature to gather feedback or get the pulse of your audience.

March 16, 2023 - 12 Tips to help you master OneDrive

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.