Microsoft OneDrive
One of my favorite OneDrive features is sharing a folder with Read Only permissions. This allows me to add files and folders so students or co-workers, or even clients can download the files, but they can't delete or edit the files. I can even set an expiration date
Zoom
When you are presenting in Zoom, it is important to have access to the Meeting Control bar. Frequently, it will disappear, and you have to Stop Presenting to get it back. **Zoom Meeting Control Toolbar** Some users have said they have to exit the meeting and join again. That is
Microsoft Excel
Excel has a powerful SORTING engine. SORT is the most popular function in Excel, and it can sort by many types of data, many attributes, and even custom sorting configurations. **Sort data in Excel - 7 tips** In this article and video, I walk you through **7 major SORT feature
Microsoft Teams
Teams will indicate your status. This is very handy if you want to let coworkers and people know when you’re busy, do not want to be disturbed, or are away from your desk. Teams will sometimes automatically set the status. If you are in a meeting, Teams will show
Microsoft Teams
When in a Teams chat, you can view a coworker's LinkedIn account. This is a new feature in Teams rolled out in 2022. LinkedIn tab in Teams Chat Microsoft purchased LinkedIn in 2016. When chatting, LinkedIn is a new tab at the top with Chat, Files, Organization, and
Microsoft Excel
If you need to compare two lists or columns in Microsoft Excel, you can either use Conditional Formatting or you can you an empty column and use Countif function. You can even use both. This is handy when you want to compare 2016 customers to 2017 customers or a list
Microsoft Excel
Have you ever had a printed page of data, and needed to put the data in Excel? Typing the data is a real pain. Excel now allows you to put the data in Excel using **Data from Picture**. Data from Picture Data from Picture is a great feature and is
Zoom
Updated: _July 9, 2022_ \- Managing a zoom meeting can be challenging with a lot of people. With Zoom's **co-host feature**, you can share hosting privileges with other users. A co-host can help manage the waiting room, breakout rooms, chats, and other features. You can have more than
Microsoft Teams
Recorded Meetings in Teams are stored in OneDrive for Work or School. The one exception is Channel Meetings are stored in SharePoint. Teams Meeting Recordings set to expire The recordings expire! Which could be really bad if you are relying on the recording. In this video, I'll cover
Microsoft Excel
Highlighting or shading every other row in Excel is a great way to make your data easier to read. I'll show three methods for applying color to alternate rows. **Share every other row in Excel** Method 1 is my least favorite, but I see users doing this a
Microsoft Excel
Excel's Unpivot Columns, part of Power Query, is an awesome feature. It is the easier way to fix data that isn't in a tabular format. **Power Query - Unpivot columns** You want data in a tabular format so it can be sorted, filtered, and PivotTables created.
Microsoft Outlook
In Outlook we live in our calendar. We have three different types of calendar items - Meetings, Appointments, and Events. When do you use each? Outlook Calendar Meetings vs. Appointments We will look at scheduling meetings, appointments, and all-day events. The main distinction is Appointments are for you and have