↓ Skip to Main Content
Excelabcd

Main Navigation

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course
Excelabcd

Off Canvas Menu

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course

Excel Funtions

Lesson#159: What is Excel function TEXTSPLIT? TEXTSPLIT vs TEXTJOIN comparison.
Excel Funtions

Lesson#159: What is Excel function TEXTSPLIT? TEXTSPLIT vs TEXTJOIN comparison.

Pushpendu Roy Karmakar Sep 9, 2022 Tagged with TEXTJOIN, TEXTSPLIT

Microsoft Excel has introduced some new functions in 2022. One of them is the Excel TEXTSPLIT …

Lesson#159: What is Excel function TEXTSPLIT? TEXTSPLIT vs TEXTJOIN comparison. Read more →

Lesson#158: What is the Excel HSTACK function? | How does HSTACK work in Excel?
Excel Funtions

Lesson#158: What is the Excel HSTACK function? | How does HSTACK work in Excel?

Pushpendu Roy Karmakar Sep 8, 2022 Tagged with HSTACK

Microsoft Excel has introduced some new functions in 2022. One of them is the Excel HSTACK …

Lesson#158: What is the Excel HSTACK function? | How does HSTACK work in Excel? Read more →

Lesson#157: What is the Excel VSTACK function? | How does VSTACK work in Excel?
Excel Funtions

Lesson#157: What is the Excel VSTACK function? | How does VSTACK work in Excel?

Pushpendu Roy Karmakar Sep 8, 2022 Tagged with VSTACK

Microsoft Excel has introduced some new functions in 2022. One of them is the Excel VSTACK …

Lesson#157: What is the Excel VSTACK function? | How does VSTACK work in Excel? Read more →

Lesson#156: XLOOKUP vs VLOOKUP in Excel. Which one is better?
Excel Funtions

Lesson#156: XLOOKUP vs VLOOKUP in Excel. Which one is better?

Pushpendu Roy Karmakar Sep 2, 2022 Tagged with HLOOKUP, IFERROR, INDEX, MATCH, VLOOKUP, XLOOKUP

Hello Reader! Welcome to my other post on Excelabcd. Microsoft Excel has introduced a new function …

Lesson#156: XLOOKUP vs VLOOKUP in Excel. Which one is better? Read more →

Lesson#155: 25 most useful Excel Functions everyone needs to know
Excel Funtions, Excel general tips

Lesson#155: 25 most useful Excel Functions everyone needs to know

Pushpendu Roy Karmakar Aug 23, 2022 Tagged with COUNTIF, COUNTIFS, IF, LEN, MID, NOW, SUM, SUMIF, SUMIFS, SUMPRODUCT, TODAY, VLOOKUP

Hello readers! In this post, we shall learn about the 25 most useful Excel Functions everyone …

Lesson#155: 25 most useful Excel Functions everyone needs to know Read more →

Lesson#150: how to write all numbers in a minimum of four digits?
Excel Funtions, Excel general tips

Lesson#150: how to write all numbers in a minimum of four digits?

Pushpendu Roy Karmakar Jun 2, 2022 Tagged with TEXT

Today I am going to discuss how to write all numbers in a minimum of four …

Lesson#150: how to write all numbers in a minimum of four digits? Read more →

Lesson#143: How to make a mirror of a table in excel
Excel Funtions, Excel Tricks

Lesson#143: How to make a mirror of a table in excel

Pushpendu Roy Karmakar Sep 13, 2019 Tagged with COLUMN, OFFSET, ROW

Hello guys! I am back with a new lesson. Here I will show you to make …

Lesson#143: How to make a mirror of a table in excel Read more →

Lesson#135: MAXIF and MINIF with function IF
Excel Funtions, Excel Tricks

Lesson#135: MAXIF and MINIF with function IF

Pushpendu Roy Karmakar Apr 2, 2019 Tagged with IF, MAX, MIN

In this post, I will show you to make two new functions. These are functions MAXIF …

Lesson#135: MAXIF and MINIF with function IF Read more →

Lesson#132: How to make the function SUMPRODUCTIF
Excel Funtions

Lesson#132: How to make the function SUMPRODUCTIF

Pushpendu Roy Karmakar Mar 14, 2019 Tagged with IF, SUMPRODUCT

In this post, I will show you the trick to make the function SUMPRODUCTIF. We have …

Lesson#132: How to make the function SUMPRODUCTIF Read more →

Lesson#128: Formula to make serial no auto arranged when filtered
Excel Funtions, Excel Tricks

Lesson#128: Formula to make serial no auto arranged when filtered

Pushpendu Roy Karmakar Jan 16, 2019 Tagged with IF, SUBTOTAL

Here I will show how to make auto arranged serial no when you filter a column. …

Lesson#128: Formula to make serial no auto arranged when filtered Read more →

Posts pagination

Previous 1 2 3 4 5 6 … 10 Next
Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy
Copyright © 2026 Excelabcd | Powered by Responsive Theme
Copyright © 2026 Excelabcd | Powered by Responsive Theme
Loading…