Get $1 credit for every $25 spent!

The 2021 Ultimate Microsoft Excel Business Intelligence Certification Bundle

Ending In:
Add to Cart - $44.99
Add to Cart ($44.99)
$2,400
98% off
wishlist
Courses
12
Lessons
611
Enrolled
303

What's Included

Product Details

Access
Lifetime
Content
8.0 hours
Lessons
114

Microsoft Excel: Advanced Formulas & Functions

Master 75+ Excel Formula & Functions with Hands-On Demos

By Maven Analytics | in Online Courses

It's time to show Excel who's boss! Whether you're starting from square one or aspiring to become an absolute Excel wizard, this is the right place for you. This course will give you a deep understanding of the advanced formulas and functions of transforming Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. Through hands-on, contextual examples, you'll learn why these formulas are awesome and how they can be applied in several ways. This is especially useful for including your portfolio or resume so that future employers can feel confident in your skillset.

4.6/5 average rating: ★ ★ ★ ★

  • Access 114 lectures & 8 hours of content 24/7
  • Easily build dynamic tools & Excel dashboards to filter, display, & analyze your data
  • Go rogue & design your own formula-based formatting rules
  • Join datasets from multiple sources in seconds w/ lookup, index, & match functions
  • Pull real-time data from APIs directly into Excel
  • Manipulate dates, times, text, & arrays
  • Automate tedious & time-consuming analytics tasks using cell formulas and functions in Excel
NOTE: Software NOT included.
Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: intermediate
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2007 - 2019 or Office 365

Course Outline

  • Your First Program
  • Getting Started
    • Course Structure & Outline - 1:28
    • DOWNLOAD: Course Resources
    • Setting Expectations - 7:12
    • Important Note for StackSkills Students
  • Excel Formulas 101
    • Introduction - 1:48
    • Formula Syntax - 11:03
    • Fixed & Relative References - 8:42
    • Common Error Types - 8:47
    • Formula Auditing: Trace Precedents & Dependents - 10:14
    • Formula Auditing: Evaluate Formula & Error Checking - 7:48
    • Ctrl Shortcuts - 7:30
    • Function Shortcuts - 9:44
    • Alt Key Tips - 4:16
    • BONUS: Mac Shortcuts
    • PRO TIP: Data Validation - 6:12
    • Congrats, You're a Developer! - 5:07
    • QUIZ: Formulas 101
    • HOMEWORK: Formulas 101 - 0:46
  • Conditional Statements & Logical Operators
    • Introduction - 1:23
    • Anatomy of the IF Statement - 4:01
    • Nested IF Statements - 4:53
    • AND/OR Operators - 8:47
    • NOT (<>) Operators - 3:17
    • Addressing Errors with IFERROR - 4:03
    • Common IS Statements - 4:00
    • QUIZ: Conditional Statements & Logical Operators
    • HOMEWORK: Conditional Statements & Logical Operators - 0:44
  • Statistical Functions
    • Introduction - 1:09
    • Basic Stats Functions - 5:17
    • SMALL/LARGE & RANK/PERCENTRANK - 6:15
    • RAND() & RANDBETWEEN - 2:12
    • The SUMPRODUCT Function - 3:55
    • SUMPRODUCT Demo - 4:57
    • COUNTIFS/SUMIFS/AVERAGEIFS - 4:49
    • DEMO: Basic Dashboards with Stats Functions - 8:09
    • Combining COUNTIF & SUMPRODUCT - 7:57
    • PRO TIP: Data Profiling - 16:06
    • QUIZ: Statistical Functions
    • HOMEWORK: Statistical Functions - 0:35
  • Lookup & Reference Functions
    • Introduction - 1:18
    • Named Arrays - 3:30
    • ROW/ROWS & COLUMN/COLUMNS - 3:18
    • VLOOKUP & HLOOKUP - 5:53
    • DEMO: Joining Data with VLOOKUP - 6:23
    • Combining IFERROR & VLOOKUP - 4:30
    • VLOOKUP Range Options - 6:18
    • Approximate Match Lookups - 5:05
    • The INDEX Function - 1:59
    • The MATCH Function - 2:32
    • Combining INDEX & MATCH - 6:08
    • Combining MATCH & VLOOKUP - 4:47
    • UPDATE: VLOOKUP Correction - 5:05
    • SNEAK PEEK: XLOOKUP (Office 365 Only) - 4:29
    • DEMO: Building Dashboards with XLOOKUP - 18:16
    • Selecting List Items with CHOOSE - 13:15
    • The OFFSET Function - 2:05
    • Combining OFFSET & COUNTA - 2:58
    • DEMO: Building a Scrolling Chart with OFFSET - 9:51
    • QUIZ: Lookup & Reference Functions
    • HOMEWORK: Lookup & Reference Functions - 0:54
  • Text Functions
    • Introduction - 0:50
    • UPPER, LOWER, PROPER & TRIM - 3:32
    • CONCATENATE (&) - 3:26
    • LEFT, MID, RIGHT & LEN - 3:31
    • TEXT & VALUE - 4:20
    • SEARCH & FIND - 5:04
    • Categorizing Data with IF(ISNUMBER(SEARCH)) - 5:39
    • Combining RIGHT, LEN & SEARCH - 5:43
    • The SUBSTITUTE Function - 2:21
    • QUIZ: Text Functions
    • HOMEWORK: Text Functions - 0:59
  • Date & Time Functions
    • Introduction - 2:08
    • Understanding DATEVALUE - 5:05
    • Date Formatting & Fill Series - 3:39
    • TODAY() & NOW() - 2:16
    • YEAR/MONTH/DAY & HOUR/MINUTE/SECOND - 3:04
    • The EOMONTH Function - 6:17
    • The YEARFRAC Function - 2:27
    • WEEKDAY, WORKDAY & NETWORKDAYS - 7:22
    • The DATEDIF Function - 4:23
    • DEMO: Budget Pacing Tool - 11:07
    • QUIZ: Date & Time Functions
    • HOMEWORK: Date & Time Functions - 0:35
  • Formula-Based Formatting
    • Introduction - 1:26
    • Creating and Managing Formula-Based Rules - 4:39
    • DEMO: Highlighting Rows with MOD - 3:50
    • DEMO: Formatting Cells Based on Values - 3:29
    • DEMO: Formatting Cells with Stats Functions - 5:28
    • DEMO: Formatting Cells with Text & Conditional Functions - 5:08
    • QUIZ: Formula-Based Formatting
    • HOMEWORK: Formula-Based Formatting - 0:34
  • Basic Array Formulas
    • Introduction - 1:24
    • READ ME: Array Formulas are Changing!
    • Rules of Array Formulas - 3:24
    • Pros & Cons of Array Formulas - 2:15
    • Vertical, Horizontal & 2-D Array Constants - 6:26
    • Using Array Constants in Formulas - 3:38
    • Named Array Constants - 4:31
    • The TRANSPOSE Function - 4:21
    • Linking Data: Array vs. Non-Array Comparison - 2:36
    • DEMO: Returning the "X" Largest Values - 3:09
    • DEMO: Counting Characters Across Cells - 1:52
    • DEMO: Creating a "MAX IF" Function (Part 1) - 3:09
    • DEMO: Creating a "MAX IF" Function (Part 2) - 6:54
    • The Double Unary Operator ("--") - 3:49
    • QUIZ: Array Formulas
    • HOMEWORK: Array Formulas - 2:09
  • Extra Bonus Functions
    • Introduction - 1:38
    • The INDIRECT Function - 10:55
    • The HYPERLINK Function - 6:19
    • WEBSERVICE & FILTERXML: Weather Underground - 7:16
    • WEBSERVICE & FILTERXML: Open Weather Map - 9:14
    • QUIZ: Badass Bonus Functions
  • Wrapping Up
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
43

