ExcelIsFun Courses

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

36 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

3 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

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

Excel Basics - Introduction to Excel - Formatting, Formulas, Cell References, Page Setup

1 review

Learn Excel basics: formatting, formulas, cell references, and page setup. Master essential skills for data entry, calculations, and spreadsheet organization in this comprehensive introduction.

• YouTube
• 1 hour 3 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

Excel LAMBDA Function - Every Single Thing You Ever Wanted to Know

Comprehensive guide to Excel's LAMBDA function, covering creation of reusable functions, helper functions, recursion, and advanced reporting techniques for enhanced spreadsheet efficiency.

• YouTube
• 1 hour 45 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