## Speed up Excel: Increase Calculation Performance in 17 Easy Steps

Excel is a great tool for performing complex calculations. Unfortunately, the larger an Excel spreadsheet gets, the slower the calculations will be. Depending on the formulas, size of the workbook and the computer, the calculations may take up to 30 minutes. In this article, we take a look at 17 methods to save time and speed… Continue reading Speed up Excel: Increase Calculation Performance in 17 Easy Steps

## IFERROR: How to Handle Error Messages in Excel

When your formula produces an error in Excel – for example #N/A or #VALUE? – you got two options: Solve the error or use it in your calculation. Solving is usually a good idea but not always possible. So, let’s take a look at how to deal with errors in Excel formulas using the IFERROR… Continue reading IFERROR: How to Handle Error Messages in Excel

## SUM in Excel: 8 Simple Ways Of Adding Up Values!

One of the basic applications in Excel is summing up values. The most popular ways of adding up numbers are just using the ‘+’ sign or the formula SUM. But there are many other methods. Do you know about these 6 other ways to sum up values in Excel? In this article we’ll take a… Continue reading SUM in Excel: 8 Simple Ways Of Adding Up Values!

## INDEX and MATCH: Great Alternative to VLOOKUP in Excel!

You’ve probably heard of the VLOOKUP formula in Excel, haven’t you? The VLOOKUP formula searches for a value in a column. Once found it returns another value from the same row. A combination of INDEX and MATCH serves the same purpose. It works slightly different and has therefore some advantages and disadvantages towards VLOOKUP.

Published
Categorized as Formula

## Transpose and Link Data to Source in Excel

When you copy and paste cells in Excel, you can either paste them as links or transpose them. Excel doesn’t allow doing both at the same time. Unfortunately, you often need to link and transpose. But there are three ways for accomplishing this: Doing it manually, using the array formula {=TRANSPOSE()} or Professor Excel Tools.

## Wrong Calculations: Why Does Excel Show Wrong Results & How to Fix It

Excel calculates wrong. Yes, in some cases, Excel will return wrong results. You don’t believe me? Then type the following formula into an empty Excel cell: =1*(0.5-0.4-0.1). The result should be 0. But what does Excel show?  -2,77556E-17. This is just a simple example, but when it comes to larger Excel models it can be quite… Continue reading Wrong Calculations: Why Does Excel Show Wrong Results & How to Fix It

## 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.

## TODAY: How to Insert the TODAY Function in Excel

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 Use Conditional Formatting With Formulas in Excel

One advanced scenario of Conditional Formatting is to use formulas to determine the format. Let’s say, you want to change the background color of cell A if cell B has a certain value.