Course

Microsoft Excel Up to Speed Parts 1 and 2


More Information
Directions
Accommodations
Learn to use more of the power of Excel to manage, analyze, and visualize your data (Parts 1 and 2)
Course Title: Microsoft Excel Up to Speed Parts 1 and 2
Course ID: COMP 410-412wr
Status: OPEN
Date(s): October 25, 2017
December 29, 2017
Location: Online-Webinar Recording
Online-Webinar Recording
Online-Webinar Recording, XX
Instructor: Adam Wilbert
Tuition: $400
Add to CartClick to pay by credit card and download course files

Other Payment Methods Click to pay by Check or Purchase Order

 

Description:

**This course was presented as a live webinar in 2015 in six 2-hour sessions. **

Purchase includes 10 files:

  • Audio/Video recording of six 2-hour sessions,
  • Two course workbooks,
  • Exercise packets for each part

Many people use Excel every day yet barely scratch the surface of what they can accomplish with this powerful program. 

In Part 1, users will learn to utilize Shortcuts, Functions, and Charts, and explore all of the hidden tools that are at their disposal.

After completing Part 1, participants will be able to:

  • Understand intermediate to advanced uses of Microsoft Excel beyond the simple data table
  • Feel comfortable exploring and using functions and recording macros
  • Leverage charting, Sparklines, PivotTables and PivotCharts for data visualization and trend analysis
  • Gain proficiency in using power shortcuts and recording macros that will save time.

In Part 2, the focus is on Analysis and Visual Basic Programming. 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. During this section, users will learn how to incorporate these workhorse tools into their Excel repertoire.

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.

Continuing Education Units: 1.20 CEUs

More Information

Course Topics

Course Topics:

Part 1

  • Macros
  • Pivot Tables
  • Pivot Charts
  • Charting
  • Sparklines
  • Dates & Times
  • Shortcut Keys & Power Techniques
  • Formulas
  • Auditing and Scenarios

Part 2

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

About the Instructor

Adam Wilbert

Adam 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 Bring

N/A

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 Cancel

Cancellations*

  • With 31 or more days notice, we will offer a 100% refund or credit towards a future course. The credit is good for one year and may be applied to any course.
  • With 30-8 days notice, we will offer a course credit towards a future course. The credit is good for one year and may be applied to any course.
  • With fewer than 8 days notice, there is no course credit available


*Please note that attendee replacement is welcome at any time

Disability Accommodations

Disability Accommodations:

N/A


Directions

  • From:

  • To:
  •   Online-Webinar Recording Online-Webinar Recording, XX

Accommodations

 



*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!

 

*Follow NWETC on twitter, and "like" us on Facebook by clicking the icons: