roadshow

>
 
>
avatar
The Excel roadshow avoided the worst of the winter weather in visiting Bristol this week. As always, one of the most exciting and challenging parts of the course is trying to come up with answers to the numerous questions asked during the break. One...
avatar
I've just survived the opening performance of the new 'More Power to your Pivot' course in this season's series of roadshows. One aspect of the course shows how PivotTables can be used as the data source for an information dashboard.



This sma...
avatar

Implementing XBRL

by Paul Booth on 17.10.2010 15:24
As promised, here is the our Implementing XBRL publication, available for download; and here are my slides from the 1 October event of the same name.

The Implementing XBRL roadshow is due to visit five more locations during...
avatar
Most Faculty Excel roadshows provide some inspiration for IT Counts articles and today in Exeter was no exception. I was demonstrating the use of Excel’s data validation feature to create a drop down list for a user to select from – a technique a...
avatar

IT Counts has addressed the spreadsheet v. database argument in the past and a question that often crops up during the Faculty roadshows is: how do I know when I should be using a database rather than a spreadsheet?

Microsoft has contributed th...
avatar
The faculty 'Making Better Use of Excel' roadshow starts in Chartered Accountants Hall on 16th March and finishes in Adnams Brewery on 15th June. Full details are on the faculty's events page. Click on the video below to see some brief extracts of ...
avatar
It's almost exactly a year ago that one of my clients accused me of being responsible for the recession. He felt that spreadsheet errors had almost certainly played their part in the financial collapse and that, as someone who spends much of their t...
avatar

 

The third roadshow query looking for an array solution involved the need to compare different rows of data to see how many non-zero cells in row one were next to non-zero rows in row two. This took perhaps more thought than it should have done as I kept forgetting the need to use SUM() to total the result of the array formula. Anyway this was the eventual array formula:

avatar

In the first part of this short series we introduced the concept of array formulae and looked at a simple example where the use of a SUMIF() function referring to an external workbook was replaced by an array formula to enable it to continue to work even if the external workbook was closed. This is a similar example which again came from a question at a recent roadshow. In this case a worksheet was returning error messages when a linked ...

avatar

Introduction

Excel array formulae are not straightforward. In some ways they can be as complex and difficult as most Excel users would like to get. Often there are simpler and easier alternatives to using array formulae, but sometimes arrays are either unavoidable or the least bad option. In the last few weeks of doing Excel lectures, I’ve been set three separate challenges for which an array formula is a possible solution.

Let’s try and ex...