### How to CONCATENATE in Excel – 2 Easy Formulas

Jul 30, 2023
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

### Exponential Smoothing in Excel – Step by Step Guide

Jun 30, 2023
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

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

Jun 25, 2023
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

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

Jun 24, 2023
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

Jun 23, 2023
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

Jun 19, 2023
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

Jun 14, 2023
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

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

### How to Calculate Probability in Excel – Easy Formula

Jun 12, 2023
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

Jun 11, 2023
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 –

### How to use Flash Fill in Excel to Automate Work

Jun 10, 2023
This easy to follow guide will run through how to use the Flash Fill function in Excel to save a lot of time when cleaning

### How to Enable the Data Analysis ToolPak in Excel

Jun 6, 2023
In this quick and easy guide we are going to run through the steps that need to be taken in order to access the Data

### Calculate Moving Average in Excel (Easy Guide)

Jun 5, 2023
In this easy step by step tutorial we will show you how to calculate a moving average in Excel, using both formulas and a built

### How to Create a Heat Map in Excel (Quick and Easy)

May 20, 2023
Heat Maps are a really handy visualization technique when looking at large tables of data to quickly and easily see which values are highest and

### How to Insert a Checkbox in Excel (Easy Guide)

Mar 13, 2023
When working with data in Excel, there are a lot of interactive elements we can play with. Maybe we have made a pivot table and

### How to Perform a Spell Check in Excel

Mar 13, 2023
Working with spell checks in Excel tends to be a bit of a different process to other tools such as Microsoft Word, largely due to

### How to Pass the AWS Cloud Practitioner Exam

Feb 28, 2023
I recently sat and passed the CLF-C01 Exam, receiving my AWS Cloud Practitioner Certification.Overall I spent around a month studying for it, with basically zero

### How to Easily Add a Secondary Axis in Excel Charts

Jan 3, 2023
Creating visualizations in Excel can be really powerful, however when working with multiple metrics sometimes things can get a little bit unreadable. This is where