SCM Excel - Intermediate

Elevate your Excel skills with this comprehensive learning path designed for intermediate users. Start with Excel: Advanced Formulas and Functions, where Excel MVP Oz du Soleil demystifies complex formulas and functions. You'll master essential keyboard shortcuts, XLOOKUP/VLOOKUP, INDEX, and a variety of other functions through practical, real-world examples. Test your knowledge with end-of-course challenges.Next, dive into Excel: Using Solver for Decision Analysis with Excel expert Curt Frye. Learn to harness the power of Excel's Solver function to find optimal solutions for a range of problems. From tuning investment portfolios to resource placement analysis and decision tree analysis, this course equips you with the skills to tackle complex decision-making scenarios.By the end of this learning path, you'll be proficient in advanced Excel techniques and ready to apply them to real-world challenges.