Highlight Active Row and Column in Excel (Based on Cell Selection) How to highlight row and column when selecting a cell in excel, Row and column को कैसे highlight करें. How To Auto Highlight Row Column of Active Cell in Excel Hindi Download Project File for Practice (.xlsx) Download Formula Download Excel File Download … Read more
In the below video, i have explained the Top 5 Amazing Excel shortcut keys which will faster your speed in your office. The first shortcut is about Repeat Header in your print. The second shortcut is about adding a Percentage symbol to the existing values. Third Shortcut about Filter Data Very Quickly with a single … Read more
Whenever we export Data from Tally to excel, like sales register, purchase register, or daybook, it does not export in proper format and we could not filter our data to extract proper results. so here in the below video, i have explained how can we convert our Tally exported data in a proper format in … Read more
How To Merge Multiple Excel Files Into One (Running VBA) Excel VBA To Combine Multiple Workbooks – Transfer Data From Multiple Excel Files Consolidate Data From Multiple Files & Multiple Sheets In VBA Merge/Combine Multiple Excel Files Into One Excel File (Hindi) Vbscript To Merge Multiple Excel Files Into One Sheet VBA To Merge Multiple … Read more
Video Tutorial Download Practice File with Formula (Download.xlsx) Download Excel File Download more Excel Project File
Video Tutorial Download Practice File with Formula (Download.xlsx) Download Excel File Download more Excel Project File
Video Tutorial Download Practice File (Download.xlsx) Download Excel File Download more Excel Project Files
Calculate Minimum Value but Greater than Zero with Formula in Excel Formula: {=MIN(IF(C2:I2>0,C2:I2))} (then Press Ctrl+Shft+Enter) Video Tutorial Download Practice File with Formula (Download.xlsx) Download Excel File Download more Excel Project Files
The table in Name and Sales amount to enter the salesman name automatically in a cell with the formula in excel Raw Data Output Data Data Formula: =IF(ISNUMBER(B3),$B$2,IF(ISNUMBER(C3),$C$2,IF(ISNUMBER(D3),$D$2,IF(ISNUMBER(E3),$E$2,””)))) Video Tutorial Download Practice File with Formula (Download.xlsx) Download Excel File Download more Excel Project Files
Pricing Chart & Calculation of Petrol Conveyance with Formula in Excel Formula for Pricing: =IF(C3>1000,1.4,IF(C3>350,1.5,IF(C3>240,1.75,IF(C3>120,1.95,IF(C3>0,2.75,))))) Formula for Amount: =IF(C3>1000,1.4*C3,IF(C3>350,1.5*C3,IF(C3>240,1.75*C3,IF(C3>120,1.95*C3,IF(C3>0,2.75*C3,))))) Video Tutorial Download Practice File with Formula (Download.xlsx) Download Excel File Download more Excel Project Files
Raw Data of Daily Sales in different-different monthly Sheets Formula: =VLOOKUP(“TOTAL”,INDIRECT(B3&”!A:D”),2,0) Output After Applied formula to make Monthly Summary Video Tutorial Download Practice File with Formula (Download.xlsx) Download Excel File Download more Excel Project Files
Raw Data to Enter Kgs and Liters in Excel Cells Output Data After Applied Formula to Enter Kgs and Liters in Excel Cells Video Tutorial Download Project File with Formula (Download.xlsx) Download Excel File Download more Excel Project Files