↓ 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#207: How to Keep an Excel File Always Saved
VBA and Macro

Lesson#207: How to Keep an Excel File Always Saved

Pushpendu Roy Karmakar Jul 5, 2023

In today’s fast-paced digital world, protecting our data is critical. When working with Excel files, it’s …

Lesson#207: How to Keep an Excel File Always Saved Read more →

Lesson#206: Three Effective Methods to Recover an Excel Workbook
Excel general tips

Lesson#206: Three Effective Methods to Recover an Excel Workbook

Pushpendu Roy Karmakar Jun 25, 2023

Microsoft Excel is an indispensable tool used by millions of professionals, students, and individuals to organize …

Lesson#206: Three Effective Methods to Recover an Excel Workbook Read more →

Lesson#205: How to extract all sheet names from an Excel file
VBA and Macro

Lesson#205: How to extract all sheet names from an Excel file

Pushpendu Roy Karmakar Jun 25, 2023

Step 1: Open the Excel file and access the VBA editor Open the Excel file that …

Lesson#205: How to extract all sheet names from an Excel file Read more →

Lesson#204: Make any calendar in excel with VBA
VBA and Macro

Lesson#204: Make any calendar in excel with VBA

Pushpendu Roy Karmakar Feb 20, 2023

If you need to create a monthly calendar in Excel, VBA can be a powerful tool …

Lesson#204: Make any calendar in excel with VBA Read more →

Lesson#203: How to make an SWP calculator in Excel?
Excel for Office

Lesson#203: How to make an SWP calculator in Excel?

Pushpendu Roy Karmakar Feb 10, 2023 Tagged with CALCULATOR, CHART, IF, MOD, VLOOKUP

A systematic Withdrawal Plan (SWP) is a popular investment strategy for retirees who want to receive …

Lesson#203: How to make an SWP calculator in Excel? Read more →

Lesson#202: How to Make a Mortgage Calculator in Excel?
Excel Features

Lesson#202: How to Make a Mortgage Calculator in Excel?

Pushpendu Roy Karmakar Feb 4, 2023 Tagged with CALCULATOR, IPMT, PMT, PPMT

A mortgage calculator is a useful tool for home buyers, real estate agents, and mortgage lenders …

Lesson#202: How to Make a Mortgage Calculator in Excel? Read more →

What are the Necessities to Buy an Original Business 365 Office?
Excel general tips

What are the Necessities to Buy an Original Business 365 Office?

Pushpendu Roy Karmakar Feb 1, 2023

Introduction: In today’s fast-paced business world, having the right tools to help manage your work efficiently …

What are the Necessities to Buy an Original Business 365 Office? Read more →

Lesson#201: How to Make a Loan Repayment Schedule in Excel?
Excel for Office

Lesson#201: How to Make a Loan Repayment Schedule in Excel?

Pushpendu Roy Karmakar Jan 29, 2023 Tagged with IPMT, PMT, PPMT

A loan repayment schedule is a tool for the calculation of Loan EMI. Use it to …

Lesson#201: How to Make a Loan Repayment Schedule in Excel? Read more →

Lesson#200: What is a percentage calculator in Excel?
Excel for Office

Lesson#200: What is a percentage calculator in Excel?

Pushpendu Roy Karmakar Jan 29, 2023 Tagged with CALCULATOR

A percentage calculator is a tool used to perform mathematical calculations involving percentages. It can be …

Lesson#200: What is a percentage calculator in Excel? Read more →

Lesson#199: How to make a SIP Calculator in Excel
Excel for Office

Lesson#199: How to make a SIP Calculator in Excel

Pushpendu Roy Karmakar Jan 27, 2023 Tagged with CALCULATOR, FV

Systematic Investment Plan (SIP) is a popular way of investing in mutual funds. It allows investors …

Lesson#199: How to make a SIP Calculator in Excel Read more →

Posts pagination

Previous 1 … 6 7 8 9 10 … 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…