“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!
More about the class
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
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