Excel Functions: An easy-to-follow guide to using functions in Microsoft Excel. Learn how to do quick calculations, analyze information, and solve common tasks with built-in functions like SUM, AVERAGE, and VLOOKUP. Great for beginners who want to work with data more easily and efficiently.
This tutorial explains how to use the new TEXTSPLIT function in Excel 365 to break text into separate parts using any symbol or space you choose. Sometimes, you may need to split text in Excel….
This tutorial will introduce you to a new Excel 365 dynamic array function named CHOOSECOLS and show how you can use it to extract any specific columns from an array. Imagine that you are working…
In this tutorial, you will learn 3 effective approaches How to Extract First Line in Excel of text. formulas, regex. In data analysis, Excel is a powerful tool that helps make difficult tasks easier. One…
An easy way to transform an array or range into a column with the TOCOL function. The ability to transpose data from columns to rows and in reverse has been in Excel for quite a…
Discover an incredibly easy way to insert a picture into a cell using the IMAGE function! For years, Microsoft Excel users had to go through a long and tricky process to add pictures to worksheets….
In this tutorial, we will explore the CHOOSEROWS function in Excel 365 and how to use it in real life. Imagine you have a big Excel sheet with hundreds of rows, and you need to…
Do you work with lots of data in Excel? Sorting, summarizing, and organizing information can take time. You may have used features like outlines, subtotals, or pivot tables before. But now, there’s an even simpler…
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…
Watch: How to use COUNT & COUNTA Function in Excel? What is COUNT Function? The COUNT function in Excel counts the number of cells in a range that contain numbers Click here to Read full Tutorial…
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…
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…
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…
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…
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…
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…
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…
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…
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…
This tutorial introduces XLOOKUP, a new function in Excel for both vertical and horizontal lookups. Tasks that used to feel super complicated, like left-side lookups, finding the last match, or using VLOOKUP with multiple criteria, are now much easier with XLOOKUP.
Before, you had to choose between VLOOKUP for vertical lookups, HLOOKUP for horizontal ones, or more complex options like INDEX MATCH or Power Query. But now, you don’t have to pick anymore. XLOOKUP can handle all those tasks in one simple function.
This guide shows how to use the nested IF function in Excel to check several conditions. You will also learn about other functions that can be to use than a nested formula.
When you want to make decisions in Excel, you often use an IF formula. It checks if something is true, then gives one result if it is and another result if it isn’t. If you need to check more than one thing, you can put many IFs inside each other.
Although using multiple IFs is common, it’s not the only way to check several conditions in Excel. This guide will introduce you to some easier and useful alternatives.
This quick tutorial explains the basics of external references in Excel and shows how to reference another sheet or workbook in your formulas.