About Andrew Richards

Andrew Richards is the Managing Director of TheIT Service. His background in training goes back to 2000, and he was involved in IT networking and support beyond that. Now he spends his time living and breathing the GDPR (fun!) and building databases. When not doing these things, he can be found attempting to train his various sheep and chickens.

We are hiring!

Due to our continued growth, we need to speak to you if you are a... Microsoft Access / SQL / VBA expert with great interpersonal skills This is a fantastic opportunity to make an impact in a dynamic company. We would love to talk to you if you have Real, in-depth understanding of relational databases [...]

By | 2012-10-15T15:02:45+00:00 October 15th, 2012|News, Uncategorized|0 Comments

Our latest feedback

Back in the height of the summer (such as it was) we promised to keep you up-to-date with our latest feedback each month. We've been a bit remiss since then - our list of happy customers has been growing, and we've been getting busier and busier - so this is the first chance we've had [...]

By | 2012-09-25T09:38:50+00:00 September 25th, 2012|Feedback, News, Uncategorized|0 Comments

The IT Service is moving!

Following the success of our first three years, we're moving to London!

July marks our third birthday - and it's all change for us. Due to our continued growth and success, we've made the decision to move from our base just south of Guildford, and set up in bigger offices in the Wimbledon area.

It's a really exciting move for us - and one which we'd like you to help us celebrate with a special discount

By | 2017-06-09T09:59:36+00:00 July 1st, 2012|News, Uncategorized|0 Comments

Excel’s Concatenate function without limits!

Get over the limitations of the built-in CONCATENATE function in Excel.

In this post we take a look at writing an alternateive to Excel's concatenate function, which both overcomes the limit on the number of values that can be concatenated, and also allows a delmiter to be specified, such as a comma, beteween values.

Advanced Excel conditional formatting video tutorial (part 2)

Creating dynamic forms with Conditional Formatting
In this video tutorial we take a look at using conditional formatting to make Excel forms dynamically respond to user entries.
For example, display "Additional info" fields when users select a particular value, or display multiple sections based on user input elsewhere.

Advanced Excel conditional formatting video tutorial

Get more from Excel's Conditional Formatting tools

Excel's conditional formatting tool really got beefed up with the new options introduced in Excel 2007. But in this video, we show you how to do more with conditional formatting - whether you're using Excel 2010 or Excel 97!
Learn how to... - Highlight a whole row of data based on a condition in one cell
- Change a value with a scroll-bar control
- Make conditional formatting more dynamic

New clients! Welcome to you all!

A chance to say a big thank you!

It's been a packed few months for us at The IT Service. As well as developing multiple database for existing clients, we've had a great time meeting new customers too.

Whether it's an in-depth look at how an existing database can be better structured, or a whistle-stop tour around the key features of Office, an introduction to XML or a look at creating a system to link Outlook and Excel - we've seen it all in the past few months!

Here's just a little of what we've been up to, and who's joined us since the start of the year...

By | 2012-04-26T16:05:36+00:00 April 26th, 2012|News, Uncategorized|2 Comments