“Vue, Dedicated to
Developing Brighter Futures”

Thursday 20th November 2008

Microsoft Excel Advanced

Description

Delegates should have basic keyboard and mouse skills and be familiar with working in the Windows environment. A very sound background of designing Excel spreadsheets through attendance of the Microsoft Excel Introduction and Intermediate courses or equivalent experience is essential.

What will you learn?

• To create powerful spreadsheets through the use of advanced functions
• To analyse data held as a database
• To understand Excel’s capabilities beyond this course

Course content

Naming Cells

• Individual Cells or Ranges
• The Name Box
• Creating Names
• Assigning a Name to a value
• Using Names in Formulas
• Applying Names
• Selecting Named Cells
• Book level v Sheet level Names

Advanced Functions

• Date and Time
• Logical
• Lookup
• Text

Further Database Features

• Advanced Filters
• Database Functions
• Subtotals
• Pivot Tables

Scenarios

• Adding Scenarios to a Workbook
• Showing different Scenarios
• Creating a Scenario Summary

Further Charting Features

• Adding Data to a Chart
• Creating Combination Charts
• Adding Graphics to Charts

Data Consolidation

• By Position and Category
• Creating Links
• Outlines

Where to go from here?

• More Functions
• Other features and Add-Ins
• Macros/Visual Basic for Applications (VBA)

Dates for this course

• Thursday 6th November 2008
• Wednesday 28th January 2009
• Thursday 12th March 2009

 

View main calendar | Book this course