Clearly having more spare time on his hand than me (or maybe he’s just not as lazy and bad at writing!) Simon has written up an excellent review of the UK OUG in Reading:
Just like Simon I really enjoyed the event. All the speakers came across really well, and the presentations where excellent.
Personally I […]
The other day a mate asked me to draw him some glass balls, I used Inkscape. Later, because I’m like that, I wondered if I could do it in Excel - this is the result - I don’t think Paint Shop has much to worry about!
I want to qualify this post. It’s 11.20 and I’ve seen away a few.
Having said that this is a idea that was suggested to me by a member of www.eusprig.org
Lets do a little role play – easy Simon ;-).
My name is Dave. I went to Manchester Uni. for 3 years, I’ve work as […]
Sorry for the lack of post, very busty, sorry, busy at the mo.
Anyway, a member of the UK Office user group pointed the product out to me the other day, which i thought i would share here:
http://www.addintools.com/english/menuoffice/default.htm
15 quid, not bad?
Ok, this could be a good chance for a few of us to meet up. I’ve booked my place, have you?!
Inaugural UK Office User Group Event
Also check this out!
There are many different definitions of reporting and analysis.
I was interested to read what Zack at Juice Analytics had to say on the matter. To paraphrase, reporting is for things we know well and are predictable where as analysis if for things that are unknown and erratic. Now I’ve […]
In this the final of my posts around messaging I’ll suggest some ideas that work towards a better experience for users and thus better functioning software. Of course this will not be exhaustive and I encourage others to shear their thoughts, ideas and experiences.
Previous Parts
Part 1
Part 2
Why bother!?!
It’s a fact that handling things well […]
Firstly sorry if I have been messing up your RSS feed, I had a few issues with wordpress, I promise to make better use of the draft option!
Previous Parts
Part 1
Here are the issues I generally have with message boxes.
All message boxes look the same.
But there suppose too! Yeah? Cosmic! That means every time any […]
This will be the first of three posts I’ll make on “interacting with users”, or more specifically message and error boxes! Here’s the outline:
1. The current state of play
2. There’s a problem?… If it aint broke?
3. Suggestions for Improvements
So let’s get started then!
Shocking really! Ok so […]
I’ve just made this easy to use data encryption tool. The encryption algorithm is taken from Rob Bovey’s site.
You can drop your data on to the worksheet (you can add extra worksheets too if you like) and then encrypt the data with the press of a button. You will be asked to provide a key, […]
There’s a new blog in town! Simon Murphy of www.codematic.co.uk has sparked up the old blogging elbow and put figure to keyboard. As you might expect there is some excellent and very interesting content from a very experienced Excel consultant. Check it out here!
Given the list of values 1,2,3,4,1,2,5, an Excel Data>Advanced Filter>Unique Records Only will return a filtered list of 1,2,3,4,5. But 1 and 2 are clearly not unique!
In fact this is often the result we want but still that check box should say, “List unique records and none unique records only once” (or something!)
Further it’s a […]
Here’s something i did not know about VBA!
http://www.puremis.net/excel/cgi-bin/yabb/YaBB.pl?num=1166424720/0#8
Cool, now i just have to get a job at the Natural History Museum.
Last in the series of videos about workbook protection. My new wide screen seams to have effected the video, I could not get it into a editor, and it looks a bit strange in the media player too. Having said that if you need to know how to protect office or Excel files, this will […]
This blog is one year old!, I’ve made about 90 post in that time, not very impressive but hey you miss 100% of the shots you don’t play!
I hope that in the next year this blog will contain more content about Excel and .Net, as well has lots more videos and VBA stuff!
Thanks for reading […]
Krypton Toolkit is a free set of user interface controls for .NET2. There’s not a whole lot of information on the site about the product(s), but i think they are trying to offer Office like controls, (2003 and 07). Might come in handy some time!
http://www.componentfactory.com/purchase.html
Sometimes your inbox is just too funny
god bless eusprig
Cant find a command in the new Excel 2007 IU? this might help:
Excel 2003 to Excel 2007 command reference guide
Love those ribbons…
This is the first video I’ve ever done, still need to work out a few things and I sound a bit different than in real life. This is a very simple example of how to set up worksheet protection. Take a look!
VSTO, (not Vista or VSTA),
Ok, ok here are some videos about VSTO (…emmmm, 2005 SE…)
First is from Andrew Whitechapel and is an example of how easy it is to do something very basic?!. Then it shows some nice solutions. At 6 mins long it does very little to help anyone understand anything, and it’s in […]