Maths

What is the age of both father and son? | Algebra | Maths | Tutorial

QUESTION
The age of a father is twice the age of his son. Twenty years ago, his age was 6 times his son’s age. What is the age of both father and son? Continue reading “What is the age of both father and son? | Algebra | Maths | Tutorial”

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

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”

Other

The Correct Format To Write a Letter | US | UK | Tutorial

Being able to write a letter is a essential skill which you will need to use in everyday life whether it is in school, office or personal life. In this guide I will explain what each of the seven sections of a letter are for and how to fill them in. Continue reading “The Correct Format To Write a Letter | US | UK | Tutorial”

Maths

How To Solve a Basic Algebra Equation – Addition | Maths | Tutorial

Algebra is a type of mathematics which uses letters to represent possible numbers and quantities in equations. Algebra can be useful in solving real world problems as the letters can be used to represent real things. Continue reading “How To Solve a Basic Algebra Equation – Addition | 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”