↓ 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

Tag: IF

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#81: Making an automatic analog clock in excel with a pie chart
Excel Tricks, VBA and Macro

Lesson#81: Making an automatic analog clock in excel with a pie chart

Pushpendu Roy Karmakar May 30, 2018 Tagged with CHART, HOUR, IF, MINUTE, NOW, SECOND

Previously I had discussed how to make an analog clock with piechart in excel. I am …

Lesson#81: Making an automatic analog clock in excel with a pie chart 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#61: Making a semi analog clock with pie chart
Excel Features, Excel Tricks

Lesson#61: Making a semi analog clock with pie chart

Pushpendu Roy Karmakar Mar 15, 2018 Tagged with CHART, HOUR, IF, MINUTE, MOD, NOW, SECOND

OK friends! How is everyone? Now in this post, we will learn an unusual trick to …

Lesson#61: Making a semi analog clock with pie chart Read more →

Lesson#59: If A=1, Z=26 then calculate the value of your name
Excel Funtions, Excel Tricks

Lesson#59: If A=1, Z=26 then calculate the value of your name

Pushpendu Roy Karmakar Mar 6, 2018 Tagged with IF, LEN, MID, SUM, UPPER, VLOOKUP

This sheet can calculate the value of your name or any word by summing every letter …

Lesson#59: If A=1, Z=26 then calculate the value of your name 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 →

Lesson#52: Let’s check your lifeline with Excel
Excel Funtions, Excel general tips

Lesson#52: Let’s check your lifeline with Excel

Pushpendu Roy Karmakar Feb 25, 2018 Tagged with DATA VALIDATION, DATE, DAY, FORMAT CELLS, IF, IFERROR, MONTH, ROUND, VLOOKUP, YEAR, YEARFRAC

Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by …

Lesson#52: Let’s check your lifeline with Excel Read more →

Lesson#49: Make a parent Gantt chart from a data table
Excel Features, Excel for Office, Excel Tricks

Lesson#49: Make a parent Gantt chart from a data table

Pushpendu Roy Karmakar Feb 15, 2018 Tagged with AND, CONDITIONAL FORMATTING, COUNTIF, IF, INDEX, MATCH

Here I have to make a parent Gantt chart from a data table. It is a …

Lesson#49: Make a parent Gantt chart from a data table Read more →

Lesson#39: Cool tricks to make automatically updating Gantt chart
Excel Features, Excel Funtions, Excel Tricks

Lesson#39: Cool tricks to make automatically updating Gantt chart

Pushpendu Roy Karmakar Jan 24, 2018 Tagged with AND, CONDITIONAL FORMATTING, IF

Hi, friend today I will show you how to make an automatically updating Gantt chart without …

Lesson#39: Cool tricks to make automatically updating Gantt chart Read more →

Lesson#38: AND function in Excel
Excel Features, Excel Funtions

Lesson#38: AND function in Excel

Pushpendu Roy Karmakar Jan 24, 2018 Tagged with AND, IF

AND function is used to satisfy multiple conditions. This function checks whether all arguments are TRUE …

Lesson#38: AND function in Excel Read more →

Posts pagination

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