文件名称:
Excel.2013.Working.with.Data.Ranges.and.Tables
开发工具:
文件大小: 6mb
下载次数: 0
上传时间: 2015-05-04
详细说明： Course Description Microsoft® Excel® 2013: Working with Data Ranges and Tables is a two-lesson intermediate level course that guides you through organizing, entering and validating worksheet data and then effectively sorting, filtering, subtotaling, and outlining the data. You also learn how to define well-organized data as an Excel table; then use Table features to work with the data. In Lesson 1 you learn how to organize columns and rows of data into a range so that you can effectively sort, filter, subtotal, and outline the data. Then you learn how to protect the data from invalid data entry by setting data validation rules for specific cells. You learn how to copy these validation rules to other cells, how to remove validation rules from cells and how to use the Data Form dialog box to enter and locate data in a range. Next you learn how to sort a data range on one column or on multiple columns and how to use a custom sort order, the Filter (AutoFilter) feature and the Advanced Filter feature to view data that meets specific criteria. Then you learn how to add and remove subtotals from a data range while viewing the data range in outline form. You also learn how to create a chart using an outline’s subtotals. Finally, in Lesson 2 you explore the advantages of defining a range of data as an Excel 2013 table. Prerequisites The Napier & Rivers courses Microsoft® Excel® 2013: Getting Started with Excel and Microsoft® Excel® 2013: Creating and Formatting Charts or the equivalent experience working with Excel 2013 in the Windows operating system environment are prerequisites for this course. Data Files If you have not yet downloaded the data files, visit http://ebooksforoffice.com/datafiles, locate Microsoft® Excel® 2013: Working with Data Ranges and Tables book title, and then click the ‘Download data files’ link. Learning Objectives After completing this course you will be able to: identify the guidelines for a well-organized data range; select ways to create and test validation rules; select the Data Form for data entry, recognize ways to sort and filter a data range, identify the main differences between a data range and a table, select ways to add subtotals, a Grand Total and data grouping to a data range, identify multiple ways to define an Excel table using buttons on the HOME and INSERT tabs, the Quick Analysis feature, a keyboard shortcut and by formatting a data range as a table, and recognize ways to enter data and formulas in a table; change table formatting; resize a table; scroll, sort, filter and summarize a table; and convert a table to a data range Table of Contents Lesson 1: Entering, Validating, Sorting, Filtering and Outlining a Data Range Lesson 2: Defining and Using Tables ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
