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
|
