Excel

How to Freeze Panes

Posted on
How to Freeze Top Row

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 […]

Excel

How to Swap Columns with Transpose

Posted on
Completed Transpose Effect in Excel

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 […]

Excel

How to Remove Tracking URL’s in Excel

Posted on
How to Remove Tracking URL's in Excel

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 […]

Excel

Text to Columns in Excel Tutorial

Posted on
Comma and Spaces in Text to Columns in Excel

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 […]

Excel

How to Import Web Data into Excel

Posted on
How to import data from the web into excel

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, […]

Excel

How to Forecast Data in Excel 2016

Posted on
how to forecast in excel

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 […]

Excel

How to Make Excel Smaller and Run Faster

Posted on
a bit smaller excel document after removing the formulas

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 […]

Excel

SUMPRODUCT for Weighted Average Find

Posted on
SUMPRODUCT Formula for Average Mean in Excel

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 […]