Analysis Toolpak
Data Validation
QA / QC
Visual Basic Overview
Pairing Excel with Microsoft Access
More Information Directions Accommodations |
NWETC has negotiated a special rate of $99.00/night. Rates are available on a first-come, first-serve basis and are available through 4/29/14, or when the block has filled-whichever comes first. Reservations can be made by calling 1-406-0505 and using group code NWETC. Please note that rates and expiration of rates vary by course. | ||||||||||||||||||
Description: 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 bring a personal laptop with Excel 2010 (Excel 2007 acceptable) a pen or pencil and paper if you prefer not to write in your manual. If you are not able to provide a laptop with Office (various types acceptable, 2010 preferred) we can provide one at a fee. Please contact us at 425-270-3274 to make arrangements two weeks prior to course.
Please wait to receive a course confirmation email, roughly one month prior to the class, before making any travel arrangements. 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. Continuing Education Units: 0.70 CEUs More InformationCourse TopicsAnalysis Toolpak About the InstructorAdam Wilbert
Adam Wilbert is a cartographer and database consultant. He has developed Access databases for the National Park Service as well as database and GIS solutions for small businesses and non-profit organizations. In 2007 Adam founded CartoGaia, a freelance cartography firm that merges a passion for data with aesthetic design. CartoGaia produces data management solutions and high-end custom maps for land use agencies, non-profit organizations and recreational groups. He is also the author of "Access 2007: Queries in Depth" available in the Lynda.com online training library. When Adam's not working at the computer, he's out exploring the world through the lens of infrared photography. What to BringA personal laptop with Microsoft Office 2010, pen or pencil and a notepad. Billing Information
In order to guarantee a space in a course, the tuition must be paid in full TWO WEEKS before the first day of the course by either check or credit card. State and government agencies paying with a purchase order are allowed payment under the two-week time frame if a copy of the purchase order is received by NWETC.
If You Need to CancelCancellations*
*Please note that attendee replacement is welcome at any time Disability AccommodationsDisability Accommodations:To request disability accommodations, please contact us at info@nwetc.org or 425-270-3274 at least 30 days prior to the event. |
*Reduced tuition available to employees of Native American tribes, nonprofits, and government agencies; students; and NAEP members.
If you have any trouble registering please call (425) 270-3274 ext 103
Please wait to receive a course confirmation email, roughly one month prior to the class, before making any travel arrangements. Please review what to bring!
© 2024 NWETC. All rights reserved