How to Freeze Panes
Working with large amounts of data can cause nightmares since you are continuously scrolling up and down to see what row you […]
Category: Excel
How to Swap Columns with Transpose
Everyone looks at data differently. Some people like having their dates (or names of people) at the top of the document. Others […]
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 […]
Text to Columns in Excel Tutorial
Sometimes you will inherit data from a tool or your boss that needs to be separated into each column to make the […]
How to Import Web Data into Excel
Importing data from the web into Microsoft Excel can be used for a range of reasons. One of the reasons why I […]
How to Forecast Data in Excel 2016
Within the data tab in Excel, there is a forecast sheet button where you can select a time series and forecast out […]
How to Show Values as Percentages in a Pivot Table
Did you know that you can visualize a pivot table’s sum or count as a percentage for the column? The benefits of […]
How to Make Excel Smaller and Run Faster
Working with large sets of data with pivot tables, slicers, graphs, macros, formulas, and more can definitely make your excel document larger […]
How to Shorten a Long Date from Google Analytics
In Google Analytics, you only have so many dimensions to work with before you hit your limit for your report. One thing […]
SUMPRODUCT for Weighted Average Find
If you are looking to calculate the mean of a group of numbers, you can use the average formula in excel. However, you […]