授课机构:上海易达教育培训中心
地址:易达教育总部地址:浦东南路1525号6楼;浦东八佰伴校区张扬路655号福兴大厦7楼;浦东南路浦电路校区浦东南路1525号6楼;浦东东方路校区浦三路159号3楼;浦东昌里校区浦东新区云台路上南八村27号;浦东上南校区西营路114弄32号206室;上钢新村街道社区学校;徐家汇校区漕溪北路502号;闸北彭浦校区闸北区岭南路1115号2楼;杨浦中原校区包头路市光四村56号殷行社区党员服务中心;静安区万航渡校区万航渡路767弄20号工艺美术职业学院
网报价格:¥电询
课程原价:¥电询
咨询热线:400-850-8622
课程详情 在线报名
详细介绍 *开班
【学校名称】上海易达教育 【交通线路】交通便利 【关 键 字】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训练班
只要一个电话
我们免费为您回电