Simon Sez IT Courses

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

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

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

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

Excel Data Analysis: VLOOKUP, HLOOKUP, XLOOKUP, and Power Query Functions

1 rating

Master essential Excel lookup functions (VLOOKUP, HLOOKUP, XLOOKUP) and Power Query techniques for efficient data analysis, transformation, and reporting in complex datasets.

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

How to Analyze Data in Excel Spreadsheets

1 rating

Learn essential Excel skills for data analysis: data entry, formatting, formulas, functions, and referencing. Practical exercises included for hands-on experience in spreadsheet manipulation and analysis.

• YouTube
• 50 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

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

Learn essential financial forecasting and modeling techniques, including understanding financial statements, defining objectives, identifying key variables, and practical exercises for real-world application.

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

Microsoft Excel Advanced Excel Training Course

1 rating

Comprehensive advanced Excel training covering dynamic arrays, advanced functions, data manipulation, and statistical analysis. Includes hands-on exercises for practical skill development.

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

Pivot Table Excel Tutorial

1 rating

Learn to create, analyze, and visualize data with Excel Pivot Tables. Master data cleaning, formatting, grouping, and advanced features like Pivot Charts and Slicers in this comprehensive tutorial.

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

Pipedrive Tutorial 2020: How to Use Pipedrive CRM

1 rating

Comprehensive tutorial on Pipedrive CRM: learn to sync contacts, manage deals, track performance, and automate emails for efficient sales pipeline management.

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

Advanced Excel Tutorial - Advanced Functions - VLOOKUP, IF, Forecasting, Statistical

1 rating

Master advanced Excel functions like VLOOKUP, IF, and forecasting. Learn to manipulate dates, use financial formulas, and apply statistical analysis for data-driven decision making.

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

Microsoft Power Automate Tutorial for Beginners

1 rating

Learn to create automated workflows using Microsoft Power Automate. Master different flow types, navigate the interface, and build flows from templates and scratch in this comprehensive tutorial.

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