Maths

Combinations & Permutations Formula Simplified | Maths | Tutorial

This tutorial will look at the difference between combinations and permutations without replacement and how to calculate these. This post expands on concepts learned from the Emma’s Dilemma permutations tutorial. Continue reading “Combinations & Permutations Formula Simplified | Maths | Tutorial”

Maths

Emma’s Dilemma – Permutations with Unique & Repeating Letters | Maths | Tutorial

In this scenario we look at two names EMMA and LUCY, we want to find out all the possible arrangements the letters of their name can be used to make this is known as permutations. We will also learn to use a formula that will help calculate how many different combinations there are without having to write them down manually this is especially useful if there are 100’s of possibilities. Continue reading “Emma’s Dilemma – Permutations with Unique & Repeating Letters | Maths | Tutorial”

Excel

Fusing Together The SUM and Index Function | Excel | Tutorial

The purpose of the index function is to help us find the position of our data in Excel so that we can retrieve it and use it for various purposes. In this example, we will be using the Index function to find the position of our monthly sales figures from table 1 so that we can summarise it into quarterly figures. Continue reading “Fusing Together The SUM and Index Function | Excel | Tutorial”

Excel

Why We Need To Use Absolute References? | Excel | Tutorial

Absolute references ensure that your formula does not change when copied of filled. You can use absolute references when you want to keep certain cells constant. The dollar sign ($) is used before a row or column reference Continue reading “Why We Need To Use Absolute References? | Excel | Tutorial”

Excel

How To Combine Data Using The Concatenate Function? | Excel | Tutorial

The Concatenate function combines text data from different cells into one. This is useful for many purposes, one common purpose is if you have your employee names in three columns Title, First Name & Surname. Continue reading “How To Combine Data Using The Concatenate Function? | Excel | Tutorial”

Excel

Understanding The SUMIF Function | Excel | Tutorial

SUMIF is a function which helps summarise data into a meaningful report. A SUMIF statement is similar to but more versatile than a pivot table. In our example, we will use the SUMIF function to demonstrate how product sales figures by country can be summarised to show total sales per product. Continue reading “Understanding The SUMIF Function | Excel | Tutorial”

Excel

Introduction To IF Statements | Excel | Tutorial

An IF statement is a function in excel which can be used to produce outputs if conditions that we have set are proved true or false. Continue reading “Introduction To IF Statements | Excel | Tutorial”

Excel

How To Create a Chart Comparing Two Sets of Data? | Excel | Tutorial

In Excel, a chart also referred to as a graph is used to graphically display data which can make it easier for the user to analyse and interpret. Continue reading “How To Create a Chart Comparing Two Sets of Data? | Excel | Tutorial”

Excel

Creating Expanding Dropdown Lists | Excel | Tutorial

A drop-down list also referred to as a pull-down menu, is a user-friendly method of displaying a large list of choices. It ensures consistency when entering large quantities of data. Continue reading “Creating Expanding Dropdown Lists | Excel | Tutorial”

Excel

Learning The Basics of VLOOKUP | Excel | Tutorial

VLOOKUP is a function within excel which can look at a value in one column and find the matching value in another column. A VLOOKUP is incredibly useful when working with several tables that have some common data but is incomplete without data from another table.

Continue reading “Learning The Basics of VLOOKUP | Excel | Tutorial”