Basic Excel Tutorial

How to Do a Vlookup Between Two Spreadsheets

Vlookup is a very useful Excel Function. Basically, what it does is ‘Look-up’ or searches for a value or text specified in a table (array) and returns a value or…

Comments Off

December 29, 2017

Pivot Table

How to create a pivot table from multiple worksheets using Microsoft Excel 2016

A pivot table in its simplest form is a program tool which permits its user to summarize selected columns and rows of data in a spreadsheet. It simply put is…

Comments Off

December 28, 2017

Go to the previous page
1
…
18
19
20
21