To Find a Subtotal
Data ----> Subtotal
To create a Scenarios
Tools ------> Scenarios
To create Pivot Table
Data ------> Pivot Table
Automatic repetitive task with macros
Tools -------> Macro
- Click 'Record New Macro'.
- Type a name for the new macro in 'Macro Name box'. Click OK
- Execute the steps that make up the macro
- Click 'Stop Recording' Button on the stop Recording toolbar.
Protecting Work books
- Protecting a workbook prevents changes to the worksheets
- To protect a workbook choose
Tools ----> Protection -----> Protect workbook dialogbox appears.
