Microsoft Access basics: How to manage Linked tables

This is the final part of a three-part series of tutorials on Linked Tables in Microsoft Access. If you've missed out on the previous parts, then you may want to take a look: Part one: Why create linked tables in Microsoft Access and then Part two: How to create linked tables in Microsoft Access. In [...]

Microsoft Access basics: How to create Linked tables

This is part two of a three-part series of tutorials on Linked Tables in Microsoft Access. If you've missed out on part one, then you may want to take a look: Why create linked tables in Microsoft Access. In this second part of the tutorial, we're taking a look at the practical nuts and bolts, [...]

Microsoft Access basics – tables, forms, queries and reports

This is the first in a series of posts we'll be creating over the coming months about the fundamentals of Microsoft Access. This series has been devised to answer the questions that everyone has when they start using Microsoft Access for creating databases, or when they first begin to use existing Microsoft Access databases. The [...]

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

Microsoft Word – making vertical selections

Boost your knowledge of Microsoft Word!

One of the first things you find out when using Microsoft Word is that clikcking and dragging selects text.

But doing so selects one or more entire lines. What if you just want to select the leftmost couple of inches of your page to make that text bold? Or apply some special effect to the right-hand few centimetres?

In this post we take a look at how you can select vertical portions of your document.

Excel subtotals tutorial

Learn how to summarise your data with Excel's Subtotal tool Excel offers lots of tools for analysing your data, from the simple formula to the mighty PivotTable. Somewhere between the two sits the "Subtotals" tool. This nifty option allows you to group your data into sections, then get totals for each section. Excel automatically writes [...]

Get in touch now!
Close X

Get in touch today!

Call us now on 020 3397 1333, or pop your details here and we'll get back to you.

Your Name *

Your Email *

Your Phone *

Your Company *

How can we help?