ExcelIsFun Courses

Excel Data Analysis Basics Class - Data Analysis & BI Made Easy with Excel Power Tools

16 reviews

Learn Excel data analysis using Power Tools: formulas, PivotTables, Power Query, Power Pivot, and Power BI. Create reports, dashboards, and visualizations for effective business decision-making with real-world datasets.

• YouTube
• 6 hours
• On-Demand
• Free Video

Excel & Business Math - MEDIAN Function for FICA Social Security & Medicare Payroll Deductions

3 reviews

Learn to calculate FICA payroll deductions using Excel's MEDIAN function, focusing on Social Security and Medicare taxes. Master tax calculations with changing rates and create employee payroll tables.

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

How to Build Excel Dashboard - PivotTable, Chart, Conditional Formatting

3 reviews

Learn to create an Excel dashboard using Power Query, PivotTables, charts, and DAX measures. Master data modeling, conditional formatting, and dynamic updates for effective data visualization and analysis.

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

Comprehensive Excel Payroll Example - SUMIFS, MROUND, MOD, VLOOKUP & More

2 reviews

Comprehensive payroll solution using advanced Excel functions like SUMIFS, MROUND, MOD, and VLOOKUP. Learn to calculate hours, deductions, and taxes efficiently.

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

Power BI Desktop - Data Modeling & Interactive Visualizations

1 review

Learn data modeling and interactive visualization in Power BI Desktop. Import Excel files, build DAX formulas, create data models, and design interactive visualizations for effective data analysis and business intelligence.

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

Calculate DAX Function and Filter Context - ALLSELECTED and KEEPFILTERS

1 review

Comprehensive tutorial on CALCULATE DAX function, filter context, and related concepts in Power BI and Excel Power Pivot. Covers 50 examples with in-depth explanations of advanced DAX techniques.

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

Excel and Business Math - Future Value, Present Value and Periodic Payments for Annuities

1 review

Aprenda a calcular valor futuro, valor presente e pagamentos periódicos para anuidades e fluxos de caixa irregulares usando Excel. Inclui exemplos práticos e diagramas.

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

The Magic of Excel - Formulas, PivotTables, Charts, Flash Fill, Sort, Filtering, Functions & More

1 review

Discover Excel's powerful features: formulas, PivotTables, charts, and more. Learn essential skills to boost efficiency and data analysis capabilities for work, school, and personal projects.

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

M Code Class from Basic to Advanced - Power Query Excel & Power BI, Custom Functions

1 review

Comprehensive tutorial on M Code in Power Query for Excel and Power BI, covering basics to advanced topics like custom functions, data types, and lookups. Ideal for mastering data manipulation.

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

Power Query Group By - Complete Lesson with 10 Examples

Comprehensive tutorial on Power Query's Group By feature, covering basic to advanced applications with 10 practical examples for data analysis and calculations in Excel.

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

Excel Array Formulas & Functions - 50 Examples of How to Become an Array Expert

Master Excel array formulas with 50 practical examples, covering fundamental concepts, advanced functions, and real-world applications for data analysis and reporting.

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

All Important Excel Lookup Formulas - Excel Worksheet, Power Query & DAX – 28 Examples

Comprehensive guide to Excel lookup formulas, covering XLOOKUP, FILTER, XMATCH, INDEX, and more. Includes examples in Excel, Power Query, and DAX for exact and approximate matches.

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

Logical Tests - Excel Formulas, Conditional Formatting, PivotTables, Power Query, and More

Master Excel's logical functions, formulas, and advanced features. Learn to create powerful data analysis tools using PivotTables, conditional formatting, and Power Query for efficient data management.

• YouTube
• 1 hour 48 minutes
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Free Video