In this article you will learn about Statistical Function in Excel that includes AVERAGE, AVERAGEIF, MODE, MEDIAN, Standard Deviation, MIN, MAX, Large http://www.certiology.com/tutorials/excel-tutorial/statistical-function-in-excel.html
There are three functions to round numbers in MS Excel. The ROUND, ROUNDUP and ROUNDDOWN function. The ROUND function is used to round the fraction va http://www.certiology.com/tutorials/excel-tutorial/the-round-roundup-and-rounddown-functio...
String Manipulations in MS Excel facilitates its user to perform within string extraction. In this article you will learn about Text Functions in Exce http://www.certiology.com/tutorials/excel-tutorial/text-functions-in-excel.html
Cell references are very important in MS Excel. Cell referencing works in formulas and other automations performed within MS Excel. It is further clas http://www.certiology.com/tutorials/excel-tutorial/cell-references-in-excel.html
MS Excel provides you the flexibility to use select, Find and Replace features to find specified text and replace it with your desired text. http://www.certiology.com/tutorials/excel-tutorial/find-and-select-in-excel.html
Worksheet plays a highly important role in MS Excel as all the automation in MS Excel requires worksheet as a key reference. In this tutorial you will http://www.certiology.com/tutorials/excel-tutorial/worksheet-in-excel.html
MS Excel supports multiple formats for data inputs. It also support date and time as a format and has the provision to apply various function over the http://www.certiology.com/tutorials/excel-tutorial/date-and-time-function-in-excel.html
MS Excel supports logical and conditional functions which enables the user to perform conditional evaluations. In this article you will learn about IF http://www.certiology.com/tutorials/excel-tutorial/logical-functions-in-excel.html
The count and sum function is MS Excel is very important. In this tutorial you will learn count and sum functions, CountA, CountBlank, CountIFs, SumIF http://www.certiology.com/tutorials/excel-tutorial/count-and-sum-function-in-excel.html
MS Excel is highly versatile and supports sharing its contents with other programs. Contents can be shared from MS Excel to MS Word, MS PowerPoint and http://www.certiology.com/tutorials/excel-tutorial/how-to-share-ms-excel-data.html
In this tutorial, you are going to learn about how to setup your Excel sheet for printing. You will learn how to set margins, setting the printing pre http://www.certiology.com/tutorials/excel-tutorial/print-gridlines-in-an-excel-worksheet.html
The protection level implemented in MS Excel is password protected and hence, without a correct password, it cannot be unlocked. To make your Excel fi http://www.certiology.com/tutorials/excel-tutorial/protecting-a-workbook-in-ms-excel-with-...
In MS Excel, you have plenty of keyboard shortcuts available that will help you performing your tasks in a quicker way. This tutorial will discuss the http://www.certiology.com/tutorials/excel-tutorial/excel-keyboard-shortcuts.html
In Microsoft Excel, Data validation is used to verify the type, format, and content of data that is acceptable in a specific cell. If any data that is http://www.certiology.com/tutorials/excel-tutorial/data-validation-in-ms-excel.html
In Microsoft Excel, Templates are the pre-defined / pre-designed formats that can be used for various purposes. Microsoft has provided a rich library http://www.certiology.com/tutorials/excel-tutorial/templates-in-ms-excel.html
Formatting Cells is one of the most power and attractive features of MS Excel. This feature provides the user with the flexibility and control over th http://www.certiology.com/tutorials/excel-tutorial/formatting-cells-in-ms-excel.html
In Excel, workbook contains multiple worksheets of account and other records. Now since, MS Excel is also associated with the record keeping and perfo http://www.certiology.com/tutorials/excel-tutorial/workbook-in-ms-excel.html
By default, the Ribbon contains 8 tabs in MS Excel 2013. In this Microsoft Excel Tutorial you will learn about Ribbon tabs and how to customize, http://www.certiology.com/tutorials/excel-tutorial/ribbon-in-ms-excel.html
Microsoft Excel provides the flexibility to use these formulas and functions in an entirely convenient manner. As long as you have the understanding a http://www.certiology.com/tutorials/excel-tutorial/formulas-and-functions-in-ms-excel.html
The term Range is used in MS Excel for the selection of one or more than one cell either horizontally or vertically or even in a block. There are vari http://www.certiology.com/tutorials/excel-tutorial/working-with-ranges-in-ms-excel.html
In this step by step Excel tutorial, you will learn how to Insert and delete rows, Columns and cells in Microsoft Excel. http://www.certiology.com/tutorials/excel-tutorial/working-with-rows-columns-and-cells-in-...