Financial Modeling for Beginners in Excel in 4 Hours

Learn & Create Your First Financial Modeling Templates Including Revenue, Expense, Profit and Loss, and Cashflow

By Bryan Hong | in Online Courses

If you want to improve your skills at Financial Modeling using Microsoft Excel so you can get a better paying job or get answers and insights from your data fast with Financial Models, then you are in the right place. Whether you are a financial modeling beginner or never used Excel before, you are sure to benefit from this quick course that goes through the must-know financial modeling foundations. In just 4 hours, you will walk away with your own financial model, knowledge about financial modeling, and more.

4.4/5 average rating: ★ ★ ★ ★

  • Access 43 lectures & 4 hours of content 24/7
  • Create your own financial model from scratch in just 4 hours
  • Understand the essence of financial model components & see them in action
  • See how financial modeling is used with real examples
  • Understand how Revenue, Expense, Profit & Loss & Cashflow are used together
NOTE: Software NOT included.
Bryan Hong | Data Analysis Ninja
4.5/5 Instructor Rating: ★ ★ ★ ★

Bryan Hong is the author of 101 Excel Series paperback books and is also an IT Software Developer for more than 10 years. His courses focus on Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping his students in whatever means possible, whether it be reaching them via courses or by books.

Certifications

  • Microsoft Certified Professional Developer (MCPD): Web Developer
  • Microsoft Certified Technology Specialist (MCTS): Windows Applications
  • Microsoft Certified Systems Engineer (MCSE)
  • Microsoft Certified Systems Administrator (MCSA)

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Excel for Windows 2007, 2010, 2013, 2016, 2019
  • Office 365
  • Excel for Mac 2011 and 2016

Course Outline

  • Financial Modeling - Beginners
    • Intro - Modules in the Course - 2:38
    • Exercise Files
    • Intro - What is a Financial Model - 4:24
    • Intro - Financial Model Design - 7:32
    • Intro - Scenario Analysis - 2:33
    • Intro - Documentation - 4:59
    • Core Excel Concepts - Cell References - 8:31
    • Core Excel Concepts - IF Formula - 2:27
    • Core Excel Concepts - AND Formula - 3:18
    • Core Excel Concepts - OR Formula - 2:33
    • Core Excel Concepts - Nested Formulas - 3:07
    • Core Excel Concepts - Conditional Formatting - 3:13
    • Core Excel Concepts - Data validation - 5:02
    • Model - Inputs - 8:40
    • Model - Revenue - 7:22
    • Model - Expenses - 6:32
    • Model - Profit and Loss - 7:21
    • Model - Cashflow - 10:20
    • Model - Adding Scenarios - 14:41
    • Model - Charts - 5:09
    • Model - Conditional Formatting - 4:49
    • Model - Protect Workbook - 6:02
  • Financial Modeling - Intermediate
    • Intro - Modules in the Course - 2:32
    • Exercise Files
    • Intro - Design Principles - 7:23
    • Core - Aggregate Functions - 5:15
    • Core - Lookup Functions - 14:15
    • Core - Forecasting - 6:14
    • Core - Mixed References and Named Ranges - 8:35
    • Core - External Links - 14:14
    • Skills - Error Checks - 9:03
    • Skills - Goal Seek - 7:39
    • Skills - WACC - 8:11
    • Skills - NPV and IRR - 9:04
    • Model - Introduction - 2:36
    • Model - Staff Expenses - 16:43
    • Model - Staff Expenses Summary - 6:31
    • Model - Revenue - 19:11
    • Model - Market Analysis - 1:57
    • Model - Profit and Loss - 6:38
    • Model - NPV IRR - 6:51
    • Model - Payback Period - 4:26
    • Model - Scenario Analysis - 6:52

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
20

Excel Pro Tips: Analytics Tools

Explore Powerful Analytical Tools like Forecasting, Optimization, & Montel Carlo Simulation

By Maven Analytics | in Online Courses

