Excel 2013 - Level 2

Upon successful completion of this course, students will be able to:

• use advanced formulas.
• organize worksheet and table data using various techniques.
• create and modify charts.
• analyze data using PivotTables, Slicers, and PivotCharts.
• insert and modify graphic objects in a worksheet.
• customize and enhance workbooks

Course Content

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 Data
• Use Functions to Calculate Data

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

• 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 the Excel Environment

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

IPLearning.net is your best choice for Excel 2013 Intermediate Level 2, Excel 2013 Intermediate Level 2 training, Excel 2013 Intermediate Level 2 certification, Excel 2013 Intermediate Level 2 certification boot camp, Excel 2013 Intermediate Level 2 boot camp, Excel 2013 Intermediate Level 2 certification training, Excel 2013 Intermediate Level 2 boot camp training, Excel 2013 Intermediate Level 2 boot camp certification, Excel 2013 Intermediate Level 2 certification course, Excel 2013 Intermediate Level 2 course, training Excel 2013 Intermediate Level 2, certification Excel 2013 Intermediate Level 2, boot camp Excel 2013 Intermediate Level 2, certification Excel 2013 Intermediate Level 2 boot camp, certification Excel 2013 Intermediate Level 2 training, boot camp Excel 2013 Intermediate Level 2 training, certification Excel 2013 Intermediate Level 2 course.