Author Archives: joezawada23

Please watch the video below to see how to build a spreadsheet lineup optimizer tool in Excel. I use Golf as the example but this can be used on any sport. This video covers the basics of what you need to build a good lineup optimizer tool.  To see the complete course which goes intoContinue reading “how to build lineup optimizer spreadsheet”

In this video I show how to customize the format of a Slicer.  Slicers are used in Excel Dashboards as a filter.  It’s a cleaner way to filter through your data. You can format slicers to look like the rest of your dashboard but it isn’t always easy or straight forward.  You need to goContinue reading “How to Format Slicers in your Excel Dashboard”

Sometimes you have a project which needs a lot of data but you don’t know where to find data to suit your needs. You may need something specific and in those cases it is best to create the data yourself. But making the data unique and random and usable isn’t easy.   Check out this videoContinue reading “Create Sample Data in Excel for your Dashboard or Project”

Making a progress or donut chart can be a challenging thing to put into your spreadsheet, however it can look very cool and professional on your dashboard.   Check out this video below showing how I build a progress chart .   Download the sample file here to follow along: http://bit.ly/excelbyjoe_downloads