Microsoft Excel 2010 Level 2

Course Objectives: 

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. 

You will: 

• Customize the Excel environment. 
• Create advanced formulas. 
• Analyze data by using functions and conditional formatting. 
• Organize and analyze datasets and tables. 
• Visualize data by using basic charts. 
• Analyze data by using PivotTables, slicers, and PivotCharts. 

Course Content: 

Lesson 1: Customizing the Excel Environment 

 Topic A: Configure Excel Options 

 Topic B: Customize the Ribbon and the Quick Access Toolbar 

 Topic C: Enable Excel Add-Ins 

Lesson 2: Creating Advanced Formulas 

 Topic A: Use Range Names in Formulas 

 Topic B: Use Specialized Functions 

 Topic C: Use Array Formulas 

Lesson 3: Analyzing Data with Functions and Conditional Formatting 

 Topic A: Analyze Data by Using Text and Logical Functions 

 Topic B: Apply Advanced Conditional Formatting 

Lesson 4: Organizing and Analyzing Datasets and Tables 

 Topic A: Create and Modify Tables 

 Topic B: Sort Data 

 Topic C: Filter Data 

 Topic D: Use SUBTOTAL and Database Functions 

Lesson 5: Visualizing Data with Basic Charts 

 Topic A: Create Charts 

 Topic B: Modify and Format Charts 

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts 

 Topic A: Create a PivotTable 

 Topic B: Analyze PivotTable Data 

 Topic C: Present Data with PivotCharts 

 Topic D: Filter Data by Using Slicers