Fran gets Another Honour

Daughter Fran has just been awarded another honour from another UK University ...

Well done again!

DW

Excel Solutions ... book 3

It's here now ... http://bookboon.com/en/excel-solutions-for-accountants-book-3-ebook

DW

The Chaos by Gerard Nolst Trenité

I think this poem is the best poem I know: http://ncf.idallen.com/english.html If you think you know English or you are learning it, this is for you. Gerard Nolst Trenité - The Chaos (1922) Dearest creature in creation Studying English pronunciation, I will teach you in my verse Sounds like corpse, corps, horse and worse. I will keep you, Susy, busy, Make your head with heat grow dizzy; Tear in eye, your dress you'll tear; Queer, fair seer, hear my prayer. Pray, console your loving poet, Make my coat look new, dear, sew it! Just compare heart, hear and heard, Dies and diet, lord and word. Sword and sward, retain and Britain (Mind the latter how it's written). Made has not the sound of bade, Say-said, pay-paid, laid but plaid. Now I surely will not plague you With such words as vague and ague, But be careful how you speak, Say: gush, bush, steak, streak, break, bleak , Previous, precious, fuchsia, via Recipe, pipe, studding-sail, choir; Woven, oven, how and low, Script, receipt, shoe, poem, toe. Say, expecting fraud and trickery: Daughter, laughter and Terpsichore, Branch, ranch, measles, topsails, aisles, Missiles, similes, reviles. Wholly, holly, signal, signing, Same, examining, but mining, Scholar, vicar, and cigar, Solar, mica, war and far. From "desire": desirable-admirable from "admire", Lumber, plumber, bier, but brier, Topsham, brougham, renown, but known, Knowledge, done, lone, gone, none, tone, One, anemone, Balmoral, Kitchen, lichen, laundry, laurel. Gertrude, German, wind and wind, Beau, kind, kindred, queue, mankind, Tortoise, turquoise, chamois-leather, Reading, Reading, heathen, heather. This phonetic labyrinth Gives moss, gross, brook, brooch, ninth, plinth. Have you ever yet endeavoured To pronounce revered and severed, Demon, lemon, ghoul, foul, soul, Peter, petrol and patrol? Billet does not end like ballet; Bouquet, wallet, mallet, chalet. Blood and flood are not like food, Nor is mould like should and would. Banquet is not nearly parquet, Which exactly rhymes with khaki. Discount, viscount, load and broad, Toward, to forward, to reward, Ricocheted and crocheting, croquet? Right! Your pronunciation's OK. Rounded, wounded, grieve and sieve, Friend and fiend, alive and live. Is your r correct in higher? Keats asserts it rhymes Thalia. Hugh, but hug, and hood, but hoot, Buoyant, minute, but minute. Say abscission with precision, Now: position and transition; Would it tally with my rhyme If I mentioned paradigm? Twopence, threepence, tease are easy, But cease, crease, grease and greasy? Cornice, nice, valise, revise, Rabies, but lullabies. Of such puzzling words as nauseous, Rhyming well with cautious, tortious, You'll envelop lists, I hope, In a linen envelope. Would you like some more? You'll have it! Affidavit, David, davit. To abjure, to perjure. Sheik Does not sound like Czech but ache. Liberty, library, heave and heaven, Rachel, loch, moustache, eleven. We say hallowed, but allowed, People, leopard, towed but vowed. Mark the difference, moreover, Between mover, plover, Dover. Leeches, breeches, wise, precise, Chalice, but police and lice, Camel, constable, unstable, Principle, disciple, label. Petal, penal, and canal, Wait, surmise, plait, promise, pal, Suit, suite, ruin. Circuit, conduit Rhyme with "shirk it" and "beyond it", But it is not hard to tell Why it's pall, mall, but Pall Mall. Muscle, muscular, gaol, iron, Timber, climber, bullion, lion, Worm and storm, chaise, chaos, chair, Senator, spectator, mayor, Ivy, privy, famous; clamour Has the a of drachm and hammer. Pussy, hussy and possess, Desert, but desert, address. Golf, wolf, countenance, lieutenants Hoist in lieu of flags left pennants. Courier, courtier, tomb, bomb, comb, Cow, but Cowper, some and home. "Solder, soldier! Blood is thicker", Quoth he, "than liqueur or liquor", Making, it is sad but true, In bravado, much ado. Stranger does not rhyme with anger, Neither does devour with clangour. Pilot, pivot, gaunt, but aunt, Font, front, wont, want, grand and grant. Arsenic, specific, scenic, Relic, rhetoric, hygienic. Gooseberry, goose, and close, but close, Paradise, rise, rose, and dose. Say inveigh, neigh, but inveigle, Make the latter rhyme with eagle. Mind! Meandering but mean, Valentine and magazine. And I bet you, dear, a penny, You say mani-(fold) like many, Which is wrong. Say rapier, pier, Tier (one who ties), but tier. Arch, archangel; pray, does erring Rhyme with herring or with stirring? Prison, bison, treasure trove, Treason, hover, cover, cove, Perseverance, severance. Ribald Rhymes (but piebald doesn't) with nibbled. Phaeton, paean, gnat, ghat, gnaw, Lien, psychic, shone, bone, pshaw. Don't be down, my own, but rough it, And distinguish buffet, buffet; Brood, stood, roof, rook, school, wool, boon, Worcester, Boleyn, to impugn. Say in sounds correct and sterling Hearse, hear, hearken, year and yearling. Evil, devil, mezzotint, Mind the z! (A gentle hint.) Now you need not pay attention To such sounds as I don't mention, Sounds like pores, pause, pours and paws, Rhyming with the pronoun yours; Nor are proper names included, Though I often heard, as you did, Funny rhymes to unicorn, Yes, you know them, Vaughan and Strachan. No, my maiden, coy and comely, I don't want to speak of Cholmondeley. No. Yet Froude compared with proud Is no better than McLeod. But mind trivial and vial, Tripod, menial, denial, Troll and trolley, realm and ream, Schedule, mischief, schism, and scheme. Argil, gill, Argyll, gill. Surely May be made to rhyme with Raleigh, But you're not supposed to say Piquet rhymes with sobriquet. Had this invalid invalid Worthless documents? How pallid, How uncouth he, couchant, looked, When for Portsmouth I had booked! Zeus, Thebes, Thales, Aphrodite, Paramour, enamoured, flighty, Episodes, antipodes, Acquiesce, and obsequies. Please don't monkey with the geyser, Don't peel 'taters with my razor, Rather say in accents pure: Nature, stature and mature. Pious, impious, limb, climb, glumly, Worsted, worsted, crumbly, dumbly, Conquer, conquest, vase, phase, fan, Wan, sedan and artisan. The th will surely trouble you More than r, ch or w. Say then these phonetic gems: Thomas, thyme, Theresa, Thames. Thompson, Chatham, Waltham, Streatham, There are more but I forget 'em- Wait! I've got it: Anthony, Lighten your anxiety. The archaic word albeit Does not rhyme with eight-you see it; With and forthwith, one has voice, One has not, you make your choice. Shoes, goes, does *. Now first say: finger; Then say: singer, ginger, linger. Real, zeal, mauve, gauze and gauge, Marriage, foliage, mirage, age, Hero, heron, query, very, Parry, tarry fury, bury, Dost, lost, post, and doth, cloth, loth, Job, Job, blossom, bosom, oath. Faugh, oppugnant, keen oppugners, Bowing, bowing, banjo-tuners Holm you know, but noes, canoes, Puisne, truism, use, to use? Though the difference seems little, We say actual, but victual, Seat, sweat, chaste, caste, Leigh, eight, height, Put, nut, granite, and unite. Reefer does not rhyme with deafer, Feoffer does, and zephyr, heifer. Dull, bull, Geoffrey, George, ate, late, Hint, pint, senate, but sedate. Gaelic, Arabic, pacific, Science, conscience, scientific; Tour, but our, dour, succour, four, Gas, alas, and Arkansas. Say manoeuvre, yacht and vomit, Next omit, which differs from it Bona fide, alibi Gyrate, dowry and awry. Sea, idea, guinea, area, Psalm, Maria, but malaria. Youth, south, southern, cleanse and clean, Doctrine, turpentine, marine. Compare alien with Italian, Dandelion with battalion, Rally with ally; yea, ye, Eye, I, ay, aye, whey, key, quay! Say aver, but ever, fever, Neither, leisure, skein, receiver. Never guess-it is not safe, We say calves, valves, half, but Ralf. Starry, granary, canary, Crevice, but device, and eyrie, Face, but preface, then grimace, Phlegm, phlegmatic, ass, glass, bass. Bass, large, target, gin, give, verging, Ought, oust, joust, and scour, but scourging; Ear, but earn; and ere and tear Do not rhyme with here but heir. Mind the o of off and often Which may be pronounced as orphan, With the sound of saw and sauce; Also soft, lost, cloth and cross. Pudding, puddle, putting. Putting? Yes: at golf it rhymes with shutting. Respite, spite, consent, resent. Liable, but Parliament. Seven is right, but so is even, Hyphen, roughen, nephew, Stephen, Monkey, donkey, clerk and jerk, Asp, grasp, wasp, demesne, cork, work. A of valour, vapid vapour, S of news (compare newspaper), G of gibbet, gibbon, gist, I of antichrist and grist, Differ like diverse and divers, Rivers, strivers, shivers, fivers. Once, but nonce, toll, doll, but roll, Polish, Polish, poll and poll. Pronunciation-think of Psyche!- Is a paling, stout and spiky. Won't it make you lose your wits Writing groats and saying "grits"? It's a dark abyss or tunnel Strewn with stones like rowlock, gunwale, Islington, and Isle of Wight, Housewife, verdict and indict. Don't you think so, reader, rather, Saying lather, bather, father? Finally, which rhymes with enough, Though, through, bough, cough, hough, sough, tough?? Hiccough has the sound of sup... My advice is: GIVE IT UP! DW

