Logical Test

If you use dynamic dates and would like for the dates to not show excessive characters then try the below formula, just replace [start date], and [end date] with the fields that contain the start and end date…..   =IF(AND(DAY([Start date])=DAY([End date]),MONTH([Start date])=MONTH([End date]),YEAR([Start date])=YEAR([End date])),TEXT([Start date],"D Mmmm YYYY"),IF(AND(MONTH([Start date])=MONTH([End date]),YEAR([Start date])=YEAR([End date])),TEXT([Start date],"D")&" - "&TEXT([End date],"D Mmmm YYYY"),IF(AND(YEAR([Start date])=YEAR([End date])),TEXT([Start date],"D Mmmm")&" - "&TEXT([End date],"D Mmmm YYYY"),TEXT([Start date],"D Mmmm YYYY")&" - "&TEXT([End date],"D Mmmm YYYY")))) Examples and what will happen…  5 March 2010 – 5 March 2010  Will equal…. “5 March 2010”  5 March 2010 – 6 March 2010 Will equal…. “5 – 6 March 2010”  5 March 2010 – 6 April 2010...

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

Ok so its been about a week since I uploaded the second version of the Dashboard style report , there are not a huge amount of changes from the first, however in my opinion I feel like I have cleaned up the whole report. The main changes are that the charts are little bit more dynamic for the user, allowing for different data to be displayed and all the data has been moved into its own spreadsheet. I’m thinking that it would be quite cool for the user was if the four charts were completely in their control they select the type of information they want and the data that they want to display, but I’ll look at into that later, unless of course people really want it, but you have to let me know. I’m not sure what sort of reports you would all like but hopefully should be uploading my second, this is loosely based on the funnel visualisation available in Google Analytics (free website analytical tool). This will mainly show the visual representation of what you can create in excel and it u...