major projects for IT training crown software and compter consultancy

Microsoft Excel Intermediate Course Outline

Course Aims

This one-day course is designed to advance users' knowledge of the features and functions within Excel and realize the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets, enhancing them with charts and graphics and using more advanced formulae.

Course Outline

Viewing Worksheets
Reviewing the Basics
Customising View Options
Displaying and Customising Toolbars
Hiding Workbooks and Worksheets
Freezing Panes
Grouping and Ungrouping Worksheets

More Formatting Techniques
Using Styles
Conditional Formatting
Using the Format Painter
Using Guidelines
Hiding and Displaying Cells

More Formulas and Functions
Using the Series Command
Using the Insert Function Wizard
Using the Excel Function Categories
Correcting Formulas
Using the Formula Error Checker
Using the Formula Auditing Toolbar
Using the Watch Window

Database and List Functions
Using Databases
Creating and Editing Databases
Sorting a Database
Using AutoFilters
Advanced Filters
Working with Filtered Data
Using Data Forms

Charts and Pictures
Chart Wizard
Chart Toolbars
Working with Charts
Formatting the Chart

Drawing and Picture Objects
The Drawing Toolbar
Working with Autoshapes
Creating Text Boxes
Adding Pictures
Layering Objects
Grouping and Ungrouping Objects

Excel and the Other Applications
Converting Files from Other Applications
Copying Data from Other Applications
Embedding and Linking Objects
Hyperlinks
Managing Links

Target Audience

Users with a basic understanding of MS Excel who want to consolidate and expand on their knowledge of the basic features in a short space of time.

Assumed Knowledge

A working knowledge of using a P, keyboard and mouse, Windows and some experience of creating basic spreadsheets is assumed, gained from the workplace or by prior attendance on a "Windows User Introduction" or "MS Excel Introduction" course.

Related Courses

Excel Introduction and Advanced; Windows; other MS Office applications

IT training microsoft office lotus smartsuite

For further information e-mail:info@major-projects.co.uk
All site content is © Major Projects Limited | Website design is © Ambrow Limited