Excel 2010 - Level 2

Course details

In this course, students will apply visual elements and advanced formulas to a worksheet to display data in various formats.

What will I learn?

Lesson 1: Calculating Data with Advanced Formulas

• Apply Cell and Range Names
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Use Functions to Calculate Data in a Table or Worksheet

Lesson 3: Presenting Data Using Charts

• Create a Chart
• Modify Charts
• Format Charts

Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

• Create a PivotTable Report
• Filter Data Using Slicers
• Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects(optional)

• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment

• Customize the Excel Environment
• Customize Workbooks
• Manage Themes (optional)
• Create and Use Templates

Requirements

Excel 2010 - Level 1