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 Download More Excel Files
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 Download More Excel Files
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 Download More Excel Files
Today i will show you that how to make automatically checkmark and cross mark symbol in excel while making a payment receivable list for your company. Watch This Video to Learn Download More Excel Files
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” option Step … 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 Startup” option Step … Read more
In this video, i will teach you a very amazing use of Condition Formatting Command and Countif Formula. you can highlight particular data automatically by entering your value in an excel cell. Watch This Video to Learn Download More Excel Files
Usually, research paper topics are given to students by professors and teachers during their course. Sometimes students are given the option to come up with their own topics. The topic chosen for research is of paramount importance. It should be a topic that is simple, interesting and at the same time related to the purpose … Read more
Hi, here in below video i have explained that how can we calculate sales commission in excel sheet using if-else formula. also, we will use the pivot table function to calculate total sales and total commission amount of every person. Watch This Video to Learn Download More Excel Files
Installment or Repayment Schedule Chart – A Smart Financial Tool Here below down you can download the EMI calculator in Excel format, which will help you to calculate the EMI of Any Loan Like-Home, Car Loan, Personal Loan, etc. So below is the screenshot for the EMI Calculator in Excel Sheet. EMI Calculator in Excel … Read more
In this video, i have explained how to use the “FormulaText” function in excel. Watch This Video to Learn Download More Excel Files