Simon Sez IT Courses

Ultimate Guide to VLOOKUP, HLOOKUP and XLOOKUP - Excel Lookup Functions Course

1 rating

Master Excel's most powerful lookup functions - VLOOKUP, HLOOKUP, and XLOOKUP - to streamline data analysis with exact/approximate matches, named ranges, and error handling techniques.

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

How to Use PowerPoint to Design Stunning Slides and Presentations

1 rating

Master layout principles, multimedia integration, and sophisticated design concepts to create visually appealing and effective PowerPoint presentations in just 12 minutes.

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

Adobe Photoshop CC Intermediate Tutorial - Advanced Tools and Techniques

1 rating

Master advanced Photoshop techniques including artboards, layer management, content-aware tools, and Creative Cloud integration to enhance your digital design workflow.

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

Accountant Excel Toolkit: Financial Ratio Analysis

1 rating

Master financial ratio analysis in Excel by calculating liquidity, profitability, and leverage ratios to assess company performance and financial health effectively.

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

Inventory Management in QuickBooks Online

1 rating

Master QuickBooks Online inventory management essentials, from setting up products and services to tracking stock levels, managing orders, adjusting inventory, and generating insightful reports to maintain accurate inventory control.

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

Introduction to Jira Software - Training for Beginners

1 rating

Discover the essentials of Jira Software for beginners, from understanding Agile methodology to navigating the interface and mastering key terminology for effective project management and team collaboration.

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

Excel Features Every Accountant and Financial Analyst Needs to Know

1 rating

Master essential Excel features for accounting and financial analysis, from data importing and FILTER functions to PivotTables, forecasting techniques, and specialized charts for effective financial reporting and analysis.

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

Top Gmail Features to Organize Emails - Gmail for Beginners Course

1 rating

Master essential Gmail features to organize your inbox efficiently - from undo send and hover actions to labels, filters, and templates that boost productivity and streamline email management.

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

QuickBooks Online Intermediate Course

1 rating

Master intermediate QuickBooks Online skills in one hour: customize settings, integrate apps, manage deferred revenue, handle expenses from bank feeds, and process international transactions for streamlined financial management.

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

Financial Forecasting and Modeling Course

1 rating

Build business financial forecasts in Excel by analyzing financial statements and identifying key variables and drivers.

• YouTube
• 2 hours 20 minutes
• Self-Paced
• Free Video

Microsoft Excel Advanced Excel Training Course

1 rating

Advanced Excel training centered on dynamic arrays, flexible XLOOKUP/XMATCH lookups, filtering, and statistical formulas with hands-on exercises.

• YouTube
• 3 hours 44 minutes
• Self-Paced
• Free Video

Pivot Table Excel Tutorial

1 rating

A beginner walkthrough of turning raw Excel data into refreshable PivotTables and PivotCharts with slicers.

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

ChatGPT Prompts That Will Replace 99% of Project Management Work - AI for Project Managers

1 rating

Discover ChatGPT prompts to automate project briefs, timelines, progress tracking, stakeholder updates, risk management, meeting agendas, and status reports for efficient project management.

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

Microsoft Power Automate Tutorial for Beginners

1 rating

Create instant, automated, and scheduled workflows—including a document approval flow—in Microsoft Power Automate.

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

Excel Tutorial - Beginner to Advanced

Build from Excel basics to dynamic arrays, lookup functions, and advanced data manipulation in a guided 12-hour course.

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