Excel Solutions ... Volume 2

It's here now ... http://bookboon.com/en/excel-solutions-for-accountants-book-2-ebook

Excel Solutions for Accountants

Book One of a series of three books is now online ... http://bookboon.com/en/excel-solutions-for-accountants-book-1-ebook DW

Abi

Update on Abi ...

She is over two weeks old now and coming along nicely.

She feeds well on mother's milk. She sleeps, wakes and feeds according to norms.

She flails her arms and legs at times, especially when she is hungry. She wears gloves all of the time to prevent scratches and they look a bit funny!

Mrs W expresses some of her milk so that others can feed her from time to time and I fed her for the first time after two weeks. I have fed her a couple of times after that too.

Delightful and good natured girl.

DW

Does my Bum Look Big in This?

I know! Who would do such a thing? Not me but it's the family dog!

DW

Funny Food

I eat local food in all sorts of places but whilst this is not weird it's odd.

Buttered bread with curry sauce. It claimed to be naan bread bit it was far too light for that.

The curry sauce was nice I have to say.

Glutinous rice now!

DW

Jaundice

Like many babies, Abi's got a touch of jaundice so she's undergoing blue light treatment! Another day or so in hospital.

Otherwise she seems to be doing well. Almost back to her birth weight.

DO

Sirinada Abigail Williamson

