Excel: Advanced Formulas & Features to Create Efficient Team Workflows | Al Chen | Skillshare

Playback Speed

• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x

# Excel: Advanced Formulas & Features to Create Efficient Team Workflows

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

### 0:58

• --
• Beginner level
• Intermediate level
• All levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

285

Students

2

Projects

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:

• Using the OFFSET function to create more robust models and scenario analysis
• NPV and IRR functions to figure out the profitability of differentÂ opportunities
• Finding optimal inputs with the advanced Goal Seek and Solver features

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:

• Navigating around Excel
• Writing basic formulas (including VLOOKUP)
• Business/finance metrics like revenue, expenses, net profit, etc.

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:

• Windows:Â Excel 2019, Excel 2016, Excel 2013 Â
• Mac:Â Excel 2016, Excel 2011

### Al Chen

Excel Trainer & Coda Evangelist

Teacher

I have been an Excel power user for 10+ years. I started learning Excel when I was a financial analyst at Google. 50,000+ students have taken my online Excel classes and I have facilitated in-person workshops to over 5,000 MBA students around the the U.S.

I founded KeyCuts, an Excel training and consulting company to Fortune 500 companies. If it isn't clear I'm addicted to Excel, perhaps my podcast about Excel and data analysis (Dear Analyst) will convince you :).

Outside of Excel and spreadsheets, I work full-time at Coda, an all-in-one doc for teams. If you would like to read my full journey with spreadsheets and Coda, check out this blog post.

Feel free connect with me on LinkedIn and ask me any questions about Excel, ... See full profile

Level: All Levels

## Class Ratings

Expectations Met?
Exceeded!
• 0%
• Yes
• 0%
• Somewhat
• 0%
• Not really
• 0%

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects