Excel 2010 - 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 2010 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

Advanced functions

• Logical functions
• Math and statistical functions
• Financial functions
• Displaying and printing formulas

Lookups and data tables

• Using lookup functions
• Using MATCH and INDEX
• Creating data tables

Advanced data management

• Validating cell entries
• Exploring database functions

PivotTables and PivotCharts

• Working with PivotTables
• Rearranging PivotTables
• Formatting PivotTables
• PivotCharts

Exporting and importing

• Exporting and importing text files
• Exporting and importing XML data
• Querying external databases

Analytical options

• Goal Seek and Solver
• The Analysis ToolPak
• Scenarios
• Views

Macros and custom functions

• Running and recording a macro
• Working with VBA code
• Creating functions

Conditional formatting and SmartArt

• Conditional formatting with graphics
• 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

Powered by EMF Web Forms Builder

Report Abuse