Excel Statistical Analysis 22: Bayes’ Theorem, Tabular Method, Probability Tree, SUMPRODUCT function

Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm
Learn about 6 different methods for calculating probabilities using Bayes Theorem.
Topics:
1. (00:00) Introduction
2. (00:16) Introduction to Baye’s Theorem with a CPA Test Score Example
3. (03:17) Probabilities from Table of Data using Worksheet Formulas and Continue reading “Excel Statistical Analysis 22: Bayes’ Theorem, Tabular Method, Probability Tree, SUMPRODUCT function”

REPLAY Power BI tips from the Pros – LIVE (Feb 26, 2022)

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment Continue reading “REPLAY Power BI tips from the Pros – LIVE (Feb 26, 2022)”

Excel Statistical Analysis 21: Multiplication Law of Probability, AND Logical Test, Probability Tree

Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm
Learn about the Multiplication Law of Probability to calculate AND Logical Test Probabilities. Learn how to build a probability tree too.
Topics:
1. (00:00) Introduction
2. (00:17) Look back at Conditional Formatting Probability Rule and how it Continue reading “Excel Statistical Analysis 21: Multiplication Law of Probability, AND Logical Test, Probability Tree”

Deneb 1.1: New Features and Language Updates | Enterprise Analytics Summit Session 18

EVENT DETAILS – https://enterprisedna.co/enterprise-analytics-summit-february-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/enterprise-analytics-summit-free

Session 18: Deneb 1.1: New Features and Language Updates

When is it?
February 24th – 1pm New York (EDT), 4pm New York (EDT), 9pm London (GMT)
February 25th – 8am Sydney Continue reading “Deneb 1.1: New Features and Language Updates | Enterprise Analytics Summit Session 18”

Power Automate Desktop | Enterprise Analytics Summit Session 19

EVENT DETAILS – https://enterprisedna.co/enterprise-analytics-summit-february-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/enterprise-analytics-summit-free

Session 19: Power Automate Desktop

When is it?
February 24th – 2pm Los Angeles (PDT), 5pm New York (EDT), 10am London (GMT)
February 25th – 9am Sydney (AEDT), 11am Auckland Continue reading “Power Automate Desktop | Enterprise Analytics Summit Session 19”

Visualization Magic In The Age Of Numbers & Science | Enterprise Analytics Summit Session 20

EVENT DETAILS – https://enterprisedna.co/enterprise-analytics-summit-february-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/enterprise-analytics-summit-free

Session 20: Visualization Magic in the Age of Numbers & Science

When is it?
February 24th – 4pm Los Angeles (PDT), 7pm New York (EDT)
February 25th – 12am London (GMT), Continue reading “Visualization Magic In The Age Of Numbers & Science | Enterprise Analytics Summit Session 20”

Challenge Submission Reviews – Learn From The Best | Enterprise Analytics Summit Session 21

EVENT DETAILS – https://enterprisedna.co/enterprise-analytics-summit-february-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/enterprise-analytics-summit-free

Session 21: Challenge Submission Reviews – Learn from the Best

When is it?
February 24th – 6pm Los Angeles (PDT), 9pm New York (EDT)
February 25th – 2am London (GMT), 1pm Continue reading “Challenge Submission Reviews – Learn From The Best | Enterprise Analytics Summit Session 21”

Event Wrap Up, Prizes and Giveaways | Enterprise Analytics Summit 2022

Congratulations to all the winners of this summit!

Again, thank you everyone who joined and participated. See you on our future events!

List of winners here – https://enterprisedna.co/enterprise-analytics-summit-february-2022-live/#winners

If you have questions regarding this training, please send it to <a Continue reading “Event Wrap Up, Prizes and Giveaways | Enterprise Analytics Summit 2022”

Excel Statistical Analysis 20: Joint Probability Table: Dynamic Spilled Array or PivotTable?

Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm
Learn what a Joint Probability Table is and how to create them with a PivotTable and Dynamic Spilled Array Formulas.
Topics:
1. (00:00) Introduction
2. (00:29) What is a Joint Probability Table
3. (01:58) Create Joint Probability Table Continue reading “Excel Statistical Analysis 20: Joint Probability Table: Dynamic Spilled Array or PivotTable?”

Creative Report Development – Tips & Tricks | Enterprise Analytics Summit Session 16

EVENT DETAILS – https://enterprisedna.co/enterprise-analytics-summit-february-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/enterprise-analytics-summit-free

Session 16: Creative Report Development – Tips & Tricks

When is it?
February 24th – 2am Los Angeles (PDT), 5am New York (EDT), 10am London (GMT)
February 24th – 9pm Sydney Continue reading “Creative Report Development – Tips & Tricks | Enterprise Analytics Summit Session 16”