返学费网 > 培训机构 > 上海易达教育培训中心

400-850-8622

全国统一学习专线 8:30-21:00

上海易达教育培训中心 Microsoft Excel Advanced

授课机构:上海易达教育培训中心

地址:易达教育总部地址:浦东南路1525号6楼;浦东八佰伴校区张扬路655号福兴大厦7楼;浦东南路浦电路校区浦东南路1525号6楼;浦东东方路校区浦三路159号3楼;浦东昌里校区浦东新区云台路上南八村27号;浦东上南校区西营路114弄32号206室;上钢新村街道社区学校;徐家汇校区漕溪北路502号;闸北彭浦校区闸北区岭南路1115号2楼;杨浦中原校区包头路市光四村56号殷行社区党员服务中心;静安区万航渡校区万航渡路767弄20号工艺美术职业学院

网报价格:¥电询

课程原价:¥电询

咨询热线:400-850-8622

课程详情 在线报名

详细介绍 *开班

【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】Excel入门基础, Excel应用培训, Excel全能培训班

课程简介

Introduction

This advanced 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.

At Course Completion 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 Modify Excel default settings

更多Microsoft Excel Advanced

  • 报名课程:
  • 性别:
  • 姓名:
  • 手机号码:
  • 其它说明:
姓名不能为空
手机号格式错误