You are here: Home » Posts Tagged ‘ Excel ’

Calculator: Excel Formula to Calculate Fiscal Week, Quarter and Year

Excel Formula Generator Published December 14, 2011 at 5:00 pm No Comments

Below is a formula generator used to take dates in Excel (assumed as A1) and convert them into the following: Fiscal Week Fiscal Quarter Fiscal Year This is particularly useful when clients use non-generic fiscal calendars and you need to assign their fiscal information to large amounts of data in Excel. The most common application I [...]

VBA: Get Redirect URLs & Title Tags In Excel

Excel VBA Published December 5, 2011 at 7:35 pm 2 Comments

The code below takes the URLs in column A, loads the page in internet explorer and returns the redirect URL in column B with the title tag in column C. This is useful to help detect broken links, incorrect landing pages and improper redirects. To use this code please refer to my post on How [...]

VBA: How to Install VBA Macros in Excel

Excel VBA Published December 5, 2011 at 6:50 pm No Comments

Many of my future posts will include macros scripting (VBA) in Excel. Below is a quick tutorial on how to set up and incorporate Macros in your Excel Document. Open up Excel and save as .xlsm Select File, Save As. For “Save as type:” change it to Excel Macro-Enabled Workbook (*.xlsm) – (I tend to [...]

Me.