June 9, 2017November 15, 2017Excel How to Freeze Panes Working with large amounts of data can cause nightmares since you are […]
June 7, 2017November 15, 2017Excel How to Swap Columns with Transpose Everyone looks at data differently. Some people like having their dates (or […]
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. […]
December 27, 2016November 18, 2017Excel Text to Columns in Excel Tutorial Sometimes you will inherit data from a tool or your boss that […]
December 10, 2016November 18, 2017Excel How to Import Web Data into Excel Importing data from the web into Microsoft Excel can be used for […]
November 6, 2016Excel How to Forecast Data in Excel 2016 Within the data tab in Excel, there is a forecast sheet button […]
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 […]
September 10, 2016Excel How to Make Excel Smaller and Run Faster Working with large sets of data with pivot tables, slicers, graphs, macros, […]
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 […]
February 15, 2016Excel SUMPRODUCT for Weighted Average Find If you are looking to calculate the mean of a group of numbers, […]