Subscribe

Why not subscribe to Logical Test and keep up to date with the latest articles and free templates...

Newsletter subscription

Just enter your email address in the field provided, to get Logical Test in you inbox.


Subscribe using...

We have a number of other ways for you to stay in touch with Logical Test.
Subscribe to our RSS feed

Subscribe...


We have a Twitter page.

Follow us...


We have a Facebook page.

Become a friend...

Popular posts from this blog

Dashboard style report - How to create a list?

Image
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!!
Read more >>

Just checking in....

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...
Read more >>

Funnel visualisation report

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
Read more >>