Microsoft Tutorials

Excel - Data from Picture - Microsoft 365 New Feature

Have you ever had a printed page and needed to put the data in Excel? Typing the data in can be a pain. Excel now allows you to put the data in Excel using Data from Picture.

Teams - 5 Tips for Recorded Meetings

Recorded Meetings in Teams are stored in OneDrive for Work or School. The one exception is Channel Meetings are stored in SharePoint.

Excel - 3 Methods to Shade Every Other Row

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.

Excel - Get and Transform Data | Unpivot Columns with Two Header Rows

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.

Outlook Calendar - Meetings vs. Appointments

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 Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver

Outlook Contact Groups, formerly called Distribution List, are great for saving time. Instead of typing in 20 emails, just type in the name of the Contact Group.

Word - Five Tips for Working with Heading Styles

Styles in Word are one of the best features in Microsoft Word. In this video, I give five tips for working with Styles.

PowerPoint Edit Speaker Notes While in SLIDE SHOW

PowerPoint for Microsoft 365 allows you to edit your Speaker Notes while in PowerPoint Slide Show. Start your presentation and in Presenter View, you can edit your speaker notes.

Teams - 3 Simple Features You May Not Be Using in Microsoft Teams

Time Zones are now displayed in Teams. You can see if a coworker is hours ahead of you or behind you by moving your mouse over their Profile card.

Excel Conditional Formatting with the TODAY function | Duplicate Rule

The TODAY function is one of my favorite Date & Time functions in Excel. It returns the current date and will automatically update. We will use the TODAY function with Conditional Formatting and create three rules on a date field.

Teams - Why You Should Always NAME Your Meetings

Microsoft Teams - ALWAYS name your meetings. I'll review the two meeting types in Teams, how to record your meetings, and why you should always name your Meet Now meetings. Your Meet Now meetings do not show on the calendar.

Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work

Accountants use Excel all the time. In this video, which is great for Accounting students, we look at the Accounts Receivable (AR) or Accounts Payable (AP) exercise.