Skip to content
  • Home
  • Additional Services
    • Free SEO Audit
    • New York Local SEO
    • SEO Audit Service
  • Blog
  • Contact
    • Greg
    • Privacy Policy
    • Terms and Conditions
  • Free Resources
    • SEO Case Studies
    • Free SEO Workshop
Search
Close menu
  • Home
  • Additional Services
    • Free SEO Audit
    • New York Local SEO
    • SEO Audit Service
  • Blog
  • Contact
    • Greg
    • Privacy Policy
    • Terms and Conditions
  • Free Resources
    • SEO Case Studies
    • Free SEO Workshop
Search Toggle menu

Category: Excel

June 9, 2017November 15, 2017Excel

How to Freeze Panes

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

June 7, 2017November 15, 2017Excel

How to Swap Columns with Transpose

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

March 31, 2017April 2, 2018Excel

How to Remove Tracking URL’s in Excel

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

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

December 10, 2016November 18, 2017Excel

How to Import Web Data into Excel

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

November 6, 2016Excel

How to Forecast Data in Excel 2016

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

October 16, 2016November 19, 2017Excel

How to Show Values as Percentages in a Pivot Table

heat map in excel finding oppportunities

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

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

September 6, 2016September 8, 2016Excel

How to Shorten a Long Date from Google Analytics

Step 3 Coverting Text to a Date in Excel

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

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

Posts navigation

1 2 >

About Greg Kristan

Greg Kristan TM Blast LLC

Hi!

My name is Greg Kristan, and I'm TM Blast LLC's owner. I offer SEO consulting services to clients in the United States. In addition to consulting, I built a Free SEO Course to watch. Finally, I now offer paid SEO audits for companies, organizations, and more.

Today, I live and work out of Saratoga Springs, New York.

Copyright © 2023 TM Blast LLC 229 Washington Street, Suite 305 Saratoga Springs, NY 12866   Sitemap