Microsoft Excel
Need to know when your investment will double? In finance, the rule of 72 is an easy method for determining when an investment will double. Take the number 72 and divide it by the interest rate, which gives you the number of years. For example, a 5,000 investment at
Microsoft Excel
The SUM function is the most popular and widely-used function in Microsoft Excel, along with its automated version: AutoSum. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. In this video, I demonstrate the SUM function and show you a few
Microsoft Excel
The rule of 72 finds the number of years to double your money at a given interest rate. Doing the math in your head is easy. Take 72 and divide by the interest rate. When you divide by the interest rate use the number without decimals. Example: 8% is 8.
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