↓ 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
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#86: Logic Gates in Excel
Excel Funtions

Lesson#86: Logic Gates in Excel

Pushpendu Roy Karmakar Jun 24, 2018 Tagged with AND, NOT, OR, XOR

So I show you here how the logic gates can be configured in Excel. AND gate …

Lesson#86: Logic Gates in Excel Read more →

Lesson#85: Adding or subtracting to Time is not same as Date in excel
Excel general tips

Lesson#85: Adding or subtracting to Time is not same as Date in excel

Pushpendu Roy Karmakar Jun 20, 2018

Hello my reader friend how are you? Hope fine. Today I will discuss a small but …

Lesson#85: Adding or subtracting to Time is not same as Date in excel Read more →

Lesson#84: Separate text in different columns easily
Excel Features, Excel general tips

Lesson#84: Separate text in different columns easily

Pushpendu Roy Karmakar Jun 15, 2018 Tagged with TEXT TO COLUMNS

Here I will discuss a very useful feature Text to Columns. We can use this feature …

Lesson#84: Separate text in different columns easily Read more →

Lesson#83: How to add a drop-down in an excel sheet
Excel Features, Excel general tips

Lesson#83: How to add a drop-down in an excel sheet

Pushpendu Roy Karmakar Jun 15, 2018 Tagged with DATA VALIDATION

I always hear a common question from beginner Excel users “How to make a drop-down menu …

Lesson#83: How to add a drop-down in an excel sheet Read more →

Lesson#82: Type in multiple sheets at one time in Excel
Excel Features, Excel Tricks

Lesson#82: Type in multiple sheets at one time in Excel

Pushpendu Roy Karmakar May 31, 2018 Tagged with SHEET

There is a nice feature in Excel by which we can type in multiple sheets at …

Lesson#82: Type in multiple sheets at one time in Excel 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#80: Make an automatically refreshing bar clock in Excel
Excel Tricks, VBA and Macro

Lesson#80: Make an automatically refreshing bar clock in Excel

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

We will learn how to make an automatically refreshing bar clock in excel. 1. First I …

Lesson#80: Make an automatically refreshing bar clock in Excel Read more →

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 →

Posts pagination

Previous 1 … 27 28 29 30 31 … 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…