My second daughter arrived yesterday at 11:40 am local time.

3.36 kg or 7 lbs 6 oz.

Fighting fit and she was born by caesarian section.

Wishing her a long, happy and peaceful life.

Parenthood

A poem what I wrote in anticipation ...

DW

Space Travel

I flew from Kuala Lumpur to Bangkok with EgyptAir last night. In the row behind me was a family that included three children who were all bilingual: English and Arabic. They switched from language to language frequently.

As we sped down the runway, the forward camera was being shown on the television screens and as we lifted off, the airport and city lights were replaced by starlight, almost in an instant.

In a beautiful deadpan voice, the girl behind me said, when she saw the stars, "We're into space?" I wish I'd recorded the moment!

DW

Are you Listening?

I was accused of not listening to someone the other day: someone who called me to deliver a monologue. As I naively believed it should be a dialogue I spoke. I tried it once. Then spoke only when I was asked something.

The other day a manager from the hotel came to talk to me and said I should use trip advisor of agoda to rate their hotel ... good and bad, he said. As we talked, again more of a monologue than a dialogue I said, there are two important things in a hotel ... I told him the first one and as I started to tell him my second one, he was already talking again.

Last night, I was waiting for my suitcase at the airport when a fellow passenger came and started talking.  At first I didn't follow what he was talking about.  I don't think he knew either! Well, it settled down and I learned about the price of his ticket,  his route, his view on various airlines, where he lived, where he worked, the comfort of the plane we had just shared, his accounting department's views on his expenses and more.

I started to offer something of my own.but he started looking around and something behind me caught his eye. I was unwittingly engaged in another monologue. I stopped talking and thankfully my suitcase arrived. We went our separate ways.

DW

I am a Hacker!

This is true:

DW

Coat Hanger Capital

I think Thailand is the coat hanger capital of the world.

This week a new mall opened in town and in one of the shops there were hundreds of coat hangers prominently displayed.

All over Thailand, coat hangers are big business!

DW

Pardon?

So I went to England in March for visa and passport business and I felt cold there. It was cold and I was there for about two weeks.

Towards the end of the trip I got a sore throat: painful but it didn't seem to spread.  Or so I thought.

When I got back home my left ear became blocked and I lost a lot of hearing power in it. I got some antibiotics and took them for a week. Still infected, still deaf.

I saw a doctor who gave me more antibiotics and anti histamines for a week. Still infected, still deaf.

I went to the hospital where the doctor gave me antibiotics and pseudo ephedrine ... for two weeks. Still deaf, still infected.

I came to Brunei and my research told me that all of their doctors are highly trained in Europe,  Australia ... I went to a clinic and was given antibiotics and anti fungal drops. For three days I noticed nothing but then ... ta daa ... big improvement. As I write this,  my hearing is almost back to normal and in two days I can stop the treatment.

My question is: what kind of infection did I get and why?

Happy to be cured.

DW

You like Beetles?

Then take a look at this beauty: the Sugarcane Longhorn Stemborer, long horn borer ... in Latin, DORYSTHENES BUQUETI. Found in our garden in Notth East Thailand this afternoon. The antennae are 4.5 inches across! Which is your favourite? DW

Farewell Meow Meow

This is the cat we called Meow Meow: it came into our lives when it was about two weeks old and was wandering around the fields having been abandoned. So, the family took it in, we fed it, we played with it and looked after it. The dogs liked it and everyone got along. Nice cat. This photo is how it was resting one evening about a year or so ago ... in a funny mood! Tom cats disappear from time to time and so did Meow Meow: for three or even four weeks. We felt he was dead. Then he returned but with a large wound on its chest. Car or dog fight? Who knows but it must have hurt. The wound healed well though and the fur grew back over it. In the meantime, our Ginger tom cat arrived, also a two week old abandoned kitten and we took him in ... Ginger and Meow Meow got on really well: they played and ran and jumped like good young friends do. They both came into our house and we fed them both. After a while Meow Meow disappeared again but when he came back this time, with another wound, in the same place, something had changed. His eyes were vacant. He would wander around crying at times. We still fed him but he wasn't all there. The wound healed again nicely so most things just jogged along. Then Meow Meow and Ginger started fighting: some epic battles with fur and excrement flying: remember the day we accidentally locked them together in our house!! Ginger also disappeared for three weeks and came back very thin: whatever he was doing, eating wasn't his priority. He is home now and eating well again. Meow Meow got thinner and thinner and more and more listless. Sad to see. Such a happy cat a year ago and now, at about the age of 20 months or so he died. He died last night after a short bout of sickness and that is the end of Meow Meow. Everyone and everything who brings joy and leaves memories deserves an obituary. So hail and farewell Meow Meow: you are free now! DW

Excel Solutions for Accountants

That is the title of my new book on Excel and here is the Introduction to the three volume set: a total of about 200 pages.

Introduction to Excel Solutions for Accountants

Duncan Williamson

April 2015

This book will be published by www.bookboon.comearly in June 2015 and of course this introduction is subject to change between now and then.

This is the first in a series of three books with the title of Excel Solutions for Accountants.

The essence of the book is that we have chosen a series of topics that we believe are of direct interest and relevance to accountants: we know that from the work we do every day. That is not to say that everything an accountant ever needs or does is included in this book; rather it’s a general book aimed at the accountant who knows that Excel can be made to do a lot more than it does but he just doesn’t know what that might be.

We have taken a very hands on approach with this book and for everything we talk about there is something for you to do: there is a spreadsheet for you to work with, too, so that you can always check your work and your accuracy at every stage.

One of our over riding ambitions was to make this book both as direct and as easy to use as possible. You will not find massive files with hideously complex formulas in them, each of which might take you an hour or two just to begin to unravel. What we have done is to give you straightforward examples with non complex lists and databases so that you come to learn the techniques and functions rather than worrying about the database.

Part One of the book comprises the following

Accountant Specific 1Excel TablesDepreciationRatio Analysis 1Graphs 1Pivot Tables 1

You can see immediately from the titles of these chapters that the accountant is the target here!

