Microsoft Outlook
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. Multiple Time Zones in Outlook YouTube Video
Microsoft Excel
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. Excel conditional formatting - duplicates are based on cell value, not
Microsoft Teams
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
Microsoft OneDrive
I love Microsoft's OneDrive and I use it all the time - in my work and also with my family. If you're using Microsoft Word, Excel, PowerPoint and any other software that needs storing files you might want backed up, synchronised across devices (and operating systems)
Microsoft Word
Microsoft Word has a new feature for track changes. You can track just your changes. The feature is called **Just Mine** and is on the Review tab under Track Changes. With this new functionality, you can only track your changes ("Just Mine"). This keeps you from forcing others
Microsoft Excel
The **TODAY** function returns the current date and is updated automatically when you open an Excel file. The TODAY function has no arguments. I'll use the TODAY function in an accounting exercise using Accounts Receivable in this blog post and video. You would use the same for Accounts
Microsoft Excel
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 convert text to numbers** The four methods to convert text
Microsoft Excel
In Excel, numbers that are stored as text can cause unexpected results. It is important before you analyze numbers to make sure there are no numbers or values stored as text. This detailed article with a video shows 5 methods for identifying numbers stored as text. **Identify numbers stored as
Microsoft Excel
One of Excel's most popular financial functions is the PMT function. The PMT function will calculate your payments for a loan based on the interest rate, loan amount, and the number of periods. You would use the PMT function to calculate a car or house loan. **PMT function
Microsoft Outlook
Need a great time-saving Outlook tip? Use Outlook calendar meeting templates. Calendar meeting templates are a great way to schedule meetings that occur frequently but do not have a recurring pattern. With templates, you can put in as much detail as you want and never have to retype it. For
Zoom
The Zoom Waiting Room is very popular. You have always been able to customize the waiting room with your logo and a description. Now, with the release of Zoom 5.7.3, you can add a video to your waiting room. **Zoom waiting room - add video** This is a
Microsoft Excel
**Sometimes working in Excel, moving data around, creating worksheets and removing, copy pasting, all that work can lead to huge file sizes, without realizing. I've had a situation like this recently, with an Excel spreadsheet that didn't have a lot of data, but the file size