Outlook - 7 Calendar Tips Every User Should Know
Posted by Chris Menard on 09/07/2021
We spend a lot of time in our Outlook calendar. With these calendar tips and tricks, you'll learn how to use your calendar efficiently. I'll demonstrate to you how I use my Outlook desktop calendar to be more productive.
Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting
Posted by Chris Menard on 09/05/2021
Microsoft Excel can find duplicates easily with Conditional Formatting. The issue is Conditional Formatting finds duplicates based on the cell value, but I want to find duplicate rows. I use three methods in the video to find duplicate rows. I start off with CONCATENATE, then use the TEXTJOIN function, and finally COUNTIFS with no helper column. To highlight the rows I use Conditional Formatting using a formula.
Teams - Why can't I record? Video call vs. meeting
Posted by Chris Menard on 09/04/2021
Microsoft Teams allows you to easily record meetings. I'm frequently asked, "Why can't I record?" or "Why is recording disabled?" The answer is that you are doing a video call. Most likely, you were chatting with one person (1-on-1 chat) or doing a group chat. A video call looks similar to a meeting, but it is a call, so the recording feature is disabled.
How to use the TODAY function in Excel
Posted by Chris Menard on 08/26/2021
The TODAY function returns the current date and is updated automatically when you open an Excel file. The TODAY function has no arguments. In this video, I'll use the TODAY function in an accounting exercise using Accounts Receivable. You would use the same for Accounts Payable.
Excel Convert Text to Numbers - Four easy methods
Posted by Chris Menard on 08/24/2021
Need to convert text to numbers in Excel? I'll demonstrate four methods in the easy-to-follow article and video. If you need to analyze data in Excel, numbers frequently come in as text and need to be converted.
Excel - 5 easy ways to identify numbers stored as text
Posted by Chris Menard on 08/18/2021
In Excel, numbers that are stored as text can cause unexpected results. It is important before you analyze numbers to make sure there are not stored as text. In this video, I'll demonstrate five methods to quickly find numbers stored as text. Numbers as text usually happens when you pull data from another data source into Excel.
Outlook Calendar Meeting Template
Posted by Chris Menard on 08/08/2021
Need a great time saving Outlook tip? Use Outlook calendar meeting templates. Calendar meeting templates are a great way to schedule meeting that happen frequently, but do not have a recurring pattern.