This course is part of the Excel Pro Tips series, designed to help everyday users develop expert-level skills by mastering the same tools and techniques used by top pros and Excel MVPs. In this course, you’ll dive into some of Excel’s advanced analytics tools, using a variety of unique, real-world demos and case studies. You’ll forecast stock prices and monthly temperatures, build our own outlier detection tools, solve complex optimization problems, design Monte Carlo simulation models, create reports using CUBE functions, and much more. It's time to start working smarter, not harder. If you're ready to step up your analytics game and see what Excel is really capable of, this is the course for you.

  • Access 20 lectures & 2 hours of content 24/7
  • Explore powerful analytics tools like forecasting, optimization, & monte carlo simulation
  • Dive into some of Excel’s advanced analytics tools
  • Use a variety of unique, real-world demos & case studies
  • Forecast stock prices & monthly temperatures
  • Build our own outlier detection tools
  • Solve complex optimization problems
  • Design Monte Carlo simulation models
  • Create reports using CUBE functions
NOTE: Software NOT included.

Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2007-2019 or Office 365 recommended
  • Designed for Windows users (some tools may not be available for Mac)

Course Outline

  • Getting Started
    • Course Structure & Outline - 1:41
    • DOWNLOAD: Course Resources
    • Setting Expectations - 1:45
    • Important Note for StackSkills Students
  • Analytics Tips
    • Introduction - 0:29
    • Quick Analysis Tools - 6:03
    • Scenario Manager - 7:55
    • Optimizing with Goal Seek - 6:33
    • Basic Forecasting - 11:09
    • Outlier Detection - 9:24
    • Automated Data Tables - 8:06
    • Power Query Tools - 10:41
    • Data Modeling 101 - 10:23
    • CUBE Functions - 16:21
    • Monte Carlo Simulation - 11:38
    • Advanced Optimization with Solver - 12:16
    • Analysis ToolPak (Preview) - 8:10
    • QUIZ: Analytics Tips
  • Wrapping Up
    • Resources & Next Steps
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
22

Excel Pro Tips: PivotTables

Explore & Analyze Your Data with Advanced PivotTable Tools and Techniques

By Maven Analytics | in Online Courses

This Excel Pro Tips: PivotTables course will be focusing on one of Excel's most powerful and flexible analytic tools—PivotTables. The 1-hour course will start with some common topics like slicers, table layouts, and field list options, then dive into more unique use cases like grouping values, enabling multiple filters, reviving source data from a cache, defining custom sort lists, and more. This course will help you work smarter and not harder. By the end of this course, you'll be ready to slice, dice, and filter your data like a PivotTable pro.

4.7/5 average rating: ★ ★ ★ ★

  • Access 22 lectures & 1 hour of content 24/7
  • Understand the use of Excel slicers, table layouts & field list options
  • Learn grouping values, enabling multiple filters, reviving source data from the cache, defining custom sort lists & more
  • Slice, dice & filter data like a PivotTable pro
  • Practice & master PivotTables techniques used by professionals
NOTE: Software NOT included.

"Everything you need to get started using Excel pivot tables (a few pivot charts as well). The amount of content and pacing was perfect for me. The real gem is the last session where you use what you learned. " – Craig Day
Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2007-2019 or Office 365 recommended
  • Designed for Windows users (some tools may not be available for Mac)

Course Outline

  • Getting Started
    • Course Structure & Outline - 1:41
    • DOWNLOAD: Course Resources
    • Setting Expectations - 1:45
    • Important Note for StackSkills Students
  • PivotTable Tips
    • Introduction - 0:18
    • Customizing the Field List - 4:07
    • Autofitting Column Width - 4:21
    • Outline & Tabular Layouts - 7:46
    • Counting Non-Numerical Fields - 6:05
    • Grouping Dates - 8:03
    • Enabling Multiple Filters - 5:00
    • Grouping Values - 6:50
    • Adding Value Calculations - 9:01
    • Showing Empty Items - 6:22
    • Configuring Slicers & Timelines - 10:23
    • Conditional Formatting - 8:23
    • Removing & Reviving Source Data - 8:19
    • Adding Custom Sort Lists - 5:23
    • Solve Order & List Formulas - 6:16
    • QUIZ: PivotTable Tips
  • Wrapping Up
    • Resources & Next Steps
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
20

Excel Pro Tips: Data Visualization

Think Outside the Pie Chart & Explore Some of Excel’s Most Powerful Visualization Tools

By Maven Analytics | in Online Courses

This Excel Data Visualization course is all about bringing data to life, using some of Excel's most powerful visualization tools. The 18 lectures of this course won't be talking about your basic pie charts and line graphs. Instead, you will be introduced to Excel's unique features like filled maps, sparklines, custom templates, dynamic visuals, interactive form controls, and much more. This course is for you if you want to create clear and effective charts and graphs and interactive reports and dashboards.

4.7/5 average rating: ★ ★ ★ ★

  • Access 20 lectures & 1 hour of content 24/7
  • Explore Excel's most powerful visualization tools
  • Know about Excel's unique features like filled maps, sparklines, custom templates. dynamic visuals, interactive form controls & more
  • Create clear & effective charts and graphs as well as interactive reports and dashboards
NOTE: Software NOT included.
Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2007-2019 or Office 365 recommended
  • Designed for Windows users (some tools may not be available for Mac)

Course Outline

  • Getting Started
    • Course Structure & Outline - 1:41
    • DOWNLOAD: Course Resources
    • Setting Expectations - 1:45
    • Important Note for StackSkills Students
  • Visualization Tips
    • Introduction - 0:24
    • Chart Properties (Move & Size) - 5:08
    • Hidden Chart Source Data - 2:43
    • Filled Maps (Excel 2016+) - 5:10
    • Customizing Charts to Tell a Story - 8:53
    • Adding Sparklines - 7:44
    • Custom Chart Templates - 6:06
    • Heat Maps with Color Scales - 7:11
    • Analyzing Distribution with Histograms - 9:28
    • Goal Pacing with Gauge Charts - 10:26
    • Highlighting Time Periods - 8:05
    • Dynamic Source Ranges - 12:08
    • Interactive Form Controls - 11:48
    • QUIZ: Visualization Tips
  • Wrapping Up
    • Resources & Next Steps
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
23

