Attendance Formula Sheet in Excel (Overtime, Leave, Half Day, Present, Absent)
Tutorial Video Download Excel File More Excel Projects
Excel Formulas
Offset Formula with Match Formula in Excel
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
Calculating Time in Excel | How to Sum Hours & Minutes in Excel
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
Rent Management in Excel (Property Rent, Shop Rent, Flat Rent, House Rent)
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
Create a Pivot Table from Multiple Sheets in Excel | Advance Feature
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
How to Delete a Worksheet in Excel: A Step-by-Step Guide
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
Debtors-Creditors Payment Overdue (Useful) Formula in Excel
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
How to use Vlookup to Pick up Second and Third Matched value in Excel
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
4 EASY Ways to Find and Remove Duplicates in Excel
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
Add Dollar Sign “$$” in Excel Sheet by One Click (in 1 Second) Apply Dollar Sign in Bulk
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
I Applied VLOOKUP on 7000 Entries in Just 1 minute in Excel
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
Separate Names in Excel (First Name – Middle Name – Last Name)
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