↓ 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

Author: Pushpendu Roy Karmakar

Hi! I am Pushpendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.
Lesson#168: How to analyze employee database with PivotTable
Excel Features

Lesson#168: How to analyze employee database with PivotTable

Pushpendu Roy Karmakar Nov 18, 2022 Tagged with CHART, PIVOTTABLE

Ok readers! How are you? Today I brought a lesson on how to analyze employee database …

Lesson#168: How to analyze employee database with PivotTable Read more →

Lesson#167:11 tips to work like Pro in Excel
Excel for Office, Excel general tips

Lesson#167:11 tips to work like Pro in Excel

Pushpendu Roy Karmakar Nov 13, 2022 Tagged with CHART, CONDITIONAL FORMATTING, DATA VALIDATION, SHORTCUTS

Are you an Excel user? If so, check out these 11 tips to work like a …

Lesson#167:11 tips to work like Pro in Excel Read more →

Lesson#166: Why Microsoft Excel Is Still the Most Useful Software?
Excel for Office, Excel general tips

Lesson#166: Why Microsoft Excel Is Still the Most Useful Software?

Pushpendu Roy Karmakar Nov 10, 2022 Tagged with CHART, CONDITIONAL FORMATTING, DATA VALIDATION, SHORTCUTS

Excel is one of the most useful and underrated pieces of software out there. Yes, it …

Lesson#166: Why Microsoft Excel Is Still the Most Useful Software? Read more →

Lesson#165: What is the Excel UNIQUE function?
Excel Funtions

Lesson#165: What is the Excel UNIQUE function?

Pushpendu Roy Karmakar Oct 23, 2022 Tagged with UNIQUE

Excel UNIQUE function has been recently introduced by Microsoft. It’s a very good function and method …

Lesson#165: What is the Excel UNIQUE function? Read more →

Lesson#164: How to easily create a mail merge in Word from Excel – step by step
Excel for Office

Lesson#164: How to easily create a mail merge in Word from Excel – step by step

Pushpendu Roy Karmakar Oct 16, 2022 Tagged with Mail Merge, Microsoft Word

Hello friends! I hope you all are very well. Today we shall go a little outside …

Lesson#164: How to easily create a mail merge in Word from Excel – step by step Read more →

Lesson#163: 6 new excel formulas must know in 2022
Excel Funtions

Lesson#163: 6 new excel formulas must know in 2022

Pushpendu Roy Karmakar Oct 2, 2022 Tagged with CHOOSECOLS, CHOOSEROWS, DROP, HSTACK, TAKE, VSTACK

Microsoft Excel has introduced some new functions in 2022. Here are 6 of the new excel …

Lesson#163: 6 new excel formulas must know in 2022 Read more →

Lesson#162: What are TEXTBEFORE and TEXTAFTER functions in Excel?
Excel Funtions

Lesson#162: What are TEXTBEFORE and TEXTAFTER functions in Excel?

Pushpendu Roy Karmakar Sep 18, 2022 Tagged with TEXTAFTER, TEXTBEFORE

Microsoft Excel has introduced some new functions in 2022. Two of them are the Excel TEXTBEFORE and …

Lesson#162: What are TEXTBEFORE and TEXTAFTER functions in Excel? Read more →

Lesson#161: How to remove duplicates in Excel? | 5 ways to delete duplicates in Excel
Excel general tips

Lesson#161: How to remove duplicates in Excel? | 5 ways to delete duplicates in Excel

Pushpendu Roy Karmakar Sep 13, 2022 Tagged with CONDITIONAL FORMATTING, MODE, MODE.MULT, PIVOTTABLE, REMOVE DUPLICATES

Maximum Microsoft Excel users frequently ask this question about Excel. One of the most asked questions …

Lesson#161: How to remove duplicates in Excel? | 5 ways to delete duplicates in Excel Read more →

Lesson#160: How to use INDEX and MATCH? | INDEX-MATCH vs VLOOKUP
Excel Funtions

Lesson#160: How to use INDEX and MATCH? | INDEX-MATCH vs VLOOKUP

Pushpendu Roy Karmakar Sep 11, 2022 Tagged with INDEX, MATCH, VLOOKUP

In this post, I am going to discuss on INDEX – MATCH combination. How can we …

Lesson#160: How to use INDEX and MATCH? | INDEX-MATCH vs VLOOKUP Read more →

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 →

Posts pagination

Previous 1 … 10 11 12 13 14 … 37 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…