↓ 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: MOD

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#147: How to get color code in Excel
VBA and Macro

Lesson#147: How to get color code in Excel

Pushpendu Roy Karmakar Apr 19, 2021 Tagged with MOD

Hello friends! How are you? Just working on a simple thing. I was making some easy …

Lesson#147: How to get color code in Excel Read more →

Short Tips#0003: Finding exact middle character(s) of text
Excel short tips

Short Tips#0003: Finding exact middle character(s) of text

Pushpendu Roy Karmakar Jul 20, 2018 Tagged with IF, LEN, MID, MOD

Lesson#79: Automatic changing Excel sheet color every second
Excel Tricks, VBA and Macro

Lesson#79: Automatic changing Excel sheet color every second

Pushpendu Roy Karmakar May 29, 2018 Tagged with CONDITIONAL FORMATTING, MOD, NOW, SECOND

Let me show you how to make a spreadsheet that changes its color every second automatically. …

Lesson#79: Automatic changing Excel sheet color every second Read more →

Lesson#78: Change the color of the whole sheet every minute in Excel
Excel Tricks

Lesson#78: Change the color of the whole sheet every minute in Excel

Pushpendu Roy Karmakar May 27, 2018 Tagged with CONDITIONAL FORMATTING, MINUTE, MOD, NOW

Now I will show how to make a spreadsheet that changes its color every minute automatically. …

Lesson#78: Change the color of the whole sheet every minute in Excel 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#22: How to find the exact middle character(s) of text using LEN
Excel Funtions, Excel Tricks

Lesson#22: How to find the exact middle character(s) of text using LEN

Pushpendu Roy Karmakar Dec 22, 2017 Tagged with IF, LEN, MID, MOD

LEN is a function that is used for finding out the number of characters in a …

Lesson#22: How to find the exact middle character(s) of text using LEN Read more →

Lesson#19: How to convert digit into word in excel
Excel Funtions, Excel Tricks

Lesson#19: How to convert digit into word in excel

Pushpendu Roy Karmakar Dec 16, 2017 Tagged with CONCATENATE, IF, MOD, SUM, VLOOKUP

In this lesson, we will learn a method to convert digits into words. I will use …

Lesson#19: How to convert digit into word in excel Read more →

Lesson#18: What is MOD function?
Excel Funtions

Lesson#18: What is MOD function?

Pushpendu Roy Karmakar Dec 14, 2017 Tagged with MOD

MOD function returns the remainder after dividing a number with a divisor. Syntax of the function …

Lesson#18: What is MOD function? Read more →

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…