Professor Excel
countifs, excel, countif

COUNTIFS in Excel: Everything You Need to Know

The COUNTIFS function works similar like the SUMIFS function. But instead of adding up the values, it counts how many items with one or more criteria are in your table.

hlookup, excel, eagle, look, search, lookup, vlookup

HLOOKUP in Excel: Everything you need to know

You’ve probably heard of VLOOKUP which is a very popular and powerful formula in Excel. Far less known is the little brother: HLOOKUP. It basically works the same way as VLOOKUP with one difference: Instead of looking up values vertically, HLOOKUP works horizontally. In this article, you learn how to use HLOOKUP, what to keep in mind, possible error messages and some more advices about HLOOKUP.  […]

vlookup, hlookup, lookup, excel, how, guide

VLOOKUP in Excel: All You Need to Know About the Powerful Formula

One of the most popular formulas in Excel is the VLOOKUP formula. Many lookup approaches are based on the VLOOKUP formula. Mastering it is crucial for any of the following chapters and methods. Unfortunately, VLOOKUP is not as easy to use as a SUM or COUNT. In this article, you learn how to use VLOOKUP, what to keep in mind and some more advices about VLOOKUP.
[…]

calculation, options, calculate, manual, automatic, excel, thumbnail

Calculation Options in Excel: Decide When and What to Calculate

Does this sound familiar to you: Excel takes too much time calculating. Instead of instantly showing the results, you have to wait for several seconds or even minutes for Excel to finish up the calculation. The problem: The larger your Excel model gets, the more you get frustrated by the lack of performance.

[…]

sumifs, excel, tutorial

SUMIFS in Excel: Everything You Need to Know (+Download)

The SUMIFS formula adds up all numbers, when one or more than one criterion is fulfilled. SUMIFS only exists since Excel 2007 and is especially useful, as it can regard several search criteria.

minif, maxif, minifs, maxifs, formula, excel

MINIF & MAXIF: 5 Ways to Get a Conditional Minimum Value

Until Excel 2016, there is no built-in MINIF-Formula in Excel. There are COUNTIF, SUMIF, AVERAGEIF but no MINIF nor MAXIF before the latest version. However, there are situations in which you need to get the minimum under a condition. In the following post, we are going to illustrate how to return the minimum using a simple example. We got an Excel table with two columns “Car type” and “Price”. We want to know the minimum price for each car type. Sounds easy? Unfortunately, Excel makes it unnecessarily difficult to calculate.
[…]

now, formula, function, excel

NOW: Learn the Secrets of the Simple NOW() Formula in Excel

The NOW formula returns the current date and time. It can be applied easily by just typing =NOW()

How to Use the OFFSET Formula

The OFFSET formula is a very powerful, but unfortunately not easy to understand formula. It basically refers to another cell or cell range. You specify a starting point (“Reference”) from which you count rows and columns. If the starting point is cell A1 and you tell Excel to count 2 cells to the right and 3 down, it’ll return the reference to cell.

How to Use the TODAY Function

You want to display today’s date? Or you want to check, if a date written in a cell is today? There is an easy formula: =TODAY()

How to Get the Week Number in Excel

You might want to use numbers of weeks especially when you create timelines, schedules or calendars. The formula is called WEEKNUM().