Course Title:
Microsoft Excel - Advanced

Duration: 1 day

Course Overview
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.

Target Audience


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

Course Objectives


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.

Course Content


Advanced Spreadsheets
Working with range names, working with multiple sheets, consolidating multiple worksheets.

Design
Planning and building large spreadsheets, understanding syntax and using additional Excel functions.

Databases
Creating Excel databases, accessing data from external sources, sorting and filtering data, using the Pivot Table to produce summary analysis.

Graphing
Different graph styles, creating and extending linear and polynominal trends.

Macros
Recording commands in macros in Visual Basic to simplify routines, editing macros and assigning to buttons.

Customising
Changing Excel default settings, customising toolbars, assigning macros to toolbars.

Protection
Customising menus, protecting areas of a worksheet, password protection for files.


Enter your email address to register for our newsletter:



IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals