Corporate Training By Zack Academy - Microsoft Excel Up to Speed Part 1 - Shortcuts, Functions, and Charts

Why Should You Take This Microsoft Excel Up to Speed Part 1 - Shortcuts, Functions, and Charts Course?

In this Microsoft Excel Up to Speed Part 1 - Shortcuts, Functions, and Charts course, 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 workflow in Excel. Tools explored include the graphing, charting, and formula functions used throughout the program. This is a hands-on class, and attendees will work with multiple page workbooks and real-world environmental data sets to organize, calculate, and visualize tabular information.

**Please bring a personal laptop with Excel 2010 (Excel 2007 acceptable):  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:

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

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:  Basic understanding of Microsoft Office software and basic computer skills are required.

Continuing Education Units: 1.30 CEUs

Topics To Be Covered Include:

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

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

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