Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led activity of video(s), at the end of the module the student will be able to:
- Identify the major categories of data shown in the study guide and directed by the instructor
- Identify the three categories of formatting; General, Number, and Text, as shown in the study guide and directed by the instructor
- Imitate the instructor’s action in applying General, Number, and Text formatting to cells (Practice Ex 1)
- Identify three ways to access the Format Cells dialog box as shown in the study guide and directed by the instructor
- Identify the various tabs used in the Format Cells dialog box including: Number, Alignment, Font, Border, Fill, and Protection.
- Imitate the instructor’s action in performing basic operations using the Format Cells tabs including: Number, Alignment, Font, Border, Fill, and Protection
Module 2 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led activity of describing the subject matter on video(s), at the end of the module the student will be able to:
- Identify differences between a range of cells and an Excel table as shown in the study guide and directed by the instructor
- Imitate the instructor’s action in performing basic operations used in creating an Excel table
- Imitate the instructor’s action in performing basic operations used in customizing an Excel table using table-specific formulas
- Imitate the instructor’s action used in customizing an Excel table using a Name Box
- Imitate the instructor’s action used in customizing an Excel table by assigning names to ranges
- Imitate the instructor’s action used in customizing an Excel table by using the Name Manager
- Identify the ways to prevent scrambling of data while performing a sort on an Excel table
- Imitate the instructor’s action in performing basic sorting operations on an Excel table
- Imitate the instructor’s action in performing basic sorting operations using filter buttons
- Imitate the instructor’s action in performing basic sorting operations using a custom sort
- Imitate the instructor’s action in performing basic filtering operations
Module 3 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led activity of video(s), at the end of the module the student will be able to:
- Identify the basic elements of an Excel chart
- Identify chart editing and customization tools
- Imitate the instructor’s action in performing basic operations used to create an Excel chart
- Imitate the instructor’s action in customizing a chart by applying filtering
- Imitate the instructor’s action in customizing a chart by applying formatting
- Imitate the instructor’s action in customizing a chart by applying a chart title
- Imitate the instructor’s action in customizing a chart by adding additional data as directed by the instructor
Module 4 Learning Objectives
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led activity of video(s), at the end of the module the student will be able to:
- Identify the elements of a pivot table
- Imitate the instructor’s action in customizing a pivot table by applying filtering
- Imitate the instructor’s action in customizing a pivot table by adding fields to the Row’s quadrant
- Identify the attributes of the three basic pivot table form types
- Imitate the instructor’s action in customizing a pivot table by changing the form type
- Imitate the instructor’s action in customizing a pivot table by changing Value Field Settings
- Imitate the instructor’s action in customizing a pivot table by preparing it for printing