Your cart is currently empty!
Tag: Excel Functions
-
What is the RANDARRAY Function in Excel 365?
The RANDARRAY function generates an array of random numbers. You can define the number of rows and columns, the minimum and maximum values, and whether you want whole numbers or decimals. It’s part of the dynamic array functions introduced in Excel 365 and is useful for simulations, testing, data sampling, random list creation, and more.…
-
What is the REDUCE Function in Excel 365?
The REDUCE function is a Lambda helper function introduced in Excel 365. It allows you to loop through an array, applying a formula to each element, and accumulate a single result (like a running total or combined value). Think of it like a fold or accumulator function in programming — it starts with an initial…
-
Master the XMATCH Function in Excel 365
📘 What is the XMATCH Function in Excel? The XMATCH function is a modern alternative to MATCH, introduced in Excel 365 and Excel 2021. It returns the relative position of an item in a row or column. Unlike MATCH, it supports reverse search, wildcard matching, and exact or approximate search modes. 🔧 Syntax of XMATCH…
-
How to Use SORT and SORTBY Functions in Excel 365
The SORT and SORTBY functions in Excel 365 are part of the dynamic array family — they allow you to sort data easily, flexibly, and without altering the original range. 🧠 1. SORT Function in Excel 🔧 Syntax: Argument Description array The range or array to sort sort_index Column or row number to sort by…
-
Excel 365 TAKE Function Explained: Extract Top or Bottom Rows Easily
The TAKE function in Excel 365 is one of the powerful Dynamic Array functions introduced to make data extraction easier and cleaner. 🧠 What is the TAKE Function? The TAKE function allows you to extract a specific number of rows or columns from the beginning or end of a range or array. It’s extremely useful…
-
UNIQUE Function in Excel 365 – Explained with Examples
The UNIQUE function in Excel 365 is a game-changing tool that helps you extract distinct or unique values from a list or range — instantly and dynamically. It’s part of Excel’s new dynamic array functions, introduced in Excel 365 and Excel for the web. 📘 What is the UNIQUE Function? The UNIQUE function returns a…
-
ISOMITTED Function in Excel 365 – Complete Guide
Learn how to use the ISOMITTED function in Excel 365 to handle optional parameters inside LAMBDA functions. Discover how to build smarter, reusable custom functions with real-world examples and practical use cases.
-
Excel 365 LAMBDA Function Explained: Make Your Own Formulas Without VBA
The LAMBDA function in Excel 365 is a powerful and advanced feature that allows you to create custom functions without VBA or macros. It’s like writing your own Excel formula and saving it as a function you can reuse across the workbook. Let’s walk through it step by step with simple explanations and examples. 🧠…
-
How to Use the LET Function in Excel 365 (Step-by-Step with Examples)
The LET function is one of the powerful new additions in Excel 365, designed to make complex formulas easier to read, write, and optimize. 🧠 What is the LET Function in Excel? The LET function allows you to: This makes formulas cleaner, faster, and more efficient—especially when repeating the same expressions. 🧪 Syntax of the…
-
Solve Quadratic Equations in Excel: Step-by-Step with Physics-Based Case Study
📚 Real-Life Scenario: Ritu’s Physics Assignment Ritu, a B.Sc. student in Delhi University, is working on a Physics assignment involving projectile motion. The equation for the height of a projectile is: She needs to find when the object hits the ground — that is, when h(t) = 0. This leads to a quadratic equation, and…
-
What is the STOCKHISTORY Function?
The STOCKHISTORY function in Excel 365 allows you to pull historical stock prices (or other financial instruments) directly from Excel’s data service — without needing external plugins or manual downloads. 📌 Available only in: 🔧 Syntax of STOCKHISTORY 📘 Arguments Explained: Argument Description stock Stock ticker symbol or company name. For example: “TCS.NS”, “AAPL” start_date…
-
How to Create a User Defined Function in Excel to Identify Triangle Types
🧠 Storytime: Why Rohan and Meera Needed a Triangle Function in Excel Rohan and Meera are engineering students in Pune. While working on a school project about geometry and architecture, they had to classify different types of triangles based on side lengths. They had a long list of side measurements in Excel. Typing the triangle…