Excel Level 2

Course details

Builds upon the foundational Microsoft Office Excel knowledge & skills you’ve already acquired & sets you on the road to creating advanced worksheets that will deepen your firm’s business intelligence

Course Content: 

Outline

Lesson 1: Customizing the Excel Environment

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

Lesson 2: Creating Advanced Formulas

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

Lesson 3: Analyzing Data with Functions and Conditional Formatting

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

Lesson 4: Organizing and Analyzing Datasets and Tables

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

Lesson 5: Visualizing Data with Basic Charts

• Create Charts 
• Modify and Format Charts

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

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

Learning Outcomes: 

• Students will be able to: Use advanced formulas. etc.
• Organize worksheet & table data using various techniques.
• Create and modify charts.
• Analyze data using PivotTables, Slicers, & PivotCharts.
• Insert and modify graphic objects in a worksheet. Customize and enhance workbooks.