Microsoft Tutorials

Excel compare two or more text strings

To compare two text strings in Excel, you can use the EXACT Function or you can use =A1=B1. The EXACT function checks for case sensitivity. Example "Chris" is not the same as "CHRIS" if you use the EXACT function. With =A1=B1, Chris would appear as the same.

Presenter Coach in PowerPoint - Rehearse your slide show

Microsoft PowerPoint includes a great feature or presentation coach that allows you to rehearse your presentation using the automated 'Rehearse with Coach' functionality.

Excel: Combining Unique and Sort functions

The UNIQUE function in Excel is one of my favorite functions. Unique returns a list of unique values in a range. The SORT function in Excel sorts the contents of a range or array.

Share Outlook email to Teams - New Feature April 2021

From Outlook or Outlook on the web, you can send emails to Team chats and Team channels. Does the email contain attachments? You have the option to share the attachments. This is a great update.

Excel Report Filters: Tips of creating multiple reports from one PivotTable

PivotTables are great for summarizing and analyzing data. Report Filters is a great way to generate multiple reports.

Export Word to PowerPoint with a few clicks - New Feature from Microsoft

Microsoft has a new feature where you can EXPORT your Word document into PowerPoint. It is three clicks. Click File - click Export - select Export to PowerPoint presentation. It is in preview mode right now, but it worked great in all my test. Exporting Word into PowerPoint is a huge timesaver.

Teams - How to Add an Excel file or Word Doc to a Teams Channel Tab

Need to quickly access an Excel file or Word document in a Teams Channel? It is easy to add a file as a documents tab in a channel. Before making the document tab, the file must exist in the channel. If you click Files Tab and see the file, you can make it a Tab.

How To Create An Outlook Contact Group (Distribution List) From Excel Data?

You can easily make a contact group, formerly known as a distribution list, in Outlook by copying and pasting Excel data into Outlook.

Microsoft Teams: March 2021 Update: New features, New look

6 new features and improvements in Microsoft Teams update from March 2021 to do with meetings, calendar, Outlook, navigation and more.

PowerPoint Presentations in a Teams Meeting: Improvements and New Features

Several great improvements for PowerPoint presentations during a Teams meeting: speaker switch, high-contrast view, speaker notes and more.

Microsoft Outlook on the Web - the FILE view feature is incredible!

Microsoft has a “File” view in Outlook on the Web, that makes it easy to find any document and photos.

Year-Over-Year Growth - Excel PivotTable

Year-Over-Year (YOY) growth compares one period, usually a quarter or a month, against the same period twelve months before. You can compare Q3 of 2021 against Q3 of 2020. Another example is comparing the month of September 2021 to September 2020.