Excel spill range explained
This tutorial explains the idea of “SPILL Range” in easy-to-understand language and answers common questions. Spilling is a new feature in Excel 365 that comes with dynamic arrays. To use it well, it helps to…
Conditional formatting in new Outlook and web to highlight emails
Make Your Important Emails Stand Out with Conditional Formatting in the New Outlook Now available in the new Outlook and Outlook on the web, conditional formatting lets you easily color-code your emails so the important…
TEXTSPLIT function in Excel: split cells text by delimiter
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….
CHOOSECOLS function in Excel to get columns from array or range
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…
How to extract first line in Excel cell
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…
Excel EXPAND function: To grow array to specified number of rows and columns
This tutorial explains a new Excel 365 function that helps you make an array bigger to the size you want by filling it with a chosen value. Do you need to expand an array to…
Excel TOCOL function – convert range to single column
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…
Excel IMAGE function – quick way to insert picture in cell with formula
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….
CHOOSEROWS function in Excel to extract rows from array
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…
How to create timeline for Excel pivot tables and charts
This article will show you how to create a timeline for Excel PivotTables and charts, making it easy to explore your data in a fun and interactive way. Imagine you have your data neatly arranged…
Excel Quick Analysis tool with examples
In this tutorial, you will learn how to make your daily tasks easier and quickly understand your data using the Excel Quick Analysis tool. Microsoft Excel is a powerful program that helps you work with…
Excel GROUPBY function to group rows and aggregate values
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…
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 COUNT & COUNTA Function Online In Excel
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…
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…