ExcelIsFun Courses

Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More

Learn to leverage Excel's Table feature for dynamic ranges in VLOOKUP, PivotTables, charts, and more. Master efficient data management and analysis techniques for improved productivity.

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

Excel Basics - Excel VLOOKUP Function Made Easy

Master Excel's VLOOKUP function with 9 practical examples, from exact matches for product pricing to approximate matches for commission calculations, enhancing your data analysis skills.

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

Excel Basics - IF Function Made Easy and IS Functions Too - Epic Examples

Master Excel's IF and IS functions with 14 practical examples, enhancing your data analysis and decision-making skills for various business scenarios.

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

Excel Basics - Complete Formula Lesson of Formula Types & Formula Elements With Examples

Comprehensive guide to Excel formulas covering number, text, and logical operations with practical examples for data analysis and business calculations.

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

Excel Basics - Date & Time Number Formatting, Formulas, Functions & Calculations

Master Excel date and time formatting, calculations, and functions. Learn essential skills for efficient data handling, invoice management, and payroll processing in this comprehensive tutorial.

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

Excel Basics - Number Formatting as Façade & the ROUND Function

Learn essential Excel skills: number formatting techniques and the ROUND function for efficient data entry, accurate calculations, and practical applications in payroll, invoicing, and taxes.

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

Excel Basics - PivotTables & SUMIFS Function to Create Summary Reports

Learn to create summary reports using PivotTables and SUMIFS function in Excel. Master data analysis techniques, proper data set creation, and efficient report formatting for regional, daily, and sales rep summaries.

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

Excel Basics - Introduction to Excel - Excel's Golden Rule for Formulas, Formula Inputs, & Charts

Learn Excel's Golden Rule for formulas, create dynamic financial projections, and design effective charts. Master essential skills for data analysis and visualization in Excel.

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

Create PowerPoint Presentation With Pictures, Links and Videos

Learn to create engaging PowerPoint presentations with images, links, and videos. Master essential features like slide layouts, transitions, animations, and printing options for professional-looking slideshows.

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

Create Research Paper in Word

Learn to create a research paper in Word using MLA style, including formatting, citations, footnotes, bibliography, and time-saving features like Find & Replace and AutoCorrect.

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

Introduction to Power Query & Power Pivot Data Model in Excel 2016

Learn to clean data, create PivotTables, and use Power Query and Power Pivot in Excel 2016. Master data transformation, import large datasets, and build efficient data models for advanced analysis.

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

Create a Resume in Word

Learn to create professional resumes in Word 2016, from templates to custom designs. Master formatting, columns, and layout techniques for standout job applications.

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

Create Ad Flyer in Word - Create PDF and Web Page Files with Save As

Learn to create professional ad flyers in Word, including formatting, images, borders, and exporting to PDF and web formats. Master essential Word skills for effective document creation.

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

Introduction to Word 2016 - 20 Important Tips for Efficiency

Learn 20 essential tips to boost efficiency in Word 2016, covering shortcuts, formatting, navigation, and customization for improved productivity and document creation.

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

COUNTIFS or SUMPRODUCT for Complex Counting Formula - 3 Examples

Learn advanced Excel techniques for complex counting using COUNTIFS and SUMPRODUCT functions, including handling empty cells and combining AND/OR logic in formulas.

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