Skip to content
ExcelSirJi
  • Excel Functions
  • Excel Courses
  • Latest BlogsExpand
    • EXCEL SHORTCUTS
    • EXCEL FOR BEGINNERS
    • ADVANCED EXCEL
    • DATA ANALYSIS
    • EXCEL CHARTS & GRAPHS
    • EXCEL VBA & MACROS
    • PRODUCTIVITY TRICKS
  • Hire Us
DOWNLOADS
ExcelSirJi
count non blank cells in excel
Excel Functions

How to Count Non Blank Cells in Excel – 3 Quick Ways

ByAnshu Taneja

Count Non Blank Cells in Excel helps you to ignore blank ones and focus only on cells with values that matter to you. Some cells in an Excel worksheet may look blank but aren’t actually…

Read More How to Count Non Blank Cells in Excel – 3 Quick WaysContinue

Practice Mode and Modeif
Excel Functions

Practice MODE and MODEIF Function Online In Excel

BySumit Shrimal

Watch: How to use MODE & MODEIF Function in Excel? What is MODE Function? In Excel, the “MODE” function is a statistical tool that identifies and returns the most frequently occurring value within a set…

Read More Practice MODE and MODEIF Function Online In ExcelContinue

practice eomonth
Excel Functions

Practice EOMONTH & EDATE Function Online in Excel

BySumit Shrimal

Watch: How to use EOMONTH & EDATE Function in Excel? What is EOMONTH Function? The EOMONTH function in Excel returns the last day of a month based on a given date and a specified number of…

Read More Practice EOMONTH & EDATE Function Online in ExcelContinue

practice today and now
Excel Functions

Practice TODAY & NOW Function Online in Excel

BySumit Shrimal

Watch: How to use TODAY & NOW Function in Excel? What is TODAY Function? The TODAY function in Excel returns the current date in a serial number format. Click here to Read full Tutorial What is…

Read More Practice TODAY & NOW Function Online in ExcelContinue

weekday practice
Excel Functions

Practice WEEKDAY Function Online in Excel

BySumit Shrimal

Watch: How to use WEEKDAY Function in Excel? What is WEEKDAY Function? In Excel, the WEEKDAY function returns the day of the week for a given date as a number Click here to Read Full…

Read More Practice WEEKDAY Function Online in ExcelContinue

practice weeknum
Excel Functions

Practice WEEKNUM Function Online in Excel

BySumit Shrimal

Watch: How to use WEEKNUM Function in Excel? What is WEEKNUM Function? The WEEKNUM function in Excel returns the week number of a given date. It is a DATE and TIME function that can be…

Read More Practice WEEKNUM Function Online in ExcelContinue

practice workday
Excel Functions

Practice WORKDAY & WORKDAY.INTL Function Online in Excel

BySumit Shrimal

Watch: How to use WORKDAY & WORKDAY.INTL Function in Excel? What is WORKDAY Function? The WORKDAY function in Excel calculates a date that is a specified number of working days before or after a given date. It…

Read More Practice WORKDAY & WORKDAY.INTL Function Online in ExcelContinue

vlookup practice
Excel Functions

Practice VLOOKUP Function Online in Excel

BySumit Shrimal

Watch: How to use VLOOKUP Function in Excel? What is VLOOKUP Function? The VLOOKUP function in Excel searches for a value in a table and returns a corresponding value from another column in the same row…

Read More Practice VLOOKUP Function Online in ExcelContinue

practice countif
Excel Functions

Practice COUNTIF & COUNTIFS Function Online in Excel

BySumit Shrimal

Watch: How to use COUNTIF & COUNTIFS Function in Excel? What is COUNTIF Function? In Excel, “COUNTIF” counts the number of cells within a range that meet a single specified criteria. Click here to Read…

Read More Practice COUNTIF & COUNTIFS Function Online in ExcelContinue

practice sumif
Excel Functions

Practice SUMIF & SUMIFS Function Online in Excel

BySumit Shrimal

Watch: How to use SUMIF & SUMIFS Function in Excel? What is SUMIF Function? The SUMIF function in Excel adds up values in a range of cells that meet certain criteria. Click here to Read Full…

Read More Practice SUMIF & SUMIFS Function Online in ExcelContinue

Online Excel Formulas and Functions Training
Excel Functions

Excel Formulas and Functions with Online Practice Files

Byexcelsirji

