|
MS Excel Level 2 |
|
| |
|
|
|
Course Description: |
This course will provide participants with the necessary skills to create more advanced and effective workbooks using Microsoft Excel 2007. Techniques acquired through this training will allow the learner to design more detailed and productive spreadsheets and workbooks. |
Course Duration: |
|
Cost: |
|
Prerequisites: |
This course is designed for participants who have an understanding of personal computers and basic Microsoft Excel 2007 skills (i.e. those covered in Level 1 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 the fill operation to complete a data series
- Move data within and between workbooks
- Use a range of formula and logical functions
- Use more advanced formatting techniques
- Use a range of find and replace techniques
- Apply advanced page set up techniques
- Sort data within a worksheet
- Enhance and format charts
|
Course Outline: |
- Filling Data
- Moving data
- Using Formula and Logical functions
- Advanced formatting techniques
- Applying borders
- Finding and Replacing data
- Page setup
- Sorting and filtering data
- Chart techniques and formatting
|
