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
=IF else( ) Amazing Formula in Excel (Sales Man Commission Formula in Excel in Hindi) Watch This Video to Learn Download More Excel Files
This is Pivot Table Part-4 Video, This is a perfect example to understand the pivot table as you can check the video. I have explained many more thing in this video that will help to understand you better. I will surely upload more videos on the pivot table soon. Below 4 Query has been Resolved … Read more
Top 3 Formula to Change Case with =upper( ) =Lower( ) = Proper( ) in Excel Watch This Video to Learn Download More Excel Files