Basic Excel Tutorial

How to match data in two Excel worksheets

November 28, 2022June 29, 2020 by Admin

Reading values in one tab are easy when it comes to excel. But looking up values in two different tabs is not easy for some people. However, there is a way that you can match data using a formula to make your work easier. You will learn several ways on how to match data in

Working with a Worksheets and its Data

November 28, 2022February 4, 2020 by Admin

A worksheet is a collection of cells. There are a lot of operations that can be conducted on the worksheet. Some of the common ones include: a) Renaming a worksheet Procedure: 1. Launch Excel. 2. Ensure you are on the active worksheet which is to be renamed. 3. Right-click on the Worksheet tab. A menu