Microsoft Excel 2007 Intermediate Training Course

Microsoft Excel 2007 Intermediate Training Course Outline

This one-day Microsoft Excel 2007 Intermediate
Training Course builds on the skills and concepts taught
in Excel 2007: Basic. Students will learn how to use
multiple worksheets and workbooks efficiently, and they
will start working with more advanced formatting options
including styles, themes, backgrounds, and watermarks.
They will also learn how to create outlines and
subtotals, how to create and apply cell names, and how
to work with lists and tables. Students will save
workbooks as Web pages, insert and edit hyperlinks, and
save a workbook as a PDF file. This course also covers
advanced charting techniques, worksheet auditing and
protection, file sharing and merging, and workbook
templates. Designated as Approved Courseware. For
comprehensive certification training, students should
complete Excel 2007: Basic, Intermediate, and Advanced.
Contact us for further details.

Course objectives

After completing this course, students will know how
to:

Link worksheets by using 3-D
formulas; add a Watch window; create and manage links
between workbooks; and create a workspace.

Apply
special and custom number formats; control the display
of zero values; use functions to format text; create,
apply, and modify styles; apply and modify themes; merge
and split cells; change the orientation of data in
cells; transpose data; and add background color and a
watermark.

Create an outline and consolidate data;
create subtotals in a list; and use multiple subtotal
functions.

Define and apply cell and range names;
use names in formulas; and define and apply 3-D names.

Sort lists by columns; filter lists based on complex
criteria and copy filtered results to another range;
create and format a table and add rows and columns;
apply structured referencing; name tables; and create
functions with [#This row].

Save and publish a
worksheet as a Web page; insert and edit hyperlinks;
publish a worksheet as a PDF file, and send a worksheet
as an e-mail attachment.

Use auditing features; add
comments to cells and workbooks; protect a worksheet or
part of a worksheet; share, merge, and track changes in
a workbook; find and remove hidden and personal data
from a workbook; and mark a workbook as final.

Prerequisites

Before taking this course, you
should be familiar with personal computers and the use
of a keyboard and a mouse. Furthermore, this course
assumes that you've completed the Excel 2007: Basic
course or have equivalent experience.

Target Audience

Beforetaking this course, you
should be comfortable using a personal computer and Microsoft Windows. You should have some
experience using Microsoft Excel. You will get the most
out of this course if your goal is to become proficient
in such tasks as consolidating data, using advanced
chart formatting options, sorting and filtering lists,
using special formatting options, using templates, using
error tracing features, protecting worksheets, and
linking worksheets and workbooks.

Certification Track

For comprehensive training,
you should complete all of the following courses: Excel
2007: Basic, Excel 2007: Intermediate, and Excel 2007:
Advanced.

Delivering courses on your
premises is a highly effective and
cost-effective way to provide the
training you require. Course prices are
lower than offsite and an expert
instructor comes to you at no additional
cost - you pay only the course fee.
click here to see further details

+-

Bespoke courses

In addition to our superb standard training courses we develop custom solutions, tailor courses to suit your needs and
provide consultancy services at all levels for all disciplines in all sectors.

+-

Fast-track and other training
styles

Fast track training sessions are highly-focussed intensive
training sessions delivered in short bursts to give busy people the
essential skills they need in the shortest possible time.

This type of training is different from our comprehensive,
standard, instructor-led training
course format: fast track training is dynamic, it is suitable for
people with excellent learning abilities and is typically carried out without
manuals or formal exercises but is designed and delivered by an
expert instructor to ensure that the essential skills required are
transferred very effectively and efficiently. Post-course support is
also included in the price.

+-

Pre-course assistance

Matching skill gaps and business needs to the most suitable courses
with this service will save time, effort and expense.

Pre-course assistance and advice from an expert instructor / consultant is provided and courses are designed to your business needs and staff training requirements.

+-

Post-course support

Our prices include post-course support for delegates requiring
assistance after a training course.

+-

Top-quality Manuals

Our training course manuals include notes, exercises and files that are excellent for post-course reference and further study.

+-

Training Needs Analysis

Our Training Needs Analysis (TNA) service will help training bookers,
administrators and HR professionals get the very best from their
training budget by identifying skill gaps, matching them to
top-quality courses and deliver the most effective training
possible.