|
|
Who is this course for?
This course is for you if you wish to gain the necessary skills to share, print, review, and manage data in workbooks.
This course is ideal for anyone who needs to:
- understand the advanced features of Excel 2007
- specify workbook properties
- print workbooks
- understand the procedures for sharing, reviewing, and managing workbooks and customising the Excel 2007 interface
- understand the various types of formulas and functions provided by Excel 2007 and the ways to use them
What prior knowledge do I need?
You should be familiar with basic concepts of Windows
You may find it useful to have completed the Getting Started with Microsoft Excel 2007 course.
|
What is the duration of the course?
The course is designed to last 4 hours but you have the flexibility to progress at the rate that suits you.
|
What does the course cover?
This course will cover advanced features of Excel 2007 and it will enable you to specify workbook properties and print workbooks. It will also teach you the procedures for sharing, reviewing, and managing workbooks and customising the Excel 2007 interface. Additionally, the course will cover various types of formulas and functions provided by Excel 2007 and the ways to use them.
The Course covers the following topics:
1.Managing Workbooks
- Specifying File Properties
- Printing Workbooks
- Quiz
2.Using Workbooks for Collaboration
- Reviewing and Fixing Workbooks
- Sharing Workbooks
- Recall
- Quiz
3.Working with Formulas and Functions
- Creating Formulas
- Using References, Constants, and Functions
- Quiz
|
4.Managing Data
- Filtering Data
- Sorting Data
- Finding and Selecting Data
- Quiz
5.Customising Excel
- Specifying Basic Customization Settings
- Specifying Advanced Customization Settings
- Do It Yourself
- Quiz
|
After completing this course, you will be able to:
- Specify workbook properties and print workbooks
- Share, review and manage workbooks
- Create Formulas
- Customise the Excel 2007 interfacea
How is the course delivered?
The course is an online eLearning course with a difference. Whereas most eLearning courses come to an end when you have worked through the course materials the way this course is delivered means that you will have access to a Community of Practice (CoP) and become part of a community of learners. You will have access to the course materials via a Virtual Learning Environment (VLE).
The course is designed with the greatest flexibility in mind. When you break off from working through the course materials it is possible to pick it up at the same point on your next learning session as the VLE will log and retain the point where you left the course materials. You will also have access to discussion forums led by facilitators where you can raise queries and discuss issues with other, current and former, delegates. This participation in the discussion forums should further refine and develop your skills in using MS Excel 2007.
Is my learning tested on the course?
There are quizzes at the end of each unit to ensure that you have understood the completed unit.
You will also have access to discussion forums led by facilitators where you can test your knowledge, raise queries, respond to queries and discuss issues with other, current and former, delegates. This will enable you to develop your learning further by applying and sharing your knowledge.
|
What after course support is available?
You will have access to discussion forums led by facilitators where you can raise queries and discuss issues with other delegates who are completing or have already completed the course. This will enable you to develop your learning further by applying and sharing your expertise to solve problems.
|
How do I register on the course?
Click on the "add" link below - you will then be guided through the purchase process.
Once you have successfully made the purchase your account will be updated from where you will be able to access registration and enrolment details providing instant access to the course.
|
|
|
|
|
|
| Item code |
071-026 |
| Price |
£49.99
( £58.74 tax incl.) |
|
|
| |
|
|
|
|
 |
£49.99
( £58.74 tax incl.)
|
| |
|
|
|
|
|
|
|
|
|