Microsoft Office Excel 2007: Level 2

Request more details:

In Microsoft Office Excel 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
Before starting this course, students are recommended to take the following course or possess equivalent knowledge: Microsoft Office Excel 2007: Level 1
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 Spreadsheet
Filter Data in a Spreadsheet
Calculate Large Volumes of Data
Add Subtotals to a Worksheet