Learning Objectives – Intermediate Excel 2016

Module 1 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 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