Hi, I'm Glen Feechan. Welcome to my blog - Not Just Numbers.

I am from Sunderland in the North-East of England and Chief Executive of
Feechan Consulting Group. Take a look at my LinkedIn profile if you want to know more.

Through this blog I aim to provide useful and/or entertaining content for those responsible for the financial side of their businesses. Although aimed loosely at finance directors, I have many subscribers from managing directors at one end to anyone who ever opened a spreadsheet. I aim to stay away from the hardcore accounting stuff - there are plenty of places to get that if that's what you are after, but finance is Not Just Numbers.

You can also sign up to the free Not Just Numbers monthly ezine (over to your left) and get a free report, the monthly ezine and regular updates of new posts to the blog.

Also have a look at the
freebies section of the blog for free training videos, etc.

I hope you find the content useful and that every now and again it makes you smile.

Regards

Glen Feechan

Email me         Connect on LinkedIn      Follow me on Twitter
Glen Feechan

Tuesday, June 16, 2009

Free Video: Record a Macro in Excel

I very briefly posted this video over a week ago, not realising that the competition that Emily of AskM had entered it in, restricted its use elsewhere on the web until the competition was finished.

The good news is that the competition has finished, and the better news is that the video reached the top 5.

It will teach you how to automate a task (or series of tasks) in Microsoft Excel 2007. If you like this video, you can also learn how to create a pivot table.




If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates, our monthly ezine and your free report.

Friday, June 5, 2009

Get Not Just Numbers headlines on your website

We have many readers who have their own accountancy or consultancy practices and/or financial blogs/websites.

If this is you, I have now made it easier to include Not Just Numbers headlines on your site. Simply click on the Get Widget link below to get some code for you (or your web developer) to paste into your html. This will place the widget on your site/blog.





If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates, our monthly ezine and your free report.

Why is Gordon Brown's cabinet like Blake's 7?

The best description I have so far heard of what is happening to Gordon Brown's cabinet came from comedian Mitch Benn via Twitter, where he likened it to the last five minutes of the '80s Sci-fi series, Blake's 7.

I must admit I needed a refresher on that one but after watching it again, I can see exactly what he means. I thought it might be a nice Friday afternoon distraction for you, so I have embedded the the video below.

I think you'll see what I mean - enjoy:






If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates, our monthly ezine and your free report.

Thursday, June 4, 2009

Excel Tip: Dropdown boxes in Microsoft Excel

This is a one you either know how to do or you don't. Either way, you will know how to do it after reading this post.

You will almost certainly have used dropdown boxes, if not in Excel, on the web. They are a great way of speeding up input of data and eliminating user errors. In Excel, they are really easy to do.

First of all select the cell, or range of cells, where you want the drop-down list to appear, then, from the Data menu, select 'Validation'. This opens the following window:


In most cases you will choose 'List' from the 'Allow' box. This will introduce a new box entitled 'Source'. In this box simply enter your list, separated by commas. You can then click OK and you are done.

For a longer list, or one you may want to edit regularly, you can name a range somewhere else in the workbook that contains the list items and enter =Range Name in the 'Source' box, obviously replacing Range Name with the actual name of your range. When defining this range, allow space below to add new items if this is a possibility.

A new box will also have appeared below 'Ignore blank' entitled 'In-cell dropdown', leave this ticked.

If you wish you can add an input message to guide the user on the second tab and/or a tailored error message (on the third tab) for when someone types something that is not on the list. These are refinements and certainly not necessary for most internal uses at least.

And there you have it - dropdown lists.

If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates, our monthly ezine and your free report.

Tuesday, June 2, 2009

Accounting in the cloud

I was sitting in the office the other day and noticed that my colleague, Gillian, and myself were sitting working entirely on the internet. She was updating our accounting transactions on the rather brilliant Kashflow, and I was processing payroll on the unbelievably free Payroo.

Cloud Computing is the term being used for these types of applications, accessed entirely on web servers through a browser, and it is an exciting area that poses real threats to established software vendors.

Solutions tend to be cheaper (often free), easier to learn, better supported, easier to share (internally and externally) and with minimal setup and hardware costs - typically nil!

With complete office suites such as GoogleDocs gaining acceptance too. Next time you are looking for software for anything, check whether you can do it 'in the cloud' before you shell out the cash.

If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates, our monthly ezine and your free report.

Thursday, May 28, 2009

IT Expenditure - putting the cart before the horse

Why businesses spend huge amounts on ineffective IT investments.

by Glen Feechan


Another IT White Elephant!
It seems that almost every day we read in the newspapers about another hideously over budget IT project that doesn’t achieve its expected benefits. The ones we read about are usually major multi-million pound projects in the public sector, however this is only the tip of the iceberg.

Many more projects achieve similar results in the private sector, in organisations large and small. These may be anything from the purchase of a new off-the-shelf accounting package for an SME, or a large-scale fully-integrated ERP implementation across multiple sites and countries. These do not usually make the headlines due to the commercially sensitive nature of this information.

Does this mean that the technology is over-rated or that we cannot manage IT implementations or is there something fundamentally wrong with the approach?

Where are we going wrong?


“Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.”
Andy Rooney, US news commentator (1919 - )

I wouldn’t go as far as the above comment, however there is an element of truth in it.

Typically the IT implementation is seen as the solution to the particular problem (or problems) being addressed, but this is rarely the case. Often the introduction of an IT “solution” can compound a problem as there is now less opportunity for the human intervention that previously stopped problems from becoming crises.

The problems usually lie in the business processes (both formal and informal), irrespective of whether these are carried out by computers or human beings. Automating these processes can simply have the effect of making the problems happen faster!

The obsession with IT as the solution to every major business issue is compounded by the marketing departments and sales people of software developers selling it as such. Until executives address the underlying processes first, we will continue to see streams of failed, expensive IT projects.

Addressing the real problem

To take a process approach to the problem, we need to understand (in some depth) the informal processes carried out every day by employees. These are not the processes that managers think they carry out, and are rarely as laid out in the ideal world of an ISO manual. We regularly find, when working with clients’ employees, that managers are unaware of a large percentage of the processes carried out in ensuring that the job gets done. This is not a criticism of the managers - the level of information overload that this would involve would render them ineffective.
Working with employees so that they can map out their processes in this level of detail and re-engineer them to resolve the perceived problems can have a radical effect with no IT expenditure.

Targeted IT Expenditure

So far I have probably given the impression that I have a “downer” on IT. This could not be further from the truth - the problem I have is with the way IT expenditure is usually approached, and the problems that this approach creates.

Having addressed the process issues, IT expenditure can then be used to facilitate the new process, targeting those areas that would benefit most and significantly multiplying the benefits of the process improvement exercise itself. This expenditure can often be in entirely different areas to those originally envisaged.

Conclusion

Organisations have benefited greatly from IT investments over recent decades and will continue to do so. However, the risks attached to these investments are significantly reduced (and the resulting benefits significantly magnified) if the underlying, informal processes are addressed first.
If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates, our monthly ezine and your free report.

Monday, May 11, 2009

AC/DC rock inside your Excel spreadsheet!

One of the most bizarre uses of Excel. An AC/DC rock video within the spreadsheet!

Watch the video below, or download the spreadsheet itself at http://www.acdcrocks.com/excel.




If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates, our monthly ezine and your free report.
Try these other services from Feechan Consulting Group: