Microsoft Excel - Advanced

Introduction

This course is designed for experienced users of Excel. It will enable them to enhance their skills further by exploring some of Excel's analysis, planning and development features. Each section of the course will provide an opportunity to explore the new subject area, followed by an exercise or activity to reinforce learning. All courses are highly interactive and we encourage all delegates to join in, to enhance their learning process.

Course Aims

To provide the delegates with a knowledge of how to use Excel as a tool for Forecasting and advanced data manipulation. In addition an introduction to the concept of Macros is developed.

Course Objectives

• By the end of the course, delegates will be able to:
• Use pivot tables to group and count data
• Work with goal seek, scenario and solver
• Create a user interface using form controls and macro buttons
• Automate routine tasks with simple macros

Pre-requisites

We recommend that all those who attend are able to:

• Use Excel at an intermediate level

Course Content

(If requested courses can be tailored to cover specific work requirements)

Pivot Tables

• Creating a pivot table
• Changing pivot table fields
• Refreshing data

"What-If' Tools

• Goal Seek
• Scenarios
• Solver

Auditing Formulae

• Tracing Precedents/Dependents
• Error Checking
• Forecasting
• Forecasting Functions
• Growth & Linear Trend Fills
• Use Of Charts In Forecasting

Form Controls

• List Boxes and Spinners
• Scroll Bars and Macro Buttons

Macros

• Recording Simple Macros
• Assigning Macros
• Editing Simple Macros

Back to previous page