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”