Microsoft Office 2007 Training

Microsoft Office 2007 Training

Learn Microsoft Office Excel 2007 Step by Step, Level 3

Microsoft 50125

Microsoft Certification

Length: 1 Days
Published: February 02, 2009
Language(s): English
Audience(s): Information Workers
Level: 100
Technology: Microsoft Office Excel 2007
Type: Course
Delivery Method: Instructor-led (classroom)
About this CourseThis one-day instructor-led course provides students with an overview of the more advanced features and functions of Microsoft Office Excel 2007.
Audience ProfileThis 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.
  • Create hyperlinks.
  • Paste charts into other documents.
  • Share data lists.
  • Manage comments.
  • Track and manage colleagues’ changes.
  • Protect workbooks and worksheets.
  • Authenticate workbooks.
  • Save workbooks for the Web.
Microsoft Training Discount Price Match Guarantee Microsoft Training Locations Redeem your Microsoft Training Vouchers here!