↓ 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.
Short Tips#0065: Some active cell shortcuts
Excel short tips

Short Tips#0065: Some active cell shortcuts

Pushpendu Roy Karmakar Oct 13, 2018 Tagged with SHORTCUTS

Short Tips#0064: Know the Excel function INDIRECT
Excel short tips

Short Tips#0064: Know the Excel function INDIRECT

Pushpendu Roy Karmakar Oct 13, 2018 Tagged with INDIRECT

Lesson#113: How to highlight cells with errors in it
Excel Features, Excel Funtions, Excel Tricks

Lesson#113: How to highlight cells with errors in it

Pushpendu Roy Karmakar Oct 11, 2018 Tagged with CONDITIONAL FORMATTING, ISERROR

I will show you how to highlight cells with errors among an array of values. Here …

Lesson#113: How to highlight cells with errors in it Read more →

Lesson#112: Calculate the match percentage of text which matches another text.
Excel Funtions, Excel Tricks

Lesson#112: Calculate the match percentage of text which matches another text.

Pushpendu Roy Karmakar Oct 7, 2018 Tagged with COUNTIF, IF, LEN

Here I will discuss an interesting formula. With this formula, we can calculate the percentage of …

Lesson#112: Calculate the match percentage of text which matches another text. Read more →

Lesson#111: Extract parts of text separated by a special character
Excel Funtions, Excel Tricks

Lesson#111: Extract parts of text separated by a special character

Pushpendu Roy Karmakar Sep 26, 2018 Tagged with FIND, LEFT, LEN, MID, RIGHT, SUBSTITUTE

Here I will show you how to extract parts of text separated by a special character. …

Lesson#111: Extract parts of text separated by a special character Read more →

Lesson#110: Separate characters from the text where any word appears
Excel Funtions, Excel Tricks

Lesson#110: Separate characters from the text where any word appears

Pushpendu Roy Karmakar Sep 23, 2018 Tagged with FIND, LEFT, MID, SUBSTITUTE, TRIM

Here I will show how to separate characters from the text where any text appears. Here …

Lesson#110: Separate characters from the text where any word appears Read more →

Lesson#109: Tricks to make a dancing chart in excel
Excel Features, Excel Tricks, VBA and Macro

Lesson#109: Tricks to make a dancing chart in excel

Pushpendu Roy Karmakar Sep 21, 2018 Tagged with CHART, RANDBETWEEN

Here I will show you a funny trick to make a dancing chart in excel. For …

Lesson#109: Tricks to make a dancing chart in excel Read more →

Lesson#108: How to divert the user to another cell in workbook when clicked
Excel Features, Excel Tricks

Lesson#108: How to divert the user to another cell in workbook when clicked

Pushpendu Roy Karmakar Sep 20, 2018 Tagged with HYPERLINK

Hi friend. Here I will show a method to divert a user to anywhere in the …

Lesson#108: How to divert the user to another cell in workbook when clicked Read more →

Lesson#107: How did I add MS Project features to the Excel project schedule
Excel for Office, Excel Tricks

Lesson#107: How did I add MS Project features to the Excel project schedule

Pushpendu Roy Karmakar Sep 17, 2018 Tagged with COUNTIF, DATE, EOMONTH, FIND, FORMULATEXT, IFERROR, INDIRECT, LEN, MID, MONTH, NOT, SUBSTITUTE, WORKDAY.INTL, YEAR

Here I will discuss a long topic about Excel Gantt chart making. I will show how …

Lesson#107: How did I add MS Project features to the Excel project schedule Read more →

Short Tips#0063: Formula to find number appearance of a character in a text
Excel short tips

Short Tips#0063: Formula to find number appearance of a character in a text

Pushpendu Roy Karmakar Sep 16, 2018 Tagged with LEN, SUBSTITUTE

Posts pagination

Previous 1 … 18 19 20 21 22 … 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…