Proficiency In Excel
(Skill Development Program)
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.
1 Accredited Courses Included: Building Excel Skills
Time Required: Approximately 4-6 hours
Excel is a skill required for most business professionals - particularly those who need to manipulate, analyze and/or graph data. Working smarter in Excel saves you time, give syou confidence in your analytics, reduces errors, and can also be fun! Learn how to maximize your Excel skills across a broad range of topics, while at the same time benefiting from the applied category management examples provided.
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 to 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.
- 365-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)
*CMKG's Online Training and Resource Center includes many resources you can use in your day to day: a Resource Library with whitepapers, articles, tips and tricks, e-books and more; a dynamic Industry Glossary with >300 terms, each with a definition, formulas and links to other related descriptions; and 6 Student Webinars per year in topics suggested / chosen by students.