Excel 2007 - Level 2 Training Class

Course ID: 13892

Excel 2007 - Level 2 Training Seminar

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.

Who Should Attend:
The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

At Course Completion:
Upon successful completion of this course, students will be able to: - enhance the workbook. - automate workbook creation by using templates. - organize data using tables. - create and modify charts. - analyze data using PivotTables and PivotCharts. - work with graphic objects. - calculate with advanced formulas. - sort and filter data.

Agenda

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 Workshee