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 16

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

Determine the Last Day of the Month with EOMONTH

Read More

Chapter 15

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

Perform Lookups with SUMIFS

Read More

Chapter 14

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

Indentation

Read More

Chapter 13

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

Multicolumn List Comparisons with COUNTIFS

Read More

Chapter 12

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

The ISERROR Function

Read More

Chapter 11

By Jeff Lenning | August 8, 2013 | Comments Off on Chapter 11

List Comparisons

Read More

Chapter 10

By Jeff Lenning | August 8, 2013 | Comments Off on Chapter 10

The IF Function

Read More

Chapter 9

By Jeff Lenning | August 8, 2013 | Comments Off on Chapter 9

Trap Errors with IFERROR

Read More

Chapter 8

By Jeff Lenning | August 8, 2013 | Comments Off on Chapter 8

Moving Beyond VLOOKUP with INDEX

Read More

Chapter 7

By Jeff Lenning | August 8, 2013 | Comments Off on Chapter 7

Improve VLOOKUP with TEXT and VALUE

Read More
Training Programs
Free Resources

Learn by Email

Subscribe to Blog (free)
!
!
Subscribe
Something went wrong. Please check your entries and try again.

Topics

Battle Breakout Chart ChatGPT CHOOSE Comparison Formulas CONCAT CONCATENATE Conditional Formatting COUNTIFS Data Model Data Validation Dynamic Arrays EOMONTH FILTER Filters FlashFill Format Get & Transform Hacks Hyperlink IFERROR INDEX INDIRECT Macro MATCH Named Ranges Named References Names PivotTable Power Pivot Power Query SEQUENCE Sort Spill SUBTOTAL SUMIFS Tables TEXT TEXTJOIN UNIQUE VLOOKUP VSTACK worksheet protection XLOOKUP

Categories