This event has ended

Excel 2007 Level 3 Training

Methode Electronics

Monday, February 17, 2014 from 9:00 AM to 5:00 PM (CST)

Harwood Heights, IL

Excel 2007 Level 3 Training

Registration Information

Type Remaining End Quantity
Seat 3 Registrations Ended Free  

Share Excel 2007 Level 3 Training

Event Details


Lesson 1: Streamlining Workflow
Create a Macro 
Edit a Macro 
Apply Conditional Formatting 
Add Data Validation Criteria 
Update a Workbook's Properties 
Modify Excel's Default Settings
Lesson 2: Collaborating with Others
Protect Files 
Share a Workbook 
Set Revision Tracking 
Review Tracked Revisions 
Merge Workbooks 
Administer Digital Signatures 
Restrict Document Access
Lesson 3: Auditing Worksheets
Trace Cells 
Troubleshoot Errors in Formulas 
Troubleshoot Invalid Data and Formulas 
Watch and Evaluate Formulas 
Create a Data List Outline
Lesson 4: Analyzing Data
Create a Trendline 
Create Scenarios 
Perform What-If Analysis 
Perform Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Create a Workspace 
Consolidate Data 
Link Cells in Different Workbooks 
Edit Links
Lesson 6: Importing and Exporting Data
Export Excel Data 
Import a Delimited Text File
Lesson 7: Using Excel with the Web
Publish a Worksheet to the Web 
Import Data from the Web 
Create a Web Query
Lesson 8: Structuring XML Workbooks
Develop XML Maps 
Import and Export XML Data
Have questions about Excel 2007 Level 3 Training? Contact Methode Electronics
Attendee List Sort by: Date | First Name | Last Name
Show More

When & Where

Methode Corporate Headquarters
7401 W Wilson Ave
Harwood Heights, IL 60706

Monday, February 17, 2014 from 9:00 AM to 5:00 PM (CST)

  Add to my calendar


Methode Electronics

Training is for Methode Employees Only

Similar to training offered in the Spring of 2013, we will be offering additional training sessions in Microsoft Office Products.  In addition to Word, Excel, PowerPoint and Access, we will this time include Outlook and Project.  Excel will be expanded to levels 4 and 5; level 5 Excel will be dedicated to macros and VBA.


Things to note

  • We have divided the training into three sections (December, January and February).  Not all class levels are available in each section; the sections progressively offer more advanced courses.
  • All classes are one day (8 hours), except Access which is a full 2 days (16 hours).
  • New Horizons trainers will be instructing all classes.  Tom has moved out of the Chicago area and is no longer available as a trainer.  We have interviewed other trainers and have select Eugene as the trainer for these training sessions.
  • Some classes will be offered at Methode’s Corporate Training Room in Harwood Heights.  Other classes will be offered at New Horizons in Rosemont (they have a new address).
  • Training materials will be distributed at the beginning of each class.
  • Laptops will be provided for each trainee.
  • There is a strict limit of 15 people per class.  Please register as soon as possible.  If a class is full, you will have the option of wait listing that particular date and time.


  • Morning start time – 9am
  • Morning end time – 12:30pm
  • Afternoon start time – 1:30pm
  • Afternoon end time – 5pm
  • Breaks – both the morning and afternoon sessions contain a 15 minute break
  • What to bring to class – nothing is needed; all materials will be provided
  • Computers – laptops with external mice
  • Lunch - food will be provided
  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.