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
  • Integrating Excel data with the web
  • Creating a web query
Benefits & Outcomes
  • Improve productivity by allowing mundane tasks to be completed more efficiently
  • Learn valuable tips and tricks to improve efficiency and accuracy
  • Become proficient in Microsoft Excel
Training Outline

**Working with Multiple Worksheets & Workbooks Simultaneously**

  • Use 3-D References
  • Use Links and External References
  • Consolidate Data

**Sharing & Protecting Workbooks**

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
  • Watch and Evaluate Formulas
  • Create a Data List Outline

**Automating Workbook Functionality**

  • Apply Data Validation
  • Work with Forms & Controls
  • Work with Macros

**Applying Conditional Logic**

  • Use Lookup Functions
  • Combine Functions
  • Use Formulas and Functions to Apply Conditional Formatting

**Auditing Worksheets**

  • Trace Cells
  • Search for Invalid Data and Formulas with Errors
  • Watch and Evaluate Formulas

**Using Automated Analysis Tools**

  • Determine Potential Outcomes using Data Tables
  • Determine Potential Outcomes using Scenarios
  • Use the Goal Seek Feature
  • Activate and Use the Solver Tool
  • Analyze Data with Analysis ToolPak Tools

**Presenting Your Data Visually**

  • Use Advanced Chart Features
  • Create Sparklines
Business and Industry Services

Fox Valley Technical College
Business & Industry Services (BIS)
D. J. Bordini Center
1825 N. Bluemound Road
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