Data Visualization
How to Build Excel Interactive Dashboards
-
Frank
- July 15, 2021
- basics
- console
- dash board
- dashboard
- dashboard excel
- Dashboards
- Data
- Design
- dynamic
- dynamic dashboard
- easy
- Excel
- excel dashboard
- excel dashboard for beginners
- excel interactive dashboard
- filter
- how to
- interactive
- interactive dashboard
- interactive Kevin Stratvert
- kevin stratvert
- kpi
- kpis
- labels
- Learn
- Microsoft
- ms
- ms excel
- pivot
- pivot chart
- pivot table
- pivottable
- refresh
- report
- simple
- Slicer
- Slicers
- spreadsheet
- table
- Tables
- template
- templates
- timeline
- timelines
- Training
- Tutorial
- worksheet
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
-
Frank
- April 12, 2021
- automate
- automations
- beginners
- Business
- Code
- code editor
- create
- Excel
- excel code
- excel macro
- excel macros
- excel script
- how to
- in excel
- java script
- Javascript
- kevin stratvert
- macro
- macro excel
- macros
- macros in excel
- Microsoft
- Microsoft 365
- Microsoft Excel
- microsoft office
- office scripts
- onedrive
- Power
- power automate
- record
- record actions
- script
- scripts in excel
- share
- stratvert
- trigger
- type script
- TypeScript
- VBA
- Web
- work book
- work sheet
- workbook
- worksheet
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