Course advisor's notes

This one day seminar looks further into Microsoft Excel and will increase your skills in using this program. More information...

Email a friend

 

Seminar Content | Excel Advanced

Customizing toolbars and centre styles and templates.
Create decision-making functions.
Analyze worksheet data by creating PivotTables.
Compare and contrast workbook files and file links.
Outline and consolidation worksheets and analyze worksheet data by using the scenario Manager.
Display and protect worksheet data by locking cells.
Record and modify macros by using the Visual Basic Editor.
Create and work with interactive Web documents.

Aims and Objectives

To further develop your skills in Excel.
To ensure you can customise toolbars and create styles and templates.
To efficently analyse worksheet data by creating PivotTables.
Be able to compare and contrast workbook files and file links.

Target Audience

Students enrolling in this course should understand the basic concepts involved in using Excel. For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opeing and saving files.

Prerequisites

To ensure students' success with this course, we recomment that they first take the following Element K Content courses or have equivalent knowledge of this software.

Seminar Code

076202

::adCenter::