Professor Excel
wrong, sum, number, average, excel, status, bar

Status Bar Shows a Wrong Result (Sum, Average) – Here Is Why

Excel has a very handy feature: It displays some quick information about the selected cells in the status bar. This might be the sum, average, maximum or minimum value. Unfortunately, in some cases, the shown number seems to be wrong. Here is why!


exchange, rates, excel, currency, currencies, conversion

Currency Conversion in Excel: Tutorial + Free Excel Add-In

In today’s business world, there is hardly any Excel workbook not  using currencies and exchange rates. Example: When I want to know my revenue for the last month – let’s say of my Excel add-ins or books – I receive an Excel file containing data in various currencies. Because I’m located in Germany, I want to convert everything to Euro. That’s when the trouble starts: Which exchange rate do I use for example for converting US Dollar to Euro? And more importantly: Where do I get the currency exchange rate in a convenient and fast way?


bullet, points, excel

Bullet Points in Excel: 6 Easy Methods (+Download)

No matter if you use Microsoft Word, PowerPoint, Outlook or OneNote: You can easily insert bullet points and create bullet point lists. In Excel you can’t. But there are some simple workarounds. In this article, you learn 6 methods for inserting bullet points in Excel. 


Text Import Wizard Gone? How to Import CSV and Text Files in Excel

Microsoft quietly replaced the comfortable Text Import Wizard from Excel and replaced it with the “Get & Transform” tools. The “Get & Transform” tools offer a lot of options and are very powerful. Unfortunately, they are quite complicated to use. Here is what you should now.


lookup, formula, excel

LOOKUP: Everything You Should Know about the Very Unknown Excel Formula

Besides the well-known VLOOKUP formula, there is a similar formula in Excel: LOOKUP. The formula is very unkown and hardly used. But there are good reasons why you should not use the LOOKUP formula. Let’s start with the basics about the formula and then talk about why you should avoid it.


formulas, dictionary, excel, language, languages

Dictionary for Excel Formulas

Microsoft Excel supports many languages. In total, you can use Excel in 107 different languages. Many of these languages also use local formula names. For example, VLOOKUP is called SVERWEIS in German, BUSCARV in Spanish or DÜŞEYARA in Turkish. Fortunately, you don’t need to remember different formula names because Excel automatically translates the formulas to your language. However, in some cases you need to know the local formula term. Please refer to our comprehensive dictionary below.


histogram, histograms, excel, chart

Histograms in Excel: 3 Ways to Create a Histogram Chart (+Download)

A histogram chart is a great way to present your data. It groups your data into bins or classes and shows the number of items per bin. For example: Your data has “Big Mac” prices in different countries. A histogram shows how many countries have a Big Mac price between 1 and 2 USD, 2 and 3 USD and so on. 

This article introduces three methods in Excel how to create a histogram. Please also feel free to download all examples in an Excel file.


custom, number, format, excel

Custom Number Formats: Big Guide, Popular Codes and a Free Download

Excel provides many default number formats. But often, these formats are not enough. For example:

Example: The default and a modifyed number format.

  • You want to display number in thousands or millions?
  • Or have a thousands separator for percentage values?
  • Or show a plus sign for positive values?

In such case, you need to create a custom number format. In this article, you learn everything you need to know. For making it easier for you, please feel free to download the example Excel file or the handy custom format card for printing it out.


thousands, decimal, separator, change, excel, powerpoint, thinkcell

Change Thousands & Decimal Separators in Excel, PowerPoint and ThinkCell

Sometimes you don’t want the comma “,” as a thousands separator, but rather a full stop “.”. Or you don’t want the full stop as the decimal separator. Changing these two separators in Office is easy: You can either do it system-wide or override the system settings.


Passwords in Excel: Everything about Locking and Unlocking Workbooks and Sheets

Excel is one of the most popular applications in the business life. No wonder, that there is lots of sensitive data saved in Excel workbooks and sheets. Excel provides methods to secure this data: By protecting them with passwords. But Excel also offers much more than just using passwords on complete workbooks: You can also protect contents on single sheets, areas on worksheets and single cells. In this article, you’ll learn all this: From protecting entire workbooks to single cells. Even better: You’ll learn how to unprotect them as far as possible.