SCL Training, Webinars & Events  -  Online Learning  -  Microsoft Excel Training

Microsoft Excel Training

 

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. 
 

Excel Training Sessions

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.

Major Topics

  • Creating your first macro in less than two minutes
  • Recording absolute and relative reference macros
  • Saving macros for future use
  • Modifying macros in the VBA Editor

Learning Objectives Upon completing this course, participants should be able to:

  • Use the Macro Recorder effectively and make minor modifications to recorded macros
  • List the three locations where recorded macros may be stored and the reasons for using each location
  • Differentiate the results when using absolute or relative references when recording macros
  • Describe how to attach macros to buttons on the ribbon or the Quick Access Toolbar

Click here to register for this session


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

  • Tips and tricks such as freezing panes, split windows, selecting cells with special characteristics, adding date and time stamps, the clipboard, and how to use these to increase productivity
  • Formatting techniques; including multiline column headings; custom date and number formats; and conditional formatting

Customizing Excel; Formula Building Essentials: July 17

  • Customizing Excel for your specific uses, including customizing the ribbon, the quick access toolbar and using templates to increase productivity
  • Use formula building tools, such as the formula tab, splitting and combining text strings, conditional calculations, VLOOKUPS and HLOOKUPS, and using the text to columns wizard

Three-dimensional Workbooks; Printing Essentials: July 18

  • Linking data from multiple workbooks; handling broken links; combining workbooks; and creating sum-through formulas and rolling reports
  • Expertly print data from Excel, including adjusting settings, using the camera feature to create report forms, and working with custom views

Register for the session of your choice, or all three here
 

 

Please send me more information!

Your contact information will never be sold or shared for any other purpose other than what you have authorized. And if you agree to be added to the CITT mailing list, you can unsubscribe at any time. SImply select the "unsubscribe" link at the bottom of every email or contact the CITT office and ask to be removed.