Ardito Computer Training

  • Increase font size
  • Default font size
  • Decrease font size
Home Microsoft Office Excel Intermediate 2003

Excel Intermediate 2003

Student Feedback

Duration:1 day | Book this course
Cost: $275.00 + GST

Course Description


This one-day course guides participants through Excel's more advanced features. Participants learn how to create and edit databases; create and modify charts; format chart objects; work with multiple worksheets and workbooks, and use financial, logical and date functions. Students also gain hands-on experience using styles, custom formats, and conditional formatting.

Prerequisites
Participants should have completed the Excel 2003 Introduction level or have equivalent experience. If you are unsure, you may phone our Booking Administrator on (07) 857.0770 or (09) 630.1220 to request for a Training Needs Assessment form.

Who Should Take This Course
Users of Excel who want to learn about the software's advanced charting, financial, database and formatting features.

Course Outline

Review of Excel Formulas

  • Using AutoCalculate
  • Using Basic Functions
  • Using Formulas
  • Using AutoSum
  • Using AutoFill

 

Viewing Worksheets

  • Renaming worksheets
  • Deleting and Inserting Worksheets
  • Customising View Options
  • Displaying toolbars
  • Grouping and ungrouping worksheets
  • Hiding workbooks and worksheets
  • Freezing Panes

 

More Formatting Techniques

  • Using Styles
  • Conditional formatting
  • Using the Format Painter
  • Using gridlines
  • Hiding and displaying cells
  • Displaying hidden rows and columns

 

More Formulas and Functions

  • Using the Series command
  • Using the Insert Function wizard
  • Using the Excel Function categories
  • Introducing the LOOKUP functions

 

Database and List Management

  • Basic database terminology
  • Creating and editing an Excel database
  • Sorting a database
  • Using Autofilters
  • Using Advanced filter
  • Working with filtered data
  • Creating Subtotals
  • Using Data forms

 

Charts

  • Using the Chart Wizard
  • The Chart toolbar
  • Working with charts
  • Formatting charts (ie. labels, plot area, axis, etc.)

 

Drawing and Pictures

  • Using the Drawing tools
  • Working with AutoShapes
  • Creating text boxes
  • Adding pictures
  • Layering objects
  • Grouping and ungrouping objects

 

Excel and Other Applications

  • Converting files from other applications (e.g. Word)
  • Copying data from another application
  • Embedding and linking objects
  • Creating hyperlinks
  • Managing links