Here in this video, i have explained that how to compare two data lists in excel and extract the unmatched data in a new sheet. so watch this video completely to learn how to match 2 data in an excel sheet. Watch This Video to Learn
Fill justify is a lifesaver option. The single-core motive to use fill justify in Excel is to merge the data from multiple cells…..into a single cell. And, if you have any other idea to merge text into one cell, leave it. Fill justify is a better option. So today, in this post, you will learn … Read more
In this video, i have explained that how can you copy visible cell’s data and paste to another area in excel. Mostly in Filter, it happens that when doing filter and copy the filtered cells and paste to another area, all data appears after pasting, but we want only visible filtered data to another area … Read more
Here in this video, i have explained that how can you merge 2 excel data in one excel sheet. I have taken an example of the Big Attendance sheet of a company, there i need to merge the Attendance sheet with Leave avail sheet and finalize a data with the merge sheet. so how it … Read more
Hi, in this video i have explained that how to save data from one sheet to another sheet in excel via Macro Function, So i have taken the Passport Application form data in excel to make it understand. so watch this video and learn. Watch This Video to Learn
In this video, i have explained how to draw excel data from the next line to the same link as you want. you just need to replace your symbol by Ctrl+J shortcut because Ctrl +J is the shortcut for replacing the ENTER button from the next line. you just need to watch this video to … Read more
Here in this video, i have explained how to convert your excel data from Horizontal format to Vertical format in one line within a very short time. Watch This Video to Learn
Today in this video i will teach you how to make your own Printing Button or Print Preview button in Excel with VBA Code and with Developer Tab in Excel. Watch This Video to Learn
Hi in this video i have explained that how can we import or copy all the files name from a folder to excel. so here is the shortcut to copy all the files path is – Select all files by doing Ctrl+A, then press Alt+Shift+Right Click from mouse then click on “Copy as Path” then … Read more
Here i will show you how to use the if-else formula in Pivot Table in Excel and also how to use Condition Formatting in Pivot Table. Watch This Video to Learn
Here is the Preview of this TDL file How to Install the TDL File in Tally Step 1. Go to Gateway of Tally. Step 2. Then Press Ctrl+Alt+T button Step 3. Now Press F4 Button or Click on “Manage Local TDL” button Step 4. Now do “Yes” to “Loan TDL Files on Startup” … Read more
Here is the Preview of this TDL file . How to Install the TDL File in Tally Step 1. Go to Gateway of Tally. Step 2. Then Press Ctrl+Alt+T button Step 3. Now Press F4 Button or Click on “Manage Local TDL” button Step 4. Now do “Yes” to “Loan TDL Files on … Read more