Microsoft Excel 2003 Level 1
With Excel 2003 you can use spreadsheets for common tasks such as budgeting, analysing sales, producing reports, creating charts and graphs and managing small lists. Powerful calculation and visualisation tools make analysing data simple.
Quick Facts
Duration: 1 Days
Class Size: 10
Level: Beginner
Times: 9.00am - 5.00pm approx
Other Microsoft Excel 2003 Courses:
About the Course
During this 1 day course, instructors will use practical exercises and real-life scenarios to take participants through the basics of Microsoft Excel 2003. Learn to navigate around the program, create workbooks and worksheets, use formulas, functions and ranges, create charts and apply formatting to enhance the presentation of your work.
Who should do this course?
This is an introductory course designed for people who need to know how to use Microsoft Excel 2003. Upon completion of the course, participants should be able to produce reports, budgets, lists and perform other similar tasks.
Prerequisites
No prior knowledge of Microsoft Excel is required, however it would be beneficial to have a general understanding of personal computers and the Windows operating system.
Course Units
- Unit 1: Spreadsheets
- - How Spreadsheets Work
- - Spreadsheet Characteristics
- - Spreadsheet Functionality
- - The Appropriateness of Spreadsheets
|
- Unit 2: Excel Orientation
- - Starting Microsoft Excel
- - The Excel Screen
- - Understanding the Workbook
- - Moving the Cell Pointer
- - Moving About the Workbook
- - Using Go to
- - Menus and Toolbars
- - Using Menus and Toolbars
- - Using Context Sensitive Menus
- - Exiting Excel
|
- Unit 3: A Simple Workbook
- - Creating a New Workbook
- - Entering Data in a Workbook
- - Saving a New Workbook
- - Opening a Saved Workbook
- - Creating an Input Range
- - Saving your Work
- - Essential Formatting
- - Column Best Fit
- - Closing a Workbook
|
- Unit 4: Selecting Ranges
- - Selecting Contiguous Ranges
- - Selecting Non-Contiguous Ranges
- - Using Special Selection Techniques
- - Selecting Larger Ranges
- - Range Calculations
|
- Unit 5: Formulas
- - Understanding Formulas
- - Formulas That Add
- - The Sum Function
- - Formulas That Subtract
- - Formulas That Multiply And Divide
- - Referential Formulas
- - What If Formulas
- - More Complex Formulas
- - Formula Error Checking
- - Common Error Messages
|
- Unit 6: Copying And Filling
- - Understanding Copying in Excel
- - Using Fill for Quick Copying
- - Copying From One Cell to Another
- - Copying From One Cell to Multiple Cells
- - Copying From Many Cells to Many Cells
- - Copying Relative Formulas
- - Copying to a Non-Contiguous Range
|
- Unit 7: Working with Functions
- - Functions
- - Typing a Sum Function
- - Summing Non-Contiguous Ranges
- - Calculating an Average
- - The Maximum Function
- - The Minimum Function
|
- Unit 8: Printing
- - Print Preview
- - Simple Printing
- - Previewing Large Worksheets
- - Page Orientation
- - Scaling to Fit
- - Printing to Multiple Pages
- - Creating Page Headers And Footers
- - Formatting Headers And Footers
- - Printing Formulas
|
- Unit 9: Charting
- - Using the Chart Wizard
- - Choosing the Chart Type
- - Changing the Chart Type
- - Modifying a Chart
- - Printing a Chart
- - Creating a Pie Chart
- - Creating a Bar Chart
- - Moving a Chart
- - Deleting a Chart
|
- Unit 10: Formatting Cells
- - Using the Font Tools
- - Using the Alignment Tools
- - Using the Number Tools
- - The Format Cells Dialog Box
- - Formatting Fonts Using the Menu
- - Superscript Subscript and Strikethrough
- - Changing Horizontal Alignment
- - Centering Across a Selection
- - Wrapping Text
- - Changing Text Orientation
- - Changing Vertical Alignment
- - Formatting Dates
- - Formatting Numbers
- - Formatting Currency
- - Creating Custom Formats
- - Borders And Shading
- - Clearing Cell Formats
|
- Unit 11: General Computer Usage
- - The Help Task Pane
- - Searching for General Help
- - Searching for Specific Help
- - Understanding a Help Window
- - Disabling Online Content
- - Enabling Online Content
- - Displaying and Using the Office Assistant
- - Customising the Office Assistant
- - Disabling the Office Assistant
- - Screen Tips And Dialog Box Help
- - Setting Up an Ergonomic Workstation
- - Breaks And Exercises
|
Upcoming Courses
|
Sydney
Level 11, 32 Walker Street
North Sydney
View map
|
- Date:
- 14 Mar 12
- 07 May 12
|
|
Melbourne
Level 12, 379 Collins Street
Melbourne
View map
|
- Date:
- 14 Feb 12
- 21 Mar 12
- 14 May 12
|
|
Brisbane
C/- Support Technology, Level 6, 371 Queen Street
Brisbane
View map
|
Date: upon demand
|
|
Canberra
C/O Atlas Business Services, 21 Barry Drive
Turner
View map
|
Date: upon demand
|
|
Adelaide
C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map
|
Date: upon demand
|
|
Perth
C/- Lansen Consulting Pty Ltd, Level 1, 484 Albany Highway
Victoria Park
View map
|
Date: upon demand
|
Duration: 1 Days
Class Size: 10
Level: Beginner
Times: 9.00am - 5.00pm approx
