ExcelIsFun Courses

Excel & Business Math - All About Excel Formulas for Business Math Class

Comprehensive guide to Excel formulas with 17 examples, covering math operations, logical formulas, and efficient formula creation techniques for business applications.

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

Excel and Business Math - Number Formatting and When You Must Use Round Function

Master number formatting in Excel, understand its limitations, and learn when to use the ROUND function to avoid calculation errors in business math applications.

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

Excel & Business Math - Excel Built-in Functions, Data Types and Keyboards are Fast

Learn essential Excel skills: data types, built-in functions, and keyboard shortcuts. Master efficient techniques for data analysis and calculations to enhance your productivity and accuracy in spreadsheet tasks.

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

Excel & Business Math - Excel's Golden Rule: Formula Inputs, What If Analysis and Excel Models

Learn Excel's Golden Rule for efficient formula solutions and models, with practical examples in building tables for student scores, monthly expenses, and payroll calculations.

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

Excel and Business Math - Introduction to Excel, Why We Use Excel for Math, First Formula

Learn Excel basics for business math: workbook layout, formulas, number formatting, and practical applications. Gain essential skills for financial calculations and data analysis.

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

Array Formula - Add Daily Rainfall 5 AM to 5 AM Next Day - Most Automatic

Learn advanced Excel array formulas to automate rainfall reporting with custom time periods. Master FREQUENCY, AGGREGATE, and SUMIFS functions for efficient data analysis and unique date extraction.

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

Access 2016 - Building Queries in Access

Comprehensive tutorial on building queries in Access 2016, covering 15 examples from basic filters to complex formulas, aggregate calculations, and multi-table queries.

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

Access 2016 - Create Database, Tables & Relationships, Import Excel Table Too

Learn to create databases, tables, and relationships in Access 2016. Import Excel data, set up data types, use lookup wizards, establish referential integrity, and create forms for efficient data entry and validation.

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

Introduction to Databases & Access

Comprehensive introduction to databases and Microsoft Access, covering key concepts, objects, data management, and comparison with Excel for effective data analysis and organization.

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

Excel Basics - Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set

Learn to use Power Query in Excel for data cleaning, transformation, and analysis. Master importing, combining, and refreshing data from various sources to create proper datasets and pivot tables.

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

Excel Basics - Excel Charts & Graphs to Visualize Quantitative Data

Learn to create effective Excel charts and graphs for data visualization, focusing on best practices and avoiding chart junk. Explore various chart types and their applications in data analysis.

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

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

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

Excel Basics - PivotTable Power - Amazing PivotTable Reporting Tricks - Slicers to Show Values As

Master advanced PivotTable techniques in Excel, including slicers, custom calculations, and data analysis. Learn to create powerful reports and gain insights from complex datasets.

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

Excel Basics - SUMIFS, COUNTIFS, AVERAGEIFS Functions Calculations With One or More Criteria

Master advanced Excel functions like SUMIFS, COUNTIFS, and AVERAGEIFS for data analysis. Learn to apply multiple criteria, use logical tests, and leverage Excel tables for efficient calculations.

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

Excel Basics - Mixed Cell References - The Number One Trick to Creating Formulas Quickly

Master mixed cell references in Excel for efficient formula creation, with practical examples and time-saving techniques for various business applications.

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