详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】微软基础辅导班,…
面议0000-00-00 77次
如遇无效、虚假、诈骗课程,请立即举报为了您的资金安全,请见面交易,切勿提前支付任何费用举报
【学校名称】 上海易达教育 【交通线路】 交通便利 【关 键 字】 Excel高级入门, Excel 应用班, Excel全能基础班
课程简介 |
Course Overview: This course is designed to teach students how to use advanced capabilities of Excel to work with naming ranges, auditing worksheets, working with databases, analyzing data, and using workgroup features. |
培训对象 |
培训大纲 |
Data Entry and Formatting Techniques Restricting Cell Entries to Numbers, Dates or Times Restricting Cell Entries to Specific Entries in a List Applying Number Formats to Cell Entries Creating a Custom Number Format Applying Conditional Formatting to a Worksheet Naming Ranges Defining a Range Name Using a Range Name in a Formula Moving the Cell Pointer to a Named Range Using Lookup Functions Using the VLOOKUP and HLOOKUP Function Using the HLOOKUP Function Working with a Template Creating a Template Modifying the Default Template Style Basing a New Workbook on a Custom Template Auditing a Worksheet Tracing Precedents and Dependents in a Worksheet Tracing Errors in a Worksheet Linking Multiple Workbooks Entering a Formula to Link Multiple Workbooks Creating a Workspace Working with a Database What is a Database? Sorting Database Records Sorting Records by the Entries in One Field Sorting Records by the Entries in Multiple Fields Totaling Database Entries Filtering Database Records Specifying a Criteria Range in a Filter Operation Using a Data Form to Enter Database Records Querying an External Database Analyzing Data (Part 1) Creating a PivotTable Report Resetting the Summary Function in a PivotTable Report Creating a PivotChart Report Creating a PivotTable Report for the World Wide Web Analyzing Data(Part 2) Using the Solver Outlining a Worksheet Additional Data Analysis Topics Importing and Exporting Data Importing Data from Other Applications into Excel Importing Data in a Text File into Excel Importing a Table in an HTML File into Excel Exporting Excel Data into Other Applications Using Excel Workgroup Features Tracking Changes in a Workbook Inserting Comments into a Worksheet Accepting and Rejecting Proposed Changes / Reviewing Comments Protecting a Shared Workbook Protecting an Unshared Workbook Additional Workgroup Topics Conclusion |
更多Excel 2003 Level 3-1 day训练班
请点击:http://sh.fanxuefei.com/xuexiao/index_2372.htm
详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】微软基础辅导班,…
面议详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】Access开发培训,…
面议详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】Access开发培训,…
面议详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】Access技术, Acc…
面议详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】Access数据库, A…
面议详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】Visio基础, 办公…
面议详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】精通Office班, 2…
面议详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】高级Excel班, 高…
面议详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】高级Excel班, 高…
面议详细介绍 *开班【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】微软excel, exce…
面议