Microsoft Excel
The LARGE function in Excel returns the k-th largest value in a data set. For example, you can use LARGE to return the customer with the highest revenue, 2nd highest revenue, third-highest revenue, and so on. Another example is to use the LARGE function to see the highest
Microsoft Excel
**If adding events to your Google Calendar is tedious or you have many events you need to add quickly, you can use a CSV file you can generate in Microsoft Excel, to populate your calendar quickly and easily. Read below to find out how to do it, what fields are
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
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