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 there is a clear pattern in our data. Adding a trendline in Excel to our data is a simple but effective technique. It…
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…
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…
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…
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…
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…
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…
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…
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…
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…