Home - Microsoft Office Training Courses - Microsoft Excel 2007 Intermediate

In our intermediate Microsoft Excel 2007 training course you will learn how to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas as well as to apply visual elements and advanced formulas to a worksheet to display data in various formats.

You will also learn how to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. This includes how to calculate with advanced formulas, organize worksheet and table data using various techniques, create and modify charts, analyze data using PivotTables and PivotCharts, insert graphic objects and how to customize and enhance workbooks and the Microsoft Excel environment.

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

Calculating Data with Advanced Formulas

• Manage Cell and Range Names
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions

Organizing Worksheet and Table Data

• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Calculate Data in a Table or Worksheet

Presenting Data Using Charts

• Create a Chart
• Modify Charts
• Format Charts

Analyzing Data Using PivotTables and PivotCharts

• Create a PivotTable Report
• Analyze Data Using PivotCharts

Inserting Graphic Objects

• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects

Customizing and Enhancing Workbooks and the Excel Environment

• Customize the Excel Environment
• Customize Workbooks
• Manage Themes
• Create and Use Templates

Schedule your own Excel 2007 Intermediate 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.