How to CONCATENATE in Excel – 2 Easy Formulas
Tom 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
Tom 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
Tom 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
Tom 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
Tom 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
Tom 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
Tom 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
Tom 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
Tom 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
Tom 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
Tom 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
Tom 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)
Tom 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)
Tom 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)
Tom 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
Tom 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
Tom 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
Tom 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