10 Most Important Excel Formula Can Make YOU Excel Expert

create-mini-inventory-management-system-in-excel

How to Create Mini Inventory Management System in Excel Last Rate Step by Step Urdu Hindi Tutorial

In this video, we will be showing you how to effectively manage your inventory using Microsoft Excel. We will create a mini but powerful #Inventory #management system in #Excel, specially we will discuss how you can use current or last purchase rate for your stock and profit valuation. The benefit of this method is to …

How to Create Mini Inventory Management System in Excel Last Rate Step by Step Urdu Hindi Tutorial Read More »

Excel Data Summarizing FORMULAS and TRICKS to Make You EXPERT Urdu Hindi Practical Tutorial

[adinserter block=”1″]   #RemoveDuplicateInExcel #SumifFormulaInExcel #DataSummaryInExcel In this tutorial you will learn excel formulas for data summarizing to remove duplicates record and clean your data in Urdu/Hindi languages. After completing this , you will be able to apply excel functions to implement logic. Key Formulas Discussed here are : 1. Conditional Formatting. 2. Sumif 3. …

Excel Data Summarizing FORMULAS and TRICKS to Make You EXPERT Urdu Hindi Practical Tutorial Read More »

How to Maintain your Customers Ledgers in Excel Step by Step Urdu Hindi Tutorial

#CustomerLedgerExcel #SupplierLedgerExcel  #ExcelTutorials [adinserter block=”1″] In this tutorial you will learn excel formulas by creating a responsive Customers Ledgers Template in Excel in Urdu/Hindi language. After completing this , you will be able to apply excel functions to implement logic. Key Formulas Discussed here are : 1. Data Validation 2. Sum 3 HyperLinks 4 Reference …

How to Maintain your Customers Ledgers in Excel Step by Step Urdu Hindi Tutorial Read More »

How to Do Image Lookup in Excel Very Informative Tutorial in UrduHindi

[adinserter block=”1″] #Excel #Photo #ImageLookup In this short video tutorial YOU Will Learn very very important advance excel formulas with a practical example Following are the key discussions of this tutorial : 1 Vlookup in excel, 2 index formuals in excel, 3 match formuals in excel, 4 and of course image lookup in a very …

How to Do Image Lookup in Excel Very Informative Tutorial in UrduHindi Read More »

How to Protect Excel Work Step by Step Urdu Hindi Tutorial

In this short video tutorial YOU Will Learn very very important advance excel formulas with a practical example Following are the key discussions of this tutorial : [adinserter block=”1″] 1 #Protect Excel Sheet 2 #Allow User to Edit Ranges 3 #Excel External Protections 4 #Set Password on opneing Excel Sheet and many more. Learn more …

How to Protect Excel Work Step by Step Urdu Hindi Tutorial Read More »

How To Create Responsive Employees ID Card System in Excel STEP BY STEP Urdu Hindi

In this short video tutorial YOU Will Learn important excel formulas used in creating employees id card System through excel. Following are the key discussions of this tutorial : [adinserter block=”1″] 1 Lookup formulas 2 data validation in excel 3 picture lookup formula in excel 4 name manager in excel 5 Drop Down list in …

How To Create Responsive Employees ID Card System in Excel STEP BY STEP Urdu Hindi Read More »

HOW TO CREATE PAYROLL|SALARY SHEET| 500 PAYSLIP IN 01 MINUTE WITH EXCEL URDU | HINDI

  In this short video tutorial YOU Will Learn important excel formualas used in salary sheet and payslip, Gross , Taxes , Loan , Advances and Allowances , Also creating individual payslip & enevelpe printing. Following are the key discussions of this tutorial : [adinserter block=”1″] 1 mod formula to calcualte leap year 2 sum …

HOW TO CREATE PAYROLL|SALARY SHEET| 500 PAYSLIP IN 01 MINUTE WITH EXCEL URDU | HINDI Read More »

Scroll to Top