Duncan Williamson: the web site!

© Duncan Williamson
5^th April 2009

Management Accounting

Objective

This management accounting section is mainly aimed at the introductory to intermediate reader. I have spent my working life working in management accounting. I am passing on some of my knowledge and expertise here.

Latest

If you are a management accountant you need to see the books I have bought recently ... combined with how I have learned to use Spry Data Sets in Dreamweaver CS4. Go to the management accounting home page and follow the trail.

Want a real live NPV type question? You've got it:

go to the Management Accounting Home page, look at the menu under Control and then click on the Real NPV Example page ... apply your knowledge to something real why don't you? 

Financial Accounting

Objectives

This section has the objective of providing you with a basic review of many of the fundamentals of bookkeeping and financial accounting. The sub objective is that the section introduces some elements of financial reporting under International financial Reporting Standards.

Latest

A good case study on ratio analysis based on Tesco plc, comes with a teaching note for teachers.
A great new page ... on British Petroleum ... taking ratio analysis a stage further: this page helps to illustrate what can come out of an analysis of the results of a company when we use rate of growth or rate of change ratios. You might even be surprised!

Business

Objective

This section is the non financial section of my web site in which I talk about matters of business that are removed from management and financial accounting. This section can contain information on the widest range of topics imaginable that can come under the heading of business!

Latest

I have prepared, October 2008, a simple page on the subject of the reporting of the UK GDP figures. I have done so partly in response to the dreadful way that the BBC and the Financial Times have reported them. Look under Economics and UK GDP in the menu.

Brian Clough: big mouth, football pundit, genius! There are some people whose passing really is a tragedy, Brian Clough is one such. Take a look in the Management section of the menu at the wit and wisdom of the man, as extracted from his autobiography by yours truly!

I read the chapter of a book on managers who have made a difference by changing their organisations: this was on the changes made by Colin, Lord Marshall, at British Airways. I then constructed a case study from it: look at the menu under Management.

MicrosoftExcel and other Spreadsheet Knowledge and Skills

Objective

The objective of the section is to share some of my Excel and other spreadsheeting knowledge and expertise. I am not an expert by any means but I have used Excel to develop proper management accounting models. I have also held many training courses on Excel and my aim here is to share some of the things I do.

Latest

Watch out for my new book: Spreadsheeting with Mr Sprite is my working title as at January 2009! It is a comprehensive and step by step guide to using Excel 2007. You will learn the basics if you need to and then the more advanced aspects of what you need to know to be an effective spreadsheet user. The book is aimed at accountants and business managers and there will be many things that engineers, scientists and even poets will be able to use. If you would like to review this book, in whole or in part, just let me know ... email icon at the bottom left

I have put together a few elements of the debate on good and bad spreadsheet modelling practice. Not everything but well worth reading just to make sure!

My review of Bob Umlas' book tells you it is a must buy: This isn’t Excel, it’s Magic! Look at the book review section for much more of this excellent book.

How about learning how to create a waterfall chart? How about a chart based on data that comes from using a combobox? They're here now! My first real demo, of sorts, using Excel 2007: making a chart communicate more effectively.

Two fantastic pages: one on the VLOOKUP function together with Range Names and the other one on the ISERROR function together with Conditional Formatting. Both of these new pages have beend designed to be used in the context of financial ratio analysis.

You might need to use the XNPV and XIRR functions some day so here's a page that shows you why and how. This page also reveals a minor Excel error and a potentially more serious one. This page is also of use to OpenOfficeOrg spreadsheet users.

Book Reviews

Objective

The objective of this section is simple: I read a book and tell you what I thought of it.

Latest

For anyone looking to spend more than their annual two week holiday on Tenerife, a month or more, for example, please take a look at Going Native in Tenerife by Andrea and Jack Montgomery.

A good read for all football geeks: Provided you don't kiss me: 20 years with Brian Clough by Duncan Hamilton

For cost accountants, take a good look at Andrew Wileman's Driving Down Costs.

If you are serious about Excel spreadsheets you must read Bob Umlas' My review of Bob Umlas' book is a must: This isn’t Excel, it’s Magic!and there is Alastair L Day's Mastering Financial Modelling in Excel that is good but is more specialist than Bob Umlas' book.

Liz Smith's Our Betty is an idiosyncratic autobiography of the nation's favourite mother/in law ... she's the mother in law from the Royle Family television programme!

My Blogs: now we are twain!

Objective

I've got two blogs now: my original personal blog, Duncan's Diurnal Diatribe (DDD1) and now my new one, Duncan's Diacritical Discussion (DDD2) which will concentrate on my writings on business and kindred matters.

My personal blog is where I let off steam, put the world to rights and generally enjoy myself. The new blog contains accounting, business and non accounting and non business things.

Examples

The by line of Duncan's Diurnal Diatribe tells you all you need to know really: some serious and some lighthearted ramblingsfrom a Tyke!This is the most dynamic part of my web site so trying to list its latest content would be futile. However, just to give you some idea of what I talk about, here are the headings from the last week or so.

• Free entertainment needed? Sit near the hat rack
• ... as others see us
• Taxi Sir?
• Is it a barrage balloon or just a balloon?
• Pony tails on men
• Are you sure?
• Long legs: top travel tip

The by line of Duncan's Diacritical Discussion is the ruminations of a realistic writer on the behaviour of business and that is a big hint too! The first article in this new blog concerns General Motors, GM:

• Why GM needs massive reoganisation

There you are, enough to whet your appetite!

 

eShop: about Duncan Williamson

Objective

This section is purely aimed at the (corporate) buyer who wants to know why they should use my services; and for non corporate buyers to see some of the few materials that are available for sale from me.

Latest

I am a self employed author, consultant, educator and trainer ... you need to know what I can do for you. Here is my sales pitch! I specialise in:

• management accounting
• financial accounting
• spreadsheet modelling
• simplifying difficult concepts
• redefining the idea of giving 100%
• my own web site

I have

• spent my entire career working in the areas of management accounting, financial accounting, education, industry, commerce and programming spreadsheets!
• spent a lot of time writing books, manuals, case studies, articles, papers, presentations, spreadsheet models … an absolute mountain of things.
• dedicated my life to working to very high standards and to working quickly. Built up an encyclopaedic knowledge of management accounting, financial accounting and financial management.
• learned a lot about business life in general: his web site shows that if nothing else.
• acted professionally and in amateur dramatics. As a professional actor I appeared on National Radio in Malawi, taking a leading role in a play entitled Sasintha. In amateur dramatics I have appeared in a number of productions both in the UK and in Malawi.