Book Three Arrived

My third book of the summer has just arrived ... Here it is and it's available from amazon.co.uk in Kindle and print format.

This is a much shorter book than The Excel Project book and it is aimed at beginners.

DW

Depreciation ... real case examples

In my new book, Introduction to Management Accounting, ready for publication within two weeks of so from now, I will provide up to date car price information for three cars:

• BMW 320d
• Volvo S80
• Porsche 911

I mention this because my web site includes a page in which I provide two examples of how to use real car price data to estimate a depreciation function. The reason for doing this is to test whether we are using the appropriate method of providing for depreciation.

There is nothing wrong with the examples on my web site but as I was writing the book I felt I ought to use up to date data ... I might leave the old data there too, I will decide later.

Anyway, watch out for the book and the updated web page; but there is nothing wrong with the web page as it is as the methods I use there are still appropriate.

Duncan Williamson

Book Number Three: Excel Work Book: introducing the basic concepts of Excel spreadsheets

I have just finished my third book of the summer, Excel Work Book: introducing the basic concepts  of Excel spreadsheets.

It's only one tenth of the size of my magnum opus, The Excel Project but it is full of great ideas and examples.

The book is, as the title suggests, aimed at beginners or raw recruits to the world of spreadsheeting and it will appear on Kindle at just GBP1.99 within 24 hours or so. I will add the link here as soon as I get it.

Take a look if you are a spreadsheet beginner, you won't be disappointed!


Duncan Williamson

Excel Book Submitted

I have finished my Excel book now and I have uploaded it to Kindle.

It is being reviewed now so I will have to wait to post full details here.

Within spitting distance of 600 pages.

DW

Excel Pivot Table Slicers: be excited!

This post has a two fold aim:

embedding an Excel file in a blog post
showing you how Pivot Table Slicers could change your life

Look at the work sheet that follows!

As far as I can tell, the embedded worksheet that you see below is not interactive in this post so ... Click on the icon in the bottom right hand corner of the embedded file here ... View full size workbook: you will see the whole Excel file then and it IS interactive.

Click on the buttons in the work sheets ... select two or more buttons by ctrl+left click ... then watch the way the chart changes ... take a look at the linked Pivot Table too ... it changes as you select and deselect the buttons ... click on the slicer buttons and see what happens to the Chart! The chart looks terrible when this file first opens ... it's meant to as it's all part of the effect!!


Feedback??
DW