Microsoft Excel 2007 Level 2
| Duration: | 1 day |
| Prerequisite: | Microsoft Excel 2007 Level 1 or equivalent experience. |
| Course Materials: | Course manual (084282S3) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | In this course, students will use Microsoft® Office Excel® 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. |
Enhancing Workbooks
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
Creating Workbooks Using Templates
Create a Workbook from a Template
Create a Custom Template
Organizing Data Using Tables
Create Tables
Modify Tables
Format Tables
Presenting Data Using Charts
Create a Chart
Modify Charts
Format Charts
Create a Chart Template
Share Excel Charts
Analyzing Data Using PivotTables and PivotCharts
Create a PivotTable
Perform Calculations Using PivotTables
Analyze Data Using PivotCharts
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
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
Sorting and Filtering Data
Sort Data in a SpreadsheetFilter Data in a Spreadsheet
Calculate Large Volumes of Data
Add Subtotals to a Worksheet