Course

Microsoft Excel Up to Speed Part 1: Shortcuts, Functions, and Charts


More Information
Directions
Accommodations
Utilizing the Power for Environmental Applications: Course 1 in a 2 Part Series
Course Title: Microsoft Excel Up to Speed Part 1: Shortcuts, Functions, and Charts
Course ID: COMP-410
Status: CLOSED
Date(s): September 10, 2013: 8:30am - 4:30pm
September 11, 2013: 8:30am - 4:30pm
Location: Hampton Inn Austin South

Austin, TX
Instructor: Adam Wilbert
Tuition: $645 / $595*
$595 / $545* (Before July 27, 2013)
Class is Closed

 

Description:

Many people use Excel every day yet barely scratch the surface of what they can accomplish with this powerful program. By emphasizing keyboard shortcuts and exploring all of the hidden tools that are at your disposal, we will take your Excel skills to the next level and beyond. If you've ever spent an 8 hour day working in Excel and thought "there has got to be a better way," then this is the class for you.

Participants will build upon basic skills in using Microsoft Excel 2010 to leverage some of the more advanced capabilities of the program and learn techniques to improve their Excel proficiency. Tools explored include the graphing, charting, and formula functions used throughout the program, with special attention paid to keyboard shortcuts and efficient best-practices. This is a hands-on class, and attendees will work with real-world environmental situations to organize, calculate, and visualize tabular information. For additional exposure, a recommended third day, "Excel Up To Speed Part 2: Analysis and Visual Basic Programming (COMP-412)," is also offered immediately following this course.


After completing this course, 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.

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

"I didn't even realize how much I didn't know about Excel. What I like most about this class is that I went from having little understanding of Excel to feeling like an expert at the end of the course." B. Nabhan, January 2014


 

An additional $50 discount applies when registering for both courses in the series.

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

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: 1.30 CEUs

More Information

Course Topics

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

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

A personal laptop with Microsoft Office 2010 and a pen or pencil (and paper if you prefer not to write in your binder).

If you are not able to provide a laptop with Office 2010 we can provide one at a fee. Please contact us at 425-270-3274 to make arrangements. 

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:

To request disability accommodations, please contact us at info@nwetc.org or 425-270-3274 at least 30 days prior to the event.


Directions

  • From:

  • To:
  •   4141 Governors Row Austin, TX 78744

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: