Lookup and Reference functions in Excel There are many useful lookup and reference functions in Excel that help users to get row/column information and also work with arrays of data. You could find these functions if you go to FormulasLookup & Reference as shown below. If you wish to get the cell reference in the […]Read More* *

Financial Functions IPMT and PPMT in Excel You can use PMT function to calculate the periodic payments for a loan assuming the payments and interest rate are constant. If you want to calculate the amount of interest you pay towards the loan and also the amount of the balance paid down, you can use IPMT […]Read More* *

Financial Functions CUMPRINC and CUMIPMT in Excel If you wish to calculate the total interest or the total principal paid towards the loan between two periods, then you can use CUMIPMT and CUMPRINC functions respectively. The syntax of CUMIPMT is CUMIPMT (rate, nper, pv, start_period, end_period, type) and the syntax of CUMPRINC is CUMPRINC (rate, […]Read More* *

Financial Function PMT in Excel Have you ever thought that financial functions in Excel are for accountants or finance officers to handle their workload? The fact is that there are many financial functions that help people for making correct and wise personal financial decisions. PMT is such a financial function which can be used to […]Read More* *

Excel LEN, LEFT, RIGHT and MID functions Many times, you need to use a combination of functions or formulas to implement a particular feature in Excel. In case of text manipulations, you might not be able to implement functionality just with a single Excel text function. Suppose an Excel file, say EmployeeSalary.xls, is created to […]Read More* *

Excel Find and Search Functions There are many functions in Excel that help users perform different kinds of functionalities easily and efficiently. Functions are categorized into different groups such as text, logical, financial, date and time, mathematical etc. Though Excel is mainly intended for simplifying mathematical calculations, there are many situations where the text data […]Read More* *

Advanced Mathematical Functions in Excel – Part 2 SUMPRODUCT is a very useful mathematical function in Excel. SUMPRODUCT function returns the sum of the products of the corresponding values in two or more arrays. The syntax of this function is SUMPRODUCT(array1, array2, ……). array1, array2 etc could be directly supplied values or a range of […]Read More* *

Advanced Mathematical Functions in Excel – Part 1 Excel mathematical functions help to perform different kinds of mathematical calculations such as basic arithmetic, trigonometric functions, exponentials, factorials, matrix functions and so on. If you go to FormulasMath & Trig, you could find around 60 mathematical and trigonometric functions. For many of these functions, their names […]Read More* *

Conditional Formatting and VLOOKUP Function Conditional formatting as the name suggests does formatting based on some conditions. The formatting is applied only if the specified conditions are met. Use the data given below to illustrate the concept. If you wish to highlight details of Sales Representatives who has completed 2 years in the company, then […]Read More* *

Excel Functions and Formulas – Sorting and Filtering Functions Sorting and filtering functions are available built in with Excel and these are two of the most useful functions used commonly. These functions are used to do very simple sorting to complex filtering operations. These functions are very useful when operations are to be done on […]Read More* *