Creating Basic Formulas Part 1: Addition and Subtraction
Excel can be intimidating for people who have just been introduced to the program, but basic mathematical functions are relatively easy through Excel when you…
Formulas & Functions
Excel Pivot Tables: Using Slicers to Filter Data
Are you looking for a way to filter your Excel pivot tables quickly? If so, then you need to learn about slicers! Slicers are a…
Excel UNIQUE Function: Explained in 4 Minutes
The Excel UNIQUE function returns a list of unique values in a list or range. Note: This function is currently available only to Microsoft 365…
Excel Date Calculations Part 2: Setting Sequential Dates
Excel offers a variety of ways to perform date calculations. In part 1 of this series, we showed you how to find the difference between…
Excel Rank Function: What is It & How to Use It
One of Excel’s advanced functions is the RANK function. This formula is used to rank numbers in a dataset by either ascending or descending order.…
How to Use the Excel MEDIAN Function
In this week’s Excel tip, we cover how to use the Excel MEDIAN function. The MEDIAN function is used the return the median value within…
Excel Formulas: How to Use the LEFT and RIGHT Functions
This demonstration covers how to use the LEFT and Right Functions in Excel. These are text functions. In the LEFT function, you can pull a…
How to Show Formulas in Excel
In this week’s blog post, we cover how to show formulas in Excel. This convenient feature is ideal for identifying which cells contain formulas and…
Excel Formulas: Using Trace Dependents to Find Data Solutions
In last week’s post, we covered how to use Trace Precedents to find and resolve formula errors. In this week’s follow up, we cover how…
Excel Formulas: Using Trace Precedents to Find & Resolve Errors
The power of Excel comes from the ability to do complicated calculations using formulas and functions. Sometimes, though, there are errors in formulas that give…