, ,

80. Templates

Template is essentially a model that serves as the basis for something. An Excel template is a workbook that’s used to create other workbooks. Viewing Available Templates To view the Excel templates, choose File » New to display the available…
, ,

79. Themes

To help users create more professional-looking documents, MS Excel has incorporated a concept known as document themes. By using themes, it is easy to specify the colors, fonts, and a variety of graphic effects in a document. And best of all,…
, ,

78. Data Validation

Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular cell to whole numbers between 0 and 10. If the user makes an invalid…
, ,

77. Usage of Data Ranges

A cell is a single element in a worksheet that can hold a value, some text, or a formula. A cell is identified by its address, which consists of its column letter and row number. For example, cell B1 is the cell in the second column and the…
, ,

76. Data Sorting

Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may want to sort a table to put names in alphabetical order. Or, maybe you want to sort data by Amount from smallest to largest or largest to smallest.To…
, ,

75. Data Filtering

Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.)Using the store data, if you are interested in seeing data where Shoe Size is 36, then you can set filter to do this.…
, ,

74. Built-in Functions

MS Excel has many built in functions, which we can use in our formula. To see all the functions by category, choose Formulas Tab » Insert Function. Then Insert function Dialog appears from which we can choose the function.Functions…
, ,

73. Formulas: Functions in Formula

Functions in Formula Many formulas you create use available worksheet functions. These functions enable you to greatly enhance the power of your formulas and perform calculations that are difficult if you use only the operators. For example,…
, ,

72. Formulas: Reference Types in Formula

Cell References in Formulas Most formulas you create include references to cells or ranges. These references enable your formulas to work dynamically with the data contained in those cells or ranges. For example, if your formula refers to cell…
, ,

71. Formulas: Copying Formulas

Copying formulas is one of the most common tasks that you do in a typical spreadsheet that relies primarily on formulas. When a formula uses cell references rather than constant values, Excel makes the task of copying an original formula to…