| HOME > RSS Feeds > - Latest Tutorial Listings For Basics | ||
| 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.
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.
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.
Excel Solver
Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
Excel What-If Analysis
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas.
Excel Tables
Excel tables allow you to analyze your data in Excel very easily.