Duncan Williamson: Spreadsheet home page spread.htm

Click on the Excel link in the menu on the left of this page to look at my PDF files on Templates in Excel ... it's all explained in the introductory page. Here also is my first demonstration, of sorts, using Excel 2007. I have taken a graph that's been produced by someone else using Excel 2003 or even earlier; and changed it by using Excel 2007. I have only changed the appearance really although I did tweak the axes too.

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.

An example of the application of the Chi Squared test: data and analysis with conclusion but no discussion.

A small update to page one of my Lorenz Curves mini series: I added the UK Gini Coefficient data by way of a graph for the period 1979 to 2002.

Two page series on plotting and analysing trends using Excel: these are relatively large pages as I had to code them using MS Word's ballooning Web Page option, otherwise I would have been coding for weeks. Aimed at the introductory Excel level.

Here's a new page that shows how we can use a spreadsheet to take a list of accounting transactions and build a Trial Balance from it ... automatically ... using the magic of a spreadsheet!

If you're interested in Permutations and Combinations, look no further. A page of maths with a bit of spreadsheeting thrown in.

A list of the shortcuts that I find most valuable plus some examples of how to use the REPT function, conditional formatting and custom formatting. All great stuff!

I don't now why I've ignored them until now but DATA TABLES are a wow! I strongly recommend them ... read about them here!

a page on using Excel's SOLVER function: we've used a simple example to demonstrate SOLVER but it really is a very powerful function that's well worth working on.

I have put together a page on drawing box and whisker diagrams, boxplots, using MS Excel. A fairly simple routine that draws on other people's work but I added a bit of formatting to help it all along!

These pages are still here, of course: SUMIF used to generate a profit & loss account; and Import External Data utility used to take data from the Internet

Using SUMIF to generate a Profit & Loss Account ... or any other account for that matter!

SUMIF is one of Excel's built in functions and even though it's been around for a long time, I think it's day has finally come!

The page on using SUMIF to generate a profit & loss account may shock and amaze you; but you'll certainly find it more than useful.

I've presented it in accounting terms but I can imagine anyone who needs to manipulate any data will find this page more than useful.

Import External Data with Microsoft Excel

What this page describes is how Excel XP/2002 allows us to import data directly from the Internet without ever having to go to the sites we are downloading from.

The Import External Data page takes us through a series of examples that explore the main parts of this excellent utility.

Work through Excel's default examples and then work through real live examples that will help to encourage you to start using and benefiting from this utility immediately.

With practice we will find that this utility is both simple to use and will quickly take us the point of believing that we cannot live without it any more!