Course Outline

Microsoft Excel 2016 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, e.g. Waterfall and Sunburst.
Creating, enhancing and editing graphs.
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.
Using Slicers and the Timeline Slicer.
Get & Tranform (Query)
Power View.

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.

call us on 01949 212121

www.vtl.co.uk
IIP