713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas
Course Links
training schedule  Schedules
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule
Resources
training schedule
training schedule
training schedule

 

 


 
 

Microsoft® Office Excel Level 3
Online Training Course Content

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.

Excel Level 3: Advanced Data Tools & Collaboration   Excel Level 3: Basic Macros and Auditing Tools
3 Hour Webinar   3 Hour Webinar
         
Lesson 1: Collaborating with Others
   • Protect Data in a Workbook
   • Restrict Document Access
   • Share and Collaborate on a Workbook
   
Lesson 2: Data Analysis Tools and Add-Ins
   • Conditional Formatting
   • Remove Duplicates
   • Create Sparklines
   • Solver Add-In
   
Lesson 3: Managing Data
   • Create a Data List Outline
   • Consolidate Data
   • Apply Data Validation to Cells
   • Convert Text to Columns
   • Link Cells in Different Workbooks
   
Lesson 4: Importing and Exporting Data
   • Export Excel Data
   • Import a Text or CSV File
   • Import Data from the Web
   • Get Geographical Location Data
 
Lesson 1: Streamlining Workflow
   • Create a Macro
   • Edit a Macro
   • Combine Macros
   • Intro to VBA Code
   • Options to Run a Macro
   
Lesson 2: VBA Code Introduction
   • Overview of VBA Window
   • Step into VBA Code
   • Run a Macro in VBA Window
   • Basic VBA Code Window
   • Delete a Macro
   
Lesson 3: Auditing Worksheets
   • Trace Cells
   • Troubleshoot Errors in Formulas
   • Circular Reference
   • Evaluate Formulas and Error Options
   • The Watch Window

Excel Training Class Outlines (Online Training):

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

 

 

  		   
     

                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |