Excel

Data Visualization

How to Build Excel Interactive Dashboards

In this step-by-step tutorial by Kevin Stratvert, learn how to create dynamic and interactive Excel dashboards. With a dashboard, you can showcase the most important information and key performance indicators (KPIs) that your organization cares about. Best of all, you only need is out of the box Microsoft Excel – no plug-ins, etc.

Read More
Power Apps

How to use Office Scripts in Excel & Power Automate

In this step-by-step tutorial, Kevin Stratvert shows you how you can use Office Scripts in Excel on the web to automate repetitive and mundane tasks. Additionally, learn how you can trigger you scripts automatically using Power Automate. With Power Automate, you can set a Teams message, an email, or other app to trigger your script.

Read More
Data

How to Build an Excel Dashboards in Under 15 Minutes!

Learn the tricks that allow you to build an Excel Dashboard super fast. 

Read More
Microsoft

How to easily automate boring Excel tasks with Power Query!

MyOnlineTrainingHub explains how  ower Query can automate the boring and laborious tasks of getting and cleaning data, reducing time spent on these tasks down to the click of a button. Get the files for this lesson here: https://www.myonlinetraininghub.com/introduction-to-power-query

Read More
Microsoft

What is Microsoft 365?

Kevin Stratvert explains all about Microsoft 365. Microsoft 365 is a subscription plan that includes the Microsoft Office suite (which includes apps like Outlook, Word, Excel, and PowerPoint), 1 TB of additional OneDrive storage and access to OneDrive Personal Vault, and 60 minutes of Skype calls per month.

Read More