## How to CONCATENATE in Excel – 2 Easy Formulas

In this simple step by step guide you will learn how to easily use the formula for concatenate in Excel. There are a few different approaches we can take when looking to merge strings of characters together using Excel. The built in formula for this makes it super easy to simply merge cell after cell,…

## Exponential Smoothing in Excel – Step by Step Guide

Exponential Smoothing is a way of smoothing out time series data in order to more easily see trends. On top of this it then allows us to forecast future values as well due to the overall trends appearing less messy. This guide will run through how to perform Exponential Smoothing in Excel, and visualise our…

## How to Find Quartiles in Excel – 1 Easy Formula

Excel makes it super easily to find quartiles within a dataset thanks to a handy built in formula that does the work for us. This guide will run through the formula that is used and break down the syntax with an example. The QUARTILE Formula To find quartiles in Excel simply use =QUARTILE(array, quart) and…

## How to Calculate Standard Error in Excel – Step by Step

This guide will run through 2 different approaches we can take in order to easily calculate standard error in Excel.

## How to Split Text to Rows in Excel in 2 Easy Steps

This guide will run through the quick and easy steps taken in order to split text into multple rows in Excel.

## Excel FORECAST Function – Extrapolate Data Easily

In this article we will run through how to use the FORECAST function in Excel with an easy to follow step by step guide.

## Calculate Mean, Median and Mode in Excel – 3 Easy Formulas

This guide will run through the various simple formulas that can be used in Excel to calculate Mean, Median and Mode.

## Add Error Bars in Excel – Easy Step by Step Guide

In this simple guide we will run through how add Error Bars to charts in Excel.

## How to Calculate Probability in Excel – Easy Formula

This guide will run through how to calculate probability using the PROB formula in Excel.

## How to Perform a T-Test in Excel – 2 Easy Methods

This quick and easy to follow guide will run through the steps taken in order to perform a T-Test in Excel in two ways – using a built in function and a formula.