Call: 0118 3243000
Shopping CartNo Items In Your Cart
Systematix Training Ltd

Excel 2007 Level 3 Advanced

Public Course Dates

  Date Location
Thu, 26 Aug 2010 Reading
Thu, 23 Sep 2010 Reading
Thu, 21 Oct 2010 Reading
Thu, 18 Nov 2010 Reading
Thu, 16 Dec 2010 Reading
Thu, 13 Jan 2011 Reading
Thu, 10 Feb 2011 Reading
Thu, 10 Mar 2011 Reading

This course is available as a public course at our Reading training centre.


£250 for 1 day

Included in the price:
  • Comprehensive Manual
  • Refreshments & Lunch
  • Post Course Support

Course Overview

Now that you have a firm foundation of basic and intermediate skills you are ready to advance your training in Microsoft Office Excel 2007. You can run calculations on data, sort and filter numeric data and more. This course will further your knowledge with more advanced Excel options such as automating common tasks, advanced analysis on more complex data sets, worksheet collaboration and sharing Excel data across other applications.

Course Objective

Learn to automate common tasks in Excel, apply advanced analysis to complex data sets, collaborate with others using Excel worksheets, and share Excel data across other applications.

Target student

This course is for the student who seeks the skills to create macros, Excel collaboration, worksheet data auditing and analysis, merging multiple data sources, and data import and export. Additionally, this course may be used to prepare for the Microsoft Certified Application Specialist exam in Microsoft Office Excel 2007, and has an established basic knowledge of Excel data management.

Prerequisites

Systematix courses, Microsoft Office Excel 2007 Level 1, Microsoft Office Excel 2007 Level 2, are recommended or similar knowledge and experience.

We offer a range of Excel training courses

Streamlining Workflow
  • Add Data Validation Criteria
  • Apply Conditional Formatting
  • Create a Macro
  • Edit a Macro
  • Modify Excel's Default Settings
  • Update a Workbook's Properties
Collaborating with Others
  • Administer Digital Signatures
  • Merge Workbooks
  • Protect Files
  • Restrict Document Access
  • Review Tracked Revisions
  • Set Revision Tracking
  • Share a Workbook
Auditing Worksheets
  • Create a Data List Outline
  • Trace Cells
  • Troubleshoot Errors in Formulas
  • Troubleshoot Invalid Data and Formulas
  • Watch and Evaluate Formulas
Analyzing Data
  • Create Scenarios
  • Create a Trendline
  • Perform Statistical Analysis with the Analysis ToolPak
  • Perform What-If Analysis
Working with Multiple Workbooks
  • Consolidate Data
  • Create a Workspace
  • Edit Links
  • Link Cells in Different Workbooks
Importing and Exporting Data
  • Export Excel Data
  • Import a Delimited Text File
Using Excel with the Web
  • Create a Web Query
  • Import Data from the Web
  • Publish a Worksheet to the Web
Structuring Workbooks with XML
  • Develop XML Maps
 
Publisher: Microsoft
Version: 2007
Length: 1 day
Course-ID: 084892

Printer Friendly Version
Download Outline As PDF
Request A Quote Ask Us A Question

Extremely professional, trainer tailored course to my needs and pace. Trainer was very enthusiastic, patient and knowledgeable, always helpful and willing to help

- Honeywell

Microsoft Registered Partner
BSI ISO 9000