Free template for Credit society Loan & Interest Calculation Management System in Excel VBA |Useful for Small Banking Finance Company

Loan Interest Calculation template  Simple Loan and Auto Interest voucher Update System Excel VBA Program Simple User form Auto Monthly Interest Calculation  One time All Customer Interest Voucher  Customer Contact & Address Search By Name Individual Ledger Report Date wise Voucher Report Master File & Transaction file Export to New Excel file Use for Personal … Read more

IF formula in excel | Example for Value Base Calculation | Tax Rebate Example | Set Maximum Value Limit |

Calculate according to the maximum range of values ​​from the Excel IF Formula. In this article, we are going to use IF Formula in a different way. If we use the IF condition to perform calculations within the maximum number limit. The article has already been written on another Example, you can learn by clicking … Read more

Customer Data File | Excel VBA Data Transfer to Sheet User Form Open Source Code Workbook

Excel VBA Code Data User form Data Transfer to Sheet This file can use for Save & Search Customer Data.Excel VBA Userform for Data with Searching Option.Easily Save and Edit Data.Search By name.Update Anytime.Open Source code for Learning VBA.Use for Save Customer Data. Open Source Code for – Add New, Edit, Update, Search. Click Here to … Read more

Sum of positive and negative Numbers from column | SUMIF Function |Excel Formula | Excel Function

Use of SUMIF Function If you have some positive numbers and negative numbers in the list, then with SUMIF function we can sum only positive or only negative numbers. You can only easily do 2 steps.1. Selecting Range2. Apply more than and less than conditions. = SUMIF(Range,Condtion)Let’s understand from an example. 1. Sum of Positive … Read more

4 new use of vlookup | Learn how to apply vlookup | MS Excel Vlookup Formula

Vlookup Formula in MS Excel What is Vlookup ? Vlookup formula is the option of vertical Lookup to get information from the table.There is a lot of data in a big table, and if we have to extract some information, we can easily see the information by applying Vlookup.  How can vlookup be used? Not only information, … Read more

Microsoft added in MS Excel 6 new dynamic functions that automatically spill results into multiple cells

New Upcoming MS Excel Formula & Function  Microsoft is adding 6 new advanced MS Excel functions. However, now these functions will be available in Office Insiders and Office 365 after a few months.By using these new functions, we will be able to easily manage the data automatically.Know which work will make it easier! Microsoft is … Read more

Invoice & Customer Management Software for Tours Travel & Transport Business for Small Business (Exce VBA)

Demo Template for Travel & Transport  Click Here Download Free Demo Version    Features Unlimited Multiple Customer Data with Searching System ((Including Edit, View ) Invoice Generation (Including Edit, View , Print & Delete ) Receipt Generation (Including Edit, View , Print & Delete ) Customer Complete Ledger Report Date wise Receipt Report (Selected Period … Read more

Advance Excel Function Data Validation- How to create a drop down list in Excel & Error Alert ?

 Excel function for data entry – Data validation & Error Alert What is data validation and drop down list? What is the use of data validation? In Excel also, like software, we can put a drop down list in data entry. Drop down list has many advantages. like …. If different data entry operators fill … Read more

30 Excel shortcut keys that make Excel user friendly | Learn Excel Shortcut Keys in Details

30 Important but simple excel shortcut keys used in tables If you are managing some big data, then Excel shortcuts are used a lot to easily change the data. In this article, we are going to learn about shortcuts on a similar simple that can easily jump, copy, paste and select data. 30 Important Excel … Read more