ExcelIsFun Courses

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

59 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

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

2 reviews

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

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 - Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data

1 review

Learn essential Excel data analysis techniques: sorting, filtering, and Flash Fill. Master organizing and cleaning data efficiently for improved productivity and insights.

• YouTube
• 30 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

Basic Excel Business Analytics - Comprehensive PowerPivot, Data Model, DAX & Reporting Example

1 review

Comprehensive guide to PowerPivot: Import big data, build data models, create DAX measures, and generate insightful reports. Master advanced Excel analytics for business intelligence.

• YouTube
• 1 hour 1 minute
• On-Demand
• Free Video

Excel & Business Math - Bank Reconciliation Made Easy

1 review

Learn bank reconciliation concepts, Excel techniques for side-by-side worksheets, and conditional formatting. Master check components, endorsements, and bank services while practicing reconciliation examples.

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

Excel for Accounting - Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards

1 review

Master Excel for accounting with advanced formulas, PivotTables, macros, and charts. Learn efficient techniques for data analysis, reporting, and visualization to enhance your financial workflow.

• YouTube
• 2 hours 44 minutes
• On-Demand
• Free Video

Excel Finance - Cash Flow Analysis, Stocks, Bonds and Model Building

1 review

Master Excel-based financial analysis including cash flow valuation, stock and bond pricing, capital budgeting, and risk assessment through comprehensive hands-on model building.

• YouTube
• 20 hours 58 minutes
• On-Demand
• Free Video