Simon Sez IT Courses

Using the SORT Function in Excel 365

Master Excel's SORT function to dynamically organize data by multiple columns or rows in ascending/descending order, streamlining your data management and analysis capabilities.

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

Building Professional Diagrams in Microsoft Visio 365 - A Beginner's Tutorial

Master the fundamentals of creating professional diagrams in Visio 365, from basic shape manipulation to connecting elements and applying custom styles for clear, visually effective business documentation.

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

Mastering Conditional Formatting in Excel - Data Visualization and Analysis

Master Excel's conditional formatting features to enhance data visualization through highlight rules, data bars, color scales, and custom formulas for more impactful spreadsheet analysis and presentation.

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

Cleaning Data and Building Reporting Dashboards in Excel - From Power Query to Interactive Visualizations

Master data cleaning and visualization in Excel through Power Query, PivotTables, and interactive dashboard creation. Transform raw data into meaningful insights while automating your workflow.

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

Interactive Excel Charts and Dashboards - Data Visualization

Master data visualization techniques to create dynamic Excel dashboards, interactive business charts, and professionally formatted visualizations for impactful data presentation.

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

Creating Custom Functions in Excel 365 with LET and LAMBDA

Master custom function creation in Excel 365 using LET and LAMBDA functions to transform complex formulas into reusable, efficient solutions for streamlined spreadsheet calculations.

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

Design Slides and Format Layouts in Google Slides

Master the art of creating professional slide layouts in Google Slides through customization of themes, element arrangement, and formatting techniques for impactful presentations.

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

Power BI Essentials: Data Transformation, Analysis and Modeling for Beginners

Master Power BI fundamentals through hands-on practice with data transformation, interface navigation, measure creation, and data modeling to build effective business intelligence solutions.

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

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

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

Essential Excel Functions: VLOOKUP, HLOOKUP, INDEX and 15 More Advanced Features

Master essential Excel functions including VLOOKUP, HLOOKUP, INDEX/MATCH, and advanced features like FILTER, SORT, and text manipulation to enhance your spreadsheet skills and boost productivity.

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

How to Build Interactive Spreadsheets in Excel

Enhance Excel spreadsheets with interactive form controls. Learn to create combo boxes, checkboxes, spin buttons, and option buttons for dynamic data entry, filtering, and visualization.

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

Advanced Excel 365 Training: Dynamic Arrays, Complex Lookups, and Power Tools

Boost data analysis skills with advanced Excel 365 features. Master dynamic arrays, complex lookups, custom functions, Power Pivot, and Power Query for efficient data manipulation and management.

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