Working with large amounts of data can cause nightmares since you are continuously scrolling up and down to see what row you are referring to. Things can get even more complicated if you need to reference a date at the top of the document with a reference on a column. Luckily in Excel, we can […]
Everyone looks at data differently. Some people like having their dates (or names of people) at the top of the document. Others like the dates and the names of people to be on the left-hand side. I fall into the latter when it comes to analyzing trends. My goal is to swap the columns at […]
Tracking URL’s are special characters that are extra additions to static URL’s. Examples of tracking URL’s include paid search campaigns, social media campaigns, email campaigns, and anything else you want to track specifically in a tool like Google Analytics. Marketing URL’s are fantastic for separating out channels from the source, but you will realize the […]
Sometimes you will inherit data from a tool or your boss that needs to be separated into each column to make the data more accessible to sort and process. One example of needing to do this is if you have imported data from the web into excel and the name of the football player, their […]
Importing data from the web into Microsoft Excel can be used for a range of reasons. One of the reasons why I do this is for Fantasy Football data analysis. I can create a connection from a website that updates player stats every week and establishes a relationship with my excel document. By doing that, […]
Within the data tab in Excel, there is a forecast sheet button where you can select a time series and forecast out what the projection will look like. This is perfect if you are looking to make a quick forecast for your team, or you are curious about how you are trending with your own goals. The best […]
Did you know that you can visualize a pivot table’s sum or count as a percentage for the column? The benefits of using this are that you can switch back and forth at any time, so you can visualize trends, act on opportunities, and genuinely compare like metrics against each other much faster. In this […]
Working with large sets of data with pivot tables, slicers, graphs, macros, formulas, and more can definitely make your excel document larger than it needs to be. The problem with a larger excel document is that it takes up more of your space on your hard drive or cloud, it takes longer to open on […]
In Google Analytics, you only have so many dimensions to work with before you hit your limit for your report. One thing you might have noticed in GA is that Google will spit out a long date within Excel that Excel can’t compute with the TEXT command. In this tutorial, I am going to show how […]
If you are looking to calculate the mean of a group of numbers, you can use the average formula in excel. However, you might find that an average for a list of numbers could lead to errors in your excel document. The reason for this is that this formula could count each value as one. Sometimes you might have something […]