About This Training Course

This Microsoft Excel 2007 Introduction Training Course is designed as an course for people who are new to MS Excel spreadsheets or converting from another program.

Subjects Covered

This Microsoft Excel 2007 Training Course will cover the following subjects:

Excel 2007 Basics

• Overview & Excel 2007 Screen
• Title Bar
• Ribbon and Ribbon Tabs
• Name Box and Formula Bar
• Worksheets
• Selecting Cells
• Using Ranges
• Entering Data into the Worksheet
• Data Entry Techniques
• Entering a Formula
• AutoSum
• Managing your Workbook
• Editing Data

• Editing the Contents of a Cell
• Find & Replace
• Editing a Formula
• Inserting Columns, Rows and Cells
• Copying and Moving Data
• Drag and Drop Editing
• Copying Formatting
• Clearing Format
• Formulas and Functions

• Relative Formulas
• Absolute References
• Using Basic Functions
• Status Bar Calculations
• Using the Function Button
• Preparing for Print

• Fine Tuning for Print
• Page Layout View
• Page Setup Options
• Print Preview
• Controlling Page Breaks
• Page Break Preview
• Printing a Worksheet
• Print Title
• Charting

• Types of Charts
• Choosing the Source Data
• Category and Value Axis
• Working with Charts
• Chart Tools
• Moving and Sizing Embedded Charts
• Creating a Pie Chart
• Charting Non-Consecutive Data
• Changing the Axis Plot Order
• Layout Tools
• Printing a Chart
• Themes & Graphics
• Themes & Graphics
• Themes and Styles
• Adding a Picture or Graphic
• Formatting Graphic
• Spreadsheet Design

• Good Design
• Analyse a spreadsheet
• Design Principles
• Planning Checklist for Spreadsheets
• Microsoft Tips for Optimising Speed
• Design Project

Training Course Outcomes

The learning outcomes of this Microsoft Excel 2007 Introduction Training Course cover the basic day to day tasks required to work with Microsoft Excel spreadsheets and produce basic reports.

Prerequisites

Participants must have basic keyboard and mouse skills and be familiar with the Windows operating system. [No previous excel experience is necessary]

Other Information

If you need more information contact Startnextweek.com.au on 1300 728 102