|
|
|||||||
|
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. 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. |
||||||||