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

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

Top 10 Microsoft Excel tips (Part 1)

Save time with Microsoft Excel At The IT Service, we spend a very high proportion of our time helping people to get more from Microsoft Excel. This can be through Microsoft Excel training courses, through spending time working with clients on optimising their spreadsheets, or just generally in answering the sort of "How do I..." [...]

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?