Excel Excellence - training that sticks

“It is when the tools of production are transparent, that we are inspired to create.”
- Chris Anderson, The Long Tail

Unlock the power of visuals using PivotTables and Pivot Charts! 

Stop looking up data one item at a time, and finally master VLookUps!

Learn how even you can record, modify and program a macro to automate tedious tasks at work!

By popular demand, Excel guru and seasoned instructor Laura Winger is thrilled to present a unique class offering of Computer Skills for Supply Chain Professionals.  This class is intended to empower its students with the Microsoft Office skills needed to make a big impact in a supply chain environment, and more broadly, in most business and academic environments.  

By giving you the tools to analyze and present data, you will be inspired to apply these skills in your own work and do amazing things!   


More about the class

This 7-module course goes in-depth into the toughest, most useful (and most often confused) Microsoft Excel topics, like PivotTables and VLookups, and also explores clever and creative ways to digest data, harnessing the power of Excel formulas, filtering and sorting.  We also will look at the basics of programming macros, using Microsoft Access and amazing visual effects in Microsoft PowerPoint.  

Doing the clicks, thinking through problems and finding solutions are all part of learning Microsoft Excel, so this is a hands-on participative course, with homework, informal quizzes and a small project.  

Class Preview

Student Testimonials 

 “When I started the class, I did not know how to do VLookUps or Pivot Tables.  After completing the course, I now have the knowledge and confidence to complete these tasks... These skill sets will be invaluable to me as I progress in the Supply Chain field.” - Jack

“Reliably acquiring and manipulating data and generating useful analysis and reports is a core activity even with the most sophisticated ERP systems.  This class provides hands-on personal computer training in the skills required to perform these supply chain activities.” - Jim


"I saw this class coming up... that seemed to address all the concerns - everything I wanted to find out within Excel - such as VLookups, Pivot Tables and macros, and now the class is complete and has answered every question I had, and addressed every field that I haven't learned elsewhere... The teacher was great, she answered all our individual questions, and we came away with a lot of information.  So it was great, I'd do it again in a minute." - Bill


Course pre-requisites and requirements

This is an intermediate to advanced level course.  The content starts out relatively slowly, but accelerates quickly to ensure that even more advanced and experienced students get new tools and skills that they can apply.  With that in mind, it is imperative that students entering this course are already familiar with computer basics, such as right-clicking and using shortcut keys (like Ctrl+V for paste), as well as Microsoft Excel basics, such as opening and saving files, entering data and basic formulas, and formatting data.  It is extremely helpful if students work in Microsoft Excel on a daily or weekly basis as part of their jobs or academic work.

Students will be required to bring their own laptops with Microsoft Excel, PowerPoint and Access loaded.  30-day trial software may be downloaded from the Microsoft webpage if needed.  

Students must attend at least 6 of the 7 sessions and complete all homework and the project in order to earn a certificate of completion.


About the Instructor

Laura has a BSE in Industrial Engineering and an MBA with a focus in Supply Chain Management, both from Arizona State University. She also has a Six Sigma Black Belt at Honeywell, in addition to the APICS designations of CPIM and CSCP. She has held positions in quality control, operational excellence, project management, production scheduling, supply and demand planning, industrial engineering and management positions.


While working in desktop support and as a research assistant in college, Laura trained using Microsoft certification materials and developed complex spreadsheets and simple macros, reducing manual administrative work to focus on the customers and more important tasks.  These skills translated into her work in supply chain after graduating, making her a valuable asset to her team.  She has taught Excel courses at Society of Women Engineers conferences and through local APICS chapters.  She has also taught Lunch and Learn sessions at Henkel and GKN, led a Macro Like a Rockstar club at Honeywell, and has informally trained many of her colleagues and MBA classmates.  Laura is excited to now offer this practical, productivity-enhancing, skill-enriching course to the public.

 

Schedule


Contact me for upcoming classes. 


No comments:

Post a Comment