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 1

Chapter 8

By Jeff Lenning | July 29, 2013 | Comments Off on Chapter 8

Tables

Chapter 12

By Jeff Lenning | July 29, 2013 | Comments Off on Chapter 12

Skinny Row

Chapter 18

By Jeff Lenning | July 29, 2013 | Comments Off on Chapter 18

Selection Groups

Chapter 6

By Jeff Lenning | July 29, 2013 | Comments Off on Chapter 6

Selected Shortcuts

Chapter 17

By Jeff Lenning | July 29, 2013 | Comments Off on Chapter 17

Nested Functions

Chapter 7

By Jeff Lenning | July 29, 2013 | Comments Off on Chapter 7

Named References

Chapter 14

By Jeff Lenning | July 29, 2013 | Comments Off on Chapter 14

Highlight Input Cells

Chapter 13

By Jeff Lenning | July 29, 2013 | Comments Off on Chapter 13

Hide Worksheets

Chapter 9

By Jeff Lenning | July 29, 2013 | Comments Off on Chapter 9

Data Validation

Chapter 10

By Jeff Lenning | July 29, 2013 | Comments Off on Chapter 10

Conditional Formatting

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 CONCATENATE Conditional Formatting Copilot COUNTIFS Data Model Data Types Data Validation Dynamic Arrays EOMONTH FILTER FlashFill Format Get & Transform Hacks Hyperlink IF IFERROR INDEX INDIRECT LET Macro MATCH Named Ranges Named References PivotTable PMT Power Pivot Power Query SEQUENCE Spill SUBTOTAL SUMIFS Tables TEXT TEXTJOIN UNIQUE VLOOKUP WEBSERVICE worksheet protection XLOOKUP

Categories