Microsoft Office Blog by Chris Menard

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.

Teams - Record a Video Clip in Chat

Teams allows you to "Record a video clip" in Chat. This is possible for one-on-one chats and group chats.

Excel Image Function

The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images.

Using Meeting CO-ORGANIZERS in Microsoft Teams Meetings

Using Meeting CO-ORGANIZERS in Microsoft Teams Meetings

Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row.

Conditional Formatting in Excel allows you to highlight every 2nd, 3rd, 4th, or 5th row. Writing a formula using the MOD function and ROW function together allows us to do this.

Excel - Share a PivotTable without the Source Data or Underlying Data

When you share a PivotTable in Excel, even if you delete the data source worksheet, the data source is still attached to the PivotTable.

Excel - How to find the Greater Common Divisor (GCD Function) and show as Ratios

The GCD Function in Excel finds the Greatest Common Divisor. We will use GCD to show Ratios in Excel.

Liquidity Ratio using Excel

Liquidity ratios determine how quickly a company can covert assets to use them to pay short-term obligations.

Excel COUNTIF Function With Wildcard Search and Cell Reference

The COUNTIF function in Excel allows you to only count the number of cells that meet certain criteria. For example, the number of cells that the HR department appears in. With COUNTIF, you can do a wildcard search by using * (asterisk).

OneDrive - Share a Folder as Read Only | Set Expiration Date and Password

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 and add a password.

Zoom Always Show Meeting Controls - Awesome Tip for Presenters

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.

Excel Status Bar - Tips Every User Should Know

The Status Bar in Excel is the area at the bottom of the windows that shows your zoom control in the right corner and Ready in the left corner.