->

Excel Advanced Formulas & Features to Create Efficient Team Workflows

Duration: 1h | Video: .MP4, 1280x720, 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 508 MBGenre: eLearning | Language: English


 

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 analysisor 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

Mastering Excel Tables: How to Make and Use Them Like a Pro

Intermediate Excel for the Real World: Cleaning Data for Analysis and Forecasting

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

HomePage:

/confirm/url/aHR0cHMlM0ElMkYlMkZ3d3cuc2tpbGxzaGFyZS5jb20lMkZlbiUyRmNsYXNzZXMlMkZFeGNlbC1BZHZhbmNlZC1Gb3JtdWxhcy1GZWF0dXJlcy10by1DcmVhdGUtRWZmaWNpZW50LVRlYW0tV29ya2Zsb3dzJTJGMTgyNTYzODU0Ng/

 

Excel Advanced Formulas & Features to Create Efficient Team Workflows

 

 


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Themelli   |  

Information
Members of Guests cannot leave comments.




rss