|
|
|||||||
|
How to Find Data in Excel Finding data is very useful when you have to deal with a lot of data on a worksheet. How to insert cells in Excel When we work with spreadsheet sooner or later we will need to insert Cells into existing sheet. Median Function in Excel The median is widely used in statistics where might be seen as a better indication of central tendency than arithmetic mean. Excel formulas and functions. A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. Quick Access Toolbar If you use an Excel command frequently you can add its icon to the Quick Access Toolbar. Excel Calendar Making a calendar in Excel is easy. Instead of creating your own calendar from scratch, you can create a calendar from a template. Excel External References An external reference (also called link) is a reference to a cell or range of cells in another Excel workbook. Adding Numbers using Autosum Autosum feature is used to make summing operation as fast as possible. I presented a few ways you can use Autosum. Autofill Autofill is a useful feature that will help you insert data such as days, months, etc. It will also let you create your own custom lists. Excel Drop-Down List Drop-down lists are helpful if you want to be sure that users select an item from a list, instead of typing their own values. |
||||||||