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
In this article you will learn the use of the Hash symbol (#) and At the Rate symbol (@) in Excel. Actually, there are different-different use if symbols. it depends on conditions and data structure. so i have explained deeply about the use of these 2 symbols in Excel. Use of the “#” Symbol in … Read more
If you have a sales team, sales data in an Excel file and you want to calculate person-wise and team leader-wise sales amount as a summary report you can use the Sum-if formula to calculate such type of amount in Excel. just watch the below video and learn how can you make a Team Leader … Read more
If you have a long data in Excel and consume so many pages when printing. Here in the below video, i have explained how i converted 19 pages of data into 4 pages with some easy and simple tricks, so if you also have long data in Excel, then watch the below video to compress … Read more
In this video, i have explained how can you make a Star Rating System in Excel just in 1 minute. to make such type of system we have to apply 2 formulas in Excel- CHAR Formula and REPT Formula. after applying the formula we have to change the font of the cell to Wingdings Font. … Read more