## Calculating Factorial in Excel using FACT

In this simple guide, we are going to explain how calculate a factorial in Excel using any given number by using the built in FACT function. This guide will cover: What is a Factorial? A Factorial is a function in maths that takes a number, and then multiplies it by every whole number below it,…

## Excel ANOVA function – Analysis of Variance

In this simple guide, we will run through how to perform the built in Excel ANOVA function to perform an Analysis of Variance with some examples. This guide will cover: What is Analysis of Variance (ANOVA)? Put simply – an Analysis of Variance is a common statistical technique that is used to compare separate groups…

## How to use the Quick Analysis Tool in Excel

In this simple guide, we will run through how to use the Quick Analysis Tool in Excel, with some examples. This guide will cover: What is the Quick Analysis Tool? The Quick Analysis Tool in Microsoft Excel is a really handy feature that provides a whole range of functions that can be accessed with a…

## How to Normalize Data in Excel With 1 Easy Formula

This guide will run through step by step how to Normalize Data with a Z-Score in Excel using the simple STANDARDIZE formula.

## How to use the Excel CEILING function

In this guide, we are going to talk about the Excel CEILING function and some examples of how to use it. We will cover: What is the CEILING function in Excel? The Excel CEILING function is a formula within Excel that sits under the Math and Trigonometry category. This formula takes a number, and rounds…

## How to easily merge data in Excel with a VLOOKUP

Working with multiple data sets in excel can be quite a time consuming and manual process. Depending on the complexity of the data and how much it needs cleaning there is often a fair bit to do in order to get it into a single clean sheet that you can work with for analysis or…

## Why Excel users should learn SQL

For many years my go to platform of choice for anything related to data was Microsoft Excel. Hours spent downloading various sources of data into a spreadsheet and running sums, counts, vlookups, countifs, pivot tables and lots and lots of formatting. As requirements got more complicated and datasets grew larger, Excel started to display some…