Microsoft Excel
We frequently need to extract part of a text string in Microsoft Excel. We are going to extract the first part of a text string. Examples of text string parts you would extract include product numbers, employee IDs, and accounting numbers. **Excel Left and Find Function** For example, the product
Microsoft Excel
Excel has three cell references - Relative, Absolute, and Mixed. It is critical to understand when to use each reference in Excel. Excel References - Relative, Absolute, and Mixed The default reference is relative is used frequently in Excel. The next highly used reference is absolute. Finally, we have two
Microsoft 365
Artificial Intelligence (AI) is in all Microsoft 365 apps - Excel, Word, Outlook, PowerPoint, Teams, and other M365 apps. In Excel, we have Analyze data on the Home tab and the ability to get data from a picture or screenshot. Popular Excel Articles Excel Charts - three methods for filtering
Teams
The new Microsoft Teams is coming soon! Teams is getting completely overhauled. The new Teams preview is now available for Windows desktop users. It will come soon to Mac users and Teams on the web. Microsoft Teams came out in 2017. Today, over 280 million people use Teams monthly. Switching
Microsoft Excel
Need to quickly understand your data in Excel and ask questions about your data? Easy to do using Excel's Analyze Data command located on the Home tab in Excel. Analyze Data using Artificial Intelligence (AI). You can type questions, and Excel will return results in a PivotTable format.
Microsoft Excel
After sorting in Excel, we will look at two great methods for separating blocks of data or showing a clean separator between our groups. Break between groups in Excel A group may be departments, states, countries, or cities. We will use the Subtotal command, and Page Breaks between Groups for
Teams
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 Virtual Appointment Examples of who would use Virtual Appointments: insurance
Teams
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. YouTube Video Teams Video Call
Microsoft Outlook
Your inbox in Microsoft Outlook can become overwhelming to manage. Microsoft Outlook has some easy commands located on the Home tab to help manage your inbox.
Microsoft Excel
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. **SORT and UNIQUE
Zoom
Zoom has a great new feature using Polls and Breakout Rooms. Now, when you launch polls, you can create breakout rooms from the poll results! This feature is part of Zoom 5.13.5 released on January 16, 2023. **Zoom Breakout Rooms from Polls** Steps to enable breakout rooms from
Microsoft OneDrive
OneDrive is great for syncing your files. OneDrive syncs your files using a feature it calls **Files On-Demand**. Using Files On-Demand allows you to store your files in OneDrive without storing them on your local drive. With Files On-Demand, your files on your computer could have three possible status icons.