ExcelIsFun Courses

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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Free Video

Two Fact Tables - DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table

Learn techniques to convert two fact tables into one using Excel formulas, DAX in Power Pivot, and Power Query in Power BI. Master data modeling and analysis skills for improved business reporting and decision-making.

• YouTube
• 1 hour 5 minutes
• On-Demand
• Free Video

Power Query - Reduce Data Model Size, Transformations to Columnar Database Size

Learn strategies to optimize data model size using Power Query transformations, enhancing efficiency for big data analysis and business intelligence with columnar databases.

• YouTube
• 25 minutes
• On-Demand
• Free Video

Power Pivot - Big Data, Data Modeling, DAX & Dashboards

Aprenda a modelar dados, criar fórmulas DAX e construir dashboards usando Power Pivot. Importe dados SQL, crie tabelas de datas e explore recursos avançados para análise de negócios eficiente no Excel.

• YouTube
• 45 minutes
• On-Demand
• Free Video