Welcome to the Video Tutorials Hub – this page is dedicated to sharing the latest content from my YouTube channel.
Here, you’ll find step-by-step tutorials on Excel, Power BI, and other productivity tools. Each post includes the full video, along with any downloadable files or resources you can use to follow along.
I’ve recently launched this website, so expect more improvements and features in the coming weeks. My goal is to make this space as helpful, organized, and easy to navigate as possible.
If you’re enjoying the tutorials or have any suggestions, feel free to reach out — I’d love to hear from you!
Easily compare Actual vs Budget data in Excel — even if they’re in different files — using Power Query and Pivot Tables. This step-by-step guide shows you how to merge datasets, calculate variances, and create a dynamic report that updates automatically each month.
New to Excel? Learn the 10 most essential Excel functions every beginner should know—complete with examples, use cases, and downloadable practice files.
Learn how to use Excel’s most powerful lookup formulas: VLOOKUP, HLOOKUP, and XLOOKUP. This step-by-step guide walks you through real examples, including advanced lookup tips and best practices for clean, error-free spreadsheets.
In this hands-on tutorial, we’ll build an interactive dashboard in Microsoft Excel from scratch — no add-ins, no complicated code. Just smart use of Excel’s built-in tools to turn raw data into a dynamic, visually appealing dashboard.
© All Rights Reserved.