Objective:
Participants will learn more advanced feature of Ms Excel 2003. Participants must know basis function of Ms Excel 2003 before joining this course.
Course Outline
1 Documentation - Working With Comments
2 More Functions And Formulas
- Formulas With Several Operators And Cell Ranges
- Using The Paste / Insert Function Feature (Fx)
- Creating And Using Range Names
- Using The If Function To Create Conditional Formulas
- Using Lookup Functions
- Displaying And Printing Formulas
- Fixing Formula Errors
3 What-If Analysis
- Defining A Scenario
- Using A One And Two-Input Data Table
- Understanding Goal Seek
- Using Solver
4 Automating Tasks With Macros
- Record And Delete A Macro
- Playing A Macro And Assigning A Macro A Shortcut Key
- Adding And Removing A Macro To A Toolbar
5 Working With Lists
- Creating A List
- Sorting A List
- Creating Subtotals
- Filtering A List With The Autofilter
- Filtering A List With An Advanced Filter
6 Pivot Tables
- Creating A Pivot Table
- Pivottable Toolbar
- To Change The Calculation Used In A Pivot Table
- Updating A Pivot Table
- Formatting And Charting A Pivottable
- Grouping Dates In A Pivot Table
- Grouping And Outlining A Worksheet
7 Sharing a Workbook and Tracking Changes
- To share a workbook
- To view changes made to a cell.
- To make a copy of a shared workbook
- Merging and revising a shared workbook
|