Excel Pro Tips: Formulas

Take Your Excel Formula Skills to the Next Level with Helpful Tips & Advanced Use Cases

By Maven Analytics | in Online Courses

This course is part of the Excel Pro tips series, designed to help everyday users develop expert-level skills by mastering the same tools and techniques used by top pros and Excel MVPs. In this course, you’ll sample some of Excel’s most powerful formula tools, including basic options like calculation modes, line breaks, and auditing tools, as well as more complex use cases like detecting duplicates, creating dynamic workbook links, randomizing lists, and configuring many-to-many lookups. It's time to start working smarter, not harder. So if you're ready to ramp up your formula skills and take your Excel analytics game to the next level, this is the course for you.

  • Access 23 lectures & 2 hours of content 24/7
  • Sample some of Excel’s most powerful formula tools including basic options like calculation modes, line breaks & auditing tools
  • Try Excel's more complex use cases like detecting duplicates, creating dynamic workbook links, randomizing lists, & configuring many-to-many lookups
  • Develop expert-level skills by mastering the same tools & techniques used by top pros and Excel MVPs
NOTE: Software NOT included.
Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel

Course Outline

  • Getting Started
    • Course Structure & Outline - 1:41
    • DOWNLOAD: Course Resources
    • Setting Expectations - 1:45
    • Important Note for StackSkills Students
  • Formula Tips
    • Introduction - 0:28
    • Manual vs. Automatic Calculation - 4:19
    • Formula Line Breaks - 4:05
    • Converting Units of Measurement - 5:50
    • Real-Time Tools with TODAY & NOW - 10:18
    • Formula Auditing Tools - 11:18
    • Pivot-Style Reports with Formulas - 8:37
    • Counting Words in a Cell - 7:24
    • Dependent Drop-Downs with INDIRECT - 8:28
    • Hyperlinking Between Worksheets - 8:13
    • "Fuzzy Match" Lookups - 7:15
    • Random Selection with OFFSET & RANDBETWEEN - 6:26
    • Combining INDEX & MATCH - 8:40
    • Matching Items Between Lists - 11:00
    • Counting Duplicates with SUMPRODUCT - 8:59
    • Many-to-Many Lookups - 9:53
    • QUIZ: Formula Tips
  • Wrapping Up
    • Resources & Next Steps
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
22

Excel Pro Tips: Formatting

Transform Excel Worksheets Into Clear & Polished Reports Using Powerful Formatting Tools

By Maven Analytics | in Online Courses

With every data collection and analysis project, it is a must that your data is not just accurate but also clearly presented. This Excel Pro Tips: Formatting course will be focusing on Excel formats. More than cell fill and font colors, this course will teach you how to turn your plain old spreadsheets into downright beautiful and functional works of art. You’ll practice freezing panes, hiding text, defining formula-driven rules, creating advanced custom number formats, and much more. If you're ready to bring your workbooks to life and take your formatting game to the next level, this is the course for you.

4.6/5 average rating: ★ ★ ★ ★

  • Access 22 lectures & 1 hour of content 24/7
  • Learn to create clean & polished worksheets
  • Turn plain spreadsheets into beautiful & functional works of art
  • Practice freezing panes, hiding text, defining formula-driven rules, creating advanced custom number formats & much more
NOTE: Software NOT included.
Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2007-2019 or Office 365 recommended
  • Designed for Windows users (some tools may not be available for Mac)

Course Outline

  • Getting Started
    • Course Structure & Outline - 1:41
    • DOWNLOAD: Course Resources
    • Setting Expectations - 1:45
    • Important Note for StackSkills Students
  • Formatting Tips
    • Introduction - 0:26
    • Formatting Shortcuts - 4:28
    • Snap to Grid - 4:30
    • Hiding Workbook Elements - 4:03
    • Format Painter - 6:41
    • Color & Border Design - 7:03
    • Freezing Panes - 5:58
    • Center Across Selection - 4:33
    • Invisible Text Formatting - 3:55
    • Zip Codes & Phone Numbers - 5:09
    • Grouping Columns & Rows - 6:25
    • Formatting Errors with IFERROR - 5:50
    • Converting Text to Date Values - 10:39
    • Formula-Based Formats - 10:41
    • Advanced Number Formats - 10:37
    • QUIZ: Formatting Tips
  • Wrapping Up
    • Resources & Next Steps
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
23

Excel Pro Tips: Productivity Tools

Save Time & Get More Done with Excel's Most Powerful Productivity Tools

By Maven Analytics | in Online Courses

The Excel Pro Tips: Productivity Tools course will improve your current productivity. This 2-hour course will cover various topics to help you save time and work more efficiently, including keyboard shortcuts, autofill and flash fill, data validation, cell protection, named ranges, multi-level sorting, advanced filters, and much more. By the end of this course, you'll be ready to supercharge your productivity and absolutely revolutionize your Excel workflow.

4.6/5 average rating: ★ ★ ★ ★

  • Access 23 lectures & 1 hour of content 24/7
  • Learn & practice Excel's productivity tools using keyboard shortcuts, autofill & flash fill, and data validation
  • Easily sort your data using cell protection, named ranges, multi-level storing, advanced filters & more
  • Supercharge your productivity & improve your Excel workflow
NOTE: Software NOT included.

Maven Analytics

4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here
Requirements
  • Microsoft Excel 2007-2019 or Office 365
  • Basic knowledge with Excel Formulas & Functions

