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.
array autorecover autosave calculate calculation column conditional copy data error excel export faq format formatting formula function hide hlookup index Link lookup Macro match name number pastespecial pdf performance pivot pivottable row select share sheets speed up sumifs sumproduct 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.
- How to See an Excel File in Two Windows Side by SideThis is a real time-saver: You can see the same Excel file side by side in two windows. Of course, this works also for different Excel files. And the best: It does not only work for Microsoft Excel, but for all other Office programs, such as PowerPoint, Word or Outlook. Here is how to do… Continue reading How to See an Excel File in Two Windows Side by Side
- Excel Facts: The Most Interesting Facts for Every Excel User!Microsoft Excel is one of the most used software products in the business world. It’s extremely flexible and seems to have a solution to every problem. With more than 1.2 billion users (see Excel fact #4 below), a loooot of people have at least heard of it. So, I have written more than 200 articles… Continue reading Excel Facts: The Most Interesting Facts for Every Excel User!
- How to Prevent Users to Restore PivotTable Source DataIn a “normal” PivotTable (without changing any of the default settings), other Excel users can easily restore the source data. Also, when you copy and paste the PivotTable into a new Excel file without the data. But what, if you want to prevent other users to see all the data? Here is how to do… Continue reading How to Prevent Users to Restore PivotTable Source Data
- How to Restore All Raw Source Data From PivotTableYou have received an Excel file with a PivotTable in it. Unfortunately, the file does not have the raw source data of the PivotTable. Or has it? Here are the steps for easily restoring the raw source data of the PivotTable.
- How to Insert Week Number & Deal With Different Week SystemsYou might want to use numbers of weeks especially when you create timelines, schedules or calendars. The formula is called WEEKNUM().
- Excel Functions: What is new? Can I use this function?When I create Excel files for my clients, one of my first questions is “Which Excel version do you use?”. The reason for this question is that I want to know which formulas and functions of Excel I can use and will work on my clients computer. For example: Can I use the more special… Continue reading Excel Functions: What is new? Can I use this function?
- Compare Sheets: How to See Differences of Two Excel SheetsYou have sent an Excel sheet to a co-worker for revision and received it back. The problem: You don’t know what has changed. Here is how to compare two Excel sheets.
- XLOOKUP, VLOOKUP or INDEX/MATCH? Big Lookup Functions Guide!One of the most often used functions when creating an Excel model is consolidating data from different sources. Traditionally, there were 3 major functions for combining data from different tables or worksheets: VLOOKUP, SUMIFS and INDEX/MATCH. Now, Microsoft has introduced XLOOKUP. So what is the difference between these four lookup functions and which one should… Continue reading XLOOKUP, VLOOKUP or INDEX/MATCH? Big Lookup Functions Guide!
- How to Format Excel Cells Perfectly With One ClickDoes this sound familiar? You work on an Excel sheet and are almost done with it. Now, you just want to “brush it up” a bit. But: It seems that the formatting takes even longer than working on the calculations. In this article we look at techniques to apply a format with as few clicks… Continue reading How to Format Excel Cells Perfectly With One Click
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.
- The best Excel tips, tricks and tutorials.
- 1x per month.
- No spam. Promised.
Or explore all articles
If you want to see all articles, please refer to this page.