Are confused that how to use IF formula in excel? This formula allows users to create conditional statements, making it possible to perform different actions based on whether a certain condition is true or false. Whether you’re a student, a business professional, or simply someone looking to better organize your data, understanding the “IF” formula … Read more
Today i will teach you that if you have a small Data in Excel and you wanted to present this data to your boss or to your senior, how can you make a small report an attractive MIS Report, watch the below video to learn and if you want practice file the download from the … Read more
Here i have explained a trick that will ease your office work. you can use the Table option to drag all formulas automatically. kindly watch the video and learn the function to faster your work. Solution Video Download Project File for Practice (.xlsx) Download Excel File Download more Excel Project File
1. Merge Excel Workbooks from a Folder in One File Below is the VBA code to merge multiple excel files which are entered in a folder in “D” Drive & the Folder name is “Files”. So if your folder name is different then you can change the path according to your drive. Input Data Final … Read more
Here i have explained, if the amount in our excel increases by a value then it becomes green and if the amount decreases by value then it becomes Red, how we can do this in excel? if you want to know then You can watch the below given video- Solution Video Download Project File for … Read more
If Date function not working in excel excel shows #### instead of date excel not recognizing date format dd/mm/yyyy how to fix date format in excel how to change date format in excel to dd/mm/yyyy excel date showing as number excel format date formula formula to change date format in excel bank statement date problem … Read more
Divide a number into random parts excel, how to distribute a number proportionally in excel divide a number into n parts in excel how to divide all cells by a number in excel split a number into random parts. Download Project File for Practice (.xlsx) Download Excel File Download more Excel Project File
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