Formulas

Saturday, July 21, 2018

Formulas are the most important function of Excel. Formulas enable users to add, subtract, multiply, divide, and interact with data on endless levels. The most important part of…

Read More

Twitch Speedrunning Timer Download

Sunday, September 3, 2017

The below video shows the custom Twitch speedrunning timer program that I built in Excel. It records all your runs. Download my speedrun timer program for free. You…

Read More

Get Rid of Blank Spaces In Front of Numbers In Excel Stored As Text

Thursday, August 31, 2017
Get Rid of Blank Spaces in Front of Number Stored as Text

If you've ever pasted a table from an email into Excel, you've probably encountered annoying blank spaces in front of numbers that prevent you from doing math with…

Read More

VBA Filter Lesson

Sunday, August 27, 2017

Filtering is an important concept in Excel. It enables you to grab specific data quickly. Learning the nuances of filtering in VBA will help you to process data…

Read More

Convert British to US Dates

Sunday, August 27, 2017

Convert British to US Dates The below video shows you how to convert from British to US dates automatically with VBA code in Excel 2007, 2010, and 2013….

Read More

Do Loop Formula

Sunday, August 20, 2017
Do Loop VBA

Do Loop Formula VBA Lesson Video Watch my Do Loop Formula Youtube video in 1080P HD above. If you're on mobile and the quality isn't clear enough, watch…

Read More