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

Excel Advanced Training

 Course Content

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously

Topic A: Use 3-D References

Topic B: Use Links and External References

Topic C: Consolidate Data

Lesson 2: Sharing and Protecting Workbooks

Topic A: Collaborate on a Workbook

Topic B: Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality

Topic A: Apply Data Validation

Topic B: Work with Forms and Controls

Topic C: Work with Macros

Lesson 4: Applying Conditional Logic

Topic A: Use Lookup Functions

Topic B: Combine Functions

Topic C: Use Formulas and Functions to Apply Conditional Formatting

Lesson 5: Auditing Worksheets

Topic A: Trace Cells

Topic B: Search for Invalid Data and Formulas with Errors

Topic C: Watch and Evaluate Formulas

Lesson 6: Using Automated Analysis Tools

Topic A: Determine Potential Outcomes by Using Data Tables

Topic B: Determine Potential Outcomes by Using Scenarios

Topic C: Use the Goal Seek Feature

Topic D: Activate and Use the Solver Tool

Topic E: Analyze Data with Analysis ToolPak Tools

Lesson 7: Presenting Your Data Visually

Topic A: Use Advanced Chart Features

Topic B: Create Sparklines

Appendix A: Cube Functions

Appendix B: Import and Export Data

Appendix C: Microsoft Office Excel 2010 Exam 77-882

Appendix D: Microsoft Office Excel 2010 Expert Exam 77-888



Contact Us:


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

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