Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

Volume 2

Chapter 26

By Jeff Lenning | August 14, 2013 | Comments Off on Chapter 26

Concepts Applied

Read More

Chapter 25

By Jeff Lenning | August 14, 2013 | Comments Off on Chapter 25

Improve Error Check with Boolean Values and the AND Function

Read More

Chapter 24

By Jeff Lenning | August 14, 2013 | Comments Off on Chapter 24

Data Validation and Reporting

Read More

Chapter 23

By Jeff Lenning | August 14, 2013 | Comments Off on Chapter 23

Mapping Tables

Read More

Chapter 22

By Jeff Lenning | August 14, 2013 | Comments Off on Chapter 22

Horizontal Reports

Read More

Chapter 21

By Jeff Lenning | August 14, 2013 | Comments Off on Chapter 21

Dynamic Headers

Read More

Chapter 20

By Jeff Lenning | August 14, 2013 | Comments Off on Chapter 20

Improve SUMIFS with CONCATENATE

Read More

Chapter 19

By Jeff Lenning | August 14, 2013 | Comments Off on Chapter 19

Concatenation Basics

Read More

Chapter 18

By Jeff Lenning | August 14, 2013 | Comments Off on Chapter 18

Build Your Own Date with DATE

Read More

Chapter 17

By Jeff Lenning | August 14, 2013 | Comments Off on Chapter 17

Date Parts – MONTH and YEAR

Read More