Font size:


This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Analyzing Data in Excel 2007 $74.95
Protecting and Sharing Excel 2007 Workbooks $74.95
Exchanging Data with Excel 2007 $74.95

Bundle Price: $139.00
Total Savings: $85.85

Analyzing Data in Excel 2007

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 interactively summarize data, making it easier to analyze and present the results. PivotChart reports provide a graphical view of PivotTable report data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. You can also use additional what-if analysis components, data tables and scenarios, to view how value changes in formulas affect the formula results and to forecast worksheet outcome models respectively. This course covers advanced data analysis features, such as PivotTable and PivotChart reports, Goal Seek, Solver, scenarios, data tables, and OLAP.

Learning Objectives
  • Create a PivotTable report
  • Rearrange PivotTable data
  • Customize PivotTable reports
  • Modify the look and feel of a PivotTable report
  • Create a PivotChart report
  • Modify a PivotChart report
  • Perform calculations in PivotTables reports
  • Recognize when to use each calculation type
  • Create a PivotTable report
  • Customize a PivotTable report
  • Change the summary calculation in a PivotTable report
  • Create a calculation with a formula
  • Create a PivotChart
  • Use Goal Seek to perform data analysis
  • Use Solver to perform data analysis
  • Create scenarios for what-if analysis
  • Use the Scenario Manager to modify scenarios
  • Create a one-variable data table for data analysis
  • Create a two-variable data table for data analysis
  • Project values in a series
  • Perform advanced functions
  • Match advanced functions with examples of when you would use them
  • Consolidate data from different workbooks using a Summary function
  • Use Goal Seek
  • Use Solver to perform what-if analysis
  • Create a data table to perform what-if analysis
  • Use advanced functions and consolidate data

Protecting and Sharing Excel 2007 Workbooks

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 review, security, and collaboration features are available in Excel 2007. Workbooks, worksheets, and specific data within worksheets, can be protected, enabling only those with access to view or make changes to them. Workbooks can be shared so that multiple people can access required data, and changes made to workbooks can be tracked, accepted or rejected, and merged. The use of Excel Services and Microsoft Windows SharePoint Services adds an additional level of collaboration and security features. This courses covers range, worksheet, and workbook protection, as well as tracking changes and merging workbooks in Excel 2007. Sharing workbooks, using Excel Services for collaboration, and publishing workbooks to SharePoint are also covered.

Learning Objectives
  • Protect a workbook in a given example
  • Apply worksheet protection in a given example
  • Identify the features of digital signatures in Excel 2007
  • Protect a workbook
  • Prevent users from editing a workbook
  • Apply worksheet protection
  • Share workbooks on a network location
  • Merge shared workbooks
  • Publish a workbook to a SharePoint library
  • Perform basic actions using SharePoint
  • Share a workbook on a shared network resource
  • Merge shared workbooks
  • Publish a workbook to SharePoint

Exchanging Data with Excel 2007

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 queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage and customize workbooks. This course explores creating links, importing text files, and creating database and web queries. Importing Excel 2007 data into other applications and using XML in Excel 2007 are also covered.

Learning Objectives
  • Create links to data
  • Identify how to import data
  • Embed a file in a workbook
  • Create database queries in Excel 2007
  • Import an entire Access table
  • Import Excel data into Access
  • Copy Excel data to Word
  • Import Excel data into Outlook
  • Embed a file in a workbook
  • Import data from a text file into Excel
  • Import data from a database into Excel
  • Use Excel data in a Word document
  • Retrieve data from an Access database using the Wizard
  • Create a manual query to retrieve data from an Access database
  • Identify how XML works in Excel
  • Recognize the components of a basic XML system
  • Create an XML map and map elements to it
  • Import XML data
  • Export XML data into mapped cells
  • Use XML data in Excel 2007
Register Now
Microsoft Office 2007: Excel for the Power User e-learning bundle
  • Course ID:
  • Duration:
    8 hours
  • Price: