Excel 2010 - Part 2

Course details

This course builds upon the foundational Microsoft® Office Excel® 2010 knowledge and skills you’ve already acquired and sets you on the road to creating advanced workbooks and worksheets that will deepen your firm’s business intelligence.

Course Outline

1 - Customizing the Excel Environment

• Configure Excel Options
• Customize the Ribbon and the Quick Access Toolbar 
• Enable Excel Add-Ins

2 - Creating Advanced Formulas

• Use Range Names in Formulas
• Use Specialized Functions
• Use Array Formulas

3 - Analyzing Data with Functions and Conditional Formatting

• Analyze Data by Using Text and Logical Functions 
• Apply Advanced Conditional Formatting

4 - Organizing and Analyzing Datasets and Tables

• Create and Modify Tables 
• Sort Data 
• Filter Data
• Use SUBTOTAL and Database Functions

5 - Visualizing Data with Basic Charts

• Create Charts
• Modify and Format Charts

6 - Analyzing Data with PivotTables, Slicers, and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data 
• Present Data with PivotCharts
• Filter Data by Using Slicers

Target Audience: This course is designed for students who already have foundational knowledge and skills in Excel 2010 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.