Course Outline

  • Getting Started
    • Course Structure & Outline - 1:41
    • DOWNLOAD: Course Resources
    • Setting Expectations - 1:45
    • Important Note for StackSkills Students
  • Productivity Tips
    • Introduction - 0:29
    • Customizing the Footer - 4:03
    • CTRL Shortcuts - 8:01
    • ALT Key Tips - 6:53
    • "Go To" Special Options - 4:36
    • Removing Blank Rows - 3:17
    • Data Validation Drop-Downs - 7:11
    • Autofill & Flash Fill - 8:26
    • Customizing the Ribbon - 6:53
    • Splitting Text to Columns - 7:39
    • Synchronous Scrolling - 2:58
    • Extracting Unique Values - 4:06
    • Named Range & Table References - 8:12
    • Protecting Cells & Formulas - 8:09
    • Multi-Level Row & Column Sorting - 10:54
    • Advanced Filter Criteria - 9:27
    • QUIZ: Productivity Tips
  • Wrapping Up
    • Resources & Next Steps
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
7.0 hours
Lessons
91

Microsoft Excel: Intro to Power Query, Power Pivot & DAX

Get Up & Running with Excel's Data Modeling & Business Intelligence Tools

By Maven Analytics | in Online Courses

This course will introduce you to Microsoft Excel's powerful data modeling and business tools Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and supercharge your analytics, then this is the A-Z guide that you're looking for. You'll be introduced to the "Power Excel" landscape and explore what these Excel tools are all about and why they are changing the world of self-service business intelligence. Also, you'll walk through the Excel BI workflow and build an entire Excel data model from scratch.

4.7/5 average rating: ★ ★ ★ ★

  • Access 91 lectures & 7 hours of content 24/7
  • Use sample data from a fictional supermarket chain to get hands-on w/ Power Query
  • Practice shaping, blending, & exploring project files
  • Cover the fundamentals of database design & normalization
  • Explore & analyze your data model using Power Pivot & DAX
  • Cover basic DAX syntax & learn some of the most powerful and commonly used functions
NOTE: Software NOT included.
Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
  • Basic knowledge with Excel PivotTables, Formulas & Functions

Course Outline

  • Getting Started
    • Course Structure & Outline - 1:22
    • IMPORTANT: Versions & Compatibility - 3:15
    • DOWNLOAD: Course Resources - 1:16
    • Setting Expectations - 1:53
    • Important Note for StackSkills Students
  • Intro to "Power Excel"
    • The "Power Excel" Workflow - 3:50
    • "Best Thing to Happen to Excel in 20 Years" - 8:18
    • When to use Power Query & Power Pivot - 0:44
    • QUIZ: Intro to "Power Excel"
    • HOMEWORK: Intro to "Power Excel"
  • Connecting & Shaping Data with Power Query
    • Introduction - 0:27
    • Meet Power Query (aka "Get & Transform") - 2:40
    • The Query Editor - 3:17
    • Data Loading Options - 1:40
    • IMPORTANT: Regional Formatting
    • Basic Table Transformations - 8:06
    • Text-Specific Tools - 10:17
    • Number-Specific Tools - 7:41
    • Date-Specific Tools - 7:39
    • PRO TIP: Creating a Rolling Calendar - 5:02
    • Adding Index & Conditional Columns - 7:44
    • Grouping & Aggregating Data - 7:10
    • Pivoting & Unpivoting - 8:52
    • Modifying Workbook Queries - 4:18
    • Merging Queries - 7:43
    • Appending Queries - 5:49
    • Connecting to a Folder of Files - 9:32
    • Power Query Best Practices - 2:44
    • QUIZ: Power Query
    • HOMEWORK: Power Query
  • Data Modeling & Normalization
    • Introduction - 0:28
    • Meet Excel's "Data Model" - 3:38
    • Data vs. Diagram View - 2:33
    • Database Normalization - 4:14
    • Data Tables vs. Lookup Tables - 5:40
    • Relationships vs. Merged Tables - 2:07
    • Creating Table Relationships - 6:54
    • Modifying Table Relationships - 2:06
    • Active vs. Inactive Relationships - 3:55
    • Relationship Cardinality - 5:46
    • Connecting Multiple Data Tables - 5:59
    • Filter Direction - 5:08
    • Hiding Fields from Client Tools - 4:59
    • Defining Hierarchies - 3:53
    • Data Model Best Practices - 1:38
    • QUIZ: Data Modeling 101
    • HOMEWORK: Data Modeling 101
  • Power Pivot & DAX 101
    • Introduction - 0:29
    • Creating a "Power" PivotTable - 5:27
    • "Power" Pivots vs. "Normal" Pivots - 2:48
    • Intro to Data Analysis Expressions (DAX) - 1:12
    • Calculated Columns - 8:39
    • DAX Measures = Supercharged Calculated Fields - 2:24
    • Creating Implicit Measures - 1:59
    • Creating Explicit Measures (AutoSum) - 7:08
    • Creating Explicit Measures (Power Pivot) - 7:42
    • Understanding Filter Context - 9:18
    • Step-by-Step Measure Calculation - 12:06
    • RECAP: Calculated Columns vs. Measures - 2:29
    • Power Pivot Best Practices - 1:50
    • QUIZ: Power Pivot & DAX 101
    • HOMEWORK: Power Pivot & DAX 101
  • Common DAX Functions
    • Introduction - 0:27
    • DAX Formula Syntax & Operators - 4:05
    • Common DAX Function Categories - 3:54
    • Basic Math & Stats Functions - 12:45
    • COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS - 10:35
    • HOMEWORK: Math & Stats Functions
    • Logical Functions (IF/AND/OR) - 16:49
    • SWITCH & SWITCH(TRUE) - 10:33
    • Text Functions - 10:53
    • HOMEWORK: Logical & Text Functions
    • The CALCULATE Function - 14:39
    • Adding Filter Context with FILTER (Part 1) - 9:20
    • Adding Filter Context with FILTER (Part 2) - 14:23
    • Removing Filter Context with ALL - 9:06
    • HOMEWORK: CALCULATE, FILTER & ALL
    • Joining Data with RELATED - 3:39
    • Iterator ("X") Functions: SUMX - 12:20
    • Iterator ("X") Functions: RANKX - 5:33
    • HOMEWORK: Iterator Functions
    • Basic Date & Time Functions - 4:58
    • Time Intelligence Formulas - 17:02
    • HOMEWORK: Time Intelligence
    • Speed & Performance Considerations - 3:02
    • DAX Best Practices - 2:03
    • QUIZ: Common DAX Functions
  • Wrapping Up
    • Introduction - 0:53
    • Data Visualization Options - 4:35
    • SNEAK PEEK: PowerBI - 5:55
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
5.0 hours
Lessons
86

