Microsoft Office Training Classes in Atlanta, GA
Microsoft Office Training Classes in Atlanta, GA
 

Excel Intermediate Training

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

Appendix A: Financial Functions

 

 

 

 

Contact Us:

770-713-3142

Contact Professional Training Solutions, Inc. today to get your FREE quote!
or send us an email

Print Print | Sitemap
© 2016 Professional Training Solutions, Inc.