Category: Excel

Working with large amounts of data can cause nightmares since you are continuously scrolling up and down to see what row you […]

Everyone looks at data differently. Some people like having their dates (or names of people) at the top of the document. Others […]

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

Sometimes you will inherit data from a tool or your boss that needs to be separated into each column to make the […]

Importing data from the web into Microsoft Excel can be used for a range of reasons. One of the reasons why I […]

Within the data tab in Excel,  there is a forecast sheet button where you can select a time series and forecast out […]

Did you know that you can visualize a pivot table’s sum or count as a percentage for the column? The benefits of […]

Working with large sets of data with pivot tables, slicers, graphs, macros, formulas, and more can definitely make your excel document larger […]

In Google Analytics, you only have so many dimensions to work with before you hit your limit for your report. One thing […]

If you are looking to calculate the mean of a group of numbers, you can use the average formula in excel. However, you […]