你的位置: 首页 > 内训课首页 > 拓展/其它 > 课程详情

details

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

暂无评价   
淘课价格
待定
可用淘币
0
?#36842;?#37329;券
待定

你还可以: 收藏

培训受众:

涉及Excel方面的人员

课程收益:

Excel是最常用的一套组件。它不仅可以制作日常工作中的各种表格而且可以对表格中的数据进行综合处理、统计计算、数据分析、图表透视?#21462;?#22823;部分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





本课程名称: Excel精湛技巧高效应用-易迪思

查看更多:拓展/其它内训课

Excel应用 excel Excel技巧 应用 相关的最新课程
讲师动态评分 与同行相比

授课内容与课纲相符00%

讲师授课水平00%

服务态度00%

福建省36选7走势图