How to Count Non Blank Cells in Excel – 3 Quick Ways
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…
Excel TEXTBEFORE function – extract text before character (delimiter)
In this tutorial you’ll learn how to use the TEXTBEFORE function in Excel to quickly get the text before a specific character or word.In older versions of Excel, this was more difficult. You had to…
Spill Ranges in Excel: Dynamic Formulas Made Easy
This tutorial breaks down the concept of “spill range” in simple terms and clears up common doubts.Spilling is a feature in Excel 365 that works with dynamic arrays. Knowing a few key terms will help…
Excel TOCOL function – convert range to single column
Excel has long allowed you to switch data between rows and columns. But turning a whole range of cells into a single column used to be difficult. That has now changed. Microsoft has introduced a…
Excel IMAGE function – quick way to insert picture in cell with formula
Learn an easy way to add pictures directly into a cell using the new IMAGE function! For a long time, adding pictures to Excel was tricky and time-consuming. But now, with the IMAGE function, you…
Practice MODE and MODEIF Function Online In Excel
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…
Practice EOMONTH & EDATE Function Online in Excel
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…
Practice TODAY & NOW Function Online in Excel
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…
Practice WEEKDAY Function Online in Excel
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…
Practice WEEKNUM Function Online in Excel
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…
Practice WORKDAY & WORKDAY.INTL Function Online in Excel
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…
Practice VLOOKUP Function Online in Excel
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…
Practice COUNTIF & COUNTIFS Function Online in Excel
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…
Practice SUMIF & SUMIFS Function Online in Excel
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…
Excel Formulas and Functions with Online Practice Files
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…
Practice XLOOKUP Function Online in Excel
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
Practice Date Function Online in Excel
Use Excel’s DATE function when you need to take three separate values and combine them to form a date.
How to Count Blank Cells in Excel – 3 Easy Ways
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”…
View Two Worksheets Side by Side in Excel – 2 Easy Methods
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…
How to Print Row Header on Each Page in Excel – 3 Easy Ways
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…
How to Group Worksheets in Excel – 3 Easy Methods
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…