Write For Us

How to Build a Real-Time Dashboard with Any Spreadsheet (Excel, Google Sheets, and more)

E-Commerce Solutions SEO Solutions Marketing Solutions
198 Views
Published
Spreadsheets like Excel and Google Sheets contain a lot of data. But what if you'd like to share those metrics and KPIs in a dashboard? In this video, Scott Friesen shows you how to create real-time dashboards in just minutes with Geckoboard.

Learn more about Geckoboard: https://www.geckoboard.com/

00:00 Problem with sharing spreadsheet data
01:48 Why Geckoboard is a better solution
03:13 Selecting key data to share on the dashboard
04:27 Adding goals to dashboard data
05:56 Moving and customizing widgets on the dashboard
06:58 Adding gauges to your visual dashboard
09:32 Spreadsheets sync with the dashboard
10:44 Connecting other data sources to the dashboard
11:19 Sharing dashboard via email, link or TV

MY FREE GUIDE:
✅ The 2-Do List Method - Build a better task list - https://www.simpletivity.com/free

MY FAVORITE SOFTWARE:
???? CRM for Gmail (NetHunt) - https://bit.ly/nethunt
???? Best book summaries (Shortform) - http://shortform.com/simpletivity
???? Powerful form builder (Jotform) - http://bit.ly/createjotform
???? Secure backups for Trello (Rewind) - https://rewind.com/scott-friesen

CONNECT WITH ME:
???? Sign up to my weekly email newsletter - https://www.simpletivity.com/free
???? My website - https://www.simpletivity.com
???? Facebook: https://www.facebook.com/simpletivity
???? Instagram: https://www.instagram.com/scottdfriesen
???? LinkedIn: https://www.linkedin.com/company/simpletivity
???? Twitter: https://twitter.com/simpletivity

ABOUT ME:
Scott Friesen is a productivity specialist and founder of Simpletivity Training Inc.. He is also a prolific public speaker, workshop leader, and time management coach. Scott helps people to focus more time on what they want to get done and to experience less stress by simplifying their technology.

Simpletivity shares productivity tips, technology apps, time management ideas, and more to help you get more done and enjoy less stress at the same time. If you’re an entrepreneur, business owner, or professional who wants to get more out of your day, make sure to subscribe for helpful training videos (http://www.youtube.com/channel/UCAp3b6zIvS8ct4yci-GwxIg?sub_confirmation=1).

​​Icons made by Freepik from www.flaticon.com
#simpletivity #dashboard #excel
Category
Tutorials
Tags
Simpletivity, Scott Friesen, How to Build a Real-Time Dashboard with Any Spread
Sign in or sign up to post comments.
Be the first to comment