Library: Knowledge Area of Professor Excel

Welcome to the


The Professor Excel knowledge library has more than 200 in-depth Excel articles. In order to find the information for you, please use one of the options below: Search, filter by category or by article label/tag.

Search the library with the search function

Search for any Excel topic, such as “performance of XLOOKUP”.

Filter knowledge articles by label or “tag”

Each Professor Excel article is labeled by one of multiple tags. Tags are like topics: Just click on any tag and explore all related knowledge articles.

Label: Filter the library by labels / tags.

array calculate calculation character column conditional copy data error excel export faq file size filter format formatting formula function hide hlookup index index-match letter Link lookup Macro match name number paste pastespecial pdf pivot pivottable row sum sumifs symbol text tools VBA vlookup worksheet worksheets XLOOKUP

Show articles by category

Every article I publish is categorized by one (or at most) two categories. Just click on a category name to see all the articles in this particular category.

New to the library: Take a look at the most recent articles

The following list has all the recent articles.

Do you want to stay up-to-date?

Boost your Excel skills in a very convenient way: Subscribe to the Professor Excel newsletter and receive one e-mail per month with 3-4 tutorials, tips and tricks. Of course it’s free. And maybe worth mentioning: I hate spam very much. That’s why I would never send you any spam e-mail.

Even better: You get my welcome gift. The Big Keyboard Shortcuts package.

Learn more about the newsletter here.

Boost your Excel skills!Join thousands of Excel users & subscribe to the newsletter!
  • The best Excel tips, tricks and tutorials.
  • 1x per month.
  • No spam. Promised.

Welcome gift: Save a lot of time with my huge keyboard shortcut package.

Learn more

Or explore all articles

If you want to see all articles, please refer to this page.

Image by Pexels from Pixabay

Image by OpenClipart-Vectors from Pixabay