Courses - Learn Excel Online By Doing
← Back to all Courses

Dashboards

ALL DO WATCH PRACTICE UNLOCKED
Learn By Watching

Whats in a dashboard? [02:25] UNLOCK NOW

Learn By Watching

Sales Dashboard 01 [03:27] UNLOCK NOW

Learn By Watching

Sales Dashboard 02 [03:03] UNLOCK NOW

Learn By Watching

Sales Dashboard 03 [02:32] UNLOCK NOW

Learn By Watching

Sales Dashboard 04 [03:50] UNLOCK NOW

Learn By Watching

Sales Dashboard 05 [05:21] UNLOCK NOW

Learn By Watching

Sales Dashboard 06 [06:44] UNLOCK NOW

Learn By Watching

Vertical Sort - 1-level & 2-level [02:25] UNLOCK NOW

Learn By Watching

Custom Sort [05:18] UNLOCK NOW

Learn By Watching

Sort Trick - add alternate blank rows in-between existing rows [03:00] UNLOCK NOW

Learn By Watching

Horizontal Sorting (Left to Right) - auto-realigning 100s of columns [03:32] UNLOCK NOW

Learn By Watching

Filter - Basics [03:39] UNLOCK NOW

Learn By Watching

Filter - Choosing the dataset correctly [01:27] UNLOCK NOW

Learn By Watching

Filter analysis w. shortcuts [02:54] UNLOCK NOW

Learn By Watching

Filter - SUBTOTAL() for calculations [05:07] UNLOCK NOW

Learned Excel Functions: SUBTOTAL()
Learn By Watching

Filter - SUBTOTAL() 9 vs. 109 series [02:42] UNLOCK NOW

Learned Excel Functions: SUBTOTAL()
Learn By Watching

Filter - Applying 2 or more Filters simultaneously on the same sheet [02:20] UNLOCK NOW

Learn By Watching

Filter - Color Filter & Text Filter [01:15] UNLOCK NOW

Learn By Watching

Advanced Filter - Basics [04:30] UNLOCK NOW

Learn By Watching

Advanced Filter - Differential Criteria [04:11] UNLOCK NOW

Learn By Doing

Richest Business People UNLOCK NOW

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()
Learn By Doing

Salesperson Ratings UNLOCK NOW

Create a summary of salesperson sales stats with the help of range lookup.

Learned Excel Functions: AVERAGEIF(), COUNTIF(), FALSE(), IF(), LEN(), SUMIF(), TRUE(), VLOOKUP()
Learn By Doing

Regional Sales Data UNLOCK NOW

Revisit your sales data, calculate regional totals, conditional totals

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

Sunshine Events UNLOCK NOW

Summarizing data with pivot table.
Learn By Watching

Advanced Filter - More parameters [03:12] UNLOCK NOW

Learn By Watching

Pivot Table - Why should you learn? [04:00] UNLOCK NOW

Learn By Watching

Pivot Table - Pre-requisites [02:26] UNLOCK NOW

Learn By Watching

Pivot Table - How to create one? [02:41] UNLOCK NOW

Learn By Watching

Pivot Table - Exploring Pivot Table grid (Fields) [03:23] UNLOCK NOW

Learn By Doing

Sales Pivot UNLOCK NOW

Create various pivot tables from sales data which contains "Country", " Salesperson", "Order Year", "OrderID" and "Order Amount" to start pivot tables.



  • Level: Intermediate
  • Exercises: 0/30
  • Steps: 0/65
  • Points: 7.000
  • Approx. Time: 2h 45m

Dashboards

Learn designing dashboards. One sheet full of data

Rating Count : 0

Courses

Excel Paths

Sheetzoom

© 2024 Sheetzoom       Legal Stuff         Made with    in Istanbul

Start learning Excel now

Get notified first! Sign-up free for our newsletter.

Follow Us