Microsoft Excel 2007 Training Course

Course Description
Our Microsoft Office Excel 2007 Training will teach you to identify  spreadsheet components, access help when required, work and manage workbooks, use templates and protect data. The Formulas, Functions, and Charts unit will show you how to enter and work with formulas. You will also learn to use references, and create and modify charts. The Formatting Worksheets unit of this course will cover methods to format worksheets. It will take you through the procedures to format text, rows, and columns. You will also learn to apply different styles, special formats, and format date and time styles. The final unit is titled Managing and Printing Workbooks. Here you will learn to work with multiple worksheets and link and manage workbooks. You will also learn to prepare and print a worksheet, and print multiple worksheets. The Advance Topics  introduces you to the advanced features and functions. Learners will be able to demonstrate competence in using Excel to perform tasks such as working with built-in functions, presenting data, auditing and exporting data, and using analytical options and macros.

Training Audience
The audience for this course consists of small office/home office (SOHO) users to all levels of business users. These users possess basic to intermediate PC skills and want to use Excel 2007 as a productivity tool. They have a couple of years of experience using a PC and have limited or no experience with Excel.

Our Microsoft Office Excel 2007 Training Course on CD-ROM will feature

• Training done in full multi-media flash format with Audio
• Over 8 hours of training
• Covers Excel Basics and Beyond Basics
• Interactive Exercises- allows you to practice what you have learned
• Review Questions
• MS Office 2007 Software not required
• Available as  single user CD-ROMs and Network Version
• Used by Thousands of Companies
• Inquire about our Network Licenses and Learning Management Software (LMS).

We also offer the following Excel Training courses

• Excel 97
• Excel 2000
• Excel 2002 (XP)
• Excel 2003

Upon completing this course you will learn:

• Set up print options for single and multiple worksheets. 
• Link and manage workbooks.
• Work with multiple worksheets.
• Format date and time.
• Format numbers using special formats.
• Format worksheets to suit needs.
• Add graphic elements to a chart.
• Create and work with charts.
• Use references.
• Enter formulas and work with formulas and functions.
• Install and use advanced features such as Goal Seek and the Analysis ToolPak.
• Identify the ways to create data table.
• Identify the ways to use a scenario.
• Use macros to automate complex and repetitive tasks.
• Create custom functions. 
• Convert workbooks into Web pages and use hyperlinks.
• Send workbooks through e-mail.
• Use the workgroup collaboration features in Excel 2007.
• Use auditing features and incorporate comments in Excel 2007.
• Create and work with PivotCharts.
• Create and work with PivotTables.
• Use data outlining and consolidating features.
• Use sorting and filtering features.
• Identify elements of a list.
• Use the DSUM function.
• Identify database functions.
• Use the nested IF function.
• Use advanced functions such as the IF, SUMIF, PMT, VLOOKUP, MATCH and INDEX functions.

The training course contains the following Content

Unit 1: Introducing Microsoft Excel 2007

• Describe the spreadsheet components . 
• Create Excel workbooks. 
• Work with formulas and functions. 

Unit 2: Formatting Worksheets

• Format data. 
• Format worksheets. 
• Use special formatting. 

Unit 3: Charts and Templates

• Create and work with charts. 
• Work with workbook templates. 

Unit 4: Managing and Printing Workbooks

• Work with multiple worksheets and workbooks. 
• Print Worksheets. 

Unit 6: Working with Built-in Functions

• Use the IF function. 
• Use the SUMIF function. 
• Use the nested IF function. 
• Use the PMT function. 
• Use the lookup functions. 
• Use the MATCH and INDEX functions. 
• Use database functions. 

Unit 7: Presenting Data

• Structure data using Sort & Filter. 
• Use advanced filtering. 
• Present data in a table. 
• Manage data. 
• Validate cell entries. 
• Create a PivotTable. 
• Rearrange a PivotTable. 
• Format a PivotTable. 
• Create a PivotChart.

Unit 8: Auditing and Exporting Data

• Use the auditing features . 
• Add comments to cells. 
• Use the protection feature . 
• Use the workgroup collaboration features. 
• Convert workbooks into Web pages. 
• Use hyperlinks. 
• Send workbooks through e-mail. 

Unit 9: Using Analytical Options and Macros

• Use the Goal Seek and Solver. 
• Use the Analysis ToolPak. 
• Create data tables. 
• Use scenarios. 
• Use macros to automate complex and repetitive tasks. 
• Add a Macro Button to the Quick Access Toolbar. 
• Use Visual Basic Editor to edit a macro. 
• Create custom functions. 

 Cisco®, Cisco Systems®, CCDA™, CCNA ™, CCDP™, CCNP ™, CCIE™, CCSI™, the Cisco Systems logo Networking Academy and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc and/ or its affiliates in the U.S and certain other countries. All other trademarks mentioned in this document or Web site are the property of their respective owners . 

United Kingdom Hours 2:00 pm to 8:00 pm
International Phone Number 561.381-0322
sales@netwind.com
webmaster@netwind.com
Copyright  © CDi Communications Inc. 1996-2008
Netwind Learning Center is a registered trademark of CDi Communications, Inc.