Microsoft Office Excel 2010: Level 3 (Second Edition) Training in Salem

Enroll in or hire us to teach our Microsoft Office Excel 2010: Level 3 (Second Edition) class in Salem, Oregon by calling us @303.377.6176. Like all HSG classes, Microsoft Office Excel 2010: Level 3 (Second Edition) may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Excel 2010: Level 3 (Second Edition) may be taught at one of our local training facilities.

Answers to Popular Questions:

 
Yes, this class can be tailored to meet your specific training needs.
Yes, we provide consulting services.
Yes, group discounts are provided.

Course Description

 
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
Course Length: 1 Days
Course Tuition: $250 (US)

Prerequisites

To ensure your success, we recommend that you first take the following courses or have equivalent knowledge: Microsoft Office Excel 2010: Level 1 (Second Edition) Microsoft Office Excel 2010: Level 2 (Second Edition)

Course Outline

 


Lesson 1: Streamlining Workflow
     Update Workbook Properties
     Create a Macro
     Edit a Macro
     Apply Conditional Formatting
     Add Data Validation Criteria

Lesson 2: Collaborating with Other Users
     Protect Files
     Share a Workbook
     Set Revision Tracking
     Review Tracked Revisions
     Merge Workbooks
     Administer Digital Signatures
     Restrict Document Access

Lesson 3: Auditing Worksheets
     Trace Cells
     Troubleshoot Invalid Data and Formula Errors
     Watch and Evaluate Formulas
     Create a Data List Outline

Lesson 4: Analyzing Data
     Create a Trendline
     Create Sparklines
     Create Scenarios
     Perform a What-If Analysis
     Perform a Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks
     Create a Workspace
     Consolidate Data
     Link Cells in Different Workbooks
     Edit Links

Lesson 6: Importing and Exporting Data
     Export Excel Data
     Import a Delimited Text File
     Import and Export XML Data

Lesson 7: Integrating Excel Data with the Web
     Publish a Worksheet to the Web
     Import Data from the Web
     Create a Web Query

Appendix A: Creating Excel Forms
Appendix B: Microsoft Office Excel 2010 Exam 77–882
Appendix C: Microsoft Office Excel 2010 Expert Exam 77–888

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.