↓ 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#0082: Advantage and Disadvantage of IF and IFS, solution
Excel short tips

Short Tips#0082: Advantage and Disadvantage of IF and IFS, solution

Pushpendu Roy Karmakar Aug 18, 2020 Tagged with IF, IFS

Short Tips#0081: How to delete unnecessary created objects in sheets
Excel short tips

Short Tips#0081: How to delete unnecessary created objects in sheets

Pushpendu Roy Karmakar Aug 17, 2020 Tagged with Go to Special

Stellar Repair for Excel is good to recover corrupted Excel files
Review check

Stellar Repair for Excel is good to recover corrupted Excel files

Pushpendu Roy Karmakar Jan 15, 2020 Tagged with Corrupted file

Hey Friends! Today I will let you know about a good software to recover corrupted excel files. Sometimes we loose important data if a file suddenly corrupts. It is hard situation for office people. Stellar Repair for Excel is a …

Stellar Repair for Excel is good to recover corrupted Excel files Read more →

Lesson#145: How to solve errors in excel when you insert columns or rows
Excel general tips

Lesson#145: How to solve errors in excel when you insert columns or rows

Pushpendu Roy Karmakar Jan 12, 2020 Tagged with WOKSHEET

Hello everyone! I hope you are all well and well. Today I will talk about How to solve errors in excel when you insert columns or rows. The error message box is just like this. To prevent possible loss of …

Lesson#145: How to solve errors in excel when you insert columns or rows Read more →

Lesson#144: How to find linked values in Excel from other Worksheets
Excel general tips

Lesson#144: How to find linked values in Excel from other Worksheets

Pushpendu Roy Karmakar Nov 30, 2019 Tagged with FIND&REPLACE

Hello friends, after a long time I am going to make a post for you. Here I am going to discuss the Find and Replace option in Excel. Suppose I have a worksheet filled with data. There may be some …

Lesson#144: How to find linked values in Excel from other Worksheets 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 a formula that can make a mirror of an excel table. Here I have made a table with some data. I will make a …

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

Short Tips#0080: How to change the preview layout of all sheets at one time
Excel short tips

Short Tips#0080: How to change the preview layout of all sheets at one time

Pushpendu Roy Karmakar Aug 15, 2019

Lesson#142: How to take print of all sheets at a time
Excel general tips

Lesson#142: How to take print of all sheets at a time

Pushpendu Roy Karmakar Aug 12, 2019 Tagged with PRINT

I will discuss here how to print all sheets of excel files at a time. For that, we need to first set the print area for all sheets as I have done in the example. After that, we need to …

Lesson#142: How to take print of all sheets at a time Read more →

Short Tips#0079: Finding the reference cells is very easy
Excel short tips

Short Tips#0079: Finding the reference cells is very easy

Pushpendu Roy Karmakar Jul 21, 2019

Lesson#141: Master method to rename all files in a folder at once using Excel
Excel Tricks

Lesson#141: Master method to rename all files in a folder at once using Excel

Pushpendu Roy Karmakar Jul 11, 2019 Tagged with CMD, TEXT TO COLUMNS

This one is really a master method. Now I will show you a master method to rename all files in a folder at once using Excel. I am sure this solution is going to ease your huge workload at the …

Lesson#141: Master method to rename all files in a folder at once using Excel Read more →

Posts pagination

Previous 1 … 13 14 15 16 17 … 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…