Course Outline

Microsoft Excel 365 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.
  • Work with multiple workbooks and data imports.
  • Utilise Excel's data analysis tools.
  • Security features.
  • Macros.

 

Price Band:

 General

Content

Recap of Fundamentals
Useful tips and shortcuts.
Absolute Cell References.
Tracing Formula.

Advanced Use of Range Names
Working with Range Names.
INDIRECT function.
Range Names and Intersect.

Advanced Array and Lookup Functions
MATCH, OFFSET and INDEX.
ARRAY Functions.
Advanced VLOOKUP Techniques.
VLOOKUP ARRAY.
VLOOKUP CHOOSE.

Working with Multiple Workbooks and Other Files
Linking Worksheets/Workbooks.
Text Import.
Text to Column's.

Database Functions
Subtotals.
Database Functions.
Advanced Pivot Tables.

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

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


Introducing Macros
Recording commands in macros to simplify routines.
Editing macros and assigning to objects.
Introduction to VBA (Visual Basic for Applications)

call us on 01949 212121

www.vtl.co.uk
IIP