Secondly you should see that four of the chapters have the number 1 after them: that tells you that in books 2 and/or 3 there is another chapter or chapters on the same topic. Take a look at the contents of books 2 and 3:

Part TwoPart ThreeAccountant Specific 2Accountant Specific 3Compound Interest and Discounting: the time value of moneyDashboardingData Validation and Form ControlsPivot Tables 3Ratio Analysis 2ForecastingGraphs 2BudgetingPivot Tables 2AGGREGATE, OFFSET and SOLVER

More than one way to skin a cat! We present one or more solutions to the problems we present in this book and from time to time we say: Excel provides more than one way to solve this problem. If you already know a better way to solve a problem than we are presenting, stay with it. Even if you think our method is better but are happy with your own method, stick with it if it doesn’t mean you are wasting time or being inefficient. Don’t be stubborn though: like the cost accountant who saw our solution to his problem but preferred not to follow our advice: that meant he preferred to wait 20 minutes every morning for his main Excel file to open and then wait a further 45 seconds or so every time he pressed the Enter key. Our solution meant no waiting time at all as we replaced his 30,000 volatile function workbook with a Pivot Table based solution that provided almost instant responses.

Templates: we have tried at every stage of every chapter of this book to provide templates for you to work with and/or create. After all, what’s the point of programming a spreadsheet over and over again when you shouldn’t have to? Excel deals with some of the most predictable things you can do and templates are consistent with that. Therefore, take each of our examples either as a template or as your template in the making. We stress PPP too: paper, pencil, plan. The PPP approach means, don’t just dive in to a spreadsheet problem, take you time and plan it out on paper first. Then develop your solution. Then derive your template if appropriate.

A total of 18 chapters and by the end of all three books we believe you can easily call yourself an intermediate user of Excel. We also feel that you will have unlocked so much potential in Excel that you will want more and more from it.

This book has been written with Excel 2013 for Windows: that will mean that some of the things we have done will be a little bit different sometimes from what any other version of Excel might do. We have kept such differences to a minimum, however. Nevertheless, we would encourage you to upgrade to 2013 soon anyway.

Other sources of help for Excel: there are many sources of help other than Excel itself. Here are just a few examples of where to get help: just search for these online to get there!

excelmaster.co: my own Excel BlogExcel-G: online/email based discussion list for general level questions on Excel. There are about 1,000 members of this group and they are friendly and really helpful people. Please note, this is a general level list and anything too advanced should be directed at …Excel-L: online/email based discussion list for Excel Developers. This is the more advanced list and seems to concentrate mainly on VBA problems and solutions.OzGrid: this is a free and commercial site offering some brilliant resources.chandoo.org: this is another really useful site whose founder, Chandoo, has the objective of making you awesome in Excel! A lot of the materials on this site are free but some of them are commercial. Chandoo also offers online and offline courses.Jon Peltier: Jon seems to be the world’s foremost authority on graphs and charts. Again, this is a combined free and commercial site but there are many wonderful free resources on there.Mr Excel: Bill Jelen is a prolific Excel materials developer and explanator! Bill provides a lot of free and highly commendable materials, again both free and commercial.Charley Kyd: Charley has specialised in the past in dashboarding and whilst he still does that, he offers a lot of free Excel based materials too. Well worth searching out.John Walkenbach: John has been around for ages and he writes the Excel Bibles, among other Excel based titles. John is always comprehensive and has a lot of useful things to offerYouTube: there are many thousands of videos on YouTube now and more appear every day. Some of them are really very good and others will leave you wondering what on earth they were trying to say. It’s pot luck really but once you find a good YouTube provider, stick with them!

There are many more people/organisations/lists that can help you so these are just a few of the ones we recommend.

DW

Excel Solutions for Accountants

That is the title of my new book on Excel and here is the Introduction to the three volume set: a total of about 200 pages.

Introduction to Excel Solutions for Accountants

Duncan Williamson

April 2015

This book will be published by www.bookboon.com early in June 2015 and of course this introduction is subject to change between now and then.

This is the first in a series of three books with the title of Excel Solutions for Accountants.

The essence of the book is that we have chosen a series of topics that we believe are of direct interest and relevance to accountants: we know that from the work we do every day. That is not to say that everything an accountant ever needs or does is included in this book; rather it’s a general book aimed at the accountant who knows that Excel can be made to do a lot more than it does but he just doesn’t know what that might be.

