Skip to content
Excelgraduate

Excelgraduate

A to Z Solution Provider

  • Home
  • Blog
  • CategoriesExpand
    • Basic Excel
    • Advanced Excel
    • Excel Functions
    • Excel Formulas
    • Pivot Table
    • Power Query
    • Visual Basic
    • Excel for Business
    • Excel Glossary
  • About
  • Contact
Excelgraduate
Excelgraduate
A to Z Solution Provider
3 Ways to Find Column Index Number in Excel
Excel Formulas

3 Ways to Find Column Index Number in Excel

Rhidi Barma May 7, 2022July 3, 2022 Excel Formulas

Often we have to work with datasheets with numerous columns. I am frequently asked the question that how to find…

Read More 3 Ways to Find Column Index Number in ExcelContinue

5 Approaches to Remove Characters from the Right in Excel
Excel Formulas

5 Approaches to Remove Characters from the Right in Excel

Rhidi Barma May 2, 2022May 6, 2023 Excel Formulas

We can remove characters from the right using either formulas, commands, or VBA scripts. I have discussed 5 approaches in…

Read More 5 Approaches to Remove Characters from the Right in ExcelContinue

7+ Methods to Remove Characters from Left in Excel
Excel Formulas

7+ Methods to Remove Characters from Left in Excel

Rhidi Barma April 28, 2022May 6, 2023 Excel Formulas

While processing data in Excel, data cleaning is a vital step for presenting data in a meaningful way. To clean…

Read More 7+ Methods to Remove Characters from Left in ExcelContinue

5 Ways to Find Matching Values in Two Worksheets in Excel
Excel Formulas

5 Ways to Find Matching Values in Two Worksheets in Excel

Rhidi Barma April 28, 2022March 26, 2023 Excel Formulas

Very often we need to deal with multiple worksheets with a good deal of similar values. From the lengthy spreadsheets,…

Read More 5 Ways to Find Matching Values in Two Worksheets in ExcelContinue

Vlookup for Duplicate Values and Return the Matches in Excel [8 Cases]
Excel Formulas

Vlookup for Duplicate Values and Return the Matches in Excel [8 Cases]

Rhidi Barma April 23, 2022March 26, 2023 Excel Formulas

To find the duplicate values in Excel, we need to Vlookup (Vertical Lookup) through columns. Sometimes we need just to…

Read More Vlookup for Duplicate Values and Return the Matches in Excel [8 Cases]Continue

How to Find Similar Text in Two Columns in Excel (6 Ways)
Excel Formulas

How to Find Similar Text in Two Columns in Excel (6 Ways)

Rhidi Barma April 20, 2022March 26, 2023 Excel Formulas

We often need to find similar texts in two columns in Excel. Well, there are quite a few handy techniques…

Read More How to Find Similar Text in Two Columns in Excel (6 Ways)Continue

How to Compare Rows in Excel for Duplicates (8 Ways)
Excel Formulas

How to Compare Rows in Excel for Duplicates (8 Ways)

Rhidi Barma April 9, 2022March 26, 2023 Excel Formulas

You may think that what can be the use of comparing rows in Excel. Well, actually there are countless applications…

Read More How to Compare Rows in Excel for Duplicates (8 Ways)Continue

How to Find Duplicates in Two Columns in Excel (7 Methods)
Excel Formulas

How to Find Duplicates in Two Columns in Excel (7 Methods)

Rhidi Barma April 3, 2022March 26, 2023 Excel Formulas

There are great tools and commands to find duplicates in two or more columns in Excel that will ease your…

Read More How to Find Duplicates in Two Columns in Excel (7 Methods)Continue

How to Sort Data in Excel Using a Formula (7 Formulas)
Excel Formulas

How to Sort Data in Excel Using a Formula (7 Formulas)

Rhidi Barma March 9, 2022March 26, 2023 Excel Formulas

Excel allows sorting your data in several ways. You can use both the Sort button as well as formulas to…

Read More How to Sort Data in Excel Using a Formula (7 Formulas)Continue

Page navigation

Previous PagePrevious 1 2 3
  • About
  • Blog
  • Contact

Excelgraduate

A to Z Solution Provider

DMCA.com Protection Status
  • Disclaimer
  • Privacy Policy
  • Terms & Conditions
YouTube YouTubeFacebook FacebookTwitter TwitterLinkedin LinkedinPinterest Pinterest

Copyright © 2023 Excelgraduate | All Rights Reserved.

Scroll to top
  • Home
  • Blog
  • Categories
    • Basic Excel
    • Advanced Excel
    • Excel Functions
    • Excel Formulas
    • Pivot Table
    • Power Query
    • Visual Basic
    • Excel for Business
    • Excel Glossary
  • About
  • Contact
Purchase
Search
x
x