Your cart is currently empty!
Category: Excel Training
-
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…
-
How to Read and Write Excel Files in Node.js with the SheetJS (xlsx) Library
To read and write Excel files in Node.js, the most popular library is xlsx (from the SheetJS project). It supports .xlsx, .xls, and .csv formats and is easy to use. ✅ Step-by-Step Guide to Read & Write Excel Files in Node.js 📦 Step 1: Install the xlsx Package Run the following command: 📘 Example: Writing…
-
How to Convert JSON to Excel File Using JavaScript (Step-by-Step Guide)
✅ What is JSON and Why Convert It to Excel? Converting JSON to Excel allows users to: 🛠 Tool Required: SheetJS (xlsx Library) SheetJS is the most popular JavaScript library for working with Excel files. It works in both browser and Node.js environments. 💻 1. Using SheetJS in Browser (Client-Side) Step 1: Include the Library…