Category: Excel Training
-
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…
-
Create Venn Diagrams in Excel Easily – SmartArt & Shape Methods
Creating a Venn diagram in Excel is possible, though Excel doesn’t have a built-in Venn chart type. However, you can create one manually using Shapes or with the help of SmartArt. Here’s a step-by-step guide for both methods: ✅ Method 1: Using SmartArt (Quick and Easy) This is ideal for simple, 2- or 3-circle Venn…
-
How to Quickly Insert Unique Sequence Numbers in Excel
Whether you’re managing data, creating reports, or organizing lists — inserting unique serial numbers is a common and essential task in Excel. Below are 5 easy methods to do it effectively. ✅ 1. Fill Handle (Drag Method) – Best for Short Lists Steps: 👉 Excel auto-extends the sequence: 3, 4, 5… ✅ 2. Fill Series…