Skip Navigation Links
Training Exchange Logo
January 27, 2023
Search
Current Training

By Course Title
By Location
By Date
By Training Partner
By Delivery Method

Course Catalog
By Course Title
By Training Partner
By Delivery Method

Students

View Registrations/Transcripts
Edit Your Profile
Request Training

About Trainex
Overview
Contact Us
Help!

OLEM Training Coordination Team
Locate Team Members
Regional/State Training
Brochure

Other Training Resources
EPA
Other U.S. Government
Non-Government
Online Instruction Design
Listservs and other resources
Microsoft Excel Up to Speed Part 2: Analysis and Visual Basic Programming
COMP-412
Hosted by Northwest Environmental Training Center

**This course will be presented online as a live webinar in three 2-hour sessions. Sessions will be recorded and will be available to all enrolled attendees.**
All classes will be from 10 a.m.-noon Pacific (11 a.m. to 1 p.m. Mountain) (noon to 2 p.m. Central) and (1-3 p.m. Eastern).
This webinar is being presented by Sustainable City Networks and NWETC.
Excel comes packaged with lots of tools specifically designed to speed up analysis and auditing tasks, yet many people never know how to use them, or that they even exist in the first place. We'll take a look at incorporating these workhorse tools into your Excel repertoire. And for those times when you need a custom solution, there is no more powerful option than leveraging Excel's built in support for the Visual Basic programming language. Even if you've never written a line of code in your life, we'll get you up and running writing custom routines and functions that you can customize to exactly fit your requirements.
This is the second course in a 2-part series. This course is separate from "Excel Up To Speed: Shortcuts, Functions, And Charts (COMP-410)," so that attendees may take it at a later date if they do not have flexibility in their schedule, however we highly recommend that the two courses be taken together. COMP-412 is not meant to be taken as a stand-alone class without first taking COMP-410.
**Please make sure your computer is equipped with Excel 2010 (Excel 2007 acceptable)

After completing this course, participants will be able to:
Install and use the Analysis Toolpak to perform common statistical analysis of their data.
Perform auditing and data validation tasks to help clean messy data sets and provide reliable results
Learn the basics of using the Visual Basic editor to create custom routines and automate tasks.

*Reduced tuition is available to employees of Native American tribes, government agencies, nonprofits students and NAEP, NEBC, NWAEP members. You may register online or by calling the Northwest Environmental Training Center at 425-270-3274.
Intended Audience:
This course is beneficial for any professional who works with a large amount of data, and needs to improve their Excel skills to be able to make the most of the power of the software. Past attendees include environmental managers, engineers, field staff, scientists, and government agency staff.
 



After completing this course, participants will be able to:

  • Install and use the Analysis Toolpak to perform common statistical analysis of their data.
  • Perform auditing and data validation tasks to help clean messy data sets and provide reliable results
  • Learn the basics of using the Visual Basic editor to create custom routines and automate tasks.

 

For general information contact Lenore Rooney by telephone at 425-270-3274 or via e-mail at lrooney@nwetc.org

 Upcoming Events

 No upcoming events.

Archives of past CLU-IN internet seminars are available in the CLU-IN Studio at http://clu-in.org/studio/. You will be able to view the slide and hear an audio stream of the presentation as it occurred.

Previous Events (click to view/hide)
Bullet  Live Online Class, Internet Based
  August 04, 2015 - August 06, 2015
Bullet  Helena, MT
  May 08, 2014 - May 08, 2014
Bullet  Sacramento, CA
  March 06, 2014 - March 06, 2014
Bullet  San Diego, CA
  February 13, 2014 - February 13, 2014
Bullet  Portland, OR
  January 30, 2014 - January 30, 2014
Bullet  Kirkland, WA
  December 05, 2013 - December 05, 2013
Bullet  Helena, MT
  November 07, 2013 - November 07, 2013
Bullet  Anchorage, AK
  October 17, 2013 - October 17, 2013
Bullet  Austin, TX
  September 12, 2013 - September 12, 2013
Bullet  Rosemont, IL
  March 07, 2013 - March 07, 2013
Logo for USA.gov website