Introduction to Excel 2002 / 2003 - Course Outline
COURSE INFORMATION
Duration: Two Days: 9am - 4:30pm
Price: $780
Book: Enquire or make a course booking
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 |