Microsoft Excel: Data Analysis with Pivot Tables

Master Excel Pivot Tables & Pivot Charts with Hands-On Demos

By Maven Analytics | in Online Courses

Pivot Tables are an essential tool for anyone who works with data in Excel. Pivots allow you to quickly explore and analyze raw data, revealing powerful insights and trends otherwise buried in the noise. In other words, they give you answers. So whether you're exploring product sales, analyzing marketing tactics, or wonder how Boston condo prices have trended over the past 15 years, Excel Pivot Tables provide fast, accurate, and intuitive solutions to even the most complicated questions. This course will give you a deep, 100% comprehensive understanding of Pivot Tables and Pivot Charts.

4.6/5 average rating: ★ ★ ★ ★

  • Access 85 lectures & 5 hours of content 24/7
  • Cover raw data structure, table layouts & styles
  • Explore design & formatting options
  • Understand sorting, filtering, & grouping tools
  • Anaylze data from a number of real-world case studies including San Diego burrito ratings, shark attack records, MLB team statistics, & more
NOTE: Software NOT included.
Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2010-2019 or Office 365
  • Basic knowledge with Excel functionality

Course Outline

  • Getting Started
    • Course Structure & Outline - 1:32
    • Getting to Know the IMDb Movie Database - 2:21
    • Setting Expectations - 1:14
    • Important Note for StackSkills Students
  • PivotTable 101
    • Why PivotTables? - 4:10
    • Structuring the Source Data - 2:00
    • Inserting Your First PivotTable - 3:13
    • Navigating the Field List - 7:43
    • Analyze & Design Options - 1:33
    • Selecting, Clearing, Moving & Copying Pivots - 5:14
    • Refreshing & Updating Pivots - 7:30
    • PRO TIP: Dealing with Growing Source Data - 6:49
    • Removing & Reviving Data from Cache - 5:41
    • How PivotTables ACTUALLY Work - 3:39
    • QUIZ: PivotTable 101
    • HOMEWORK: PivotTable 101
  • PivotTable Formatting
    • Number Formatting - 2:12
    • PRO TIP: Formatting Empty Cells - 1:41
    • Table Layouts & Styles - 5:30
    • PRO TIP: Using Tabular Layouts to Create New Tables - 2:20
    • Customizing Headers & Labels - 1:16
    • Adding Conditional Formats - 6:51
    • PRO TIP: Data Bars with Invisible Text - 2:13
    • Advanced Conditional Formatting - 6:51
    • QUIZ: PivotTable Formatting
    • HOMEWORK: PivotTable Formatting
  • Sorting, Filtering & Grouping
    • Basic Sorting Options - 5:01
    • PRO TIP: Incorrect Alphabetical Sorting - 2:01
    • Label Filters & Manual Selections - 8:15
    • PRO TIP: Label Filters with Wildcards - 3:15
    • Value Filters - 3:10
    • PRO TIP: Enabling Multiple Filters - 2:42
    • Grouping Data - 3:23
    • Automatic Date Grouping - 4:25
    • Filtering with Slicers & Timelines - 4:51
    • Breaking Out Report Filter Pages - 4:13
    • QUIZ: Sorting, Filtering & Grouping
    • HOMEWORK: Sorting, Filtering & Grouping
  • Calculated Values & Fields
    • Summarizing Values - 4:45
    • PRO TIP: Avoiding the "Count Of" Trap - 3:49
    • "Show Values As" Calculations - 3:35
    • Show Values As: % of Column/Row - 3:47
    • Show Values As: % of Parent - 3:02
    • Show Values As: Difference From - 4:41
    • Show Values As: Running Total - 2:44
    • Show Values As: Rank - 2:36
    • Show Values As: Index - 8:06
    • Inserting Calculated Fields - 6:30
    • Calculations in Pivots vs. Raw Data - 4:32
    • Calculating Using Counts (Part 1) - 7:20
    • Calculating Using Counts (Part 2) - 4:19
    • Calculated Items (NOT RECOMMENDED) - 6:11
    • Solve Order & List Formula Tools - 4:54
    • QUIZ: Calculated Values & Fields
    • HOMEWORK: Calculated Values & Fields
  • Data Visualization with Pivot Charts
    • Intro to PivotCharts - 2:26
    • DEMO: Column Chart - 4:13
    • DEMO: Pie & Donut Charts - 5:46
    • DEMO: Clustered Bar Chart - 3:25
    • PRO TIP: Prevent Charts from Resizing with Cells - 4:45
    • Changing Chart Types on the Fly - 3:18
    • DEMO: Stacked Area Chart - 5:46
    • PivotChart Layouts & Styles - 4:03
    • Moving PivotCharts to New Sheets - 2:09
    • Applying Slicers & Timelines to Multiple Charts - 5:01
    • DEMO: Building a Dynamic Dashboard - 13:22
    • QUIZ: PivotCharts
    • HOMEWORK: PivotCharts
  • PivotTable Case Studies
    • Setting Expectations - 1:45
    • U.S. Voters (2012) - 10:33
    • HOMEWORK: U.S. Voters (2012)
    • San Francisco Salaries - 13:06
    • HOMEWORK: San Francisco Salaries
    • Shark Attack Records - 10:31
    • HOMEWORK: Shark Attack Records
    • Stock Market Data - 12:25
    • HOMEWORK: Stock Market Data
    • Baseball Team Statistics - 14:16
    • HOMEWORK: Baseball Team Statistics
    • San Diego Burrito Ratings - 16:40
    • HOMEWORK: San Diego Burrito Ratings
    • Daily Weather Conditions - 12:41
    • HOMEWORK: Daily Weather Conditions
    • Spartan Race Facebook Posts - 14:37
    • HOMEWORK: Spartan Race Facebook Posts
  • Wrapping Up
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
62

