| Course Name |
Advanced Features of Microsoft Excel 2007
|
| Audience |
Users who desire to gain the necessary skills to share, print, review, and manage data in workbooks. |
| Course Requirements |
You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above.
Plug-in Requirements ØMacromedia Flash plug-in for Windows for IE/NN |
| Pre-requisites |
- Familiarity with basic concepts of Windows - Getting Started with Microsoft Excel 2007 (WBT) |
| Course Duration |
4 hours |
| Course Objectives |
This course covers advanced features of Excel 2007 that enable you to specify workbook properties and print workbooks. It also teaches the procedures of sharing, reviewing, and managing workbooks and customizing the Excel 2007 interface. Additionally, the course covers various types of formulas and functions provided by Excel 2007 and the ways to use them. |
| Course Outline |
- Managing Workbooks
- Specifying File Properties
- Printing Workbooks
- Quiz
- Using Workbooks for Collaboration
- Reviewing and Fixing Workbooks
- Sharing Workbooks
- Recall
- Quiz
- Working with Formulas and Functions
- Creating Formulas
- Using References, Constants, and Functions
- Quiz
- Managing Data
- Filtering Data
- Sorting Data
- Finding and Selecting Data
- Quiz
- Customizing Excel
- Specifying Basic Customization Settings
- Specifying Advanced Customization Settings
- Do It Yourself
- Quiz
|