Excel Formatting Essentials: Hiding Extra Rows & Columns
Today’s Excel blog post comes directly from a Learn Excel Now customer who was having trouble formatting her spreadsheet. She wanted to hide the extra…
Excel 2013
Essential Excel Skills: Protecting an Excel Worksheet
There are various skills everyone should learn in Excel. One of those skills is protecting an Excel worksheet. Excel allows you to add protection to…
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 2 – Intro to Simple IF Function
In Part 2 (get Part 1 Here) of our IF Statement series, we are discussing simple IF statements. These are the basic formulas for returning…
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…
How to Calculate a Subtotal In Excel Using the Filter
Excel has many ways to calculate data. If you know the right formulas and functions, you can find out just about anything you want to…
Sorting and Filtering Data With Excel
There are many built-in Excel tools to help with data management and the sorting and filtering features are among the best. The filter tool gives…
Essential Excel Functions: How to Use CONCATENATE
Excel possess many formulas and functions to help you perform essential tasks. The CONCATENATE function is one of most useful. It allows you to combine…
The Excel Fill Handle: How to Quickly Add Data
The Excel fill handle is one of the most convenient tools available to enter data quickly and easily. Using the fill handle, you can enter…
Removing Duplicates in Excel: Quick How-to Guide
This Excel tip from Learn Excel Now is on removing duplicates in Excel. The request is directly from a Learn Excel Now fan who asked…