# Author: Puneet Tayal

## Excel Financial Functions || PMT Functions in Excel

What are Financial Functions?? Hello all, We are here to help you with the Excel’s Financial Functions to make your calculations like Capital Investment, the Calculation of yield, Interest Rates, Duration, Valuation and Asset Depreciation easier.These calculations can be made easy...

## HOW TO USE V LOOKUP Function IN EXCEL

What is VLOOKUP? Hello all, We are back with the most interesting and useful tool for the MS Excel, you might be searching for.Vlookup is a great tool for MS EXCEL, that helps us in looking up the desired data from...

## Wrapping Text | How to wrap text in cells in Excel

Hello Everyone, Today we will discuss how to wraps the text in the cells in MS Excel. MS excel is a powerful tool to design the data in a good manner. If we want to display the data in a proper...

## How to Recover Unsaved Excel File | Enable AutoRecover Excel File

Hello Everyone, Today we’ll discuss a topic How to Recover Unsaved Excel File. This article helps you to know how to recover your whole excel data when you forget to save the file or accidentally close the documents. Just imagine you...

## How to Create a Sparklines In Excel 2010

Hello everyone, Today we’ll discuss how to Create a Sparklines or Mini Chart in Excel. A sparkline is a tool/cell  that provides the visual(graphically) representation of data. Excel 2010 Sparklines is used to represent the data (a data which were taken in a rows...

## SUMIF Function : How to use SUMIF Formula in Excel

Hello Everyone, Today you’ll find How to use SUMIF Function in Excel. SUMIF Function used to add the specified cells based on the single or multiple supplied criteria. Sometimes we require conditional sum in Excel then we can use this function to...

## Free Excel Templates – How to use Spreadsheet Templates

Hello Everyone, Today You’ll find How to use Spreadsheet Templates in MS Excel. A template is a pre-designed worksheet that can use to create a new worksheet with the same formatting. Excel Templates is a powerful part to create a workbook and...

## How to use Text Functions in Excel

Hello Everyone, Today we’ll discuss How to use Text Functions in Excel. Text Functions return an information about a text string and also used to combine a text string and a number together. Excel string Functions have been grouped into various category...

## How to Create a Histogram in Excel

Hello Everyone, Today You’ll find How to Create a Histogram in Excel. A histogram is a tool of Analysis ToolPak in MS Excel. It is used to represent the data in the graphical form and use the column chart to display frequency...

## How to Create a Chart in Excel | Graph in Excel

How to Create a Chart in Excel: Hello everyone, Today we’ll discuss how to Create a Chart or Graph in Excel. A chart is a tool to show the data graphically. It is used to show the series of data in...