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 2013
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 Essentials: Running Spell Check in Excel
Excel offers many built-in tools to help you perfect your spreadsheets. Some of these tools, however, need to be activated rather than running automatically. Today,…
Excel Essentials: Adding Images to a Spreadsheet
Excel has many tools to help you master the look and feel of your spreadsheet. One feature it offers is the ability to add images…
Excel MAX and MIN Functions: Essential Tips for Success
There are far too many Excel functions for one person to learn, but there are essential functions every user should know. The MAX and MIN…
Excel Functions: What is the MID Function & How to Use It
Excel offers a variety of different formulas and functions for everyday use. This week, we will focus on the MID function. This function allows you…
Excel Find & Replace: Building Fundamental Skills
Excel contains tons of built-in tools designed to help you do what you need to. This week we are talking about one of those tools,…
Excel Basics: Adding, Editing & Formatting Comments
In Excel, you can add a comment to any cell. This could be a note to yourself, a reminder, a correction, a question – anything…