Create Bulk Folders by One Click with Given Name with Excel & cmd
Name Sheet Sample Data Download Practice File ✪ DOWNLOAD FILE Download More Excel Files Video Tutorial
Excel Formulas
School-College Data Management Make MIS Report (Gender-wise/Class-wise/Caste-wise/Category-wise)
Raw Data 1. Introduction One of my Subscribers was send me the sample data to extract MIS Report from the Student’s (School’s) Data. I have sent him the solution and I thought that I should share this report with All subscribers and website visitors because it will be very helpful for all of them. So … Read more
Stock Management in Excel – Use Closing Stock as Opening Stock
1. Introduction In the below video i have explained how you can manage Stock in Excel easily. Also, You can automate Closing Stock as Open Stock on Next Day or Next Month. Some people commented on my video to make a new video on this topic – how can we enter Opening Stock in Next … Read more
How to Format Proper Data when Export from Tally to Excel
1. Introduction When we export data from Tally to Excel Software it doesn’t show in the proper format in excel. So here in the below video, I will explain to you how to do proper formatting for data exported from TALLY to EXCEL. 2. Command Used To format Data properly in Excel I have used … Read more
How to Create a Sales DYNAMIC Map Chart With Slicer in Excel
Introduction Do you know, how to create map chart in Excel? if you don’t know, you are at the right place to learn for creating map chart in Excel easily. When we click on the Area button the chart will automatically changed as per the location and the stats will be also automatically change. So … Read more
Download Automated EXPENSE TRACKER Software in Excel (FREE)
Introduction Are you searching for an Expense Tracker in Excel or are you searching How to make a Daily Expense Tracker in Excel? So you have open the right article, in this article I will explain to you How to make a Daily Expense Tracker in excel without any VBA coding easily. Command Used In … Read more
Customer Care Complaint Management in Excel
This is sample data to check duplicate complaint. we have trace duplicated complaint with “Product Serial No.” and if complaint is “Open” then our formula will show that “Complaint is duplicate” other wise the formula will show blank, check out the video below and download the sample file from download button as given here under. … Read more
VLOOKUP Function Step by Step Process with Example
Introduction VLOOKUP stands for ‘Vertical Lookup’. It is a formula or function which makes Excel search for a certain value in a column. Purpose To find information in a large spreadsheet, or looking for the same kind of information, we mostly use the VLOOKUP function. You will get to know, how to use the VLOOKUP … Read more
How to Convert Excel to PDF (Very Simple)
Introduction Converting your spreadsheet /excel file into a PDF format is called convert to pdf. This feature provides the user a safety in document formatting changes by the sender or receiver. Purpose Saving the document as a PDF, to ensures that no formatting changes to the original document while the senders opens it to avoiding … Read more
How to Merge Cells In Excel (Merge & Center, Merge Across, Merge Cells)
Introduction Merging combines two or more cells to create a new, larger cell is called Merge Cell. This is very useful feature in excel to create a label that spans several columns. Purpose Combination of two or more cells in a spreadsheet to join one or more adjacent cells (horizontally or vertically or both) into one … Read more
Calculate Expiry Date in Excel | Product Expiry Formula in Excel
(how to set expiry date for excel file excel expiry date formula colour expiration date tracking excel template how to calculate remaining shelf life in excel excel formula highlight expiry date how to calculate days to expiry in excel how to calculate expiry date) Medicine Example Data to Calculate Expiry List OUTPUT DASHBOARD & MIS … Read more
MIS Report 2D Column Chart in Excel (HINDI)
दोस्तों नीचे दी गई वीडियो में मैंने यह बताया है कि एक्सेल में 2D Column Chart कैसे बनाया जाता है और इसमें मैंने एक बड़ी Problem का Solution भी बताया है l जैसे कि हमारे Years 2D Column Chart में Show नहीं होते हैं, तो उसको Axis Label में कैसे दिखाया जाए, इस वीडियो में … Read more