March 24, 2022 - FREE Excel Webinar for Administrative Professionals

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.

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.

Excel Recommend PivotTables - Improved Experience

Recommended PivotTables in Excel is getting a great update. To use Recommended PivotTables, click the Insert Tab, and click Recommended PivotTables.

Excel PivotTable - Calculate the number of days of each week for every month of the year

If you want to calculate how many days are in each month for a year, it is easy to do with a PivotTable in Excel. I want to know how Sundays through Saturdays there are for each month of the year.

Analyze Results from Microsoft FORMS POLLS in Excel | Watch Chris Work

I recently spoke at the Administrative Professional Day Conference hosted by the University of Georgia. After reviewing my survey results in Microsoft Forms, I realized I needed to analyze the survey data. Forms results are immediately available in Excel.

Excel AVERAGE excluding the highest and lowest values | TRIMMEAN Function

When you have a range of numbers in Excel and want to figure out the AVERAGE but you have some extreme values that can skew your averages, there is a function that helps solve that problem.

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.

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.

Teams - How do I Delete Chat Files?

In Teams, it is easy to add files in a chat. In a chat, you click the paperclip for attaching files, select your files, and click Send. The files show up in the Files tab. The question I was asked is "How do I delete files?"

Saving Chats and Conversations in Microsoft Teams | 5 TIPS

Saving chats and channel conversations in Microsoft Teams helps you reference old discussions, go back to questions or things you want to remember from your conversations with your colleagues.