Proficiency In Excel
This accredited program builds your Excel skills, no matter to help you become more proficient in developing and analyzing Excel spreadsheets using category management data.
Your program is broken into different mini-modules that start with the basics, followed by intermediate and advanced topics. Each mini module includes a how-to video, followed by a workshop where you will complete examples that were taught in the video. You only need to complete the modules that are relevant or new to you.
Topics reviewed include Range Names, Dynamic Range Names, Absolute and Relative References, Basic Formula Writing, Custom Formats, Custom Lists, Text Functions, Pivot Tables and VLOOKUP and HLOOKUP formulas. All of the data examples used in these courses are appropriate for category management work.
All of the examples tie in with real data sources that you use in your everyday business, so you get the benefit of also learning how to manipulate similar data sources within Excel.
- Building Excel Skills
- Approximately 4-6 hours to complete
- No Prerequisites
- 90-day Access via CMKG's Online Training and Resource Center, including individual course Hands-On Workshops, Downloadable Notes & Reference Guides, Knowledge Checks, and Course Tests. Desktop, Laptop and Mobile Devices compatible.
- Ongoing student support (Email, Live Chat