Cost Savings Calculator
 

Excel 2010 – Level 3

Working World provides training on many of the leading software programs and applications.  To book your next computer training course please call our main office number at (800) 463-3074.

Course Length

  • 1 Day

Objectives

  • enhance productivity and efficiency by streamlining the workflow.
  • collaborate with other workbook users.
  • audit worksheets.
  • analyze data.
  • work with multiple workbooks.
  • import and export data.
  • integrate Excel data with the web.
  • structure workbooks with XML.

Prerequisites:

  • Excel 2010 – Level 2

Content

Streamlining Workflow

  • Update Workbook Properties
  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria

Collaborating with Other Users

  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access

Auditing Worksheets

  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline

Analyzing Data

  • Create a Trendline
  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Importing and Exporting Data

  • Export Excel Data
  • Import a Delimited Text File

Integrating Excel Data with the Web

  • Publish a Worksheet to the Web
  • Import Data from the Web
  • Create a Web Query

Structuring Workbooks with XML

  • Develop XML Maps
  • Import and Export XML Data

 

 
“The services that Working World have provided over the past year to Gorilla Brake have made a huge difference in the way we do business and our efficiencies throughout the company and what we are able to provide to our customers. Knowing that our backup and recovery is being looked after, knowing that Working World is looking after Gorilla Brake’s best interests; it certainly makes me rest easier. They’ve offered a lot of assistance to us especially during a huge growth period. Working World has provided a huge service to us in our IT and has made everyone’s lives much easier in allowing us to provide our products and services to our customers and not have to worry about things we don’t specialize in.” - Laurie Macyszyn, Gorilla Brake and Components