Microsoft Excel 2013 Courses

Instructor led Courses << Back to Home

Excel 2013 - Advanced Plus

Enquire about this Course >>

Microsoft Excel 2013 Advanced Plus - 1 Day

This course is designed to enable delegates to use spreadsheets with a high degree of skill by automating much of the daily workflow and using the forecasting facilities available in Excel.

Delegates will be able to automate both simple and complex tasks by creating automated spreadsheets for use by others.

Delegates should have a
- Attended our Excel 2013 Introduction, Intermediate & Advanced course
- Have an equivalent knowledge through use
- You do not need
  - To be a mathematician but being logical is cool!
If you would like to discuss this course further or wish to enquire if you're at the correct level call us on 08458 62 62 65 we'll be only too pleased to help.

By the end of this course you'll be able to
- Recognise options and settings within Excel that may be adjusted to suit the user
- Create templates to speed workbook creation
- Create on-line forms to control and ease input by users
- Record macros to automate repetitive tasks
- Create user-defined functions to automate repetitive calculations
- Create and manage Scenarios
- Create What-if data tables
- Utilise the Goal Seek and Solver tools to produce forecasts
- Utilise the built-in auditing tools to trace formulae and dependants to assist in troubleshooting
- Recognise options and settings

Lesson 1 - Templates
- - Create a template
  - Use a template
- - Edit a template
  - Insert a template as a worksheet

Lesson 2 - What If
- - Use goal seek
  - What-if tables
- - Scenario Manager

Lesson 3 - Solve
- - Solver overview
  - Use the solver feature
- - Use the help feature to obtain help on solver reports

Lesson 4 - Macros & Custom Controls
- - Record a macro
  - Assign a macro to a shortcut key
  - Run a macro using the tools macro command
  - Create option buttons
- - Attach macro to a button
  - Assign a macro to a button that already exists
  - Format the text inside a button

Lesson 5 - User Defined Functions
- - Create and use a simple custom function
- - Edit the custom function to recalculate the worksheet

Lesson 6 - Auditing Worksheets & Online Forms
- - The auditing toolbar
  - The Developer Ribbon
- - Form Controls
  - Use buttons linked to formula on a form