Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • 150 Keyboard Shortcuts
  • Contact

formatting

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

AVERAGE – Excel Function

The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be

Excel Functions Excel Math Functions
SMALL – Excel Function

SMALL – Excel Function

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

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?

Posts navigation

« 1 2 3 … 8 »
  • Articles
  • Excel Training Videos
  • Books on Excel & Data
  • 150 Keyboard Shortcuts in Excel (Windows)
  • 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