## How to use Exponents in Excel in 2 Easy Ways

Exponents are a value that is applied to a number to determine how many times to multiply against itself. 42 for example means 4 x 4 = which would equal 16 54 means 5 x 5 x 5 x 5 which would be 625 And so on. It is a simple but powerful mathematical method…

## How to Print Gridlines in Excel in 3 Easy Ways

By default, when printing a workbook from Excel the gridlines that appear by default in the document itself will disappear in the printout itself. Sometimes this can make a document look cleaner, but often it makes things like tables a bit harder to actually read. In this simple guide, we will cover how to print…

## How to add Axis Labels in Excel in 2 Easy Ways

Making charts in Excel is a great way to visualise our data in a way that is easy to understand. That being said sometimes there is a bit of work that needs to be done to really make it as useful as possible. One of these areas is axis labels as they are not included…

## How to use PI in Excel

Of all of the formulas in Excel to help calculate values, PI is one of the more simple ones, but also incredibly useful. PI is a value that depending on how far you want to go with it has a fair bit to memorise. A quick Google search will obviously provide you with as many…

## How to use the AGGREGATE function in Excel

Basic formulas in Excel such as SUM, MAX, COUNT and so on are incredibly useful, however do have their limitations especially when working with potentially messy datasets. 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…

## Matrix Multiplication in Excel using MMULT

In this simple guide, we are going to run through the process for applying Matrix Multiplication in Excel, by using the built in MMULT formula. We will cover: Let’s get started with a basic summary on matrices in general. What is a Matrix Put simply, Matrices are an array of numbers, organised into rows and…

## Binomial Distribution in Excel with BINOM.DIST

In statistics, a binomial distribution is a method of calculating the probability of the number of successes within a set of trials. Binomial also means that there are only ever two possible outcomes – success or failure. Real life examples may include something like whether a university student passes or fails an exam. In this…

## How to Easily Switch X and Y Axis in Excel

Visualizing our data in Excel in the form of a chart can be super useful in helping to display trends. Charts like bar charts, line charts, scatter plots and so on are generally easy to make, but sometimes depending on the order of the columns of data it can sometimes look a little weird. In…

## How to Square a Number in Excel in 3 Easy ways

Excel is a really powerful tool when we want to jump in and perform basic mathematical functions. A good example of this is when we want to square a number. In this simple guide, we are going to run through 3 Easy ways to square a number using Excel. We will cover: Let’s get started…

## How to use the Excel MOD function

In math, a modulo (also known as modulus) is a calculation that determines the remaining value following a division. This is a very commonly used method in computer science (and often one of the very first things you will learn when beginning to write just about any coding language). Excel also has this feature as…