ExcelIsFun Courses

Excel Statistical Analysis - Introduction to Probability, Power Query & Pivot Table Example

Aprenda os fundamentos de probabilidade em Excel, incluindo experimentos aleatórios, espaço amostral, combinações e permutações. Aplique conceitos em exemplos práticos de negócios usando Power Query e Tabelas Dinâmicas.

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

Excel Statistical Analysis - 5-Number Summary - Box & Whiskers Chart - Power Query & Array Formulas

Aprenda a criar análises estatísticas avançadas no Excel usando Power Query, fórmulas de matriz e gráficos Box & Whiskers para visualizar e interpretar conjuntos de dados complexos.

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

Excel Statistical Analysis - Range, Variance, Standard Deviation, Coefficient of Variation

Master Excel's statistical analysis tools for calculating range, variance, standard deviation, and coefficient of variation. Apply these measures to make informed business decisions and interpret financial data.

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

Excel Statistical Analysis - Location, Mean, Median, Mode, Moving Average, Skew & More

Comprehensive guide to Excel statistical analysis, covering mean, median, mode, moving averages, and skew. Includes practical examples using Power Query, PivotTables, and dynamic arrays for data visualization and interpretation.

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

Excel Statistical Analysis - Cross Tabulation, Visualizations, and Logical Tests, Simpson’s Paradox

Master cross tabulation, visualizations, and logical tests in Excel. Learn to create insightful reports, understand Simpson's Paradox, and effectively analyze data relationships using PivotTables and charts.

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

Excel Statistical Analysis - Frequency Distributions, Visualizations & Skew for Quantitative Data

Master frequency distributions and data visualizations in Excel, including column charts, histograms, and line charts. Learn to analyze discrete and continuous data, handle time series, and interpret skew in distributions.

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

Excel Statistical Analysis - Frequency Distributions & Visualizations for Categorical Data

Learn to create frequency distributions and visualize categorical data using Excel. Master PivotTables, column/bar charts, and advanced techniques for effective data presentation and analysis.

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

Excel Statistical Analysis - PivotTable & Power Query to Build Frequency Distributions

Master PivotTables and Power Query for creating frequency distributions from various data types. Learn efficient techniques for data import, transformation, and analysis in Excel.

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

Excel Statistical Analysis - Comprehensive Worksheet Formula & Model Building

Master Excel formulas and model building, from basic elements to advanced techniques like Dynamic Spilled Array Formulas. Learn efficient methods for data analysis and presentation in Microsoft 365 Excel.

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

Big Data Analysis with Power Pivot & Power BI - Visuals & DAX Formulas

Master advanced data analysis techniques using Power Pivot and Power BI, including data modeling, DAX formulas, and creating interactive visualizations for effective business insights.

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

Excel Data Analysis - Power BI Desktop, DAX Formulas, Relationships, Data Modeling & Visuals

Comprehensive guide to Power BI Desktop: data import, DAX formulas, relationships, modeling, and visualizations. Learn to create powerful reports and dashboards for advanced Excel data analysis.

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

Excel Data Analysis - Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More

Master Power Pivot and DAX formulas for advanced Excel data analysis. Learn data modeling, relationships, and visualization techniques to create powerful reports and dashboards.

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

Excel Data Analysis - PivotTables, Power Query, Formulas and Charts

Learn essential Excel data analysis techniques using PivotTables, Power Query, formulas, and charts. Master importing data, creating reports, and visualizing trends for effective business insights.

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

Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples

Comprehensive guide to Excel's XLOOKUP function, covering 27 examples from basic usage to advanced techniques like dynamic column retrieval and array formulas.

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

Running Total in Column - Power Query, DAX or Worksheet Formula?

Learn to create running totals in Excel using worksheet formulas, Power Query, and DAX. Master expandable ranges and cumulative calculations for overall and monthly totals.

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