## Rounding Functions

In this tutorial I will show how to use the `ROUND`, `ROUNDUP` and `ROUNDDOWN` functions in Excel.  … continue reading »

## Statistical Funtions

In this tutorial I will show you how to use some of Excel’s very useful statistical functions. If you’re doing any data analysis work for your job, I’m sure you’re going to use these a lot.

## How to use Financial functions in Excel

In this tutorial I will show you how to use some very useful financial functions in Excel by walking you through an example about a mortgage.

## Text Functions

Excel offers many text functions that are super helpful if you need to edit or make additions to your text strings. In this tutorial I’ll teach you how to use them. … continue reading »

## Date and Time functions

In this tutorial I will show you the different things you can do with Excel’s Date & Time function. … continue reading »

## Logical functions in Excel: IF, AND and OR

In this tutorial I will show you how to use the Excel Logical functions such as IF, AND and OR. They are super useful if you need to calculate some values based on some logical criteria.

For example you only want a field to show you a number when another field is bigger than a specific value. In the following I’ll teach you how to do this:

## SUM, COUNT & AVERAGE functions in Excel

Two of the most frequently used tools in Excel are the `Count` and `Sum` functions. These functions let you count and sum cells based on one or multiple different criteria.

## Formula Errors

In this tutorial I will show you how to identify and fix some of the frequently recurring formula errors in Excel.