The Excel COUNTA function is a built in function that is used as a relatively simple formula to count the number of cells that are not empty - containing

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 lowest.

In this simple guide, we will run through how to find outliers in Excel using a few different methods. We will cover:

This guide will provide a step by step run through on how to make a Scatter Plot in Excel.

In this simple guide, we are going to run through how to use the Excel TRANSPOSE function. We will cover:

This guide will provide a step by step run through on how to make a Scatter Plot in Excel.

To separate names in excel we can simply use the LEFT and RIGHT formulas, or use the built in text to columns function. Steps for both of these methods will be explained in this guide.

In this simple guide, we are going to run through how to use the NOW function in Excel, along with some examples of the outputs.

In this guide, we will run through 2 easy methods on how to alphabetize in Excel. We will cover:

Sparklines in Excel are a really handy way of visualizing our data in a compact and easy to understand way, without the need to create full blown charts.

In this guide, we will run through 2 easy methods on how to alphabetize in Excel. We will cover:

In this simple guide, we are going to run through how to use the NOW function in Excel, along with some examples of the outputs.

This is where the powerful Maths and Trig AGGREGATE function in Excel can come in super handy. In this simple guide we are going to run through the benefits

In this simple guide, we will run through how to find outliers in Excel using a few different methods. We will cover:

In this simple guide, we are going to run through how to use the NOW function in Excel, along with some examples of the outputs.

A trendline, also known as a line of best fit, is a straight or curved line that sits on top of a series of data points to help visualise and determine if

In this simple guide, we are going to run through the benefits, and steps to group worksheets in excel. Also known as tabs, this guide will explain how to

In this simple guide, we are going to run through how to use the NOW function in Excel, along with some examples of the outputs.

The Excel COUNTA function is a built in function that is used as a relatively simple formula to count the number of cells that are not empty - containing

Sparklines in Excel are a really handy way of visualizing our data in a compact and easy to understand way, without the need to create full blown charts.