In this tutorial I will show how to use the ROUND
, ROUNDUP
and ROUNDDOWN
functions in Excel. … continue reading »
Rounding Functions
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.
Financial Functions
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 »
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
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
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.
Excel Templates
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.