Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Articles
  • Videos
  • Excel Courses

formatting

  • Home
  •   »  
  • formatting
Excel
merge and center text

How to Merge Cells in Excel (with Video)

Merging cells in Excel is easy. 99% of the time this is done for formatting improvements. Below we’ll learn how to

Excel
sum and sumif function

How to Use the SUMIF Function

The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the

Videos
left, right, and mid functions

Learn the LEFT, RIGHT, and MID Functions in Excel

Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings

Excel
top things to know in Excel

Top 5 Things to Know in Excel

I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how

Functions Math Functions
RANDBETWEEN – Excel Function

RANDBETWEEN – Excel Function

What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than

Functions Math Functions
RAND – Excel Function

RAND – Excel Function

What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother

Excel
dates in excel

Dates in Excel – Part 1

Excel is very good when it comes to dealing with dates. To simplify the math on its end, it calculates a date as “the

Excel
paste special

How to use Paste Special in Excel

Paste special is a very good tool to have for a variety of reasons. Let’s cover the most common use cases: Paste Values

Functions 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

Posts navigation

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