Skip to Main Content

Microsoft Excel 2013-Level 3

Hours: 6.00 | Estimated Cost: $175.00

Learn more specialized and advanced capabilities of Microsoft® Excel®. You will learn about some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing your data with other people, analyzing data, and using Excel data in other applications. Prerequisite: Microsoft Excel 2013 - Level 1 & 2 or equivalent knowledge/experience.

Additional Information

Learn About
  • Automating worksheet functionality
  • Auditing worksheets
  • Analyzing and presenting data
  • Working with multiple workbooks
  • Importing and exporting data
  • Integrate Excel data with the web
  • Create a web query
Training Outline

** Automating Worksheet Functionality**

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

** Auditing Worksheets**

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

** Analyzing and Presenting Data**

  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
  • Create Interactive Data with Power View

** Working with Multiple Workbooks**

  • Consolidate Data
  • Link Cells in Different Workbooks
  • Merge Workbooks

** Exporting Excel Data**

  • Export Excel Data
  • Import a Delimited Text File
  • Integrate Excel Data with the Web
  • Create a Web Query
Business and Industry Services

Fox Valley Technical College
Business & Industry Services
D. J. Bordini Center
5 N. Systems Drive
P.O. Box 2277
Appleton, WI 54912-2277
View BIS Calendar

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771

Join us on LinkedIn