Excel精湛技巧高效应用-易迪思

涉及Excel方面的人员

Excel是最常用的一套组件。它不仅可以制作日常工作中的各种表格而且可以对表格中的数据进行综合处理、统计计算、数据分析、图表透视等。大部分Excel用户运用到了日常的表格输入输出，很少将Excel的功能发挥到极致的效果。如：Excel图表的高级数据分析、高级函数与公式的深层应用、VBA等更多使用技巧。易迪思课程专家可以结合企业实际应用，帮助用户快速熟练地掌握Excel高效的使用捷径。以求用户快速有效地达到处理业务的满意效果............

大纲：
 
Excel Medium Level Enterprise Application Course

Lesson 1: Creating and Applying Templates

- Create a Workbook from a Template

- Create a Custom Template

- Working with Comments

- Create a Hyperlink

- Use Web-based Research Tools


Lesson 2: Creating and Modifying Charts

- Create a Chart

- Format Chart Items

- Change the Chart Type

- Create a Diagram

Lesson 3: Working with Graphic Objects

- Insert Graphics

- Create AutoShapes

- Format Graphic Objects

- Change the Order of Graphic Objects

- Group Graphic Objects

- Move, Copy, and Resize Graphic Objects



Lesson 4: Calculating with Advanced Formulas

- Create and Apply a Name for a Range of Cells

- Calculate Across Worksheets

- Calculate with Date and Time Functions

- Calculate with Financial Functions

- Calculate with Statistical Functions

- Calculate with Lookup and Reference Functions

- Calculate with Logical Functions

Lesson 5: Sorting and Filtering Data

- Sort Data Lists

- Filter Data Lists

- Create and Apply Advanced Filters

- Calculate with Database Functions

- Add Subtotals to a Worksheet


Lesson 6: Using Excel with the Web

- Export Excel Data

- Publish a Worksheet to the Web

- Import Data from the Web

- Create a Web Query

 

 

Excel Advanced Level Enterprise Application Course

Lesson 1: Streamlining Workflow

- Create a Macro

- Edit a Macro

- Customize Access to Excel Commands

- Apply Conditional Formatting

- Add Data Validation Criteria

- Update a Workbook★s Properties

- Modify Excel★s Default Settings



Lesson 2: Collaborating with Others

- Protect Files

- Share a Workbook

- Set Revision Tracking

- Review Tracked Revisions

- Merge Workbooks

- Adjust Macro Settings

- Administer Digital Signatures

Lesson 3: Auditing Worksheets

- Trace Cell Precedents

- Trace Cell Dependents

- Locate Errors in Formulas

- Locate Invalid Data and Formulas

- Watch and Evaluate Formulas

- Group and Outline Data


Lesson 4: Analyzing Data

- Create a Trendline

- Create Scenarios

- Perform What-If Analysis

- Develop a PivotTable© Report

- Develop a PivotChart© Report

- Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

- Create a Workspace

- Consolidate Data

- Link Cells in Different Workbooks

- Edit Links


Lesson 6: Importing and Exporting Data

- Export to Microsoft Word

- Import a Word Table

- Import Text