ExcelIsFun Courses

Visualizing Data and Building Dashboards in Excel & Power BI

Comprehensive guide to data visualization and dashboard creation in Excel and Power BI, covering various chart types, PivotTables, Power Query, and advanced techniques for effective data presentation.

• YouTube
• 1 hour 42 minutes
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• 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
• Self-Paced
• Free Video

Conditional Formatting to Visualize Data - Built-in and Logical Formulas

Explore advanced Excel data visualization techniques using conditional formatting, including built-in features and logical formulas for effective data analysis and presentation.

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

Excel Charts to Visualize Data - Comprehensive Lesson with 11 Chart Examples

Comprehensive guide to creating effective Excel charts, covering 11 types with practical examples and tips for data visualization without unnecessary clutter.

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

Lookup Functions and Formulas in Excel 2016 - Comprehensive Lessons with 20 Examples

Comprehensive tutorial on Excel lookup functions with 20 practical examples, covering VLOOKUP, HLOOKUP, INDEX, MATCH, and LOOKUP for data retrieval and analysis.

• YouTube
• 1 hour 19 minutes
• Self-Paced
• Free Video

Conditional Calculations with Excel Formulas - Comprehensive Lessons

Comprehensive guide to conditional calculations in Excel, covering AND/OR functions, SUMIFS, array formulas, and more. Ideal for mastering complex data analysis techniques.

• YouTube
• 1 hour 23 minutes
• Self-Paced
• Free Video

Excel Array Formulas - Comprehensive Lessons with 12 Examples

Comprehensive guide to Excel array formulas, covering 12 practical examples from basic operations to advanced functions like SUMPRODUCT, TRANSPOSE, and FREQUENCY for efficient data analysis.

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

Data Analysis Fundamentals - PivotTables, Power Query & Data Model

Master Excel data analysis with PivotTables, Power Query, and Data Model. Learn sorting, filtering, and advanced techniques to handle large datasets efficiently and create insightful reports.

• YouTube
• 1 hour 43 minutes
• Self-Paced
• Free Video

Excel Fundamentals - Comprehensive Formula Lesson

Comprehensive Excel formula tutorial covering 15 examples, including VLOOKUP, IF functions, array formulas, error tracking, and best practices for efficient spreadsheet creation.

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

Excel 2016 IFS Functions - Compare and Contrast IF and IFS Functions

Learn to use Excel 2016's IFS function for complex conditional logic, comparing it with IF and VLOOKUP. Explore practical examples and advanced techniques for efficient data analysis and formula creation.

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

Build Database with Excel Table Feature and VLOOKUP to Get Invoice Detail

Learn to create dynamic databases in Excel using Tables, master VLOOKUP for invoice details, and explore advanced features like structured references and data validation.

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