Napier H.A. - Microsoft Excel 2013: Working with Data Ranges and Tables

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 outlines subtotals. Finally, in Lesson 2 you explore the advantages of defining a range of data as an Excel 2013 table.

• 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

• identify the guidelines for a well-organized data range,
• enter and test validation rules,
• copy validation rules,
• enter and locate data using the Data Form,
• search for data using the Data Form,
• remove validation rules,
• sort a data range on a single field,
• sort a data range on multiple fields
• apply a custom sort order to a data range,
• sort a data range by font or fill color
• use Filter (AutoFilter) to filter a data range,
• filter by one or more fields using the Filter feature,
• filter for the Top Items using the Filter feature,
• sort, copy and paste filtered data,
• create a custom filter,
• use Advanced Filter to filter a data range,
• add subtotals and an outline to a data range,
• expand and collapse the outline,
• create a chart from subtotals,
• insert nested subtotals, and
• outline data containing subtotals.

• define and name an empty table,
• define a table using existing data,
• define a table using the Quick Analysis feature,
• format data as a defined table,
• enter data and expand the table vertically,
• enter and copy formulas in a table,
• use the Data Form with a table,
• resize a table using the mouse pointer, the Resize Table button and dynamically,
• select table elements,
• change table formatting,
• retain the Header Row text while scrolling a table vertically,
• sort and filter records in a table,
• add a Total Row to a table, and
• convert a defined table to a data range.

Albert Napier, Ph.D. H. Albert Napier is a Professor of Management in the Jones Graduate School of Business at Rice University, where he has taught graduate level courses related to entrepreneurship, information technology, and e-business. Dr. Napier also makes numerous management development program presentations on various topics of business and information technology topics. Dr. Dr.

Napier has trained thousands of CPAs and others to use various software packages in classroom and online environments. Dr. Napier is on the board of directors of three e-business companies. He is the author of more than 20 articles related to management information systems and application of computer-based decision processes in business and is the co-author of more than 60 textbooks. Dr. in Business Administration, an M.B.A. and a B.A. in Mathematics and Economics, all from The University of Texas at Austin. Ollie N. Ollie N.

Rivers Ollie N. Rivers has more than 20 years' business experience in financial and administrative management and more than 10 years experience as a corporate trainer. She is a co-author of two e-business textbooks, an Internet textbook and a Web design textbook and is a contributing author on more than 15 software package textbooks. Ms. Rivers has also developed and delivered numerous classroom and online continuing education seminars for CPAs. Ms.

Rivers holds an M.B.A. and a B.S. in Accounting and Management from Houston Baptist University. COPYRIGHT (C) 2015 Napier-Rivers LLC Microsoft and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Microsoft product screen shot(s) reprinted with permission from Microsoft Corporation.