↓ 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

Author: Puspendu Roy Karmakar

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Video Published: IF and IFS function in excel explained

By Puspendu Roy Karmakar Posted on September 27, 2020 Posted in Video Notification No Comments Tagged with IF, IFS
Video Published: IF and IFS function in excel explained

Hey friends! I have just published a new video explaining how to use Excel IF and Excel IFS function. I have explained the advantages and disadvantages of Excel IF and IFS function. Please visit my YouTube channel and watch this …

Video Published: IF and IFS function in excel explained Read more »

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

By Puspendu Roy Karmakar Posted on August 18, 2020 Posted in Excel short tips 2 Comments Tagged with IF, IFS
Short Tips#0082: Advantage and Disadvantage of IF and IFS, solution

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

By Puspendu Roy Karmakar Posted on August 17, 2020 Posted in Excel short tips No Comments Tagged with Go to Special
Short Tips#0081: How to delete unnecessary created objects in sheets

Stellar Repair for Excel is good to recover corrupted Excel files

By Puspendu Roy Karmakar Posted on January 15, 2020 Posted in Review check 2 Comments Tagged with Corrupted file
Stellar Repair for Excel is good to recover corrupted Excel files

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

By Puspendu Roy Karmakar Posted on January 12, 2020 Posted in Excel general tips No Comments Tagged with WOKSHEET
Lesson#145: How to solve errors in excel when you insert columns or rows

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

By Puspendu Roy Karmakar Posted on November 30, 2019 Posted in Excel general tips No Comments Tagged with FIND&REPLACE
Lesson#144: How to find linked values in Excel from other Worksheets

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

By Puspendu Roy Karmakar Posted on September 13, 2019 Posted in Excel Funtions, Excel Tricks 3 Comments Tagged with COLUMN, OFFSET, ROW
Lesson#143: How to make a mirror of a table in excel

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

By Puspendu Roy Karmakar Posted on August 15, 2019 Posted in Excel short tips No Comments
Short Tips#0080: How to change the preview layout of all sheets at one time

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

By Puspendu Roy Karmakar Posted on August 12, 2019 Posted in Excel general tips No Comments Tagged with PRINT
Lesson#142: How to take print of all sheets at a time

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

By Puspendu Roy Karmakar Posted on July 21, 2019 Posted in Excel short tips No Comments
Short Tips#0079: Finding the reference cells is very easy

Posts pagination

Previous 1 … 12 13 14 15 16 … 36 Next
  • AI Prompt techniques (2)
  • Excel Features (65)
  • Excel for Office (24)
  • Excel Funtions (99)
  • Excel general tips (58)
  • Excel News (3)
  • Excel short tips (84)
  • Excel Tricks (55)
  • Premium Products (3)
  • Review check (1)
  • stock market (4)
  • VBA and Macro (50)
  • Video Notification (5)

Buy This Ebook from Amazon

Archives

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
Copyright © 2025 Excelabcd | Powered by Responsive Theme
Loading…