Rounding Functions

Rounding a number to two decimal places

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

Statistical Funtions

Using the MEDIAN function in Excel

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.

continue reading »

Financial Functions

Using the PMT function in Excel

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.

continue reading »

Text Functions

Joining Strings in Excel

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

Entering Date and Time into Excel

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

How to compare two columns to find duplicates in Excel

In this tutorial I will show you how to compare two columns in Excel so that the values that appear in both columns become highlighted and you can do something with those duplicate values. … continue reading »

How to find differences in a row or column in Excel

Highlight the range of cells with data that needs to be processed

Have you ever had to find the cell whose value did not match those of other cells in the same row? … continue reading »

Logical functions in Excel: IF, AND and OR

Example of an Excel IF Function

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:

continue reading »

SUM, COUNT & AVERAGE functions in Excel

Using the COUNT function 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.

continue reading »

Excel Templates

Select New after clicked the File tab

Excel templates are pre-set configurations that help you in designing beautiful spreadsheets.

Instead of having to make a template whenever starting a new workbook, Excel offers a wide variety of pre-built templates which you can use.

continue reading »