Logical Test

Cell I8 on the Dashboard style report , is a list of all the months, years or date range. To create this list first define all the content that you want within the drop down in a selection of cells. Once you have done this select the cell that you to have the dropdown be contained in and then set the list by… 1. Go to the "Data" tab, and select "Data validation"… 2. Then a pop should appear, then select "List" from the dropdown. 3. Then select the source field, this should then close up the box then select the data that you would like to appear within the list. 4. Once you have done this it should reopen the screen, and look a little like the below. 5. If you would like to add a note to the cell, select the "Input message" tab, add a heading, and content then select ok 6. And you have now created a nice simple list. Done!!

Hi all, As promised but a little late, a new report. This is my version of the Google Analytics funnel visualization report, this is great for defining a funnel and then looking for those weak pages. As is always the case, if you have any questions or queries then leave a comment and I can get back to you. This report is currently only available from http://www.scribd.com/doc/27322109/Funnel-Visualisation-v1-for-Excel-03 but I hope to have a more versions available soon. Cheers Logical Test

Hi all, Just a quick not to let you know that this report is also available for Office 2003, from http://www.scribd.com/doc/26686010/A-dashboard-style-report-version-2-for-Excel-2003 Also if you have any ways on improving these report then let me know. Cheers Logical Test

I've got my first created report available from: A dashboard style report http://office.microsoft.com/en-us/templates/TC300077811033.aspx Hopefully you'll find this report useful I'll be adding additional notes for this report. But if you are having difficulties or need help just drop a comment and I'll try my best to help. Back soon.... If you have found this useful why not donate via pay pal