Introduction to Excel 2002 / 2003

TARGET AUDIENCE & PURPOSE

This Introduction to Excel Course is for people new to Spreadsheets, and for self taught users wanting to enhance their knowledge. It is a pre-requisite for the Advanced Microsoft Excel course.

OBJECTIVES

By the end of this course participants should be able to:

* Recognise the main areas of the Excel window and workbook
* Enter, edit and delete data in a workbook
* Create workbooks using formulae and functions, including SUM, AVERAGE, MAX and MIN
* Enhance the presentation of workbook data
* Create, display and enhance charts, print worksheets
* Set up and work with multiple worksheets
* Freeze titles on a worksheet
* Sort and subtotal data
* Add comments to a worksheet

PREREQUISITES

Participants should already be competent in using a mouse and keyboard and have an understanding of Windows.

COURSE CONTENT

* Exploring Microsoft Excel
Working with Excel Windows & Worksheets, Displaying & Hiding Toolbars & Buttons, Using Menu Commands & the Task Pane

* Using Basic Workbook Skills
Selecting a Cell using the Keyboard & Mouse, Entering Text & Numbers into Cells, Saving & Closing a Workbook, Opening an Existing Workbook, Using Data Entry Shortcuts, Editing Cell Entries, Checking Spelling, Creating a New Folder, Renaming a Workbook

* Working with Ranges
Selecting Ranges with the Keyboard & Mouse, Selecting Non-adjacent Ranges, Entering Values into a Range, Using Auto Fill

* Creating Simple Formulas
Entering Formulas & Basic Functions, Using AutoSum, Inserting Functions in Formulas, Using AutoCalculate

* Copying & Moving Data
Copying/Cutting & Pasting Data, Using the Paste List, Using the Clipboard Task Pane, Creating an Absolute Reference, Filling Cells, Using Drag & Drop Editing, Using Undo & Redo

* Formatting Numbers & Text
Using Currency, Percent & Comma Styles, Changing Decimal Places, Changing Text Appearance, Rotating, Wrapping & Shrinking Text in a Cell, Changing Cell Alignment, Changing Text Indentation

* Formatting Cells
Using the Merge & Centre Button, Changing the Vertical Alignment, Using the Borders Button, Pasting Formats, Using the Format Painter Button, Copying Formats to Non-Adjacent Cells, Clearing Formats, Inserting Selected Cells, Deleting Selected Cells

* Working with Columns & Rows
Changing the Column Width & the Row Height, Adjusting Columns, Automatically, Hiding & Unhiding Columns & Rows, Inserting a Column, Insert a Row, Deleting a Column, Deleting a Row

* Using Page Setup
Setting Margin & Centring Options, Changing the Page Orientation, Customizing Headers & Footers, Changing Page Setup Options

* Printing
Previewing a Worksheet, Printing the Current Worksheet, Printing a Selected Range, Printing Multiple Copies, Printing a Page Range

* Customizing Excel Preferences
(Time Permitting)
Setting View Options, Setting Edit Options, Setting General Options

* Working with Comments
Creating, Viewing & Printing Comments, Discussion Comments

* Working with Multiple Worksheets
Navigating between Worksheets, Selecting & Renaming Worksheets, Selecting Multiple Worksheets, Colouring Worksheet Tabs, Inserting & Deleting Worksheets, Printing Selected Worksheets, Copying & Moving Worksheets, Using Grouped Worksheets, Moving & Copying Data between Worksheets, Creating 3-D Formulas & Functions

* Using Other Functions
Using Function Arguments, Using Financial Functions, Using Logical Functions, Using Date Functions, Formatting Dates, Revising Formulas

* Creating & Editing Charts
Creating Charts, Moving & Resizing Charts, Changing the Chart Type & Sub-type, Changing the Plot Direction, Removing/Adding a Legend, Charting Non-adjacent Ranges, Changing the Data Source, Changing the Chart Location, Printing a Chart, Formatting Chart Objects, Changing the Text Orientation, Adding a Data Table, Creating an Exploded Pie Chart, Adjusting the 3-D View, Deleting a Chart

* Using Large Worksheets
Magnification, Full Screen View, Splitting the Window, Freezing Panes

* Managing Data
Sorting Lists, Sorting in Ascending / Descending Order, Finding Data, Replacing Data, Finding & Replacing Cell Formats, Managing Data

* Drawing an Object
Drawing Enclosed Objects, Drawing a Line, Selecting & Moving Objects, Adding Text to an Object, Resizing an Object, Changing the Fill Colour, Changing the Font Colour, Deleting an Object

* Additional Effects & Objects
Adding a 3-D Effect, Adding a Shadow, Drawing a Text Box, Drawing an Arrow, Inserting & Formatting Graphics

* Using AutoShapes & Diagrams
Drawing a Callout, Basic Shape, Connector, Flowchart Shape & a Block Arrow, Inserting a Diagram, Working with Diagrams

* Using Worksheet Protection
Unlocking Cells in a Worksheet, Protecting & Unprotecting a Worksheet & Workbook, Creating & Deleting Allow-Editing Ranges, Assigning a Password, Using the Document Recovery Pane

* Using Paste Special
Working with Paste Special, Copying Values & Formulas between Worksheets, Performing Mathematical Operations

Duration: Two Days

see less