Library: Knowledge Area of Professor Excel

Welcome to the

LIBRARY

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

Ad

Build an App from Excel

Have you ever built an app based on Excel?

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.

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