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 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…
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…
This guide will run through 2 different approaches we can take in order to easily calculate standard error in Excel.
This guide will run through the quick and easy steps taken in order to split text into multple rows in Excel.
In this article we will run through how to use the FORECAST function in Excel with an easy to follow step by step guide.
This guide will run through the various simple formulas that can be used in Excel to calculate Mean, Median and Mode.
In this simple guide we will run through how add Error Bars to charts in Excel.
This guide will run through how to calculate probability using the PROB formula in Excel.
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.