↓ 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
Short Tips#0044: How to use dollar to freeze cell reference
Excel short tips

Short Tips#0044: How to use dollar to freeze cell reference

Pushpendu Roy Karmakar Sep 2, 2018

Short Tips#0043: Insert a Chart very easily
Excel short tips

Short Tips#0043: Insert a Chart very easily

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with CHART

Short Tips#0042: Avoid data input error by Data Validation
Excel short tips

Short Tips#0042: Avoid data input error by Data Validation

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with DATA VALIDATION

Short Tips#0041: Find duplicates or unique with Conditional Formatting
Excel short tips

Short Tips#0041: Find duplicates or unique with Conditional Formatting

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with CONDITIONAL FORMATTING

Lesson#104: The easiest method to separate words from a text
Excel Features, Excel Tricks

Lesson#104: The easiest method to separate words from a text

Pushpendu Roy Karmakar Sep 1, 2018 Tagged with TEXT TO COLUMNS

Do you know which is the easiest method to separate words from the text? It is …

Lesson#104: The easiest method to separate words from a text Read more →

Lesson#103: 4 Ways to find duplicate values in a worksheet
Excel Features, Excel Funtions, Excel general tips

Lesson#103: 4 Ways to find duplicate values in a worksheet

Pushpendu Roy Karmakar Sep 1, 2018 Tagged with CONDITIONAL FORMATTING, COUNTIF, MODE, MODE.MULT, PIVOTTABLE

Often we need to find the duplicate values in an Excel worksheet. Here in this post, …

Lesson#103: 4 Ways to find duplicate values in a worksheet Read more →

Lesson#102: How to avoid name conflict error when copying a sheet in Excel
Excel Features, Excel general tips

Lesson#102: How to avoid name conflict error when copying a sheet in Excel

Pushpendu Roy Karmakar Aug 31, 2018 Tagged with NAME MANAGER

How to avoid name conflict errors when copying a sheet in Excel. In this post, I …

Lesson#102: How to avoid name conflict error when copying a sheet in Excel Read more →

Lesson#101: Hyperlink all files and folders in the worksheet within a minute
Excel Features, Excel for Office, Excel Funtions, Excel Tricks

Lesson#101: Hyperlink all files and folders in the worksheet within a minute

Pushpendu Roy Karmakar Aug 25, 2018 Tagged with CMD, HYPERLINK, TEXT TO COLUMNS

Here in this post, I will show you how to hyperlink all files and folders in …

Lesson#101: Hyperlink all files and folders in the worksheet within a minute Read more →

Lesson#100: Making a master formula to separate words from the sentence
Excel Funtions, Excel Tricks

Lesson#100: Making a master formula to separate words from the sentence

Pushpendu Roy Karmakar Aug 21, 2018 Tagged with LEN, MID, REPT, SUBSTITUTE, TRIM

Hello. Now we will learn how to make a master formula to separate words from sentences. …

Lesson#100: Making a master formula to separate words from the sentence Read more →

Lesson#99: Formula to separate words from a full name
Excel Funtions, Excel Tricks

Lesson#99: Formula to separate words from a full name

Pushpendu Roy Karmakar Aug 20, 2018 Tagged with FIND, IFERROR, LEFT, LEN, MID, RIGHT

OK. I am back again with some crazy formula. Here in this post, I will show …

Lesson#99: Formula to separate words from a full name Read more →

Posts pagination

Previous 1 … 21 22 23 24 25 … 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…