# Course 50125A: Learn Microsoft® Office Excel® 2007 Step by Step, Level 3

 Type: Course Audience(s): information workers Technology: Excel Level: 100 This Revision: A Delivery method: Instructor-led (classroom) Length: 1 day Language(s): English First published: 02 February 2009
Overview
This one-day instructor-led course provides students with an overview of the more advanced features and functions of Microsoft Office Excel 2007.
Audience profile
This course is intended for experienced information workers who want to learn advanced-level Excel 2007 skills.
At course completion
After completing this course, students will be able to:
• Define an alternative data set.
• De?ne multiple alternative data sets.
• Vary your data to get a desired result by using Goal Seek.
• Find optimal solutions by using Solver.
• Analyze data by using descriptive statistics.
• Analyze data dynamically by using PivotTables.
• Filter, show, and hide PivotTable data.
• Edit PivotTables.
• Format PivotTables.
• Create PivotTables from external data.
• Create dynamic charts by using PivotCharts.
• Describe and examine macros.
• Create and modify macros.
• Run macros when a button is clicked.
• Run macros when a workbook is opened.
• Include Office documents in worksheets.
• Store workbooks as parts of other Office documents.
• Paste charts into other documents.
• Share data lists.
• Track and manage colleagues’ changes.
• Protect workbooks and worksheets.
• Authenticate workbooks.
• Save workbooks for the Web.
Course details
 Course OutlineModule 1: Data AnalysisThis module explains how to define alternative data sets, use Goal Seek and Solver, and analyze descriptive statistics.Lessons Defining an Alternative Data SetDefining Multiple Alternative Data SetsVarying Your Data to Get a Desired Result by Using Goal SeekFinding Optimal Solutions by Using SolverAnalyzing Data by Using Descriptive StatisticsLab : Data AnalysisAfter completing this module, students will be able to:Create scenarios and work with Scenario Manager.Determine a value by using Goal Seek.Determine multiple values by using Solver.Use descriptive statistics to analyze data.Module 2: PivotTables and PivotChartsThis module explains how to work with PivotTables and PivotCharts.Lessons Analyzing Data Dynamically by Using PivotTablesFiltering, Showing, and Hiding PivotTable DataEditing PivotTablesFormatting PivotTablesCreating PivotTables from External DataCreating Dynamic Charts by Using PivotChartsLab : PivotTables and PivotChartsAfter completing this module, students will be able to:Create PivotTables.Filter PivotTables to highlight specific information.Edit and format PivotTables.Use external data to create PivotTables.Use PivotCharts to visually represent PivotTable data.Module 3: MacrosThis module explains how to create and run macros.Lessons Introducing MacrosCreating and Modifying MacrosRunning Macros When a Button Is ClickedRunning Macros When a Workbook Is OpenedLab : MacrosAfter completing this module, students will be able to:Move through a macro a step at a time.Create and modify macros.Run macros in various ways.Module 4: Office Document RecyclingThis module explains how to use Office documents in Excel workbooks and how to use Excel data in other Office programs.Lessons Including Office Documents in WorksheetsStoring Workbooks as Parts of Other Office DocumentsCreating HyperlinksPasting Charts into Other DocumentsLab : Office Document RecyclingAfter completing this module, students will be able to:Link other types of Office documents to Excel workbooks.Embed Excel workbooks in other Office documents.Create hyperlinks to and from workbooks.Use Excel charts in other Office documents.Module 5: CollaborationThis module explains how to collaborate on Excel files by sharing files, managing comments and changes, password-protect workbooks and worksheets, use digital signatures, save and publish Excel data.Lessons Sharing Data ListsManaging CommentsTracking and Managing Colleagues’ ChangesProtecting Workbooks and WorksheetsAuthenticating WorkbooksSaving Workbooks for the WebLab : CollaborationAfter completing this module, students will be able to:Share workbooks with colleagues.Manage comments and changes made by colleagues.Password-protect workbooks, worksheets, and cells.Use digital signatures.Save and publish workbook and worksheet data to the Web.
Prerequisites
Before attending this course, students must have:
• Basic computer knowledge
• Basic file-management skills
• Basic knowledge of the Excel interface, workbook manipulation, and formula creation
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks: