Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • Contact

formatting

  • Home
  •   »  
  • formatting
Excel Functions Excel Math Functions
LARGE – Excel Function

LARGE – Excel Function

What it does: The LARGE() Function provides the n-th largest piece of data from an array. Plain English: The LARGE() Function

Excel Functions Excel Math Functions
COUNTIFS – Excel Function

COUNTIFS – Excel Function

What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria. Plain English:

Excel
Autofill in Excel

Using AUTOFILL in Excel – Part 2

(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste

Excel
Autofill in Excel

Using AUTOFILL in Excel – Part 1

The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the

Excel
Using iferror in Excel

Using IFERROR to trap and handle errors

When I first found out about IFERROR, I was a little confused. “There’s a formula to use if we generate an error?

Excel
count functions in excel

How to Use Excel’s COUNT Functions

There are many functions in Excel that contain “count” in the name. What are the differences? In this blog post

Excel
text to columns

Text to Columns – Excel

Text to Columns is a very fun feature of Excel. This feature will help you break apart cells that have information that

Excel
text - len, right, left, mid

Manipulating Text in Excel – LEN, RIGHT, LEFT, & MID

There are many times in Excel when you only need to extrapolate or evaluate PART of a cell. For this, the following functions

Excel
if function in Excel

The IF Function in Excel & Boolean Logic

If new to Excel and building formulas, there’s a concept I think is very important to understand before learning to

Posts navigation

« 1 2 3 … 6 »
  • Articles
  • Excel Training Videos
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Excel Text Functions
    • Excel Math Functions
    • Excel Logical Functions
    • Excel Lookup and Reference Functions
Copyright ©2023 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com