Microsoft Excel: Data Visualization with Charts & Graphs

Master 20+ Charts & Graphs in Excel with Hands-On Demos

By Maven Analytics | in Online Courses

Ask people what comes to mind when they think of Excel, and odds are they'll say, "spreadsheets." However, Excel is an incredibly powerful, robust, and dynamic data visualization platform. This course will give you a deep, comprehensive understanding of Excel's latest data visualization tools and techniques. You'll learn when, why, and how to use each chart type, discover key data visualization best practices, and learn through interactive, hands-on demos and exercises every step of the way.

4.6/5 average rating: ★ ★ ★ ★

  • Access 62 lectures & 4 hours of content 24/7
  • Understand when, why & how to use 20+ chart types in Excel
  • Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, & more
  • Master unique tips, tools, and case studies that you won't find in any other Excel course
  • Build 10+ Excel projects designed to take your data visualization skills to the next level
NOTE: Software NOT included.
Maven Analytics
4.6/5 Instructor Rating: ★ ★ ★ ★

Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training.

Chris Dutton
4.6/5 Instructor Rating: ★ ★ ★ ★

Chris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization. He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016+ or Office 365

Course Outline

  • Getting Started
    • Course Structure & Outline - 1:27
    • Bonus Homework Exercises
    • Setting Expectations - 2:02
    • Important Note for StackSkills Students
  • Data Visualization Best Practices
    • Key Principles & The 10-Second Rule - 2:45
    • The Good, The Bad & The Ugly - 3:44
    • Three Key Questions - 1:49
  • Chart Formatting & Customization
    • Chart Elements, Layouts & Styles - 6:20
    • Chart Formatting Options - 5:26
    • Changing Chart Types & Adding a Secondary Axis - 3:03
    • Creating, Modifying & Applying Custom Templates - 4:06
    • QUIZ: Chart Customization
  • Mastering Basic Charts & Graphs
    • Bar & Column Charts - 8:49
    • HOMEWORK: Bar & Column Charts
    • Histogram & Pareto Charts - 5:58
    • HOMEWORK: Histogram & Pareto Charts
    • Line Charts & Trendlines - 5:16
    • HOMEWORK: Line Charts & Trendlines
    • Area Charts - 4:41
    • HOMEWORK: Area Charts
    • Pies, Donuts & Race Tracks - 12:04
    • HOMEWORK: Pies, Donuts & Race Tracks
    • Scatter Plots - 7:30
    • Bubble Charts - 6:36
    • HOMEWORK: Scatter Plots & Bubble Charts
    • Box & Whisker Charts - 6:05
    • HOMEWORK: Box & Whisker Charts
    • Tree Maps & Sunbursts - 6:36
    • HOMEWORK: Tree Maps & Sunbursts
    • Waterfall Charts - 3:17
    • Funnel Charts - 3:42
    • HOMEWORK: Waterfall & Funnel Charts
    • Radar Charts - 7:56
    • HOMEWORK: Radar Charts
    • Stock Charts - 7:18
    • HOMEWORK: Stock Charts
    • Heat Maps - 4:41
    • HOMEWORK: Heat Maps
    • Surface & Contour Charts - 7:35
    • HOMEWORK: Surface & Contour Charts
    • Geospatial Maps with Power Map - 5:28
    • HOMEWORK: Power Map
    • Basic Combo Charts - 7:57
    • HOMEWORK: Combo Charts
    • Sparklines - 2:07
    • HOMEWORK: Sparklines
    • QUIZ: Basic Charts & Graphs
  • Next-Level Data Viz Demos
    • Setting Expectations - 1:40
    • DEMO: Custom Image Overlay Charts - 6:01
    • DEMO: Adding Binary Values to Highlight Ranges - 5:02
    • DEMO: Automation with OFFSET & COUNTA - 7:08
    • DEMO: Adding Interactive Elements with Form Controls - 12:30
    • DEMO: Animating Changes Over Time - 14:20
    • DEMO: Building a Dynamic Dashboard (Part 1) - 16:10
    • DEMO: Building a Dynamic Dashboard (Part 2) - 12:08
    • DEMO: Dynamic Value-Based Formatting - 10:09
    • DEMO: Dynamically Highlighting a Data Series - 10:26
    • DEMO: Building a Custom Pacing Chart - 10:22
    • DEMO: Building a Custom Gauge Chart - 9:58
    • DEMO: Visualizing Percentages with Arrays - 7:16
    • QUIZ: Next-Level Data Viz
  • Wrapping Up
    • More from Maven Analytics

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
85

Advanced Excel Dashboards & Data Visualization Master Class

Learn Advanced Skills To Create Excel Dashboards & Data Visualizations

By Jordan Goldmeier | in Online Courses

In this course, you will take a quick dive into concepts such as Array Formulas and formula-driven developments. As you progress, you will see how each module builds from top to bottom. Also, you will be exposed to often overlooked features such as Excel's form controls, which can drive tremendous interactivity. At the same time, you will run through the rules of data visualization, making sure that what you build communicates its message. By the end of this course, you won't just be good at data visualization and dashboards, but also, you will become a master Excel builder.

4.3/5 average rating: ★ ★ ★ ★

  • Access 85 lectures & 6 hours of content 24/7
  • Learn advanced skills to create dashboards & data visualizations in Excel
  • Quickly create dashboards, reports & interactive applications without macros
  • Use Microsoft Excel with confidence
  • Get downloadable Excel workbooks to practice on
  • Attain personal Excel support from professional Excel trainers
  • Become expert at creating interactive analysis
  • Be more productive at using Microsoft Excel
  • Increase your Microsoft Excel skills & knowledge within hours
  • Test your skills with different real life quizzes, homework, practice activities, & assignments
