“Vue, Dedicated to
Developing Brighter Futures”

Thursday 20th November 2008

Microsoft Excel Intermediate

Description

Delegates should have basic keyboard and mouse skills and be familiar with working in the Windows environment. Attendance of the Microsoft Excel Introduction course or thorough equivalent experience is essential.

What will you learn?

• To create and print charts
• To create more complex spreadsheets
• To create template spreadsheets
• To use Excel as a simple database

Course content

Creating Charts

• Using the Chart Wizard
• Chart Sheets versus Chart Objects
• Column, Line and Bar Charts
• Formatting Charts
• Printing Charts

Working with Multiple Sheets

• Inserting, Deleting, Moving and Copying Sheets
• Renaming Sheets
• Grouping Sheets
• Creating Linking and 3-D Formulas

Linking Workbooks

• Linking Formulas across Workbooks
• Updating Links
• Workspaces

Templates and Folders

• Creating a Template
• Using a Template
• The XLStart Folder
• Alternate Startup File Location

Further Formatting

• Styles
• Custom Formats
• Conditional Formatting

Databases

• Terminology
• Creating a Database
• Using the Data Form
• Sorting
• Filtering

Dates for this course

• Monday 13th October 2008
• Wednesday 10th December 2008
• Friday 30th January 2009
• Wednesday 11th March 2009

 

View main calendar | Book this course