One of my subscribers attended an interview for an MIS Executive position, and the interviewer asked him a question. He was given an Excel sheet and instructed to apply VLOOKUP to alternate rows, meaning some rows contain data while others do not. He needed to pull data for the blank rows from another sheet using … Read more
If you are applying Filter in Your data in Excel, but filter is not working in your excel file, then here in the below video i have provided a best solution for it. You have to change the pattern of applying the filter. you just need to select your all data first then apply filter … Read more
Tutorial Video Download Excel File More Excel Projects
Tutorial Video Download Excel File More Excel Projects
Tutorial Video Download Excel File More Excel Projects
Tutorial Video Download Excel File More Excel Projects
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