Excel 2007 - Level 2 هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

In this course, students use Excel® 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. (Second Edition)

Objectives

Upon successful completion of this course, students will be able to:

• calculate with advanced formulas.
• organize worksheet and table data using various techniques.
• create and modify charts.
• analyze data using PivotTables and PivotCharts.
• insert graphic objects.
• customize and enhance workbooks and the Microsoft® Office Excel® environment

Prerequisites

Lessons

Lesson 1: Calculating Data with Advanced Formulas

• Manage Cell and Range Names 
• Calculate Data Across Worksheets 
• Use Specialized Functions 
• Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

• Create and Modify Tables 
• Format Tables 
• Sort or Filter Worksheet or Table Data 
• Calculate Data in a Table or Worksheet

Lesson 3: Presenting Data Using Charts

• Create a Chart 
• Modify Charts 
• Format Charts

Lesson 4: Analyzing Data Using PivotTables and PivotCharts

• Create a PivotTable Report 
• Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

• Insert and Modify Pictures and ClipArt 
• Draw and Modify Shapes 
• Illustrate Workflow Using SmartArt Graphics 
• Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment

• Customize the Excel Environment 
• Customize Workbooks 
• Manage Themes 
• Create and Use Templates