Microsoft Excel Archive

0

How to format Excel document using Cell Style, Theme and Direct formatting

Last updated onTuesday, October 31, 2017We 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

0

How to calculate Square Root and Square Root PI in Excel

Last updated onTuesday, October 31, 2017One 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

0

How to make a drop down list in Excel 

Last updated onSunday, October 29, 2017Excel 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

0

How to place video inside a spreadsheet

Last updated onTuesday, October 31, 2017Excel 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

0

Tracing precedents and dependent in an Excel table

Last updated onWednesday, July 27, 2016Precedents: 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

0

How to create a Gantt chart on Excel

Last updated onSunday, September 4, 2016What 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