|
|
|
  
EXCEL 2003:
CORE
 Click
here for Expert
Course Objectives:
To teach the
Excel 2003 program to Microsoft Office Specialist Level
Pre-requisites:
Familiar with
Windows environment and basic keyboarding experience
Course Content:
-
The Excel 2003
screen, creating a worksheet, entering text and numeric data,
navigation, saving, naming and closing, opening an existing
spreadsheet, editing cell contents, accessing help
-
Changing font type
and size, text enhancement, selecting cells and ranges, text
alignment, merging and splitting cells, modifying column width
and row height, printing the active sheet, creating a folder,
saving in a different format
-
Inserting and
deleting rows, switching between multiple workbooks, moving and
copying cells, cut, copy and paste, AutoFill, Office clipboard
-
AutoComplete, Hide
and unhide columns and rows, freezing and unfreezing panes,
inserting columns, change text orientation, page break preview,
changing to landscape orientation, adjusting margins and
scaling, centring between margins, displaying gridlines,
inserting headers and footers, setting a print area, selecting
non-adjacent data, naming and deleting a worksheet, saving a
workbook as a template, creating a workbook from a template
-
Applying borders,
formatting numbers, defining and applying styles, Auto
Calculate, complex formulas, absolute cell references
-
Inserting a new
worksheet, formatting a worksheet tab, grouping and ungrouping
worksheets, 3-D references, applying wrap text formatting,
indenting text, printing row and column headings, centring text
horizontally and vertically in a range, adding, viewing and
editing comments
-
Using the SUM and
COUNT functions, AVERAGE, MAX and MIN functions, sorting
columns, using NOW and IF functions, PMT and FV functions,
AutoFilter, find and replace
-
Using the Chart
Wizard, creating a two series line chart, formatting the plot
area, creating a pie chart, saving selected data and a workbook
as a web page, inserting a picture, resizing and repositioning,
inserting and modifying an object, inserting and using a
hyperlink, creating, modifying and positioning a diagram
Benefits
-
Learn how to use this popular spreadsheet program to Microsoft
Office Specialist level
-
The
flexibility and value of a self-study course designed to enable you
to work at your own pace
-
A
personalised workbook to use as a reference guide on completion of
the course
-
The opportunity to gain
the widely recognised Pitman Training Certificate
Duration:
20 hours
EXCEL 2003:
EXPERT
Course Objectives:
To teach Excel
2003 to Microsoft Office Expert level
Pre-requisites:
Working
knowledge of the Excel 2003 program, ideally having completed the
first Microsoft Office Excel 2003 course
Course Content:
-
Creating a template,
using an existing template, editing a template, creating custom
views, deleting custom views, consolidating data, creating a
workspace file, using workspace files, creating and modifying
custom number formats, using conditional formatting, deleting
conditional formatting
-
Printing grouped
worksheets and multiple workbooks, naming and modifying cell
ranges, moving a named range, using range names to locate data,
deleting a named range, using range names in calculations,
formatting and resizing graphics, formatting charts and
diagrams, finding trends in data
-
Setting security
levels for macros, creating macros, running macros, editing a
macro, creating a toolbar and menu to hold macros, deleting
macros, deleting a toolbar button, deleting a custom toolbar and
menu
-
Applying data
validation rules, adding input messages and error alerts,
locating invalid data, tracing precedents and dependents,
tracing errors, evaluating formulas, using the watch window,
using AutoFilter and Advanced Filter, using a data form
-
Compiling subtotals
and consolidations, summarising data using outlining tools,
using the database functions DSUM and DAVERAGE, using the Query
Wizard with an external data source, analysing data using pivot
tables, creating a pivot table chart, creating a pivot table
from external data
-
Using data analysis
to calculate rank and percentile, solving a problem using goal
seek, using solver to calculate a quotation, creating What-If
Analyses using the scenario manager
-
Protecting
worksheets and workbooks, applying and removing passwords,
sharing a workbook, merging workbooks, understanding workbook
history, track changes, accept or reject changes, using digital
signatures
-
Inserting an
embedded object, inserting a linked object, retrieving data from
the web, saving as a web page, publishing worksheets, editing a
web page and republish, saving an Excel workbook as an XML
document, mapping data in a workbook, importing an XML document
into an existing mapping
Benefits
-
Know how to use Excel
2003 to Microsoft Office Specialist level
-
The flexibility and
value of a self-study course designed to enable you to work at your
own pace
-
A personalised workbook
to use as a reference guide on completion of the course
-
The opportunity to gain
the widely recognised Pitman Training Certificate
Duration:
18 hours each
|
|
