Telephone:
020 3397 1333
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"8d45c":{"name":"Main Accent","parent":-1},"f9a69":{"name":"Main Accent Light","parent":"8d45c","lock":{"saturation":1,"lightness":1}}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"8d45c":{"val":"var(--tcb-skin-color-0)"},"f9a69":{"val":"rgb(235, 246, 251)","hsl_parent_dependency":{"h":210,"l":0.95,"s":0.66}}},"gradients":[]},"original":{"colors":{"8d45c":{"val":"rgb(55, 179, 233)","hsl":{"h":198,"s":0.8,"l":0.56,"a":1}},"f9a69":{"val":"rgb(235, 246, 251)","hsl_parent_dependency":{"h":198,"s":0.66,"l":0.95,"a":1}}},"gradients":[]}}]}__CONFIG_colors_palette__

Get more from your spreadsheets

We've spent many years working with our clients to 

  • Train staff with the latest Excel skills
  • Fix existing issues with business-critical spreadsheets
  • Create new systems and templates using Excel
  • Integrate Excel with other applications

Now you can learn from us too!

Browse our knowledgebase of Microsoft Excel articles

We're adding to our Excel knowledgebase all the time, so why not sign up at the bottom of this page to be the first to know when we publish new content? Functions, database functionality, VBA and more - delivered straight to your Inbox!

Sign Up Now and Never Miss Out!

Don't miss a thing!

We publish new content regularly, so be the first to hear about it by signing up now!

Using RAG statuses with dates in Microsoft Excel

The problem I recently had a plea for help from a client for whom I was running an Excel training course. They wanted to highlight dates an Excel worksheet in various ways – red for dates in the past, amber for dates in the next week, yellow for dates a couple of weeks away, and

Read More
Using RAG statuses with dates in Microsoft Excel

There is a bug in Excel…

Excel gets maths wrong sometimes… Do you use Excel regularly? And do you trust that if it says something’s true, then it’s probably true? Perhaps not in the area of global politics, or issues around faith and ethics, but you can rely on it when it comes to maths, right? We’re not talking high-level, professor

Read More
There is a bug in Excel…

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.

Read More
Advanced Excel conditional formatting video tutorial (part 2)

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

Read More
Advanced Excel conditional formatting video tutorial

Microsoft Excel Pivot Tables – video guide part 2

In the first part of our video tutorial, we looked at the basics of what PivotTables are, how they work, and how to create them. In this second part, we’re going to take a look at some ways in which you can extend your PivotTables, to include: Grouping dates, so that they can be summarised

Read More
Microsoft Excel Pivot Tables – video guide part 2

Microsoft Excel Pivot Tables – a video guide

Let’s debunk some PivotTable myths Myth 1: PivotTables are better than chocolate. They’re not. But it is a close-run thing. If you’ve ever needed to work with large amounts of data, and actually make sense of it, PivotTables are for you. If you’ve got 100,000 rows – or even just 400 rows – of data,

Read More
Microsoft Excel Pivot Tables – a video guide

Experience THe Difference - Now!

Want to learn more? Take a look at our online courses!

For the first time ever, our training is now available online. 

Now anyone, anywhere can experience the quality of training and the depth of knowledge that makes our courses different.