ExcelIsFun Courses

Basic Excel Business Analytics - Intro to Linear Programming Using Algebra, Pencil & Paper

Introduction to linear programming using algebra and graphing methods to solve manufacturing problems and maximize contribution margin, with focus on mathematical modeling and feasible region analysis.

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

Basic Excel Business Analytics - Basic Forecasting Methods & Measures of Forecast Error

Explore essential forecasting techniques and error measures in Excel, including Naïve Method, Moving Average, and Exponential Smoothing. Learn to calculate and interpret forecast accuracy metrics for improved business analytics.

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

Basic Excel Business Analytics - Forecasting with Linear Regression: Trend & Seasonal Pattern

Learn advanced Excel forecasting techniques using linear regression for trend and seasonal pattern analysis, including FORECAST function and multiple regression with categorical variables.

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

Basic Excel Business Analytics - Visualizing Data: Table & Chart Guidelines

Aprenda diretrizes essenciais para visualização eficaz de dados em Excel, incluindo princípios de design de tabelas, tipos de gráficos e técnicas avançadas como formatação condicional e mapeamento 3D.

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

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

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

Basic Excel Business Analytics - Introduction to PowerPivot & Data Modeling

Comprehensive introduction to PowerPivot and data modeling in Excel, covering key concepts, DAX functions, and best practices for building efficient and effective data models for business analytics.

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

Basic Excel Business Analytics - Clean & Transform Data - Formulas, Flash Fill, Power Query, Text To Columns

Aprenda técnicas avançadas para limpar e transformar dados no Excel, incluindo fórmulas, Flash Fill, Power Query e Text to Columns, preparando-os eficientemente para análise.

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

Basic Excel Business Analytics - Good Spreadsheet Model Design, Fixed Variable Cost Example

Learn essential spreadsheet modeling techniques for business analytics, focusing on fixed and variable cost analysis using Excel. Gain practical skills in creating well-designed models for effective decision-making.

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

IF or VLOOKUP Function for Assigning Categories with Excel Formula - 8 Examples

Learn advanced Excel techniques for assigning categories using IF and VLOOKUP functions. Master data organization, formula creation, and efficient lookup methods for various scenarios.

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

Aging Accounts Receivable Reports on Multiple Sheets With Array Formula

Learn to create automated Aging Accounts Receivable Reports using Excel's array formulas, table features, and structured references. Master advanced functions like COUNTIFS, AGGREGATE, and INDEX for efficient data extraction and reporting.

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

Ctrl - Shift - Enter- Excel Array Formulas - 26 Amazing Array Formulas

Discover 26 powerful Excel array formulas for advanced data analysis, including unique value summation, conditional ranking, and complex lookups. Enhance your spreadsheet skills and efficiency.

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

Ctrl - Shift - Enter- Excel Array Formulas - Extract Unique Lists & Sorting Formulas

Learn advanced Excel techniques for extracting unique lists, sorting data, and creating efficient array formulas to solve complex data analysis problems and enhance spreadsheet functionality.

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

Ctrl - Shift - Enter- Excel Array Formulas - Unique Count Formulas- FREQUENCY or COUNTIF Function?

Explore advanced Excel array formulas for unique counting, including FREQUENCY and COUNTIF functions, handling mixed data, empty cells, and wildcards. Learn efficient techniques for data analysis.

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

Ctrl - Shift - Enter- Excel Array Formulas - Formulas to Extract Records With Criteria

Master advanced Excel array formulas for efficient data extraction, including AND/OR criteria, INDEX, SMALL, and AGGREGATE functions. Optimize spreadsheet performance with practical examples and timing comparisons.

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

Ctrl - Shift - Enter - Excel Array Formulas - Boolean Logic, AND & OR Criteria, Convert TRUE FALSE

Aprenda a usar fórmulas de matriz avançadas no Excel, incluindo lógica booleana, critérios AND e OR, e conversão de TRUE/FALSE para análise de dados eficiente.

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