Simon Sez IT Courses

Microsoft Project Essential Features for Project Management

Master essential Microsoft Project features for effective project management, from creating tasks and managing resources to utilizing WBS codes and critical path analysis for on-time project delivery.

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

Excel for Accountants - Linking QuickBooks Online and General Ledger

Master the integration of QuickBooks Online with Excel for efficient general ledger management and streamlined financial reporting processes in accounting workflows.

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

QuickBooks Online 2025 - Complete Interface and Integration Guide

Master QuickBooks Online 2025's interface, account settings, dashboard customization, and third-party app integration for streamlined financial management and improved business organization.

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

Excel Conditional Formatting - From Beginners to Advanced

Master Excel's conditional formatting to enhance spreadsheets with automatic cell highlighting, icons, and custom rules. Create visually appealing data presentations and improve analysis capabilities.

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

Timeline, Calendar, and List View in Jira - A Beginner's Guide

Master essential Jira project management views - Timeline, Calendar, and List - to efficiently track tasks, deadlines, and project progress while improving your workflow organization skills.

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

Jira Beginners Guide - Team Managed and Company Managed Projects

Discover essential Agile project management concepts and navigate both team-managed and company-managed Jira environments to streamline your workflow and enhance team collaboration.

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

Power BI Data Visualization for Beginners - From Basics to Creating Interactive Reports

Master the fundamentals of data visualization in Power BI through hands-on practice with text boxes, formatting, page creation, and date visualizations - perfect for beginners seeking essential skills.

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

Enhance Excel Financial Models and Dashboards Using ChatGPT

Discover how to leverage ChatGPT to build dynamic Excel financial models, create income statements, perform ratio analysis, and automate dashboard creation for enhanced accuracy and efficiency.

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

Data Cleaning With Power Query - Automate Boring Tasks

Automate data cleaning workflows using Power Query to eliminate repetitive tasks and build refreshable processes that update with one click for faster, reliable Excel results.

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

Advanced PivotTable in Excel - GETPIVOTDATA, PivotCharts and More

Master advanced PivotTable techniques including GETPIVOTDATA functions, custom styling, PivotCharts, and dynamic reporting tools for enhanced Excel data analysis.

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

How to Use ChatGPT for Finance Tasks in QuickBooks

Discover how to integrate ChatGPT with QuickBooks to automate financial summaries, expense categorization, and document generation for enhanced accounting efficiency.

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

How to Go From Beginner to ChatGPT Pro in 2025

Master ChatGPT fundamentals: structure effective prompts, assign roles, control tone, and refine outputs for professional-level AI interactions in just 31 minutes.

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

How to Extract Data and Clean It Using Power Query in 15 Minutes

Master data extraction and cleaning with Power Query in Excel - import raw data, fix common issues, and prepare tables for analysis in just 15 minutes with repeatable techniques.

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

Excel Formulas and Functions Course - Beginners to Advanced

Master essential to advanced Excel formulas and functions to elevate your data analysis skills through logical functions, lookups, and statistical tools for all skill levels.

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

Excel 365 Course - Beginner to Advanced

Master Excel 365 from basics to advanced techniques including formulas, PivotTables, Power Query, and data analysis for business and analytical applications.

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