Skip to content
  • Home
  • Excel Tips
    • Pivot Table
    • Vlookup
    • Worksheet
    • Tips
  • Formula
    • Formula List
    • Find
    • Convert
  • Graphs and Charts
    • Graphs
    • Charts
    • Tables
  • Calculations
  • Formatting
    • Columns
    • Cells
    • Rows
  • VBA
    • Macros
  • Terms of Service
  • Guest Post

Worksheet

How to match data in two Excel worksheets

November 28, 2022June 29, 2020 by Admin
How to match data in two Excel worksheets

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

Categories Worksheet Tags Complete guide on how to match data in two Excel worksheets, Tips for matching data in two Excel worksheets

Working with a Worksheets and its Data

November 28, 2022February 4, 2020 by Admin
Working with a Worksheets and its Data

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

Categories Worksheet Tags Guide on worksheet and it's data, How to work with Worksheet?
Newer posts
← Previous Page1 … Page3 Page4
  1. Admin on How to update excel to the latest versionMarch 26, 2021

    Can you please comment on the right page? Your comment is on http://basicexceltutorial.com/excel-tips/how-to-update-excel-to-the-latest-version

  2. Randy on How to update excel to the latest versionMarch 25, 2021

    your answer to "excel function count cells that contain dates" to use counta(a4:a9) only counts non blank cells. Even a…

Facebook

basicexceltutorial.com

Recent Posts

  • Mastering Excel's IF Function: Handling Multiple Conditions and Outputs
  • Excel How to Put Text and Formula in the Same Cell (With VBA Examples)
  • Mastering the CONCAT Function in Excel: A Complete Guide (with VBA Examples)
  • Step-by-Step Guide on Using Excel for QuickBooks (With VBA Examples)
  • How to Remove Multiple Blank Rows in Excel Using Formula (With Examples & VBA)
© 2025 Basic Excel Tutorial