In this tutorial I have explained an efficient method for performing bank reconciliation in Excel by comparing exported Tally data with bank statement entries using Pivot Tables. The process begins by consolidating both datasets into a single sheet, where entries are clearly labeled as “As per Tally” or “As per Bank” to distinguish the sources. … Read more
VLOOKUP is one of the most powerful and commonly used functions in Excel, especially for searching and matching data from large tables. It helps users quickly find values from one column and return related information from another column within the same dataset. This function is extremely useful for tasks like employee records, billing, inventory management, … Read more
If you’re managing projects in Excel and want a visual representation of your project timelines, creating a Gantt chart with conditional formatting is a slick move. Here’s how you can do it like a pro. A Gantt chart is basically a bar chart that shows project timelines. It helps you visualize when projects start, how long … Read more
Download Excel File More Excel Projects Automatic Right Tick (✅) & Cross Tick (❌) in Excel Using IF Formula Excel is a powerful tool for data analysis and reporting, and sometimes we want to make our reports more visual and easy to understand. Instead of just writing Accept or Reject, you can use … Read more
Download Excel File More Excel Projects When working with financial reports, sales data, or dashboards in Excel, you often deal with large numbers. Writing them in full form (like 36,731,702) makes reports look bulky and harder to read. Instead, you can convert them into short formats like Cr (Crore), L (Lakh), and K … Read more
There are 2 ways to make Index automatically in Excel for All Excel Sheets – One is by VBA code and another by Hyperlink formula. 1. Create Automatic Index Sheet of All Sheets in Excel Using VBA VBA Code: Sub CreateCustomIndex() Dim wsIndex As Worksheet Dim ws As Worksheet Dim i As Long Dim … Read more
Download Excel File More Excel Projects Excel Conditional Formatting: Color Negative Numbers Red and Positive Numbers Green (With Formula) In Excel, Conditional Formatting allows users to visually highlight data based on specific rules. One popular use case is to color-code positive and negative numbers — for example: ✅ Positive numbers → Green ❌ … Read more
Download Excel File More Excel Projects How to Extract RTGS/UPI/NEFT Number in Excel Using MID and FIND If you have a value like the following in your Excel cell: DRY RTGS/306017054099/MANNAT You can extract the RTGS number (which is 306017054099 in this example) using the following Excel formula: =MID(C13, FIND(“RTGS/”, C13) + 5, … Read more
Download Excel File Download Word File More Excel Projects Mail Merge is a powerful feature that allows users to create personalized documents, such as letters, labels, and envelopes, by linking a Microsoft Word document with an Excel data source. This tutorial will guide you through the process of performing a Mail Merge using … Read more
Download Excel File More Excel Projects When you’re working in Excel, formulas are designed to calculate numerical values. If you manually enter symbols like a currency sign (Rs., $, €) or measuring units (Ltr., Kg) directly into the cell, Excel treats the entire entry as text instead of a number. Text values cannot be … Read more
Highlighting the active row and column in Excel can make it much easier to visualize data and stay focused while working on large spreadsheets. This feature allows you to automatically highlight the row and column of the currently selected cell, helping you track your position in the spreadsheet effortlessly. Below, we’ll walk you through how … Read more
Excel offers powerful tools to handle time-related calculations. If you’re looking to calculate the difference between two times or sum hours and minutes, Excel provides easy solutions. Calculating Time Difference in Excel To find the time difference between two points, use a simple subtraction formula. For example: Enter the start time in cell A1 (e.g., … Read more