Surgent's Microsoftr Excelr 365/Excelr 2019: Working with Data Ranges and Tables
Available Anytime
Location:
Online
4Credits
Technical Business
Registration is Open
FICPA Members
Nonmembers
$109.00 Regular Price
Product Code: SU24-WRTB-SSDL
Level: Intermediate
Vendor: Surgent
Field of Study: Computer Software and Applications
Overview:
Microsoftr Excelr 365/Excelr 2019: 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 table. You also learn how to analyze data using table tools. This course emphasizes using the traditional keyboard and mouse actions to perform tasks in Excel.Objectives:
- 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
- Select ways to add subtotals, a grand total, and data grouping to a data range
- Identify data range and table differences
- 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
- 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
Major Topics:
- Identify the guidelines for a well-organized data range
- Enter, test, and copy validation rules
- Use the Data Form for data entry
- Sort and filter a data range
- Select ways to add subtotals, a grand total, and data grouping to a data range
- Identify data range and table differences
- 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
- Enter data and formulas in a table
- Change table formatting
- Resize a table
- Scroll, sort, filter, and summarize a table
- Convert a table to a data range
Designed For:
Users experienced with using Excel 2019 in the Windows 10 operating system environment or experienced Excel users switching from earlier versions of Excel.Prerequisite:
Napier & Rivers courses Microsoftr Excelr 365/Excelr 2019: Getting Started and Microsoftr Excelr 365/Excelr 2019: Creating and Formatting Charts or the equivalent experience working with Excel in the Windows operating system environment are prerequisitesAdditional Info:
You will receive an email from info@surgent.com with instructions on how to log onto your course shortly. If you do not receive the email within the hour, please check your spam filter.
For technical support, registration questions or other customer service-related inquiries, please call (800) 778-7436 or email info@surgent.com. Phones are staffed from 8:30 a.m. to 5:00 p.m. Eastern Time, Monday through Thursday, and 8:30 a.m. to 4:00 p.m. Eastern Time on Friday.