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