Courses - Learn Excel Online By Doing

Building Models

ALL DO WATCH PRACTICE UNLOCKED

Richest Business People

Look at the some of richest people in the world using a table their age, earnings and their companies. And get information by a variety of comparison and filtering criteria from this table.

Learned Excel Functions: AVERAGE(), AVERAGEIF(), AVERAGEIFS(), COUNT(), COUNTBLANK(), COUNTIF(), COUNTIFS(), SUM(), SUMIF(), SUMIFS()

Body Mass Index Calculation UNLOCK NOW

Create a body mass index calculator using height and weight of a person

Learned Excel Functions: FALSE(), HLOOKUP(), IF(), IFERROR(), TRUE(), VLOOKUP()

Regional Sales Data UNLOCK NOW

Revisit your sales data, calculate regional totals, conditional totals

Learned Excel Functions: COUNTIF(), SUM(), SUMIF(), SUMIFS(), SUMPRODUCT()

Free

Shortcuts - Formula auditing magic [04:52]

Free

What IF Analysis – Using Form Control Buttons from Developer Tab (Spin Bar, Scroll Bar) [05:09]

What IF Analysis – Limitations of Spin Bar, Scroll Bar [04:03] UNLOCK NOW

What IF Analysis – Scenario Managers [07:01] UNLOCK NOW

What IF Analysis – Goal Seek [04:29] UNLOCK NOW

What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & 1 Output [08:23] UNLOCK NOW

What IF Analysis – Data Tables Basics (Sensitivity Analysis) - with PMT for Loan EMI [05:22] UNLOCK NOW

What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & multiple Output - Question [02:38] UNLOCK NOW

What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & multiple Output - Answer [10:08] UNLOCK NOW

Subtotal - Creating a 1-level SubTotal on a Sorted list [05:34] UNLOCK NOW

Subtotal - Deleting a SubTotal [01:18] UNLOCK NOW

Subtotal - Creating a 2-level SubTotal on a Sorted list [04:28] UNLOCK NOW

Subtotal - Coloring the Subtotal rows with different Color [01:46] UNLOCK NOW

Subtotal - Trick to Merge blocks of cells with similar names [05:31] UNLOCK NOW

Consolidate - 2 Dimensions [04:07] UNLOCK NOW

Consolidate - 3 Dimensions [07:55] UNLOCK NOW

Level: Intermediate
Exercises: 0/19
Steps: 0/41
Points: 8.600
Approx. Time: 1h 45m

Building Models

Build more complex models -not necessarily financial- using multiple functions and controls.

Rating Count : 2

Building Models

Richest Business People

Body Mass Index Calculation UNLOCK NOW

Regional Sales Data UNLOCK NOW

Shortcuts - Formula auditing magic [04:52]

What IF Analysis – Using Form Control Buttons from Developer Tab (Spin Bar, Scroll Bar) [05:09]

What IF Analysis – Limitations of Spin Bar, Scroll Bar [04:03] UNLOCK NOW

What IF Analysis – Scenario Managers [07:01] UNLOCK NOW

What IF Analysis – Goal Seek [04:29] UNLOCK NOW

What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & 1 Output [08:23] UNLOCK NOW

What IF Analysis – Data Tables Basics (Sensitivity Analysis) - with PMT for Loan EMI [05:22] UNLOCK NOW

What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & multiple Output - Question [02:38] UNLOCK NOW

What IF Analysis – Data Tables Basics (Sensitivity Analysis) - 2 Inputs & multiple Output - Answer [10:08] UNLOCK NOW

Subtotal - Creating a 1-level SubTotal on a Sorted list [05:34] UNLOCK NOW

Subtotal - Deleting a SubTotal [01:18] UNLOCK NOW

Subtotal - Creating a 2-level SubTotal on a Sorted list [04:28] UNLOCK NOW

Subtotal - Coloring the Subtotal rows with different Color [01:46] UNLOCK NOW

Subtotal - Trick to Merge blocks of cells with similar names [05:31] UNLOCK NOW

Consolidate - 2 Dimensions [04:07] UNLOCK NOW

Consolidate - 3 Dimensions [07:55] UNLOCK NOW

Building Models

Courses

Excel Paths

Sheetzoom

Start learning Excel now

Follow Us