Simon Sez IT
Creating Custom Excel Functions with LAMBDA
Master Excel's LAMBDA function to create custom, reusable functions for streamlining calculations and automating repetitive tasks in your workbooks.
YouTube12 minutesSelf-pacedFree video
Simon Sez IT
Creating Professional Business Charts in Excel - Advanced Visualization Techniques
Master advanced Excel charting techniques to create professional visualizations, from multi-series dumbbell charts to dynamic REPT charts, enhancing your data storytelling capabilities for business impact.
YouTube59 minutesSelf-pacedFree video
Simon Sez IT
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.
YouTube2 hours 32 minutesSelf-pacedFree video