↓ 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

Author: Pushpendu Roy Karmakar

Hi! I am Pushpendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Lesson#4: What is Data Validation in Excel?

By Pushpendu Roy Karmakar Posted on November 26, 2017 Posted in Excel Features Tagged with DATA VALIDATION
Lesson#4: What is Data Validation in Excel?

In this post, we will learn the function DATA VALIDATION. This is very useful for making proper data entry. I will give a good example of where we can use it. I made a report card format in another sheet, …

Lesson#4: What is Data Validation in Excel? Read more »

Lesson#3: Showing percentage, learning function MAX, function MIN

By Pushpendu Roy Karmakar Posted on November 26, 2017 Posted in Excel Funtions Tagged with MAX, MIN
Lesson#3: Showing percentage, learning function MAX, function MIN

We made a table of mark sheets in the previous post; now we will learn something new. We will learn to show percentages, the function MAX, and the function MIN I have added columns on the right-hand side and put …

Lesson#3: Showing percentage, learning function MAX, function MIN Read more »

Lesson#2: Making and formatting table, SUM function, and AVERAGE functions

By Pushpendu Roy Karmakar Posted on November 26, 2017 Posted in Excel Funtions Tagged with AVERAGE, SUM
Lesson#2: Making and formatting table, SUM function, and AVERAGE functions

We will learn how to make a table with a simple mark-sheet example, and we will learn the Excel SUM and AVERAGE functions. This is a table I have made. On the left side, there are names of students, on …

Lesson#2: Making and formatting table, SUM function, and AVERAGE functions Read more »

Lesson#1: Basic operations in Excel

By Pushpendu Roy Karmakar Posted on November 26, 2017 Posted in Excel Funtions, Excel general tips Tagged with DIVISION, MULTIPLICATION, SUBTRACTION
Lesson#1: Basic operations in Excel

OK friends. This is going to be my first lesson. The ABCD of Excel starts here. We will learn how to perform basic operations in Excel. How to add, subtract, multiply, and divide two numbers. This picture now shows how …

Lesson#1: Basic operations in Excel Read more »

Introduction: The first post

By Pushpendu Roy Karmakar Posted on November 26, 2017 Posted in Excel general tips
Introduction: The first post

Why Excel? Microsoft Excel is a very powerful software developed by Microsoft Inc. It’s a spreadsheet software where we can make any type of data calculation, chart, or graph preparation. It is very much useful and widely used in offices …

Introduction: The first post Read more »

Posts pagination

Previous 1 … 35 36 37
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
Copyright © 2026 Excelabcd | Powered by Responsive Theme
Loading…