June 9, 2017November 15, 2017Excel 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 […]
June 7, 2017November 15, 2017Excel 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 […]
March 31, 2017April 2, 2018Excel 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 […]
December 27, 2016November 18, 2017Excel 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 […]
December 10, 2016November 18, 2017Excel 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 […]
November 6, 2016Excel 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 […]
October 16, 2016November 19, 2017Excel 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 […]
September 10, 2016Excel 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 […]
September 6, 2016September 8, 2016Excel 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 […]
February 15, 2016Excel 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 […]