Formatting
Excel Formula Formatting Quick Tip
Learn the best Excel Formula Formatting technique so that you can quickly edit them in the future! You will use these simple techniques for all of your Excel Formulas going forward.
EXPLORE THE LIBRARY
/2017/
Fun
Excel Dashboard Templates – Mean Tweets Edition
Checkout many of the mean things that people have said about ExcelDashboardTemplates.com videos and tutorials over the years.
Align
Quickest Way to Select and Align Charts for an Excel Dashboard
Select and Align Charts for an Excel Dashboard Creating dashboards can take a lot of time. With this simple technique that I just learned, you can quickly select and align charts for your f
Chart
Create Dynamic Excel Chart Conditional Labels and Callouts
Learn this SIMPLE executive dashboard chart trick for conditional labels and callouts so you can QUICKLY identify individual data points.
Ideas
Do you have an Idea to Make Excel Better? Excel’s Suggestion Box is Here!
Microsoft needs your help. Check out how you can influence Microsoft roadmap for the next release by submitting your votes on Excel’s Suggestion Box
How-To
Alternate Ways to Select Large and Non-Contiguous Ranges in Excel
Learn how to use alternate techniques to select very large ranges in Excel and also another way to select non-contiguous ranges.
Bar Chart
How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel Excel is awesome because, even when a certain chart type is not a standard option, there may be a way that you can create the type of chart that y
About
Who is this Steve=True guy? Getting to know the true me
Who are you? Hello to all of my Microsoft Excel friends and family out there. I wanted to write a post so you can get to know more about me. I also hope to get to know you well, so please
Challenge
Friday Challenge – My Answer – Chart This Data in Excel
Check out How I Used Different Graphing Techniquest to Chart This Data in Excel, including Pivot Tables, Slicers and Multi-Level Labels.
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