Excel 2007 Level 3 Advanced

Public Course Dates

	Date	Location
	Fri, 24 May 2013	Reading
	Fri, 19 Jul 2013	Reading
	Fri, 13 Sep 2013	Reading
	Fri, 8 Nov 2013	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 Description
Course Outline

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

Related Courses

Each of us returned extremely positive and motivated - the arrangements, as usual, ran like clockwork - we certainly felt the course was of benefit

- Local Charity