ExcelIsFun Courses

Ctrl - Shift - Enter - Excel Array Formulas - Dynamic Ranges - INDEX & OFFSET Functions

Master Excel's dynamic ranges using INDEX and OFFSET functions. Learn to create flexible formulas, charts, and data validation lists that automatically adjust as data changes, enhancing efficiency and accuracy in data analysis.

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

Ctrl + Shift + Enter - Excel Array Formulas - SUMPRODUCT Function - Including Timing

Comprehensive guide to SUMPRODUCT function in Excel, covering 21 examples with array formulas, timing comparisons, and efficient calculation techniques for data analysis and problem-solving.

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

Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics

Comprehensive tutorial on Excel array formulas, covering formula basics, advanced functions, and practical applications for efficient data analysis and problem-solving.

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

Slaying Excel Dragons - Complete Lessons on Excel Charts

Comprehensive guide to Excel charts: creation, formatting, and advanced techniques. Covers various chart types, data manipulation, and practical applications for effective data visualization.

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

Cell References in Formulas - Relative, Absolute, Mixed

Master Excel cell references: relative, absolute, and mixed. Learn to create dynamic formulas, use FV function, and build multiplication tables. Enhance your spreadsheet skills for efficient data manipulation.

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

SUMIFS Function - Adding with Criteria and SUMIF Function

Master Excel's SUMIFS and SUMIF functions with 36 practical examples, covering various criteria, operators, and advanced techniques for efficient data analysis and reporting.

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

CHOOSE Function - Beginner to Advanced Examples

Master Excel's CHOOSE function with 12 practical examples, from basic text selection to advanced array manipulation for powerful data analysis and formula creation.

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

LOOKUP Function Beginner to Advanced 23 Examples - Excel VLOOKUP WEEK Video

Master Excel's LOOKUP function with 23 practical examples, from basic to advanced applications. Enhance your data analysis skills and streamline your spreadsheet workflows.

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

Excel VLOOKUP Function - All You Need to Know

Comprehensive guide to mastering VLOOKUP function in Excel, covering basic to advanced techniques for efficient data lookup and manipulation.

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

Conditional Formatting Basic to Advanced - 30 Examples

Comprehensive tutorial on Excel's conditional formatting, covering 30 advanced techniques for data visualization, analysis, and highlighting specific information in spreadsheets.

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

Tour of Excel - Formulas, Formatting, Sort, Filter, PivotTables, Charts, Keyboards

Comprehensive Excel tutorial covering formulas, formatting, data manipulation, PivotTables, and charts. Includes practical examples and keyboard shortcuts for enhanced productivity.

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

INDEX & MATCH Lookup Functions - Beginning to Advanced

Comprehensive tutorial on INDEX & MATCH functions in Excel, covering 18 advanced techniques from basic lookups to complex array formulas for data extraction and manipulation.

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

Excel Magic Trick - FREQUENCY Array Function

Comprehensive tutorial on Excel's FREQUENCY function, covering various applications from basic usage to advanced techniques for data analysis and unique item extraction.

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