Courses - Learn Excel Online By Doing

Reporting

ALL DO WATCH PRACTICE UNLOCKED

Free

Oil Production

Learn absolute and relative referencing using a sample data about oil production in Northern American countries.

Learned Excel Functions: SUM()

Free

Coffee Shop Price Table

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() functions in this exercise.

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

Social Media Statistics UNLOCK NOW

Create some statistics to better understand the social media adoption

Learned Excel Functions: FALSE(), INDEX(), MATCH(), VLOOKUP()

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()

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.

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()

Regional Sales Data UNLOCK NOW

Revisit your sales data, calculate regional totals, conditional totals

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

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

Custom Sort [05:18] UNLOCK NOW

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

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

Free

Filter - Basics [03:39]

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

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

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

Learned Excel Functions: SUBTOTAL()

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

Learned Excel Functions: SUBTOTAL()

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

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

Advanced Filter - Basics [04:30] UNLOCK NOW

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

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

Data Validation - Drop Down List using hard coded text & pre-defined range [02:39] UNLOCK NOW

Data Validation - Drop Down List using named range [03:53] UNLOCK NOW

Sales UNLOCK NOW

Using and testing some values.

Learned Excel Functions: INDEX(), MATCH(), OFFSET(), SUM()

Sunshine Events UNLOCK NOW

Summarizing data with pivot table.

Free

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

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

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

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

Practice: Pivot Tables-II UNLOCK NOW

Practice your skills about pivot tables.

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

Free

Printing - Rows to Repeat at Top (Print Titles) [02:20]

Printing - Gridlines [01:16] UNLOCK NOW

Printing - Custom Header & Footer [02:54] UNLOCK NOW

Printing - Page Order - Vertical vs. Horizontal [02:13] UNLOCK NOW

Printing - Tricks for Financial Analysts - Check underlying formulas [01:50] UNLOCK NOW

Printing - Tricks for Financial Analysts - Cell Comments [01:49] UNLOCK NOW

Printing - Print Entire Workbook [00:58] UNLOCK NOW

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

Sales Dashboard 01 [03:27] UNLOCK NOW

Sales Dashboard 02 [03:03] UNLOCK NOW

Sales Dashboard 03 [02:32] UNLOCK NOW

Sales Dashboard 04 [03:50] UNLOCK NOW

Sales Dashboard 05 [05:21] UNLOCK NOW

Sales Dashboard 06 [06:44] UNLOCK NOW

Level: Advanced
Exercises: 0/51
Steps: 0/112
Points: 21.850
Approx. Time: 3h 30m

Reporting

Various reporting techniques, functions and case studies to present your data

Rating Count : 4

Reporting

Oil Production

Coffee Shop Price Table

Social Media Statistics UNLOCK NOW

Richest Business People UNLOCK NOW

Sales Pivot UNLOCK NOW

Salesperson Ratings UNLOCK NOW

Regional Sales Data UNLOCK NOW

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

Custom Sort [05:18] UNLOCK NOW

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

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

Filter - Basics [03:39]

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

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

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

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

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

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

Advanced Filter - Basics [04:30] UNLOCK NOW

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

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

Data Validation - Drop Down List using hard coded text & pre-defined range [02:39] UNLOCK NOW

Data Validation - Drop Down List using named range [03:53] UNLOCK NOW

Sales UNLOCK NOW

Sunshine Events UNLOCK NOW

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

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

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

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

Practice: Pivot Tables-II 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

Printing - Rows to Repeat at Top (Print Titles) [02:20]

Printing - Gridlines [01:16] UNLOCK NOW

Printing - Custom Header & Footer [02:54] UNLOCK NOW

Printing - Page Order - Vertical vs. Horizontal [02:13] UNLOCK NOW

Printing - Tricks for Financial Analysts - Check underlying formulas [01:50] UNLOCK NOW

Printing - Tricks for Financial Analysts - Cell Comments [01:49] UNLOCK NOW

Printing - Print Entire Workbook [00:58] UNLOCK NOW

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

Sales Dashboard 01 [03:27] UNLOCK NOW

Sales Dashboard 02 [03:03] UNLOCK NOW

Sales Dashboard 03 [02:32] UNLOCK NOW

Sales Dashboard 04 [03:50] UNLOCK NOW

Sales Dashboard 05 [05:21] UNLOCK NOW

Sales Dashboard 06 [06:44] UNLOCK NOW

Reporting

Courses

Excel Paths

Sheetzoom

Start learning Excel now

Follow Us