# Month: July 2016

## 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...

## What-If Analysis in Excel

What-If Analysis in Excel: Hello Everyone, Today We’ll discuss What-If Analysis in Excel. Excel provides the most powerful tool for making the calculation quickly and easily. It is used to explore different scenarios on the same data in the excel spreadsheet. You...

## How to Use Data Validation in Excel

Data Validation in Excel: Hello friends, We’ll discuss How to Use Data Validation in Excel. Data Validation means you can restrict the data or value that enter into a cell by the user. We can give the limitation on the data to...

## How to Insert Table in Excel

How to Insert Table in Excel: Hello Friends, Here We’ll discuss how to Insert Table in Excel. We all know that Table provides us to analyze data and calculation in excel quickly and easily. Excel provides more features or Table formattings...

## Logical Function in Excel

Logical Function in Excel: Hello Friends, Today we’ll discuss the Logical Function in Excel. MS Excel provides four main logical functions-AND, OR, NOT, and IF. Now some more logical functions are also available to work with the logical value. These functions...

## How to Protect Excel Sheet with Password

Protect Excel Sheet with Password: Hello guys, Today we’ll discuss that how to Protect Excel Sheet with Password. As We all know that we save all the business data or some important data in excel sheet so it is very important...

## How to Use Pivot Table in Excel in 2010

Pivot Table in Excel 2010: Hello Friends, Today We’ll discuss how to Use a Pivot table in Excel 2010.  A pivot table is one of the powerful features of MS Excel. This tutorial will show you how to create a Pivot table in...

## How to Calculate Descriptive Statistics in Excel | Data Analysis

Descriptive Statistics in Excel : Hello friends, in this post, we’ll discuss that how to Calculate Descriptive Statistics in Excel. This tutorial useful to show data analysis using an MS Excel spreadsheet program. It is used to the analysis of the...