713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas

>
  
training schedule Course
 Schedules

Houston Schedule
>
 
 
San Antonio Schedule
>
  
 

>
>
>
 
 

Better Business Bureau

 

 

.


 

 

Microsoft® Office Excel 2007: Level 3

Training Course Content

Course Objective: 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 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 2007: Make your data easier to analyze with the new conditional formatting options. Along with other improvements in accessibility to other programs, you can now create a PDF or XPS document from Excel, and use new ways to share your work with others.

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: Find Solutions with Goal Seek
Topic 4C: Create Scenarios
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 a Delimited Text File
Topic 6C: Import Data from the Web
Topic 6D: Publish a Workbook to the Web
Topic 6E: User Created Templates


Excel 2007 Training Class Outlines:

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   |