It’s Sunday morning in the Perkins household. My wife, Natalie, is fast asleep still after having a nightmare (should I be sharing that? Oh well) and I’m pondering the future of my website. As you might remember, I moved my blog to http://www.nicholasperkins.com/blog/ a few week ago, and there was a reason for this.

Recently I’ve been working with Drupal a lot. I worked on getting Natalie’s new portfolio site up and looking awesome (if I do say so myself). Drupal is not really a CMS, although it can be used as one. Drupal is more of  framework that gives web developers the tools to create very complex sites without having to hand code thousands of lines of PHP.

In the case of Natalie’s site, I still needed to hack into some of the modules code, wrote a few lines of customer PHP database lookups to create the dynamic sub-menu and a few other bits and bobs. What I didn’t need to do is create an entire CMS from scratch. When I wanted to have a new content type for her portfolio images, I didn’t need to design the database structure and code the posting and editing and whatever else functions. Drupal just made it happen.

So I’m now considering moving my blog across to Drupal as part of a larger site redesign. I’m currently looking at creating a main website for my Excel and PHP development business, which is why I moved the blog. It will be a few months before I have the design and content ready to go up though, but that gives me plenty of time to get Drupal into shape.

What I am wondering is whether I should transfer my blog into Drupal and away from Wordpress.

Wordpress is probably the best blogging software I have ever used. The interface is clean and easy to use, the plugin and themes are so easy to install, configure and “just work”. When I helped Natalie with http://www.axisoffat.com/ (it’s on Drupal as well) I wondered if it was really the best option. It did work out in the end but it required more fluffing around to get it to work just the way we wanted it to.

I’d be interested in your thoughts on both Drupal and Wordpress, but also any other CMS/Framework solutions you have used. The decision on what I use for my own site is critical. Whatever I choose I will have to work closely with and become and expert at using and modifying as required so that I can offer similar services to my clients.

I work in the public sector in a finance department. This requires me and my co-workers to interact with numbers every day. So it is natural to think that in this environment that spreadsheets, and particular Excel spreadsheets, would be used all the time. And that those who were there would be the best at using such a tool for analysing financial data and all the other stuff you can do with spreadsheets. You’d be wrong.

When you think about it, it is perfectly understandable. They are general data entry/administration roles where data entry skills and the ability to process, process, process is the key. You get taught how to use the accounting package in use in the area, told how to do the tasks of your job and you get on with it.

You can get away with being an excellent data processor and not need to worry about Excel too much, other than to punch in some data (usually lists of numbers or figures) and to use the auto sum button to add things up.

Yes it is possible to do Gantt Charts. It just takes some tweaking and know how.

I’m a bit different though and a bit lucky. Why? Well let me give you “The Brief History of Nicholas Perkins” – Computer Stream.

I have a programming background, having coded my first BASIC script on the Commodore 64 when I was about six or seven years old. I used to get books from the library and copy the code into the machine and run it. Then I’d have a go at writing other stuff. This continued on through to high school, where I learned some PASCAL and SQL.

I then decided I wanted to be a music teacher (WTF?) and went to university.

After realising my mistake, I ended up dropping out and spent the next five years either in part time work or out of work. I coded HTML, CSS and PHP (back when it was PHP3) mainly for fun but also for a little bit of profit. I also worked as a PHP coder for a small business for about three months. Shame the pay packets never arrived.

One thing lead to another and I was on my way to a job in the public service in an administration role. I was good and finished my traineeships course within six months rather than twelve.  I had experience with word processing and spreadsheets from school and from some work experience I had done previously.

What helped me most was three things.

1. My self taught programming background;
2. My affinity with computers; and
3. My ability to research and teach myself what I needed to know.

So now at work I’m a (relative) Excel Guru. I’ve taught myself how to write Excel macros (when you think about it, it’s not surprising) and asked to go on an advanced Excel VBA course through work, which taught me about forms and better refining hand coded macros. I write spreadsheets to take the boring and repetitive tasks and automate them.

You have data in one format and need it in another? Excel macros can make that happen. You want a nice, clean data entry form for your excel data? Done. Data validation? No problem.

So why mention this? Because I want you to understand that if you are confused by Excel, you are not alone. It’s not you, it’s just that  no one has ever shown you how awesome it can be and how easy it can be to use. You maybe don’t have the programming/mathematical background of some of the self taught Excel gurus out there. You can learn. Or just hire someone like me to help you.

I hope to start helping with that by providing tips and tricks that I’ve picked up along the way. Drop me a comment if there is something you are particularly interested in.