“The best Microsoft Office training we’ve ever had…”

Every course built to your exact needs.

Your work, your files, your location.

Our customers love us. Become one now, and let's do something special together.

We operate throughout southern England, and we come to you, so that you're in a familiar environment and not away from your desk all day. We use your data and your files to make certain everything is truly relevant.

And because we don't charge per person, if you find on the day that there's someone extra, that's fine. Or you suddenly find that there's something else you need to cover that wasn't in the original outline - that won't be a problem.

Whatever you need, whoever you are, whatever you do, we have the experience and the expertise to make sure that this is the best training you've ever experienced.

Call us now, on 01483 277172, or contact us via this site, and start something amazing.

Recent feedback

Trainer was really good - enthusiatic, worked at the right pace and considering the different needs was able to include all of us. I found the training clear and concise and learnt many new and useful things that had always been there, I just didnt know about them. Really found the training invaluable - 2 May 2012

Completely satisfied with both content and delivery. Very impressed - 11 April 2012

The trainer exhibited a highly professional attitude prior during and after the training course - 11 April 2012

Well delivered and clearly explained - 9 March 2012

Informative , relaxed and bespoke catering to my level - 5 March 2012

At-a-glance training course list

Microsoft Access 2007 / 2010 courses Microsoft Access 2003 courses
Microsoft Excel 2007 / 2010 courses Microsoft Excel 2003 courses
Microsoft Access VBA courses Database design training courses
Microsoft Excel VBA courses Office VBA and Macros courses
Microsoft PowerPoint courses Microsoft Word courses

If you'd like to take your knowledge of these applications to another level, just give us a call on 01483 277172, or fill in the form on any page on our website - we'd love to hear from you!

Join the conversation! Follow our blog

Recent blog posts

Advanced Excel conditional formatting video tutorial (part 2)

May 3, 2012

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.

Read more

Advanced Excel conditional formatting video tutorial

April 30, 2012

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

Read more

New clients! Welcome to you all!

April 26, 2012

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

Read more

A Microsoft Access tool to automatically rename your form controls

April 4, 2012

I love Microsoft Access. There, I said it. Thare are so many things I love about it that I wouldn't know where to start with listing them all. So, it's just as well that this article isn't about that. It's about fixing one of those things that's just a bit of a pain. Use prefixes for your controls? Access doesn't! I remember the first time I attended an Access course all those years ago. "It's a good idea to name your forms with a prefix of frm, your tables with a prefix of tbl..." and so on, said the instructor. And that made sense. So I was a bit surprised when we used the wizard to make a form from our table called tblCustomers. Access asked what to call the form and being told "frmCustomers" decided to add heading label in nice big, bold characters saying "frmCustomers". And ...

Read more

The InputBox Function, the InputBox method, and using strptr

March 22, 2012

The InputBox is one of the most commonly called functions in the whole of VBA. Whether you're writing a complete database application in Microsoft Access, or just adding bit of functionality to your Microsoft Excel workbooks, the odds are that you won't do much coding before you make your first call to the InputBox function.

So, I thought I'd dedicate this post to getting a little more from the InputBox - particularly in Excel, but also in Access.

Read more
  • Advanced Excel conditional formatting video tutorial (part 2)
  • Advanced Excel conditional formatting video tutorial
  • New clients! Welcome to you all!
  • A Microsoft Access tool to automatically rename your form controls
  • The InputBox Function, the InputBox method, and using strptr

A la carte training

What you want from a course won't necessarily be what other people might want.

So rather than telling you what's in our course, we'd rather you tell us what you want.

Browse our menu of topics, each with a guideline of how long it might take to complete. And give us a call to kick things off.

Take a look now

Consultancy

A macro to tidy up your Outlook inbox into folders named by month.

A database to import CSV files from your suppliers, track your sales and then email your clients with a monthly statement and invoice.

Both examples of work we've done of late.

What can we do for you?

Database design work

Whether you want to be guided in the process of designing a database, or want us to do the whole thing for you, we'd be delighted to help.

Our clients in this field have ranged from music marketing to publishing, from manufacturing to hi-tech laboratories - so we have the skills and experience to help you get what you need.

Find out more...

Get in touch!

Whatever you want to talk about - whether its training or consultancy, we'd be delighed to call you back, just fill details and we'll be in touch very shortly.

How can we help?