Corporate Training By Zack Academy - Microsoft Excel Up to Speed Part 2 - Analysis and Visual Basic Programming

Why Should You Take This Microsoft Excel Up to Speed Part 2 - Analysis and Visual Basic Programming Course?

Microsoft Excel Up to Speed Part 2 - Analysis and Visual Basic Programming is the second course in a 2-part series. In the first class, COMP-410, attendees learn techniques to improve their workflow in Excel, including leveraging the graphing, charting, and formula functions used throughout the program. In this training, attendees will build on these skills by installing and using the Analysis Toolpak to provide more advanced statistical modeling, and look at ways to cleanse data sets to ensure data validity. Special attention will be paid towards preparing and cleansing data for use with Microsoft Access.

This course is separate from 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) NWETC can provide one at a fee. Please contact them at 425-270-3274 to make arrangements two weeks prior to course. 

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.

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.

Prerequisites:  COMP-412 is not meant to be taken as a stand-alone class, we highly recommend taking COMP-410 first.

Topics To Be Covered:

• Analysis Toolpak
• Data Validation
• QA / QC
• Visual Basic Overview
• Pairing Excel with Microsoft Access

Continuing Education Units: 0.70 CEUs

Course Materials:  Attendees will receive a course manual containing workshop proceedings and reference material.

What To Bring To Class:  A personal laptop with Microsoft Office 2010, pen or pencil and a notepad.