Home - Microsoft Office Training Courses - Microsoft Excel 2007 Advanced

In our advanced Microsoft Excel 2007 training course you will learn how to extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications. This includes how to increase productivity and improve efficiency by streamlining your workflow, collaborate with others using workbooks, audit worksheets, analyze data, work with multiple workbooks, import and export data, use Excel with the web and how to structure workbooks with XML.

Duration: 1 day.

Location: 21st Century New Media Ltd, Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire, WD6 1JG. [Click here for a map]

Times: 10.00am to 4.30pm. For security reasons, further details are only provided upon booking.

Equipment: Our fully featured training room includes six top-of-the-range iMac computers configured to work in both Macintosh (OSX) and PC (Windows) modes, ensuring you the maximum familiarity with your chosen operating system.

Accommodation: Details of local accomodation can be found here.

Further assistance: Our FAQ help page contains the answers to many popular questions. Alternatively please call 0844 844 2428 to arrange to speak to our training manager.

COURSE CONTENT

Streamlining Workflow

• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update a Workbook's Properties
• Modify Excel's Default Settings

Collaborating with Others

• Protect Files
• Share a Workbook
• Set Revision Tracking
• Review Tracked Revisions
• Merge Workbooks
• Administer Digital Signatures
• Restrict Document Access

Auditing Worksheets

• Trace Cells
• Troubleshoot Errors in Formulas
• Troubleshoot Invalid Data and Formulas
• Watch and Evaluate Formulas
• Create a Data List Outline

Analyzing Data

• Create a Trendline
• Create Scenarios
• Perform What-If Analysis
• Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks

• Create a Workspace
• Consolidate Data
• Link Cells in Different Workbooks
• Edit Links

Importing and Exporting Data

• Export Excel Data
• Import a Delimited Text File

Using Excel with the Web

• Publish a Worksheet to the Web
• Import Data from the Web
• Create a Web Query

Structuring Workbooks with XML

• Develop XML Maps
• Import and Export XML Data

Schedule your own Excel 2007 Advanced training course
Please tell us where and when YOU would like to attend this course. If we are able to schedule the course we will contact you.
Course	Please Select Access 2003 Advanced Access 2003 Expert Access 2003 Intermediate Access 2003 Intro Access 2007 Advanced Access 2007 Complete Access 2007 Essential Access 2007 Expert Access 2007 Intermediate Access 2007 Intro Access 2010 Advanced Access 2010 Complete Access 2010 Essential Access 2010 Expert Access 2010 Intermediate Access 2010 Intro Acrobat Adobe Air Adobe Flex Advanced CSS After Effects Alternatives: Graphics Alternatives: Publishing Alternatives: Web Design Animation Workshop Apple Motion Business Startup Business Vision Coaching Comedy Scriptwriting Complete Final Cut Pro CSS Layout Digital Video Cameras Dreamweaver DVD Studio Pro Essential Final Cut Pro Excel 2003 Advanced Excel 2003 Intermediate Excel 2003 Intro Excel 2007 Advanced Excel 2007 Complete Excel 2007 Essential Excel 2007 Expert Excel 2007 Intermediate Excel 2007 Intro Excel 2010 Advanced Excel 2010 Complete Excel 2010 Essential Excel 2010 Expert Excel 2010 Intermediate Excel 2010 Intro Film and TV Industry Intro Film and TV Scriptwriting 1 day Film and TV Scriptwriting Intro Film Making Fundamentals Final Cut Express Final Cut Pro Intro Final Cut Studio Fireworks Flash ActionScript Flash Advanced Flash Catalyst Flash Complete Flash Intro Flash Media Flash Video Google Adwords Google Adwords Advanced Green Screen Complete Green Screen Intro Green Screen Plugins Green Screen Practical HTML Emails HTML Intro Illustrator Advanced Illustrator Complete Illustrator Intro iMovie InDesign Complete Internet Marketing iPhone Apps JavaScript Open Office Outlook 2000 Advanced Outlook 2000 Intro Outlook 2003 Advanced Outlook 2003 Intermediate Outlook 2003 Intro Outlook 2007 Advanced Outlook 2007 Complete Outlook 2007 Essential Outlook 2007 Intermediate Outlook 2007 Intro Outlook 2010 Advanced Outlook 2010 Complete Outlook 2010 Essential Outlook 2010 Intermediate Outlook 2010 Intro PC Networking PC Repair and Maintenance Photography Photography Intro Photoshop Advanced Photoshop Complete Photoshop Intro Photoshop Web Podcasting PowerPoint 2000 Advanced PowerPoint 2000 Intro PowerPoint 2003 Advanced PowerPoint 2003 Intro PowerPoint 2007 Advanced PowerPoint 2007 Complete PowerPoint 2007 Intro PowerPoint 2010 Advanced PowerPoint 2010 Complete PowerPoint 2010 Intro Premiere Pro Publisher 2000 Intro Publisher 2002 Intro Publisher 2003 Intro Publisher 2007 Intro Publisher 2010 Intro QuickBooks Response Forms SEO Techniques Shopping Carts Social Media Twitter Viral Video Web 2.0 Intro Web Business Web Database Techniques Web Effects Web Hosting Web Project Management Web Video Techniques Website Accessibility Word 2000 Intermediate Word 2000 Intro Word 2003 Advanced Word 2003 Intermediate Word 2003 Intro Word 2007 Advanced Word 2007 Complete Word 2007 Essential Word 2007 Intermediate Word 2007 Intro Word 2010 Advanced Word 2010 Complete Word 2010 Essential Word 2010 Intermediate Word 2010 Intro WordPress Advanced WordPress Complete WordPress Intro WordPress Theme Design  Enter a custom course
Month	March 2012 April 2012 May 2012 June 2012
Time	Please Select Weekday (Mon-Fri) Weekend Saturday only Sunday only Evening
Location	Elstree Studios At your location
First Name *
Last Name *
Telephone Number *
Email Address *
If you cannot easily read the two words above, click on the icon that has two arrows chasing each other and new words will be displayed for you.