MyOnlineTrainingHub

MyOnlineTrainingHub

Publication
0 followers

Excel/Power Query/Power BI tutorials for reporting and analytics.

The AI Tool Every Modern Manager Should Be Using in 2026
VideoApr 9, 2026

The AI Tool Every Modern Manager Should Be Using in 2026

The video introduces Scribe, a desktop and web‑based AI tool that records on‑screen actions and instantly converts them into interactive how‑to guides. Targeted at modern managers, it promises to replace tedious manual documentation—Word files, screenshots, and video tutorials—with a single...

By MyOnlineTrainingHub
The Excel Gantt Chart That Replaces Your Project Management Tool
VideoMar 24, 2026

The Excel Gantt Chart That Replaces Your Project Management Tool

The video demonstrates how to build a fully modern, color‑coded Gantt chart directly in Excel, positioning the spreadsheet as a free alternative to paid project‑management platforms such as Asana, Monday.com, or Notion. The author shows that only three inputs—start date, duration,...

By MyOnlineTrainingHub
Turn an Excel Spreadsheet Into a Real App Without Coding
VideoMar 10, 2026

Turn an Excel Spreadsheet Into a Real App Without Coding

The video demonstrates turning an Excel inventory spreadsheet into a fully functional no‑code app using Glide, showing step‑by‑step import and UI creation. It walks through creating computed columns for product‑site keys, establishing relations, using a rollup to sum quantities, and lookups...

By MyOnlineTrainingHub
STOP Writing Multiple Formulas When One Will Do
VideoFeb 17, 2026

STOP Writing Multiple Formulas When One Will Do

The video teaches Excel 365 users how to embed array constants—denoted by curly braces—directly inside functions, turning a single formula into a multi‑value engine. By separating values with semicolons (vertical) or commas (horizontal), functions like DATE, FILTER, CHOOSE, VSTACK, XLOOKUP, SORT...

By MyOnlineTrainingHub
Excel Just Made File Imports Ridiculously Simple (New Functions)
VideoFeb 3, 2026

Excel Just Made File Imports Ridiculously Simple (New Functions)

Microsoft Excel has added two native functions—IMPORTCSV and IMPORTTEXT—that let users pull data from CSV and plain‑text files directly into a worksheet using a single formula. Both functions accept a file path (local or URL) and expose optional arguments for delimiter,...

By MyOnlineTrainingHub