Simon Sez IT Courses

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
• On-Demand
• Free Video

QuickBooks Online Tutorial 2026 - 5-Hour Beginner's Course with AI Agents and New Updates

Master QuickBooks Online 2026 with AI agents through comprehensive 5-hour training covering setup, invoicing, payroll, banking, and reconciliation for business management success.

• YouTube
• 4 hours 50 minutes
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Free Video

How to Edit the Agile Board in Atlassian Jira

Master customizing your Agile board in Jira to improve project visibility and tracking. Learn detailed instructions for adapting the board to your team's specific workflow needs in this focused Scrum tutorial.

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

How to Create and Format Tables in Excel 365

Master table creation and formatting in Excel 365 to organize data effectively with styles, headers, filters, and structured references for streamlined analysis.

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

How to Use Shapes and Drawing Tools in Adobe Illustrator CC

Master Adobe Illustrator CC's shape and drawing tools to create precise geometric designs and detailed sketches with professional techniques and creative control.

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

TOP Excel Productivity Tips Every Professional Needs to Know

Master essential Excel shortcuts, formatting, data management, and chart creation to boost your professional productivity and work more efficiently.

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

How to Create Advanced Recurring Tasks in Microsoft Project

Master advanced recurring task creation in Microsoft Project with custom patterns, resource assignment, and timeline integration for streamlined project planning.

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

Create, Customize, and Automate Reports in QuickBooks Online

Master QuickBooks Online reporting by building custom reports, automating delivery schedules, creating multi-year financial statements, and exporting to Excel for analysis.

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

How to Create Excel Drop-down Menus and Data Validation

Learn to create Excel drop-down menus and implement data validation to streamline data entry, prevent errors, and maintain data integrity in your spreadsheets with step-by-step guidance on customized lists and validation techniques.

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

Run and Process Payroll in QuickBooks Online

Master the payroll process in QuickBooks Online 2025 with step-by-step guidance on setting up, customizing, and processing payments efficiently to maintain optimal cash flow and manage client payment terms effectively.

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

Connect Bank Accounts and Reconcile Transactions in QuickBooks Online

Learn how to connect bank accounts and reconcile transactions in QuickBooks Online to streamline your accounting processes and efficiently manage your business finances.

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

Microsoft Word 365 - Intermediate Course

Master intermediate Microsoft Word 365 skills including document sectioning, building blocks, indexes, tables of contents, hyperlinks, Excel data linking, document properties, and tracking changes.

• YouTube
• 1 hour 52 minutes
• On-Demand
• Free Video

Excel Forecasting Tools for Data Analysts

Master Excel's forecasting tools for data analysis: Forecast Sheet for trend predictions, Goal Seek for desired outcomes, Scenario Manager for financial modeling, and PivotTable reports for strategic decision-making.

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