| HOME > RSS Feeds > - Latest Tutorial Listings For MS Excel | ||
| Add To: | 
|
 |
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.