|
Excel 2007 Introduction |
 |
 |
|
 This course is designed for people who are new to spreadsheets or converting from another program. The learning outcomes of this course cover the basic day to day tasks required to work with an Excel spreadsheet and produce basic reports.
Duration:
1 Day
Audience:
The course has been designed for new users of Microsoft Excel 2007.
Prerequisites:
Participants must have basic keyboard and mouse skills and be familiar with the Windows operating system.
Course Content:
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
|
CTS Training Pty Ltd | Level 8 40 Creek St. Brisbane ...For Course Bookings or enquiries...
tel:(07) 3210 0002
Software Courses 
(07) 3210 0002
info@CTStraining.com.au
