Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

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

excel dashboards

  • Home
  •   »  
  • excel dashboards
Excel
dates in excel

Find the Difference Between Two DateTimes in Excel

Excel is very good when it comes to dealing with dates and datetimes. In this post we’ll look specifically at finding

Excel Training Videos
what is a pivot table

Pivot Tables (Video)

A pivot table is a feature of Microsoft Excel that allows a user to quickly summarize and analyze a large set of data.

Excel Training Videos
3 tips for better pivot tables

Tips for Better Pivot Tables with a Large Data Set (Video)

In this tutorial we discuss creating a pivot table for a data set containing 3,000 rows. We cover which values should go in

Excel Training Videos
combo chart in Excel

How to Make a Combo Chart in 2 Minutes

In this short tutorial we’ll learn how to quickly make a combo chart in Excel to better visualize data coming to a

Excel Training 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 Training Videos
tables to refresh pivot tables

Improve Your Pivot Table Workflow in Excel

In this quick video we take a look at how to improve your workflow around Pivot Tables in Excel. One of the best ways to

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

Posts navigation

1 2 »
  • 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