The OFFSET formula in Excel is a powerful tool for creating dynamic references within your spreadsheets. Here’s a breakdown of what it does: Purpose of Offset Formula in Excel It takes a starting cell (reference) as input and then lets you specify how many rows and columns you want to move (offset) from that cell. … Read more
If you are facing issue to sum-up the timing in excel sheet then you are at the right place, here in the below video i have explained that how can you grand total of your employees timing in excel that how many hours he has worked. i also have explained that how to calculate and … Read more
Are you searching for how to maintain Monthly Rent Details in Excel for all your properties, whether it is Shop Rent, House Rent, Flat Rent, or any other property rent? Then you can download the sheet below and maintain Rent details in Excel very easily. You can watch the video to learn how it works. … Read more
Lots of people don’t know that we can make pivot tables from multiple sheets also. Yes, if you have lots of data in an Excel sheet and want to make a pivot table using these multiple Excel sheets then you can make a joint data pivot table very easily. You have to follow some steps … Read more
Ever felt the frustration of clutter in your Excel workbooks, with sheets sprawled like a messy desk that you just can’t seem to organize? That’s where mastering how to delete a worksheet in Excel becomes a game-changer. It’s not about just tidying up; it’s about streamlining your data for better efficiency and clarity. Imagine having … Read more
If you have a sales report in excel and wanted to know the over dues amount and remaining days for due then you can use this Formula in your excel sheet. This formula will show the Overdues Days in Red Color, Remaining Days for Payment in Blue color and if Amount if due for Today … Read more
Here i want to explain to you with an example of how can you pick up the Second and Third values in Excel by Vlookup. Below is my Excel data and i want to pick up the 2nd matched value and the 3rd matched value of Salesman “JOHN” with the help of vlookup formula, then … Read more
In this video, i have explained 4 Easy ways to find and remove duplicates in Excel very easily, so you have to watch this video till the end and you can download the practice file from the below-given button. Download the Practice File for Find and Remove Duplicates in Excel Download Excel File Download More
Here is the VBA Code to Add Dollar Sign “$$” in Excel Sheet by One Click with VBA Code: Sub InsertDollarSigns() Dim cellRange As Range For Each cellRange In ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas) cellRange.Formula = Application.ConvertFormula(cellRange.Formula, xlA1, xlA1, True) Next End Sub Download VBA Code Here Download this Code Download More
Here i have explained how to apply Vlookup on 7000 Entries in Excel. i have given 2 examples to explain the Vlookup formula properly, and 2 more formulas is explained in the video that is Column() formula and Row() form, which helps a lot to apply Vlookup on large data in Excel. Tutorial Video … Read more
In the below video, i have explained how can you split or separate the names in 3 words, like First Name, Middle Name, and Last Name. In this post, i have provided a sample file download option below. so that you can check the formulas in the Excel file and how i have split the … Read more
In this video, i have explained to you that how can you make bulk hyperlinks in Excel easy. There is one formula to be used as given below: =HYPERLINK(link_location, [friendly_name]) This formula used in attached Excel sheet =HYPERLINK(“https://trackcourier.io/track-and-trace/trackon-courier/”&C2,C2) Tutorial Video Download this File Download All Templates