How to format Excel document using Cell Style, Theme and Direct formatting
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…
How to calculate Square Root and Square Root PI in Excel
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…
How to make a drop down list in ExcelÂ
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…
How to place video inside a spreadsheet
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…
Tracing precedents and dependent in an Excel table
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…
How to create a Gantt chart on Excel
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…