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.

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