Microsoft® Office Excel 2013: Level 3

Course Objectives: Students will automate Excel tasks through macros, use advanced analysis tools with more complex data sets, collaborate on worksheets in a team environment, and share Excel data with other applications.

Prerequisites: To ensure your success, we recommend that you have experience with performing complex calculations, intermediate level functions, charting, and data filtering. Students can obtain this level of skill through our Level 1 and 2 courses.

Contact us to discuss if this level is right for you.

What’s New in 2013: View multiple Excel workbooks in separate windows side by side when comparing data or to link workbooks easily without the need for workspaces.

Lesson 1: Streamlining Workflow

Topic 1A: Create a Macro
Topic 1B: Edit a Macro
Topic 1C: Combine Macros
Topic 1D: Intro to VBA Code
Topic 1E: Options to Run a Macro

Lesson 2: Collaborating with Others

Topic 2A: Protect Sheets and Workbooks
Topic 2B: Restrict Document Access
Topic 2C: Share a Workbook
Topic 2D: Track Changes - Apply and Review
Topic 2E: Merge Workbooks

Lesson 3: Auditing Worksheets

Topic 3A: Trace Cells
Topic 3B: Troubleshoot Errors in Formulas
Topic 3C: Evaluate Formulas and Error Options
Topic 3D: Create a Watch Window
Topic 3E: Remove Duplicates

Lesson 4: Analysis Tools and Add-Ins

Topic 4A: Conditional Formatting
Topic 4B: Create Sparklines
Topic 4C: Perform What-If Analysis
Topic 4D: Solver Add-In

Lesson 5: Managing Data

Topic 5A: Create a Data List Outline
Topic 5B: Consolidate Data
Topic 5C: Data Validation
Topic 5D: Convert Text to Columns
Topic 5E: Link Cells in Different Workbooks

Lesson 6: Importing and Exporting Data

Topic 6A: Export Excel Data
Topic 6B: Import Text or CSV File
Topic 6C: Import Data from the Web
Topic 6D: Publish a Workbook to the Web
Topic 6E: User Created Templates

Excel 2010 Training Class Outlines:

Excel 2013 Level 1: Fundamentals of Excel
Excel 2013 Level 2: Intermediate Functions and Features
Excel 2013 Level 3: Advanced Tools and Collaboration Features
Excel 2013 Level 4: Advanced Formulas and Functions
Excel 2013 Level 5: Introduction To VBA Macros
Excel 2013 Level 6: Advanced VBA Macros