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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.