↓ 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: DATA VALIDATION

Excel for Freelancers: Managing Finances and Invoices
Excel general tips

Excel for Freelancers: Managing Finances and Invoices

Pushpendu Roy Karmakar Oct 8, 2023 Tagged with CHART, CONDITIONAL FORMATTING, DATA VALIDATION, HLOOKUP, SUMPRODUCT, VLOOKUP

Introduction In the gig economy, where freelancers thrive, the ability to manage finances and invoices efficiently …

Excel for Freelancers: Managing Finances and Invoices Read more →

Lesson#233: How to Troubleshoot Excel Pivot Table Errors
Excel Features

Lesson#233: How to Troubleshoot Excel Pivot Table Errors

Pushpendu Roy Karmakar Sep 26, 2023 Tagged with DATA VALIDATION, GETPIVOTDATA, PIVOTTABLE

Microsoft Excel’s pivot tables are a powerful tool for data analysis, enabling users to summarize and …

Lesson#233: How to Troubleshoot Excel Pivot Table Errors Read more →

Revolutionize Your HR Management with the Ultimate Excel HR Template – Only $1.5!
Premium Products

Revolutionize Your HR Management with the Ultimate Excel HR Template – Only $1.5!

Pushpendu Roy Karmakar Sep 24, 2023 Tagged with CHART, CONDITIONAL FORMATTING, COUNTIF, DATA VALIDATION, SUMIF, VLOOKUP

Are you tired of drowning in paperwork and spending countless hours on HR management tasks? Do …

Revolutionize Your HR Management with the Ultimate Excel HR Template – Only $1.5! Read more →

Lesson#193: 15 Common Problems in Excel Solved
Excel general tips

Lesson#193: 15 Common Problems in Excel Solved

Pushpendu Roy Karmakar Dec 27, 2022 Tagged with CHART, DATA VALIDATION, FILTER

Excel is a powerful tool for organizing and analyzing data, but it can also be frustrating …

Lesson#193: 15 Common Problems in Excel Solved Read more →

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#106: How to VLOOKUP pictures in excel
Excel Features, Excel Funtions, Excel Tricks

Lesson#106: How to VLOOKUP pictures in excel

Pushpendu Roy Karmakar Sep 12, 2018 Tagged with DATA VALIDATION, INDEX, MATCH, NAME MANAGER

Okay, friends here I will show you some interesting tricks about Excel. That is how to …

Lesson#106: How to VLOOKUP pictures in excel Read more →

Short Tips#0042: Avoid data input error by Data Validation
Excel short tips

Short Tips#0042: Avoid data input error by Data Validation

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with DATA VALIDATION

Lesson#96: How to HLOOKUP chart from a drop-down menu in Excel
Excel Features, Excel Tricks

Lesson#96: How to HLOOKUP chart from a drop-down menu in Excel

Pushpendu Roy Karmakar Aug 15, 2018 Tagged with CHART, DATA VALIDATION

So here is another important lesson for you. How to HLOOKUP chart from a drop-down menu …

Lesson#96: How to HLOOKUP chart from a drop-down menu in Excel Read more →

Lesson#95: How to VLOOKUP chart from a drop-down menu in Excel
Excel Features, Excel Tricks

Lesson#95: How to VLOOKUP chart from a drop-down menu in Excel

Pushpendu Roy Karmakar Aug 15, 2018 Tagged with CHART, DATA VALIDATION

So that’s an important lesson for you my dear. How to VLOOKUP chart from a drop-down …

Lesson#95: How to VLOOKUP chart from a drop-down menu in Excel Read more →

Posts pagination

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…