Most supply chain logistics professionals use Microsoft Excel in their work. Yet most people in business have little or no formal training in Excel, meaning they’re overlooking many efficiencies, quality control mechanisms, and data analysis methods – among other things.
Now, over the next year, CITT is offering a suite of seminars presented live but online for busy people like you. Each of these acclaimed seminars is taught by an expert instructor with content based on over 20 years of experience delivering Excel training and implementing feedback from working professionals. Regardless of your skill level, you’ll learn something valuable. And a recording of each seminar will be provided to the attendees - so you can go back and review what you've learned.
Mastering the Excel Macro Recorder: April 24, 2019
Excel macros are a compilation of keystrokes and mouse clicks that are memorized and stored for later use, but you don't have to be a VBA programmer to make use of this outstanding functionality. Simply use the Macro Recorder to create and store macros that will save time and reduce errors in repetitive processes. This session provides the necessary knowledge to use the Macro Recorder effectively. It covers tips on when to use relative references, using the Visual Basic editor to make minor modifications to recorded macros, and saving macros for easy access. Don't miss this opportunity to improve your productivity with Excel macros.
Learning Objectives Upon completing this course, participants should be able to:
Excel Tips, Tricks, and Techniques: July 16, 17, & 18, 2019
These three sessions will walk you through productivity-enhancing tactics in Excel, building from foundational tips into more advanced techniques that will allow you to customize Excel to your specific needs, calculations and more. Regardless of your skill level, you’ll learn something valuable. And a recording of each seminar will be provided to the attendees - so you can go back and review what you've learned. If you’ve never taken formal Excel training these are can’t-miss sessions that will provide you with immediately relevant skills. The three chapters will cover:
Productivity Tips & Tricks; Formatting Essentials: July 16
Customizing Excel; Formula Building Essentials: July 17
Three-dimensional Workbooks; Printing Essentials: July 18