Microsoft Excel - Advanced

Pentland Training

Training

In Congleton

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Training

  • Level

    Advanced

  • Location

    Congleton

  • Duration

    1 Day

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. Suitable for: Those with basic skills and some experience of Microsoft Excel.

Facilities

Location

Start date

Congleton (Cheshire)
Pentland Training 1 The Courtyard Greenfield Road, CW12 4TR

Start date

On request

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

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.

See related categories

Microsoft Excel - Advanced

Price on request

The best Excel courses

See all

See all