Discover free videos and tutorials to master Excel formulas and functions. Practice directly in our Online Excel Practice Files without downloading anything. Have questions? Drop them in the comments. Let’s begin! Basic Excel Formulas and…

Read More Excel Formulas and Functions with Online Practice FilesContinue

practice xlookup
Excel Basics

Practice XLOOKUP Function Online in Excel

Byexcelsirji

XLOOKUP can find a value that matches exactly or is the closest approximation. It can also look to the left, right, or both, which is an alternative to the VLOOKUP function

Read More Practice XLOOKUP Function Online in ExcelContinue

Date
Excel Basics

Practice Date Function Online in Excel

BySumit Shrimal

Use Excel’s DATE function when you need to take three separate values and combine them to form a date.

Read More Practice Date Function Online in ExcelContinue

Count blank cells in excel
Excel Basics

How to Count Blank Cells in Excel – 3 Easy Ways

ByAnshu Taneja

The only thing worse than wrong data in your spreadsheet is Empty Cells. If these blanks aren’t filled, they can cause problems when using formulas. I usually fill these empty cells with 0 or “NA”…

Read More How to Count Blank Cells in Excel – 3 Easy WaysContinue

view two worksheets side by side
Excel Basics

View Two Worksheets Side by Side in Excel – 2 Easy Methods

ByAnshu Taneja

View two worksheets Side-by-Side in Excel lets you view multiple worksheets at once in layouts like vertical, horizontal, tiled, or cascade, so you don’t have to keep switching between sheets. You can also split a…

Read More View Two Worksheets Side by Side in Excel – 2 Easy MethodsContinue

Print Row header on each page in excel
Excel Basics

How to Print Row Header on Each Page in Excel – 3 Easy Ways

ByAnshu Taneja

Print Row Header on Each Page in Excel means that when you print your worksheet, the selected row (often the top row with column headers) will repeat at the top of every printed page. This ensures…

Read More How to Print Row Header on Each Page in Excel – 3 Easy WaysContinue

group worksheet in excel
Excel Basics

How to Group Worksheets in Excel – 3 Easy Methods

ByAnshu Taneja

Group worksheets in Excel makes it easier to manage a big workbook. This feature allows you to treat multiple worksheets as one, helping you perform identical tasks like formatting or data entry across several sheets…

Read More How to Group Worksheets in Excel – 3 Easy MethodsContinue

undo in excel
Excel Basics

How to Undo in Excel – 3 Easy and Quick Ways

ByAnshu Taneja

Undo in excel very useful If you’re new to Excel or even if you’ve been using it for a while, you’ve probably made a mistake on a spreadsheet. Mistakes happen a lot, especially when working…

Read More How to Undo in Excel – 3 Easy and Quick WaysContinue

remove password from excel
Excel Basics

How to Remove Password from Excel – 2 easy methods

ByAnshu Taneja

While passwords in Excel help protect data, there are times when you may need to remove them to make changes, like modifying the workbook structure or editing data. This tutorial explains six methods to remove…

Read More How to Remove Password from Excel – 2 easy methodsContinue

Turn Off Scroll Lock in excel
Excel Basics

Turn Off Scroll Lock in Excel – 4 Easiest and Quick Ways

ByAnshu Taneja

Scroll Lock in Excel can make scrolling, selecting cells, checking formulas, entering data, and recording macros harder. So, you might need to turn it off to work normally. In this article, we’ll show you how…

Read More Turn Off Scroll Lock in Excel – 4 Easiest and Quick WaysContinue

Lock columns in excel
Excel Basics

Lock a Column in Excel – 3 Easy and Simple Methods

ByAnshu Taneja

Microsoft Excel lets you share your spreadsheets with others, but sometimes your co-workers might edit the wrong column by mistake. To avoid this, you can lock specific columns. In this guide, we’ll show you how…

Read More Lock a Column in Excel – 3 Easy and Simple MethodsContinue

Page navigation

1 2 3 … 11 Next PageNext
DMCA.com Protection Status
  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2025 ExcelSirJi

Scroll to top
  • Excel Functions
  • Excel Courses
  • Latest Blogs
    • EXCEL SHORTCUTS
    • EXCEL FOR BEGINNERS
    • ADVANCED EXCEL
    • DATA ANALYSIS
    • EXCEL CHARTS & GRAPHS
    • EXCEL VBA & MACROS
    • PRODUCTIVITY TRICKS
  • Hire Us
Search