Course Outline

Microsoft Excel 2010 Advanced

Overview

Who is this course for?

With basic skills and some experience of Microsoft Excel, the topics covered on this course will enable you to further enhance your spreadsheets and to use some of the more advanced features to streamline your work

 

How long is this course?

1 Day 

 

What do I need to know before attending?

It is assumed only that you have a skill level equivalent to that gained through attending the Excel Intermediate Course. 

 

What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:

  • Use more Excel functions.
  • Utilise Excel's database functions.
  • Control and enhance Excel graphs.
  • Create simple macros.
  • Customise your Excel environment.

 

Price Band:

 General

Content

Advanced Spreadsheets
Working with range names.
Working with and consolidating multiple sheets.
Further use of Excel functions such as conditional IF and Lookup.

Working with Text
Text Functions and Text Import.

Graphs and Charts
Different graph styles, creating, enhancing and editing graph.
Printing independently or as part of the spreadsheet.

Database Functions
Creating Excel databases.
Accessing data by sorting and filtering data.
Producing summary statistics.
Cross tabulation using Pivot tables.
Specific database functions.

Introducing Macros
Recording commands in macros to simplify routines.
Editing macros and assigning to objects.

Object Linking & Embedding
Embedded Objects and Linking Objects.

Security Features
Protecting Files.
Protecting Cells.
Protecting Worksheets.
Protecting Workbooks.

What-If Analysis
Goal Seek and Solver.
Scenarios.
Data tables.

Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.

call us on 01949 212121

www.vtl.co.uk
IIP