In this course, students will work with the new and enhanced features in Microsoft Office Excel 2007.
Pre-requisite: An understanding of how to use MS Excel, and familiarity with the Internet.
Lesson 1: Exploring the Excel Environment
Explore the User Interface
Work with the Ribbon
Work with Contextual Tabs
Use the Excel Galleries
Customize the Excel Interface
Lesson 2: Organizing Data
Explore the Enhancements in Excel 2007 Spreadsheets
Insert Tables
Format Tables
Lesson 3: Analyzing Data
Apply Conditional Formatting
Sort Data in a Spreadsheet
Filter Data in a Spreadsheet
Apply a Formula
Lesson 4: Presenting Data
Create Charts
Format Charts
Work with Illustrations
Create PivotTables and PivotCharts
Share Excel Charts
Save Data in Presentable Formats
Forsythes Training provides instructor led computer training on the Microsoft Office and Adobe range of applications. We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia.With our mobile training room we can provide a range of courses on-site at your premises.