## Window view in Excel 2010

The Window view in Excel 2010 helps to  open, view and arrange workbook. Window is the option in View ribbon. In this tutorial I will show how to use window option in view ribbon to work with multiple sheets. How to create multiple sheets in same work book? Step 1: Open the work book Step 2: Click […]

## Statistical Functions in Excel 2010

Statistical Functions in Excel 2010  Excel provides a large selection of Statistical functions. This will help to perform common calculations to complex statistical distribution and probability tests. Finding the right statistical function in Excel 2010 Follow the below steps to identify the Statistical function in excel. Step 1: Click the Formulas tab in excel and […]

## Math functions in Excel 2010

Excel Math functions, grouped into categories with simple examples.

## Date and Time Function in Excel2010

Date and Time function in Excel This step-by-step article describes how to use date and time functions in Microsoft Excel to perform complex date and time calculations. Excel stores all dates as integers and all times as decimal fractions. To get started Creating a date functions in Excel Step 1 : Create a Workbook Step 2: Type the […]

## Protecting Worksheets in Excel 2013

Protecting Worksheets in Excel 2013 Sometimes you may require to protect your important worksheets from misuse & theft. in this post, you are going to learn how to protect your Worksheet in Excel 2013 from unauthorized access. There are variety of ways in Excel 2013 to protect an Excel sheet. These are the available options: […]

## Using Transpose Tool in Excel 2013

Using Transpose Tool in Excel 2013 In this Post I am gonna show you how you can use transpose Tool to convert rows into columns! Do you Know? In Excel 2013,  you can use the same transpose function that appeared in Excel 2010 to rotate tables or change rows & columns. Using Transpose tables you […]

## Sharing Workbooks in Excel 2013 & Onedrive

Sharing Workbooks in Excel 2013 Excel 2013 makes it really easy to share workbooks using OneDrive, which we discussed in Earlier Sections. In order to share any workbook in Excel 2013, it must first be saved to your OneDrive (See How to Save onto OneDrive Section). Here’s How to Share a Workbook: Simply click the tab that says, “File” to access the backstage view, and […]

## Saving an Workbook in Excel 2013

Saving an Workbook in Excel 2013 When you create & work on a new workbook in Excel 2013, you’ll should to know how to steps to save your work & workbook so that you can access it & edit it later. There are many different ways to save a workbook in Excel 2013. In previous versions of Microsoft Excel […]