major projects for IT training crown software and compter consultancy

Microsoft Excel Advanced Course Outline

Course Aims

This one-day course is designed to give users an understanding of some of the more advanced features and functions within Excel and the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in using advanced features of Excel to manage, automate and customise workbooks.

Course Outline

MS Excel Advanced
Review Exercise

Importing Data
Importing Data from External Sources
Importing Text Files

Templates and Styles
Working with Templates
Working with Styles

Analyzing Data
What-If Analysis
Goal Seek
Data Tables
Scenario Manager
Solver

Pivot Tables
Creating Simple Pivot Tables
Formatting Pivot Tables

Macros and Custom Controls
Working with Macros
Running Macros
Adding Custom Controls

Security and Proofing
Security Features
Protecting Excel Files
Worksheet Protection
Working with Digital Signatures
Checking Spelling
Using Data Validation
Documentation

Customising Excel
Configuring Excel
Customizing the Excel Environment
Working with Workspaces

Collaboration and Consolidation
Sharing Workbooks
Sending Workbooks
Consolidation

Target Audience

Existing users of MS Excel who want to gain further in-depth knowledge in a short space of time.

Assumed Knowledge

A good working knowledge of Excel plus Windows is assumed, gained from the workplace or by prior attendance on an "MS Excel Intermediate" course.

Related Courses

Excel Introduction and Intermediate; 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