top of page

Color Banding
Do you want to have different color columns in your dashboard? Sometimes this helps to visually break up the space in your dashboard. ...
Jun 22, 20211 min read
310 views

Forgot to Save? No problem!
Did your computer shut down and you forgot to save the workflow you were working on? Did you know that similar to Microsoft Office...
Jun 15, 20211 min read
74 views


Top 10 Filter in a Pivot Table
Did you know you can automatically filter a Pivot table by the Top or Bottom 10? You can also customize this if you want to just filter...
Jun 15, 20211 min read
113 views

Don't Forget to Cache and Run!
Are you in the beginning stages of creating a workflow and one of your data sets is very large? One way to speed up the time it takes...
Jun 15, 20211 min read
88 views

KPI Color Arrow Calculation
Did you know you can just have the KPI arrows their own color in your dashboard? KPI's look less visually distracting if you just limit...
Jun 15, 20211 min read
585 views

How to Create a Unit Chart
Have you ever wondered how to create a population chart with people icons representing a portion of the population? These types of...
Jun 15, 20212 min read
659 views

Show me the Macros!
Do you know the many methods to add existing macros to your workflow young Alteryx padawan? There is also a way to change the macro...
Jun 9, 20211 min read
101 views


How to Build a Quadrant Chart in Excel
Do you want a chart that will quickly display 3 measures quickly? A Quadrant chart looks like a scatter plot but it is divided into four...
Jun 9, 20213 min read
10,315 views

Email Actions
Do you have a dashboard that you want to add a link for users to email you if they have any questions? You can do this by adding an...
Jun 9, 20212 min read
394 views

How to find Current Month to Date Data to the Prior Month with the Same Date
Have you ever wondered how to compare this month's data up to the current day of the month to the previous month's data to the same day? ...
Jun 1, 20211 min read
493 views


Excel - Password Protection in a Worksheet
Do you have a spreadsheet that contains complex formulas that you don't want your users to accidently change? You can protect these...
May 27, 20211 min read
17 views

Cancel Running Workflow on Error
Do you have a workflow that takes a long time to run? Perhaps you have multiple data sources and you are in testing mode. Do you want...
May 27, 20211 min read
53 views

Create an Area Chart with a Slider
Do you have an area chart in your dashboard that you would like to have a slider to select a certain time period? One way to spruce up a...
May 27, 20212 min read
440 views


SUMPRODUCT Formula in Excel
Do you have a spreadsheet where you want to obtain the total of different products by different values? SUMPRODUCT is a very useful...
May 18, 20211 min read
40 views
bottom of page