↓ 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

Excel for Office

Lesson#167:11 tips to work like Pro in Excel
Excel for Office, Excel general tips

Lesson#167:11 tips to work like Pro in Excel

Pushpendu Roy Karmakar Nov 13, 2022 Tagged with CHART, CONDITIONAL FORMATTING, DATA VALIDATION, SHORTCUTS

Are you an Excel user? If so, check out these 11 tips to work like a …

Lesson#167:11 tips to work like Pro in Excel Read more →

Lesson#166: Why Microsoft Excel Is Still the Most Useful Software?
Excel for Office, Excel general tips

Lesson#166: Why Microsoft Excel Is Still the Most Useful Software?

Pushpendu Roy Karmakar Nov 10, 2022 Tagged with CHART, CONDITIONAL FORMATTING, DATA VALIDATION, SHORTCUTS

Excel is one of the most useful and underrated pieces of software out there. Yes, it …

Lesson#166: Why Microsoft Excel Is Still the Most Useful Software? Read more →

Lesson#164: How to easily create a mail merge in Word from Excel – step by step
Excel for Office

Lesson#164: How to easily create a mail merge in Word from Excel – step by step

Pushpendu Roy Karmakar Oct 16, 2022 Tagged with Mail Merge, Microsoft Word

Hello friends! I hope you all are very well. Today we shall go a little outside …

Lesson#164: How to easily create a mail merge in Word from Excel – step by step 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 →

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#88: How to make a Salary slip format from Employee Database
Excel Features, Excel for Office, Excel Funtions

Lesson#88: How to make a Salary slip format from Employee Database

Pushpendu Roy Karmakar Jul 1, 2018 Tagged with DATA VALIDATION, VLOOKUP

So, my friend, I will here discuss an important lesson which is really required for office …

Lesson#88: How to make a Salary slip format from Employee Database Read more →

Lesson#87: How to make month wise auto-updating program schedule
Excel for Office, Excel Tricks

Lesson#87: How to make month wise auto-updating program schedule

Pushpendu Roy Karmakar Jun 26, 2018 Tagged with CONDITIONAL FORMATTING, DATE, EOMONTH, FORMAT CELLS, IF, MONTH, YEAR

Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating Gantt chart …

Lesson#87: How to make month wise auto-updating program schedule Read more →

Lesson#77: Scope the breakup program schedule and explain the formula
Excel for Office

Lesson#77: Scope the breakup program schedule and explain the formula

Pushpendu Roy Karmakar May 24, 2018 Tagged with AND, CONDITIONAL FORMATTING, EOMONTH, IF, MONTH, NOT, OR, SUM, YEAR

Here I have got a case where my colleague was working with a project schedule. He …

Lesson#77: Scope the breakup program schedule and explain the formula Read more →

Lesson#75: Get a new fresh formatted sheet every time when you click the button
Excel for Office, Excel Tricks, VBA and Macro

Lesson#75: Get a new fresh formatted sheet every time when you click the button

Pushpendu Roy Karmakar May 1, 2018

Hello friend. In this post, I will show how to get a new fresh formatted sheet …

Lesson#75: Get a new fresh formatted sheet every time when you click the button Read more →

Lesson#56: How to make birthday reminder in excel
Excel Features, Excel for Office, Excel Tricks

Lesson#56: How to make birthday reminder in excel

Pushpendu Roy Karmakar Mar 2, 2018 Tagged with AND, DAY, FORMAT CELLS, IF, MONTH, PIVOTTABLE, TODAY

Here I am having an employee database and I have to make a birthday reminder in …

Lesson#56: How to make birthday reminder in excel Read more →

Posts pagination

Previous 1 2 3 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…