Dashboard
How-to Build a Plan vs Actual Excel Dashboard
Hi All, I wanted to share with you a great post from a fellow Excel creator and teacher. Mynda Treacy has just released a great video tutorial on how to create your own Plan vs Actual Excel
THE EXCEL LEARNING LIBRARY
Good data.
Better dashboards.
Practical tutorials, clever chart techniques and downloadable workbooks. Build your next dashboard, one useful skill at a time.
Start here
FROM THE TUTORIAL LIBRARYLatest tutorials
Explore the library
Clustered Stacked Bar Chart
How-to Make an Excel Clustered Stacked Column Chart Type
Quikly learn how to make a new chart type Excel Clustered Stacked Column Chart. This is Not in Excel, but this tip you can make the chart you need.
Clustered Stacked Bar Chart
How to Make a Clustered Stacked and Multiple Unstacked Chart in Excel
Quickly learn the tricks to make an Excel Clustered Stacked and Multiple Unstacked Chart.
Uncategorized
Free Excel Dashboard Webinars & Excel and Power BI Dashboard Courses
Hi Everybody, I’m excited to share with you a Microsoft Excel MVP, Mynda Treacy’s, highly acclaimed Excel Dashboard course. More details are below. – STEVE=TRUE Hurry, Last Chance for Free
Chart
How to easily change chart element selections in Excel 2016 2019 and Office 365
Selecting chart elements changed in Excel 2016 2019 and Office 365. Learn how to easily change chart element selections with this quick tip. The technique you used in previous versions of E
Chart
How-to Fix Sales Goal Error of Excel Thermometer Chart
Learn how to fix a problem with my Thermometer template that was created in the original version of the Excel chart when the Sales is greater than the goal.
Hack
How-to Hack Excel Protect Workbook Feature When You Forgot the Password
Hack Excel Protect Workbook So you forgot / lost your password and need to update your workbook tabs or structure? Well don’t cry, don’t complain, we can Hack Excel Protect Workbook feature
How-To
How-to Fix a FRUSTRATINGLY Annoying Excel Scroll Lock Issue
Find the quickest way to Stop this disgustingly horrible issue with Microsoft Windows and Microsoft Excel
Bar Chart
Create a Vertical Line Between Columns in Excel Using Error Bars
Learn another technique to create a vertical line between columns in Excel to help the end user focus on the right data.
Chart
Add Vertical Line Between Columns in Excel Stacked Column Chart
Learn how to QUICKLY add a vertical line between columns in a stacked column chart to visually separate your graph data.
PUT IT ALL TOGETHER
Build your Excel dashboard
Dashboard
How-to Build a Plan vs Actual Excel Dashboard
Hi All, I wanted to share with you a great post from a fellow Excel creator and teacher. Mynda Treacy has just released a great video tutorial on how to create your own Plan vs Actual Excel
Chart
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months If you wanted to create a dynamic Excel chart of last 3 months of your data but didn’t know how to use or didn’t want to use the Excel Offset Function, then check out
Chart
How-to Make an Excel Single Image Goal Chart
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save trees by reducing their usage of paper in copiers and
EXCEL DASHBOARD TEMPLATES
A practical place
to learn Excel.
This is your one-stop-shop for everything Excel Dashboard Related. Tutorials, Free Templates, Formula and Chart Resources will be provided so that you can develop your Executive Dashboard.