Simon Sez IT Courses

Top 10 Featured Functions in Excel - According to Microsoft

Master Excel's top 10 intermediate functions including Named Ranges, IF statements, VLOOKUP, HLOOKUP, and XLOOKUP to create dynamic, error-resistant spreadsheets efficiently.

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

ChatGPT Prompting Basics - Essential Skills Most People Still Don't Know in 2025

Master essential ChatGPT prompting techniques including structure, role assignment, tone control, and iteration methods that most users overlook for optimal AI interactions.

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

Master Data Cleaning Essentials with Power Query and Excel

Master essential data cleaning techniques using Excel and Power Query to transform messy datasets into organized, analysis-ready information with automated tools and refreshable reports.

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

Steps You Need to Do Before Finalizing and Printing Your Excel Spreadsheet

Master essential pre-printing steps in Excel: review layout, adjust scaling, set print areas, and ensure professional-looking spreadsheets to avoid common printing mistakes.

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

Essential Outlook 365 Features - All You Need to Know

Master Outlook 365's essential features: navigate interface, customize views, format emails, add signatures, organize folders, sort/filter messages, and search efficiently.

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

Adobe Illustrator CC Essentials - Unleashing Creative Possibilities with Drawing Shapes

Master fundamental Illustrator shapes - squares, circles, polygons, and stars - then transform them into complex vector designs with precision and creative flair.

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

How to Upload and Analyze Documents Using ChatGPT

Master document analysis with ChatGPT by uploading PDFs, spreadsheets, and text files to extract insights, summarize reports, and generate actionable results instantly.

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

How to Create Reports in MS Project

Master Microsoft Project reporting to present project data clearly with built-in reports, custom layouts, and key metrics like progress, costs, and timelines.

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

How to Create Excel Charts and Graphs

Master creating professional Excel charts and graphs to transform raw data into compelling visuals that highlight key trends and insights in just 16 minutes.

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

Excel Formulas and Functions You Need to Master

Master intermediate Excel functions including Named Ranges, IF statements, VLOOKUP, HLOOKUP, and XLOOKUP to create dynamic, error-resistant spreadsheets and work more efficiently.

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

How to Customize Settings in QuickBooks Online

Discover how to tailor QuickBooks Online settings including company preferences, invoice templates, tax configurations, and user permissions for optimal business efficiency.

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

Excel Forecasting Functions Every Analyst Needs to Know

Master Excel's forecasting tools including Forecast Sheet, Goal Seek, and Scenario Manager to analyze data and make informed business decisions efficiently.

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

Microsoft Project - Schedule and Project Management Tutorial

Master Microsoft Project's scheduling tools to set task dependencies, define milestones, adjust timelines, and monitor progress for effective project management control.

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

How to Use Advanced Layer Techniques in Adobe Photoshop CC Tutorial

Explore advanced Photoshop layer filtering and master Layer Comps to create multiple document versions with unique visibility, positions, and appearances efficiently.

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

Leveling Up Your Skills with Vanishing Point Filter

Master Photoshop's Vanishing Point Filter to superimpose images while maintaining realistic perspective through grid alignment and seamless blending techniques.

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