Other

## What Are The Most Popular Interview Questions? | Tutorial | Guide

Job interviews are something nearly everyone will go through once in their lives.  With most job interviews the questions are very standard and there are only so many questions that you are likely to be asked. In this guide we will look at what some of most common interview questions are and for each one a couple of bullet points to give you an idea of how to approach these questions. Continue reading “What Are The Most Popular Interview Questions? | Tutorial | Guide”

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

## 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”