INFOCHINA全国office培训中心(46家)

加盟电话:400 600 1998

金融/保险专区

客户:中行  建行 法兴 三菱东京 PICC...

汽车/制造专区

客户:宝马 丰田 卡特彼勒 三一重工...

通信/电子专区
客户:移动、联通、澳电、 VERIZON 
石化/能源专区
客户:中石油 中石化 康菲 斯伦贝谢...
医疗/生物专区
客户:辉瑞、强生、合生元、诺和诺德...

 敬 告

诸多培训机构复制INFOCHINA培训大纲、培训客户、培训方案甚至公司简介,却没有专业讲师授课,让客户蒙受损失!INFOCHINA是宝马、华夏银行、卡特彼勒...全国唯一指定高端Office培训与服务提供商,如有雷同,绝非巧合。

Excel training in English:Excel Managing Data training

用户评价:  / 175
好 

课程简介

--------------------------------------------------------------------------------

This advanced Excel training course will give financial professionals the ability to manipulate data and to share workbooks in a team workgroup environment. Participants will learn how to audit data ,use the workgroup features ,Import and export data in different formats and create simple macros in Microsoft Excel .This course will introduce the advanced Excel techniques which participants can further utilize Excel’s powerful features to handle different financial statements.

培训对象

--------------------------------------------------------------------------------

After completing this course, students will be able to:

Sort and filter financial figures

Manage and audit spreadsheets

Share accounting and financial statements with others

Customize and automate Excel using macros and toolbars

培训大纲

--------------------------------------------------------------------------------

 1. Organizing and Analyzing data

1) Use subtotals

2) Define and apply advanced filters

3) Group and outline data

4) Use data validation

5) Create and modify list ranges

6) Using scenarios

7) Perform data analysis using automated tools

8) Create PivotTable and PivotChart reports

9) Use lookup and Reference functions

10) Use database functions

11) Trace formula precedents, dependents and errors

12) Watch and evaluate formulas

13) Using named ranges

14) Structure work books using XML

2. Formatting Data and Content

1) Create and Apply custom data formats

2) Use conditional formatting

3) Format and resize graphics

4) Format charts and diagrams

3. Collaborating

1) Protect cells, worksheets, and workbooks

2) Apply workbook security settings

3) Share workbooks

4) Merge workbooks

5) Track, accept ,and reject changes to workbooks

4. Managing Data and Workbooks

1) Import data to Excel

2) Export data from Excel

3) Publish and edit Web worksheets and workbooks

4) Create and edit templates

5) Consolidate data

6) Define and modify workbook properties

7) Customizing Excel

8) Customize toolbars and menus

9) Create, edit ,and run macros

10) Modify Excel default settings

 

 Hardy Nickerson Jersey

客户展示 - 涵盖56.4%的世界500强企业


电话: 0532-89755616 4006001998
咨询QQ 邵老师: 点击这里给我发消息
咨询QQ 李老师: 点击这里给我发消息

战略合作伙伴

   
   
   
   
   
   
   
   @2004 北京助力东方(INFOCHINA)科技有限公司版权所有 京ICP备06024442全国业务咨询热线:400-600-1998   

十大经典课程 + 十大金牌讲师 + 独创5S教学法 + 一年完美技术服务 = INFOCHINA|中国Office培训专家