Excel for the Power User

Description: Excel 2007 provides powerful data analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. With PivotTable reports you can interactiv...
Target audience: End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level o...
Estimated Duration: 3.5 hours
Lesson Objectives: PivotTable Reports in Excel 2007
• create a PivotTable report
• rearrange PivotTable data
Excel 2007's PivotTable Tools
• customize PivotTable reports
• modif...

Description: In many organizations, teams and individuals require frequent and possibly simultaneous access to common spreadsheets and workbooks. To meet these demands without affecting efficiency, a number of rev...
Target audience: End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level o...
Estimated Duration: 2.0 hours
Lesson Objectives: Worksheet and Workbook Protection in Excel 2007
• protect a workbook in a given example
• apply worksheet protection in a given example
Authenticate Workbooks with Excel 2007

Description: In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database quer...
Target audience: End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level o...
Estimated Duration: 3.0 hours
Lesson Objectives: Link, Import, and Embed Data in Excel 2007
• create links to data
• identify how to import data
• embed a file in a workbook
Create Database Queries in Excel 2007