Spreadsheet & Visualization Mastery – Ted Jordan Academy

Current Status

Not Enrolled

Price

Closed

Get Started

This course is currently closed

Course Content

Expand All

Phase 1: Handy Functions 6 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/6 Steps

1.1 Unique Function

1.2 Auto-Sum Feature

1.3 Text to Column

1.4 Transpose Function

1.5 Filter Function

Summary Phase 1

Phase 1: Handy Functions Quiz

Phase 2: Tables management 6 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/6 Steps

2.1 Flash Fills

2.2 Replace All

2.3 Table Indexing

2.4 Pivot Table: Slicers

2.5 Pivot Table: Connections

Phase 2 Summary

Phase 2: Table Management Quiz

Phase 3: Data Visualizations 6 Topics | 1 Quiz

Expand

Lesson Content

0% Complete 0/6 Steps

3.3 Themes (sheet & Excel)

3.4 Custom Chart

3.5 Navigational Buttons

Summary Phase 3

Phase 3: Data Visualizations Quiz

Phase 4: Check List Dashboard

Phase 5: Client Reporting Marketing

Phase 6: SQL-based dashboard 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

6.2 How does it work?

6.3 SQL on Google Sheets

6.4 Fields Needed

6.5 Building the query

6.6 Customising the dashboard

Conclusion 1 Topic | 1 Quiz

Expand

Lesson Content

0% Complete 0/1 Steps

Referral Program

Advanced Spreadsheet Course Feedback

Final Assignment 1 Quiz

Expand

Lesson Content

Advanced Spreadsheet Assignment