NOTE: Software NOT included.
Jordan Goldmeier | Chief Data Anarchist
4.3/5 Instructor Rating: ★ ★ ★ ★

Jordan Goldmeier is an internationally recognized analytics professional and data visualization expert, author and speaker. A former chief operations officer at Excel.TV, he has spent years in the data training trenches. He is the author of Advanced Excel Essentials and Dashboards for Excel, and currently working on this 3rd book, Becoming a Data Head (Wiley, 2021), on helping managers communicate, challenge, and understand data science with a common language and expectation.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Certificate of completion included
  • Experience level required: advanced
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Excel for Windows 2010, 2013, 2016, 2019
  • Office 365
  • Excel for Mac 2011 and 2016

Course Outline

  • 1 - Introduction
    • 1.1 Introduction - 0:49
    • 1.2 Why Even Use Excel? - 7:35
    • 1.3 Why Dashboards + Datavis? - 5:23
    • 1.4 Interactive Dashboards in Excel - 10:19
    • 1.5 Quiz
  • 2 - Thinking Outside the Cell
    • 2.1 Thinking Outside the Cell - 6:47
    • 2.2 Why develop differently - 3:40
    • 2.3 Inserting the camera tool - 2:57
    • 2.4 How to use the camera tool - 7:54
    • 2.5 Development Principles - 12:49
    • 2.6 Quiz
  • 3 - Working with Formulas
    • 3.1 Formula Editing Tips - 11:52
    • 3.2 Excel Calculation Engine - 9:08
    • 3.3 Writing Better Formulas - 11:10
    • 3.6 Quiz
  • 4 - Advanced Formulas for Dashboards & Decisions
    • 4.1 Lookup Functions - 2:44
    • 4.2 How to use VLOOKUP - 3:24
    • 4.3 How to use INDEX/MATCH - 6:28
    • 4.4 Combining formulas - 4:24
    • 4.5 How to use Array Formulas - 2:49
    • 4.6 Array Formulas Demo - 20:44
    • 4.7 Section Review - 2:20
    • 4.8 Quiz
    • 4.9 Practice
  • 5 - Excel Tables are the Best!
    • 5.1 Introduction to Excel Tables - 3:43
    • 5.2 Inserting a New Excel Table - 8:35
    • 5.3 Working with Tables - 7:29
    • 5.4 Excel Tables Demo - 4:34
    • 5.5 Rules for using Excel Tables - 2:35
    • 5.6 Quiz
    • 5.7 Practice
  • 6 - Sorting and Decision Functions
    • 6.1 Introduction to Sorting Functions - 19:20
    • 6.2 Creating Filters with SUMPRODUCT - 1:38
    • 6.3 Filtering on Excel Tables - 17:26
    • 6.4 Data Aggregation - 13:26
    • 6.5 Section Summary - 2:12
    • 6.6 Quiz
    • 6.7 Practice
  • 7 - Form Controls for Interactivity
    • 7.1 The DEVELOPER Tab - 1:32
    • 7.2 Excel Form Controls - 3:44
    • 7.3 Form Controls Demo - 14:55
    • 7.4 Form Control Basics - 1:59
    • 7.5 Creating a Scrollable Table - 7:26
    • 7.6 Quiz
    • 7.7 Practice
  • 8 - Formula-driven Development
    • 8.1 Introduction to Formula-driven Development - 29:11
    • 8.2 The Information-Transformation-Presentation Dynamic - 5:06
    • 8.3 Quiz
  • 9 - Creating an Interactive Legend Dashboard
    • 9.1 Section Introduction - 1:50
    • 9.2 Creating an Interactive Legend - 7:18
    • 9.3 Perfecting the Interactive Legend - 16:50
    • 9.4 Maintaining the Interactive Legend - 3:11
    • 9.5 Practice
  • 10 - Creating an Interactive Chart Dashboard
    • 10.1 Section Introduction - 0:38
    • 10.2 Setting up an Interactive Chart - 6:56
    • 10.3 Formatting the Interactive Chart - 5:04
    • 10.4 Maintaining the Interactive Chart - 2:51
    • 10.5 Practice
  • 11 - Interactive Tornado Dashboard with Drill Downs
    • 11.1 Section Introduction - 0:41
    • 11.2 Setting up the Interactive Dashboard - 15:27
    • 11.3 Formatting the Interactive Dashboard - 1:49
    • 11.4 Maintaining the Interactive Dashboard - 2:58
    • 11.5 Practice 1
    • 11.6 Practice 2
  • 12 - Data Visualization
    • 12.1 Introduction to Visual Perception - 8:22
    • 12.2 The Gestalt Laws of Grouping - 4:37
    • 12.3 Preattentive Attributes - 2:34
    • 12.4 The Problem with Pie Charts - 1:45
    • 12.5 Introduction to Infographics - 2:01
    • 12.6 Quiz
  • 13 - Special Charts
    • 13.1 Expanding the Chart Library - 0:26
    • 13.2 Dual Axis Band Chart - 4:21
    • 13.3 Shaded Area Banded Chart - 4:31
    • 13.4 Limit and Control Charts - 3:11
  • 14 - Bullet Charts
    • 14.1 Introduction to Bullet Charts in Excel - 1:28
    • 14.2 Bullet Chart Demo - 7:00
    • 14.3 Horizontal Bullet Chart Trick - 4:03
    • 14.4 Practice
  • 15 - Infographics in Excel
    • 15.1 Introduction to Infographics in Excel - 1:17
    • 15.2 Progress Meter Chart - 8:44
    • 15.3 Donut Chart - 6:01
    • 15.4 "Waffle" Chart - 5:58
    • 15.5 Bringing it all together with the CAMERA - 2:13
    • 15.6 Practice
  • 16 - Conclusion
    • Continue Learning! - 2:38

View Full Curriculum



Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.