|
MS Excel Level 3 |
|
| |
|
|
|
Course Description: |
This course will provide participants with the necessary skills to create more advanced and effective workbooks in Microsoft Excel 2007 using analysis tools, pivot tables, solver, outlining, and macros etc. Techniques acquired through this training will allow the learner to design detailed and productive spreadsheets and workbooks through the use of advanced analysis and automation tools. |
Course Duration: |
|
Cost: |
|
Prerequisites: |
This course is designed for participants who are familiar with, and have a sound understanding of personal computers and the basic Microsoft Excel 2007 features and skills (i.e. those covered in Level 1 and level 2 of this training). |
Methodology: |
This course is delivered in a classroom style learning environment. All work is hands on and participants will work through interesting examples and scenarios as part of their learning process. |
Learning Outcomes: |
At the completion of this course, participants will be able to:
- Use a range of lookup and reference functions
- Modify Excel options
- Develop names and labels in a workbook
- Protect data
- Use data linking to create more efficient workbooks
- Understand and create simple Pivot Tables
- Group cells and use outlines to manipulate the worksheet
- Use Solver
- Create macros
|
Course Outline: |
- Lookup functions
- Formatting charts
- Labels and Names
- Protecting data
- Creating Subtotals
- Data Linking and Data Consolidation
- Pivot Tables
- Grouping and Outlining
- Solver
- Macros
- Recorder Workshop
|