We have taken a very hands on approach with this book and for everything we talk about there is something for you to do: there is a spreadsheet for you to work with, too, so that you can always check your work and your accuracy at every stage.

One of our over riding ambitions was to make this book both as direct and as easy to use as possible. You will not find massive files with hideously complex formulas in them, each of which might take you an hour or two just to begin to unravel. What we have done is to give you straightforward examples with non complex lists and databases so that you come to learn the techniques and functions rather than worrying about the database.

Part One of the book comprises the following

• Accountant Specific 1


• Excel Tables


• Depreciation


• Ratio Analysis 1


• Graphs 1


• Pivot Tables 1

You can see immediately from the titles of these chapters that the accountant is the target here!

Secondly you should see that four of the chapters have the number 1 after them: that tells you that in books 2 and/or 3 there is another chapter or chapters on the same topic. Take a look at the contents of books 2 and 3:

Part Two	Part Three
Accountant Specific 2	Accountant Specific 3
Compound Interest and Discounting: the time value of money	Dashboarding
Data Validation and Form Controls	Pivot Tables 3
Ratio Analysis 2	Forecasting
Graphs 2	Budgeting
Pivot Tables 2	AGGREGATE, OFFSET and SOLVER

More than one way to skin a cat! We present one or more solutions to the problems we present in this book and from time to time we say: Excel provides more than one way to solve this problem. If you already know a better way to solve a problem than we are presenting, stay with it. Even if you think our method is better but are happy with your own method, stick with it if it doesn’t mean you are wasting time or being inefficient. Don’t be stubborn though: like the cost accountant who saw our solution to his problem but preferred not to follow our advice: that meant he preferred to wait 20 minutes every morning for his main Excel file to open and then wait a further 45 seconds or so every time he pressed the Enter key. Our solution meant no waiting time at all as we replaced his 30,000 volatile function workbook with a Pivot Table based solution that provided almost instant responses.

Templates: we have tried at every stage of every chapter of this book to provide templates for you to work with and/or create. After all, what’s the point of programming a spreadsheet over and over again when you shouldn’t have to? Excel deals with some of the most predictable things you can do and templates are consistent with that. Therefore, take each of our examples either as a template or as your template in the making. We stress PPP too: paper, pencil, plan. The PPP approach means, don’t just dive in to a spreadsheet problem, take you time and plan it out on paper first. Then develop your solution. Then derive your template if appropriate.

A total of 18 chapters and by the end of all three books we believe you can easily call yourself an intermediate user of Excel. We also feel that you will have unlocked so much potential in Excel that you will want more and more from it.

This book has been written with Excel 2013 for Windows: that will mean that some of the things we have done will be a little bit different sometimes from what any other version of Excel might do. We have kept such differences to a minimum, however. Nevertheless, we would encourage you to upgrade to 2013 soon anyway.

Other sources of help for Excel: there are many sources of help other than Excel itself. Here are just a few examples of where to get help: just search for these online to get there!

• excelmaster.co: my own Excel Blog


• Excel-G: online/email based discussion list for general level questions on Excel. There are about 1,000 members of this group and they are friendly and really helpful people. Please note, this is a general level list and anything too advanced should be directed at …


• Excel-L: online/email based discussion list for Excel Developers. This is the more advanced list and seems to concentrate mainly on VBA problems and solutions.


• OzGrid: this is a free and commercial site offering some brilliant resources.


• chandoo.org: this is another really useful site whose founder, Chandoo, has the objective of making you awesome in Excel! A lot of the materials on this site are free but some of them are commercial. Chandoo also offers online and offline courses.


• Jon Peltier: Jon seems to be the world’s foremost authority on graphs and charts. Again, this is a combined free and commercial site but there are many wonderful free resources on there.


• Mr Excel: Bill Jelen is a prolific Excel materials developer and explanator! Bill provides a lot of free and highly commendable materials, again both free and commercial.


• Charley Kyd: Charley has specialised in the past in dashboarding and whilst he still does that, he offers a lot of free Excel based materials too. Well worth searching out.


• John Walkenbach: John has been around for ages and he writes the Excel Bibles, among other Excel based titles. John is always comprehensive and has a lot of useful things to offer


• YouTube: there are many thousands of videos on YouTube now and more appear every day. Some of them are really very good and others will leave you wondering what on earth they were trying to say. It’s pot luck really but once you find a good YouTube provider, stick with them!

There are many more people/organisations/lists that can help you so these are just a few of the ones we recommend.