0 Items
**This is a recording of a live webinar presented in three 2-hour sessions.**
This webinar was presented by Sustainable City Networks and NWETC.
Purchase includes 5 files:
- Audio/Video recording of three 2-hour sessions,
- Course workbook,
- An exercise packet
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.
Course Topics:
- Macros
- Pivot Tables
- Pivot Charts
- Charting
- Sparklines
- Dates & Times
- Shortcut Keys & Power Techniques
- Formulas
- Auditing and Scenarios
**Please ensure that your computer has Excel 2010 (Excel 2007 acceptable).
Student Testimonial: "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
Prerequisites:
Basic understanding of Microsoft Office software and basic computer skills are required.
Course Materials:
Attendees will receive a .pdf containing workshop proceedings and reference material. Webinar login instructions will be sent after registration.
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.
