In this guide, we will run through the basics of how to apply both superscript and subscript formatting to values… Read More »How to apply Superscript and Subscript in Excel

In this guide, we will cover off a series of techniques that can be used to easy compress an excel… Read More »8 easy ways to reduce Excel file size

In this simple guide, we are going to run through how to use the Excel ATAN function to calculate the… Read More »Calculating Inverse Tangent in Excel using ATAN

In this simple guide, we are going to run through how to measure for covariance in Excel. We will cover:… Read More »How to use the Excel COVARIANCE functions

In this guide we will provide 2 easy methods to stop Excel from automatically formatting numbers as dates. We will… Read More »How to stop Excel from changing numbers to dates

This guide will cover how to copy conditional formatting in Excel from one cell to another easily. This post will… Read More »How to copy conditional formatting in Excel

This guide will explain how to use the Excel SMALL function, and provide example use cases. We will cover: What… Read More »How to use the Excel SMALL function

This guide will cover off the basics of working with a legend in Excel charts. We will run through how… Read More »How to Edit Legend in Excel

This guide will provide a summary of the built in Excel Database Functions, with descriptions of each individual function, and… Read More »Excel Database Functions Explained