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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Excel for Accountants - PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts Seminar
Comprehensive Excel seminar for accountants covering essential functions, PivotTables, data analysis, and Power Query. Enhance your skills with practical examples and real-world applications.
DAX Formulas for Running Total and % of Running Total & Other DAX Tricks
Master advanced DAX formulas for running totals, percentages, and data modeling in Excel. Learn to create relationships, use functions like CALCULATE and FILTER, and handle regular and irregular increments.
Data Model & DAX Formulas - Quantity Frequency Distribution by Year & Country
Learn to create a Data Model with DAX formulas for PivotTable frequency distributions, including conditional formatting and big data handling in Excel.
Extract Records With Multiple Contains - Partial Text Criteria: 4 Examples
Learn advanced Excel techniques for extracting records with multiple contains criteria, using array formulas, functions like SEARCH and MMULT, and exploring matrix multiplication concepts.
Average of Customer Total Sales by Product - Formulas, DAX or Array Formula?
Learn advanced Excel techniques for calculating average customer sales by product using formulas, array formulas, and DAX measures in Power Pivot. Compare methods and optimize performance.
Excel for Accountants - VLOOKUP & PivotTables - Complete Lessons from Basic to Advanced
Comprehensive tutorial on VLOOKUP and PivotTables for accountants, covering basic to advanced techniques. Includes practical examples, efficiency tricks, and number formatting tips for Excel mastery.
Power BI Desktop - Build Data Model, Get Data, DAX Formulas, Visualizations, Publish to Web
Comprehensive tutorial on building data models, creating DAX formulas, and designing visualizations in Power BI Desktop. Learn to import data, establish relationships, and publish interactive reports online.
Comprehensive Power BI Desktop Example - Visualize Excel Data & Build Dynamic Dashboard
Learn to import, transform, and visualize Excel data in Power BI Desktop. Create dynamic dashboards with maps, charts, and slicers while mastering DAX calculations for insightful business analytics.