Microsoft Excel
To compare two text strings in Excel, you can use the EXACT Function, or you can use =A1=B1. The EXACT function checks for case sensitivity. Example "Chris" is not the same as "CHRIS" if you use the EXACT function. With =A1=B1, Chris would appear
Microsoft Excel
The **UNIQUE** function in Excel returns a list of unique values in a list or range. The **SORT** function in Excel sorts the contents of a range or array. The functions are great individually, but I frequently combine them. In the video below, I show Unique and Sort in seven
Microsoft Excel
PivotTables are great for summarizing and analyzing data. **Report Filter Pages** is a great way to generate multiple reports. For example, we have a list of 12 Salespeople and their customer and their orders. We can use Report Filter Pages to create 12 additional reports, one for each rep quickly.
Microsoft Excel
Trying to decide what University or College to attend is a big life decision. Microsoft is helping out with these big life decisions with their Excel **College Decision Helper Template**. The template uses Excel's new linked data types. Type in a college and see data for location, tuition,
Microsoft Excel
Need to quickly access an Excel file or Word document in a Teams Channel? It is easy to add a file as a documents tab in a channel. This is so much easier than trying to find a file. If there is an Excel file you access daily or frequently
Microsoft Outlook
You can easily make a contact group, formerly known as a distribution list, in Outlook by copying and pasting Excel data into Outlook. A Contact Group is handy if you email the same group of people frequently. The group can be your team, a project team, a committee, or even
Microsoft Excel
Year-Over-Year (YOY) growth compares one period, usually a quarter or a month, against the same period twelve months before. You can compare Q3 of 2022 against Q3 of 2021. Another example is comparing the month of November 2022 to November 2021. You can even compare one day to the same
Microsoft Excel
If you need to find out what day of the week is the most profitable or what day of the week do we receive the most support calls, Excel's PivotTables can handle it. PivotTables will group dates automatically. If you have any date field - invoice dates, order
Microsoft Excel
Filtering data in Excel charts is easy to do. The method you use should be based on the amount of data you have. In this video, I show three methods of filtering chart data. Method 1 is using Chart Filters. This is the easiest method. Method 2 is using Filters
Microsoft Excel
I'm frequently asked how to convert decimal hours to Excel's hour and minute format. A couple of examples: 7.75 need to show as 7:45, and 30.25 needs to show as 30:15. The solution is to divide by 24 hours. The formula is
Microsoft Excel
The Outlook desktop client now allows all meetings to be Teams meetings by default. No longer do you have to remember to click the Teams Meeting add-in icon in the ribbon. Another new feature in Outlook is you can now have a Meet Now meeting in Teams. YouTube Video on
Microsoft Excel
Do you need to add or subtract time in Excel? Some time calculations are easy, but depending on how the time is entered, you may need to use the TIME function or formula to add or subtract time. For example, if you have 9am in B2, and in cell C2,