Microsoft Office Blog by Chris Menard

How to use the SUM Function and AUTOSUM in Microsoft Excel | Tutorial for Absolute Beginners

The SUM function is the most popular and widely-used function in Microsoft Excel, along with its automated version: AutoSum. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

Zoom Vanishing Pen Annotation | Draw on Screen during meetings or webinars while sharing. Zoom 5.6.3

You can annotate your screen sharing, window sharing or webinars in Zoom by using a 'vanishing pen annotation'. Zoom had annotation features before, but in this update for Zoom version 5.6.3 you can draw anywhere on screen and in a few seconds that annotation disappears automatically.

Outlook - End meetings early or start late - NEW feature 2021

If you're using Outlook for Microsoft 365, you can now have Outlook end your meetings a few minutes early or start late. I prefer to end early, but it's up to you. This can help you build in travel time between meetings.

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.

Use Tab Groups in Google Chrome to stay organized

Do you use Google Chrome and have too many tabs open? The solution is to use Tab Groups. Tab groups in Chrome help you organize your tabs. You can use tab groups to groups tabs, name the tab group, and even add color to the group to make it easy to find.

5 things to do before closing your Simple Bank Account

Simple Bank is being taken over by BBVA USA. Here are some things you may want to check if you are closing your account with Simple Bank.

Simple Bank to BBVA USA - Essential dates you need to know

Simple Bank is moving to BBVA USA. Here are some dates you need to know. May 4, 2021 - Support messages: You'll no longer be able to send a new support message through your Simple app.

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.