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”
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”
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”
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”
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”
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.
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. Continue reading “How to Create a Basic Pivot Table? | Excel | Tutorial”