Unlimited Elite Pack On-Demand Training

Pack Details

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our Unlimited Elite Pack covers a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and much more!

Benefits Included:

Unlimited Classes - Access our entire vault of 30+ training courses for 12 months
Live Training - Free access to all virtual, half-day workshops
Special Discounts - Get 40% off all week-long boot camps
Class Labs - Apply what you've learned to real-world examples
Class Certifications - Get certified in all aspects of SQL Server and Business Intelligence
Reporting - Monitor your progress, assessment scores and completed courses
Webinar - Access more than 700 webinars on various topics like Power BI, Azure, SQL Server, Business Intelligence and more
Bonus Courses - Gain access to exclusive courses

Courses:

Module 1 - Introduction to Interactive Dashboards with Excel

Module 1A

Introduction to Interactive Dashboards with Excel (Why Excel?)

7:44
Module 1B

Introduction to Interactive Dashboards with Excel (Why Dashboards?)

4:59
Module 1C

Introduction to Interactive Dashboards with Excel (VLOOKUP Series Selection Demo)

Preview

9:39

Module 2 - Thinking Outside the Cell

Module 2A

Thinking Outside the Cell (Introduction)

6:13
Module 2B

Thinking Outside the Cell (Why Develop Differently?)

3:29
Module 2C

Thinking Outside the Cell (Inserting the Camera Tool)

2:47
Module 2D

Thinking Outside the Cell (Using the Camera Tool)

7:14
Module 2E

Thinking Outside the Cell (Development Principles)

12:35

Module 3 - Working with Formulas

Module 3A

Working with Formulas (Formula Editing Tips)

11:06
Module 3B

Working with Formulas (Excel's Calculation Engine)

8:25
Module 3C

Working with Formulas (Writing Better Formulas)

10:15

Module 4 - Lookup Functions

Module 4A

Lookup Functions (Introduction)

2:30
Module 4B

Lookup Functions (VLOOKUP, INDEX, MATCH)

12:30
Module 4C

Lookup Functions (Array Formulas)

21:06
Module 4D

Lookup Functions (Array Formulas Review)

2:08

Module 5 - Excel Tables

Module 5A

Excel Tables (Introduction)

3:31
Module 5B

Excel Tables (Inserting an Excel Table)

7:42
Module 5C

Excel Tables (Working with Tables)

6:40
Module 5D

Excel Tables (Excel Table Chart)

4:12
Module 5E

Excel Tables (Excel Table Rules)

2:23

Module 6 - Sorting and Decision Function with Excel Tables

Module 6A

Sorting and Decision Function with Excel Tables (Sorting Functions)

15:56
Module 6B

Sorting and Decision Function with Excel Tables (Filters and SUMPRODUCT)

1:34
Module 6C

Sorting and Decision Function with Excel Tables (Filtering on Excel Tables)

15:25
Module 6D

Sorting and Decision Function with Excel Tables (Aggregation with Excel Tables)

11:21
Module 6E

Sorting and Decision Function with Excel Tables (Summary)

2:04

Module 7 - Introduction to Form Controls

Module 7A

Introduction to Form Controls (Enabling the Developer Tab)

1:34
Module 7B

Introduction to Form Controls (Excel Controls)

13:19
Module 7C

Introduction to Form Controls (Form Control Basics)

8:55

Module 8 - Formula Driven Development

Module 8A

Formula Driven Development (Introduction)

4:53
Module 8B

Formula Driven Development (Information-Transformation-Presentation)

6:53

Module 9 - Interactive Legends in Excel

Module 9A

Interactive Legends in Excel (Setting Up the Interactive Legend)

8:23
Module 9B

Interactive Legends in Excel (Perfecting the Interactive Legend)

17:29

Module 10 - Interactive Chart Toggle

Module 10A

Interactive Chart Toggle (Setup)

6:50
Module 10B

Interactive Chart Toggle (Formatting)

4:33
Module 10C

Interactive Chart Toggle (Maintenance)

2:31

Module 11 - Interactive Dashboards

Module 11A

Interactive Dashboards (Setup)

13:32
Module 11B

Interactive Dashboards (Formatting)

1:40
Module 11C

Interactive Dashboards (Maintenance)

2:32

Module 12 - Primer on Data Visualizations

Module 12A

Primer on Data Visualizations (Visual Perception)

7:49
Module 12B

Primer on Data Visualizations (Gestalt Laws of Grouping)

4:26
Module 12C

Primer on Data Visualizations (Preattentive Attributes)

2:27
Module 12D

Primer on Data Visualizations (The Problem with Pie Charts)

1:35
Module 12E

Primer on Data Visualizations (Data Visualizations vs. Infographics)

1:56

Module 13 - Expanding the Chart Library

Module 13A

Expanding the Chart Library (Dual Axis Banding)

3:41
Module 13B

Expanding the Chart Library (Area Chart Banding)

4:00
Module 13C

Expanding the Chart Library (Limit Charts)

2:56

Module 14 - Bullet Charts in Excel

Module 14A

Bullet Charts in Excel (Building the Chart)

7:10
Module 14B

Bullet Charts in Excel (Horizontal Bullet Chart Trick)

3:19

Module 15 - Infographics

Module 15A

Infographics (Introduction)

1:17
Module 15B

Infographics (Progress Meter)

7:37
Module 15C

Infographics (Donut Chart)

5:08
Module 15D

Infographics (Waffle Chart)

5:09
Module 15E

Infographics (Bringing it Together with the Camera)

1:52

Module 16 - Summary

Module 16

Summary

2:27

Jordan Goldmeier

Data Science/Analytics Professional and Visualization Expert

Jordan is an internationally recognized data science/analytics professional and visualization expert, author, and speaker. He is the owner of Cambia Factor, a data consulting agency and the author of "Advanced Excel Essentials" (Apress 2014) and Dashboards for Excel (Apress 2015). He has consulted with and provided training for NATO, the Pentagon, and Financial Times, among others. His work has been cited by and quoted in the Associated Press, Bloomberg Businessweek, Dice News, and American Express OPEN Forum. He has also held the prestigious MVP award from Microsoft since 2013.

Related Courses

Course Info

30+ Courses
Access on Mobile and TV
Certificate of Completion
Download Syllabus
Enrollment Price:	$995/Year

Free Trial

Share this course with your friends

Shopping Cart 0