Excel Advanced

Length of Programme: 3 hours

About the Workshop:

Excel Advanced Course covers a range of topics including:

* Templates

* Automating spreadsheets

* Recording Macros

* Macro playback shortcuts

* The Visual Basic Editor

* Troubleshooting Macro Code

* Programming Fundamentals

* Interacting with the User

* Making Decisions

* User Forms

* Repeating Code

* Streamlining Code

* Custom Functions

Learning Objectives:

By the end of this course you will be able to:

* Record repetitive series of keystrokes and commands

* Create customised functions to perform calculations

* Understand the basics of the Excel programming language

* Automate spreadsheets and make them interactive for other users

When you book on to this session you will be sent a short questionnaire designed to identify your particular development needs and goals. The course provider will use this information to focus the course content to your needs and to the needs of other participants on the course.

Participants:

The Excel Advanced Course is designed for delegates who wish to learn how to automate processes within spreadsheets. The course will help participants to create their own customised functions to perform calculations, specific or unique to a task and to gain greater control of the Excel environment by learning the Excel programming language.

Please use this link: https://lpdc.admin.keele.ac.uk/index.php/hr_courses to view all scheduled workshops.