When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Excel: Advanced Formulas & Features to Create Efficient Team Workflows
Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.
Free
This Course Includes
skillshare
0 (0 reviews )
1 hours 
english
Online - Self Paced
course
SkillShare
About Excel: Advanced Formulas & Features to Create Efficient Team Workflows
Introduction
Use OFFSET W/ AVG & SUM
Pick Scenarios Using OFFSET
Make Decisions W/ IRR & NPV
Search W/ Ease Using Wildcards
Find Optimum Inputs W/ Goal Seek
Complex Optimizations W/ Solver
Final Thoughts
What You Will Learn?
- Learn advanced features and formulas in Excel to make better business decisions with your team!.
- This class is all about using some advanced features and formulas in Excel to help make your model, dashboard, and analysis more efficient and impactful. Excel is great for doing scenario analysis--or figuring out what the impact will be when you choose option A, B, or C. By using the skills taught in this advanced Excel class, you'll learn how to do better scenario analysis and ultimately make optimal business decisions..
- A sample of skills you'll learn in this class:.
- Wow your teammates and business stakeholders by using these advanced Excel features. You'll be actively using the Excel workbook I created for this class (see Projects & Resources)..
- Who is this class for?.
- Advanced Excel users, but all students are encouraged to participate and enjoy. .
- Prerequisites:.
- This class moves fast. You should have a basic understanding of Excel including:.
- Some classes to consider taking as a prerequisite:.
- Software.
- I’ll be using Mac Excel 2016 for Office 365. You can use any of the following versions of Excel for this class:.