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 turn multiple sheets into a single one for the purposes of editing. We will cover: Advantages of grouping worksheets When you are working with a lot…
In this guide, we will run through the basics of how to apply both superscript and subscript formatting to values in Excel. We will cover: What is Superscript and Subscript A superscript is a formatting technique that can be applied to a value that makes it appear at an elevated level (and generally smaller) than…
In this guide, we will cover off a series of techniques that can be used to easy compress an excel file that has gotten out of hand. Excel is a really powerful tool for data analysis, but it is also an absolute pain to work with when the file size starts creeping up. We have…
In this simple guide, we are going to run through how to use the Excel ATAN function to calculate the inverse tangent of a given number. We will cover: What is an inverse tangent? An inverse tangent is a term used within trigonometry The inverse tangent is also known as the arctangent (hence the shortened…
In this simple guide, we are going to run through how to measure for covariance in Excel. We will cover: What is covariance? Covariance is a measure within the field of statistics, and specifically probability, that allows us to measure the relationship between two sets of values. More specifically, it determines if the trends that…
In this quick and easy to follow guide we will provide 2 easy methods to stop Excel from automatically formatting numbers as dates. There are two easy ways to stop Excel turning numbers into dates – formatting as text, and using apostrophes. Both of these methods will be discussed in detail below, both in our…
This guide will cover how to copy conditional formatting in Excel from one cell to another easily. This post will cover: Why use conditional formatting? Conditional formatting in Excel is super handy. When we are working with large sets of data and tables it can be useful to have some kind of visual guide so…
This guide will explain how to use the Excel SMALL function, and provide example use cases. We will cover: What is the Excel SMALL function? Excel has a large range of useful statistical functions that can be used to easily and quickly analyse a set of raw data. Some are very simple, such as the…
This guide will cover off the basics of working with a legend in Excel charts. We will run through how to add a legend, rename them, and how to change the look and feel of them. We will cover: Excel provides us with a lot of very simple ways to visualise our data with only…
This guide will provide a summary of the built in Excel Database Functions, with descriptions of each individual function, and examples. We will cover: What are Database Functions in Excel? Database functions in Excel allow for a series of basic calculations to be performed against a dataset that is similar in format to a more…