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 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
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
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
In this video, i have explained how to use the “FormulaText” function in excel. Watch This Video to Learn Download More Excel Files
In this video, i have explained how to use the trim formula in excel. We can remove extra space by using trim formula in excel easily. Watch This Video to Learn Download More Excel Files
In this video, i have explained how to use flash fill option in excel by extracting the name from First Name, Middle Name, Last Name. Watch This Video to Learn Download More Excel Files
Below 4 Query has been Resolved in this video:- How to Record Macro in Excel How to Create Data Save Sheet with Macro How to make Data Entry Software with Macro Creating Button with Macro Watch This Video to Learn Download More Excel Files