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. In this tutorial, I… 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. Video Guide Instructions In this tutorial, I am going to show you how to create a basic IF statement. Create or have ready data that is comparable such as… 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. In this tutorial, we will show you how to compare revenue figures for two different years using a line graph. Video Guide Instructions Firstly you will need… 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. This tutorial will show you how to create an expanding drop-down list. Video Guide Instructions Create a table which you would like to use a… 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. This tutorial will show you how to use the… Continue reading Learning the basics of VLOOKUP | Excel | Tutorial

Excel

How to Create a Basic Pivot Table? | Excel | Tutorial

A pivot table is an excel built-in tool which allows you to sort and summarise complex data. This table typically consists of rows, columns, and fields. This tutorial will show you how to create a very simple pivot table. Video Guide Instructions Add the data that you want to analyse or summarise. Click on Insert… Continue reading How to Create a Basic Pivot Table? | Excel | Tutorial