Course Overview

In this course, students use Microsoft® Office Excel® 2007 to streamline and enhance spreadsheets with templates, charts, graphics, and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Delivery

Classroom

Duration

1 Day

Locations

• Classroom - Brisbane, Melbourne, Newcastle, Perth and Sydney
• Group bookings - All States and Territories of Australia

Related Courses

Excel 2007 - Level 1

Excel 2007 - Level 3

Course Outline

Lesson 1: Enhancing the Workbook

• Customize the Excel Environment
• Customize an Excel Worksheet
• Enhance Worksheets Using Themes
• Work with Comments
• Access External Resources Using Hyperlinks
• Use Web-Based Research Tools

Lesson 2: Creating Workbooks Using Templates

• Create a Workbook from a Template
• Create a Custom Template

Lesson 3: Organizing Data Using Tables

• Create Tables
• Modify Tables
• Format Tables

Lesson 4: Presenting Data Using Charts

• Create a Chart
• Modify Charts
• Format Charts
• Create a Chart Template
• Share Excel Charts

Lesson 5: Analyzing Data Using PivotTables and PivotCharts

• Create a PivotTable
• Perform Calculations Using PivotTables
• Analyze Data Using PivotCharts

Lesson 6: Enhancing Visual Appeal Using Graphic Objects

• Insert Graphics
• Modify Graphic Objects
• Emphasize an Area of a Worksheet
• Illustrate Workflow Using SmartArt Graphics
• Format Graphic Objects
• Change the Order of Layered Graphic Objects
• Group Graphic Objects
• Organize Graphic Objects

Lesson 7: Calculating Data with Advanced Formulas

• Refer to a Range of Cells
• Calculate Data Across Worksheets
• Perform Date and Time Calculations
• Format Text Using Formulas
• Perform Numeric Calculations
• Calculate Data with Lookup & Reference Functions
• Perform Logical Analysis
• Print Formulas

Lesson 8: Sorting and Filtering Data

• Sort Data in a Spreadsheet
• Filter Data in a Spreadsheet
• Calculate Large Volumes of Data
• Add Subtotals to a Worksheet