Course Outline

Microsoft Excel Advanced - Open Schedule

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?

Delegates should have attended the Microsoft Excel Intermediate course or have the equivalent skills and knowledge to that level. 

 

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, Cells, Worksheets and Workbooks.

Templates
Creating & editing templates.
XLSTART Directory.
Understanding AutoTemplates.

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

Customising Excel
Changing Microsoft Excel's default settings.
Customising menus and toolbars and assigning macros to new buttons.

call us on 01949 212121

www.vtl.co.uk
IIP