Microsoft Excel Archive

We need to apply different types of formatting in the excel cell to make any excel document more meaningful and attractive for the reader. We can apply formatting in any excel document by three ways. These are Cell Styles, Theme and direct formatting. The most commonly used formatting way is direct formatting.

One of the most useful feature of Excel is built-in excel function. We can perform different types of mathematical operations very easily in the worksheet by applying different excel functions as formula. The built-in functions of excel are used to calculate any general arithmetic operation and complex mathematical operation. Excel user don’t

Excel user entries different types of data such as, number, text, date etc. in the cell of a spreadsheet based on the document’s requirement. Normally data are inserted in the cell like text box and user can type any type of data there. But if it is require to restrict the value

Excel is one of the most popular application which is mainly used to store data in tabular form using spreadsheet. Various types of data can be stored in spreadsheet. Excel users not only use spreadsheet to insert number, text or date types of data but they can also insert different types of

Precedents: These are the ranges or cells that affect the value of the active cell. Dependent:  These are the ranges or cells that are affected by the active cell. The Formula Auditing group located in the Formulas tab features the Trace Precedents and Trace Dependent options to locate the precedents or the dependent

What is a Gantt chart? It is a horizontal bar chart which is quite frequently used in the applications pertaining to project management. The chart is eponymous to its founder Henry Gantt. Gantt came up with the idea for this chart in early 20th century. Besides being a mechanical engineer, Gantt was