Archive for Excel VBA
Find Statistical Significance in Excel for A/B Ad Copy or Landing Page Tests
Below returns the P-Value. Since tests are two tailed, a .95 is equivalent to .05 (it just depends on which order you enter the data). To use this formula, visit How to Install VBA Macros in Excel. After you have installed it, go back to your worksheet and type =SignificantTest(A1,A2,B1,B2) where: A1 = Impressions for [...]
VBA: Decode and Strip HTML encoded URLs
The code below adds a new function to your workbook to strip and trim encoded URLs. The process is broken up into two parts: The first part takes the encoded URL and decodes it the number of times set by the user (TimesToDecode = number of encoding levels). The second part takes the decoded URL [...]
VBA: Get Redirect URLs & Title Tags In Excel
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
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 [...]
