Learn to use the intermediate and advanced features of Microsoft Excel in this 12-hour online course recorded in August 2015. Includes session recordings (MP4) and sample Excel worksheets.
This course, presented by Sustainable City Network and the Northwest Environmental Training Center, 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 technical managers, engineers, field staff, scientists, and government agency staff.
Part 1: Shortcuts, Functions and Charts in Excel (6 hours)
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 situations to organize, calculate, and visualize tabular information.
Part 2: Analysis and Visual Basic Programming in Excel (6 hours)
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.
Instructor 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.