ExcelIsFun Courses

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

62 ratings

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
• Self-Paced
• Free Video

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

3 ratings

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
• Self-Paced
• Free Video

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

3 ratings

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
• Self-Paced
• Free Video

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

3 ratings

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

• YouTube
• 29 minutes
• Self-Paced
• Free Video

Power BI Desktop - Data Modeling & Interactive Visualizations

2 ratings

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
• Self-Paced
• Free Video

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

2 ratings

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
• Self-Paced
• Free Video

Excel Business Analytics - Forecasting, Linear Programming, Simulation and More

2 ratings

Master Excel business analytics through forecasting, linear programming, Monte Carlo simulation, Power Query data transformation, and statistical modeling techniques.

• YouTube
• 19 hours 18 minutes
• Self-Paced
• Free Video

Calculate DAX Function and Filter Context - ALLSELECTED and KEEPFILTERS

1 rating

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
• Self-Paced
• Free Video

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

1 rating

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
• Self-Paced
• Free Video

Excel Basics - Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data

1 rating

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
• Self-Paced
• Free Video

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

1 rating

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
• Self-Paced
• Free Video

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

1 rating

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
• Self-Paced
• Free Video

Excel & Business Math - Bank Reconciliation Made Easy

1 rating

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
• Self-Paced
• Free Video

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

1 rating

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
• Self-Paced
• Free Video

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

1 rating

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
• Self-Paced
• Free Video