Excel 2007 - Advanced level

View our full Excel Course Schedule for course dates or call 0845 485 1173 today for more details

You can view this course outline as a PDF for printing

Excel 2007 Advanced

1 Day Course

Objectives

By the end of the day you will know how to:

• Use advanced functions
• Create Lookups and data tables
• Manage large lists of data
• Create and use PivotTables and PivotCharts
• Export and import data
• Analyse data effectively
• Create basic macros
• Use conditional formatting

Prerequisites

You should have ideally attended our Excel Intermediate level course, or have sufficient experience and understanding of Excel, especially complex formulae.

Course Contents

Unit 1: Advanced functions

• Topic A: Logical functions
• Topic B: Math and statistical functions
• Topic C: Financial functions
• Topic D: Displaying and printing formulas

Unit 2: Lookups and data tables

• Topic A: Using lookup functions
• Topic B: Using MATCH and INDEX
• Topic C: Creating data tables

Unit 3: Advanced list management

• Topic A: Validating cell entries
• Topic B: Exploring database functions

Unit 4: PivotTables and PivotCharts

• Topic A: Working with PivotTables
• Topic B: Rearranging PivotTables
• Topic C: Formatting PivotTables
• Topic D: PivotCharts

Unit 5: Exporting and importing

• Topic A: Exporting and importing text files
• Topic B: Exporting and importing XML data
• Topic C: Querying external databases

Unit 6: Analytical options

• Topic A: Goal Seek and Solver
• Topic B: The Analysis ToolPak
• Topic C: Scenarios
• Topic D: Views

Unit 7: Macros and custom functions

• Topic A: Running and recording a macro
• Topic B: Working with VBA code
• Topic C: Creating functions

Unit 8: Conditional formatting and SmartArt

• Topic A: Conditional formatting with graphics
• Topic B: SmartArt graphic

If you would like to make an enquiry about our Training, fill in the form below, or call us on 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk

Name:* Please enter your name

Company:

Email:* Please enter your email

Telephone:

Contact us for:* Booking Enquiry Information Request

Course interest: Access Dreamweaver Excel Google AdWords Illustrator Indesign Not Listed/Other Outlook Photoshop PowerPoint Project Publisher Word

Message: Please enter your message