ExcelIsFun Courses

Fundamentals of DAX in Power BI & Power Pivot

Comprehensive tutorial on DAX fundamentals for Power BI and Power Pivot, covering key concepts, functions, and advanced techniques to enhance data analysis and reporting skills.

• YouTube
• 2 hours 26 minutes
• Self-Paced
• Free Video

Excel LAMBDA Function - Every Single Thing You Ever Wanted to Know

Comprehensive guide to Excel's LAMBDA function, covering creation of reusable functions, helper functions, recursion, and advanced reporting techniques for enhanced spreadsheet efficiency.

• YouTube
• 1 hour 45 minutes
• Self-Paced
• Free Video

Visualizing Data and Building Dashboards in Excel & Power BI

Comprehensive guide to data visualization and dashboard creation in Excel and Power BI, covering various chart types, PivotTables, Power Query, and advanced techniques for effective data presentation.

• YouTube
• 1 hour 42 minutes
• Self-Paced
• Free Video

Text Formulas & Functions in Excel Worksheet and Power Query

Comprehensive tutorial on Excel text functions and Power Query, covering formulas, data extraction, error handling, and data cleaning techniques for efficient spreadsheet management.

• YouTube
• 34 minutes
• Self-Paced
• Free Video

Date & Time Formulas & Functions in Excel Worksheet and Power Query

Aprenda fórmulas e funções avançadas de data e hora no Excel e Power Query, incluindo cálculos de dias úteis, atributos fiscais e manipulação de períodos para análises eficientes.

• YouTube
• 51 minutes
• Self-Paced
• Free Video

Excel & Power BI Data Analysis Complete Class in One Video

Comprehensive guide to data analysis using Excel and Power BI, covering essential tools and techniques for importing, transforming, visualizing, and sharing data effectively.

• YouTube
• 3 hours 44 minutes
• Self-Paced
• Free Video

Excel Worksheet Formulas & Models – Everything You Ever Wanted to Know

Comprehensive guide to Excel formulas, covering various types, editing modes, and practical applications through real-world models. Ideal for mastering advanced spreadsheet techniques.

• YouTube
• 1 hour 11 minutes
• Self-Paced
• Free Video

Excel Formulas & Functions, PivotTables, Slicers & Charts

Comprehensive guide to Excel's powerful features: formulas, functions, PivotTables, charts, and data analysis tools. Master essential skills for efficient spreadsheet management and insightful data visualization.

• YouTube
• 1 hour 14 minutes
• Self-Paced
• Free Video

Introduction to Microsoft 365 Excel and Conventions for Class

Learn essential Microsoft 365 Excel basics, including file management, interface navigation, keyboard shortcuts, formulas, and data alignment. Master fundamental concepts for efficient spreadsheet creation and analysis.

• YouTube
• 28 minutes
• Self-Paced
• Free Video

Linear Regression Made Easy - The Epic Full Story with All Details - Excel Statistical Analysis

Comprehensive guide to linear regression in Excel, covering key calculations, formulas, and visualizations. Learn to interpret data, make predictions, and understand statistical concepts through practical examples.

• YouTube
• 1 hour 12 minutes
• Self-Paced
• Free Video

Excel Statistical Analysis - Hypothesis Testing - P-Value & Critical Value Methods - 1 Tail Upper

Master hypothesis testing in Excel: learn 5-step process, P-value and Critical Value methods for one-tail upper tests. Practical example using realtor salary data enhances understanding of statistical concepts.

• YouTube
• 33 minutes
• Self-Paced
• Free Video

Excel Statistical Analysis - Learn Central Limit Theorem by Building Sampling Distribution of Xbar

Explore the Central Limit Theorem through practical Excel exercises, learning to build sampling distributions and apply statistical concepts for informed business decision-making.

• YouTube
• 50 minutes
• Self-Paced
• Free Video

Excel Statistical Analysis - Binomial Probability Distributions - BINOM.DIST.RANGE Function & Chart

Master binomial probability distributions in Excel using BINOM.DIST.RANGE function. Learn formulas, create charts, and analyze real-world scenarios to enhance your statistical analysis skills.

• YouTube
• 32 minutes
• Self-Paced
• Free Video

Excel Statistical Analysis - Build Discrete Probability Distributions with Worksheet Formulas

Learn to create discrete probability distributions using Excel formulas. Master expected value, standard deviation, charting, and applying these concepts to real-world business scenarios for data-driven decision-making.

• YouTube
• 29 minutes
• Self-Paced
• Free Video

Excel Statistical Analysis - AND, OR, and NOT Logical Tests for COUNTIFS & FILTER Functions

Master Excel's AND, OR, and NOT logical tests for COUNTIFS and FILTER functions. Learn to analyze data using Venn diagrams, mutually exclusive events, and probability concepts.

• YouTube
• 29 minutes
• Self-Paced
• Free Video