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…
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…
Offset Function in Excel
In this tutorial, we’re going to explore one of the most intriguing features in Excel: the OFFSET function.
So, what is the OFFSET function in Excel? Simply put, OFFSET gives you a reference to a range of cells that’s moved from a starting point by a certain number of rows and columns.
Absolute Value in Excel – Simple steps with 4 examples
What is Absolute Value in Excel? The absolute value of a number is its distance from zero on the number line, regardless of direction, so it’s always a non-negative number. The ABS function in Excel…
How to Count Words in a cell?
How to count words in Excel using the LEN function along with other Excel functions. It also gives formulas for counting words or text, whether case-sensitive or not, in a cell or range.
Excel CHOOSE function
The tutorial explains how to use the CHOOSE function in Excel, showing you the basics and some interesting examples. While CHOOSE might seem simple on its own, when you combine it with other functions, it can be powerful. Essentially, the CHOOSE function helps you pick a value from a list based on its position. The tutorial also covers some advanced ways to use CHOOSE that you might find very useful.
Calculate and highlight 90/60/30 days from or before today in Excel
The tutorial demonstrates how to find a date any number of days before or after today, counting either all days or only business days.
How to Calculate Days Between Dates in Excel
This guide will show you quick and easy methods to find the number of days between dates in Excel.
Do you need to know how many days are between two dates? Maybe you want to find out the days between today and a date in the past or future, or just count the working days between two dates? Whatever you need, one of the examples below will help you find the solution
How to Calculate Weighted Average in Excel?
Microsoft Excel is a useful tool for analyzing data and conducting statistical research. The program includes numerous functions for performing various statistical calculations. One of the essential measures Excel supports is the weighted average.
How to calculate compound interest in Excel: daily, monthly, yearly compounding
How to use the compound interest formula in Excel and gives examples of how to calculate the future value of an investment with yearly, monthly, or daily interest. It also shows you step-by-step how to make your own Excel compound interest calculator.