Creating Basic Formulas Part 2: Multiplication
Addition, subtraction, multiplication, and division are essential mathematical functions that can be made easy by using Excel formulas. In Part 1 of this series, we covered…
formulas
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…
Excel Basics: How To Separate Text Into Columns
Do you have a list of data that you need to separate into columns in Excel? Maybe you have an address list with the city,…
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…
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…
Excel IF Statements Part 3 – Nested IF Statements
In this week’s IF statement series, we are covering Nested IF Statements. This convenient formula allows you to return values based on multiple logic tests…
Excel IF Statements Part 1 – Intro to CountIF
IF Statements in Excel are some of the most useful functions you can use. There are a variety of IF functions and each one can…
Excel Formula Tricks: Absolute Reference
Using Excel to its fullest potential requires knowing how to use formulas. Knowing the different formulas is a great start, but there are tips and…