Another Book

I have been commissioned to write another book. Working title: Excel for accountants.

15 to 20 chapters of high quality explanations with loads of examples.

Will keep you informed!

DW

Buriram United AFC Champions League Game

We got here 30 minutes late but Burian already two goals up.

Playing Seongnan FC from South Korea

DW

What Happens in a Cat Fight

I left the house yesterday and, as normal, locked the door. Then Mrs W and I went on a 20 mile waste of time drive since we were going to the market but realised, a couple of miles short of our mission, that neither of us had money or cards with us.

Home!

Dogs running excitedly around our house. Sisters shouted excitedly at Mrs W. Mrs W relayed the message: our tom cat and their tom cat were both locked in our house and were fighting ... they fight two or three times a week, sadly.

I opened the door and Ginger was there surrounded by six or seven clumps of his fur. It had taken a lot of effort to do that I'm sure. Ginger calmly left and settled himself at the front of the house.

I couldn't see or hear the other cat but I caught a smell. I followed my nose and got to the dining room. All I can say is that I am glad there is no carpet in there. Excrement covered half of the floor and it was on the wall, table legs and chair legs.

I can't imagine the battle that must have taken place but it was clearly hard fought and one of the cats was more nervous than the other.

As I left the dining room to summon Mrs W for help I met the other cat, Meow Meow. As I sometimes do with the dogs,  I clapped my hands as a way to get his attention and, surprisingly, he turned tail and skittered under the settee.

After a minute Meow Meow left the house and sauntered away: Ginger saw him, arched his back and hissed the hiss of a fearful or aggressive cat. I am not sure which cat Ginger is but I have seen him running and hiding from Meow Meow before.

In conclusion,  it took us a while to clean the dining room but I was sorry that I had inadvertently locked both cats in the house. I had no idea Ginger was at home let alone Meow Meow. I'll certainly make sure I don't do that again!

DW

I passed and what does a vegetarian taste like?

I passed my MOOC: my Data Analysis course with the University of Texas at Austin. 82% overall.

In Brunei I found pot noodles: vegetarian flavour. My question is, what does a vegetarian taste like?

DW

Two New Cases

Here are two new Excel based cases I have just prepared that I know some of you will appreciate.

UK Petrol Prices

I downloaded a file of all retail petrol and diesel prices for the UK from 2003 to 2014. The task is to prepare an interactive table so that the user just enters a date in one cell and the table then shows the

• retail pump price per litre


• duty per litre


• VAT percentage


• calculation of the cost of the petrol net of duty and VAT

This case involves the use of a variety of techniques including

• VLOOKUP()


• Data Validation


• IFERROR()


• Paste Special Multiply

Here's an example of my output:



 

This video summarises the case:

[wpvideo nw5NNOOh]

Sleep Requirements.

In today's Borneo Bulletin newspaper there is an article on the sleep requirements of people of all ages. They give the requirements such as, a new born baby needs from 14 to 17 hours a day ... someone over 65 years of age needs from 7 to 8 hours sleep a day.

The task is to turn a photo of the data into a table and a chart that communicates as effectively as possible: I prepared the following:





 

Please feel free to write to me at any time to ask for the spreadsheets that accompany these cases. At the moment they are live cases and I won't release them generally until the course has finished in a week's time..

Duncan Williamson

 

Wat Lan Kuat

Wat Lan Kuat, a temple near Sisaket in Thailand. Made of bottles. Take a look at these few snaps I took there today.

DW

New Video! - Mean, Median and Mode in this Introductory Presentation

An introduction to measures of central tendency: mean, median and mode. We use Excel to discuss this topic and there are three exercises in this presentation. http://ift.tt/1xS5gnV

New Video! - find & replace

The Find&Replace menu in Excel contains some hidden gems. Things that you might never have seen before. Take a look here to see what you've been missing. http://ift.tt/1JrisW3

New Video! - ctrl+enter with the correlation function in excel

This video shows you how to use the =CORREL() function in Excel with the Ctrl+Enter technique. This is especially useful for Mac users who do not have access to the Data Analysis Toolpak http://ift.tt/1yWlzFO

Death of a Tree

We call it a shelf tree because we don't know its real name. It's a shelf tree because its branches stick out like shelves! Anyway, we bought a nice shelf tree and planted it. We cared for it. The cat learned to climb up it. Then the insects moved in. The tree lost a lot of leaves over a few days we we found the cause: insects. We bought insect spray and the tree revived. Then we noticed a top branch was looking a bit sick but we couldn't get at it. Today I was watering the garden and noticed a lower branch had weakened in the middle and was hanging loose. I told Mrs W and by the time it was time for a break she'd dug around the root and the tree had to go. We huffed and puffed a little bit and got the tree out. Dead branches allright. Sticky blobs on the bark. Holes in the trunk. I investigated one piece and found a lot of 2 mm sized ants inside. two MILLIMETRE ants had killed our 4 - 5 metre tree. When humans have been wiped out, I am sure that ants will rule the world. Here's what's left of our big shelf tree ... there are two smaller ones in the garden and I hope they grow and survive. DW

Hasselback Garlic Potatoes

Ever heard of Hasselback Garlic Potatoes? I just made them ... see my photo. They are very good.

I got the recipe from a friend on Facebook.

DW

Stewart ... Stewart!

Stewart is part of the family and has been since is birth.  He lives with his mother and although his father and brother met untimely deaths,  he seems happy and lively, if a little shy.

Stewart is young but is fully grown: that means he is fit and slim given his adequate diet.

I have to say that I have had misgivings about Stewart for a while now.  You know, when something happens and it's a bit off key. Or someone does something and you wonder,  did they really do that?

It all came to a head this morning for Stewart.  I was just looking out through the dining room window when I saw him and another young lad. They were engaged in the kind of activity that no one should see but between members of the same sex: well, it's just not right.

I didn't feel to be in a position to intervene in any way and the matter was over rather quickly. I did discuss what I saw with Mrs W but she was not so concerned as I was.

After all, Mrs W has been around dogs all her life and Stewart is just another dog as far as she is concerned, gay or straight!

Still, you don't see many gay dogs do you!

DW

First of January 2015

My diary. I have kept a diary since I was 14 years old. I kept all my diaries too and read them every now and again. Some trivial things. Some memorable things. Some sad things, some happy things.

When I moved to Thailand last year I threw away my diaries. Over the last few years I have relied more and more on electronic notes and journal items so my diary had become less important. Still, when my blog service provider disappeared without a trace a few years ago I realised that I need to have a diary strategy which is why I have this blog and it is why I use twitter and to a much lesser extent Facebook.

Like many people I take photos of food and people, buildings, landscapes and animals. I include some of them here from time to time. Here's a photo I took about an hour ago ... mother and two week old calf!

Anyway, I bought a diary for 2015 and I will use it for business rather than personal reasons. I think.

DW

Happy New Year

Hello everyone!

It is 20:35 on 31st December where I am and that means new year celebrations have started or are very shortly about to start somewhere.

I wish all of you a happy and peaceful new year. It is my resolution to post more pages here in the coming year. As you know, I post something as often as I can and I try to ensure everything is of high quality.

I have upgraded my screen capture video production software and intend to create and post more of them.

Do feel free to write to me at any time, by the way: I always reply to my messages and comments.

Best wishes

Duncan Williamson

Happy New Year

Hello everyone!

It is 20:35 on 31st December where I am and that means new year celebrations have started or are very shortly about to start somewhere.

I wish all of you a happy and peaceful new year. It is my resolution to post more pages here in the coming year. As you know, I post something as often as I can and I try to ensure everything is of high quality.

I have upgraded my screen capture video production software and intend to create and post more of them.

Do feel free to write to me at any time, by the way: I always reply to my messages and comments.

Enjoy the photo of the individual cheese cakes I have just made!! And the English trifle that has already been eaten!!

Best wishes

DW

Khan Academy

I am learning all sorts of things this year and will continue next year as well.

One of my sources of learning is the Khan Academy and I recommend it to you for all sorts of things including mathematics … plus science and computing. It’s FREE too!

Here my link to take you there, please take a look.

 

Duncan Williamson

Two Videos … more to come

The menu system on this blog has fallen apart for some reason and until I get it sorted out I will communicate this way as well as through the home page and so on.

Anyway, two new videos in case you missed them that can be found in my OneDrive Public folder

how to create a positive and negative chart/graph. That is, making the positive numbers blue and the negative numbers red … or any colours you wish

Introduction to setting up a Pivot Table and drilling down in a Pivot Table. Pivot Tables are vital for anyone dealing with numbers and analysis and if you haven’t learned them yet … spend about 10 minutes with me.

You should see the respective Excel files there too!

Stop and start these videos as you wish until everything is clear.

 

Duncan Williamson

21st December 2014

Testing the Menus

I am not at all sure of how the menus are working now … testing, testing …

 

Dw

True Kindness

I was buying a diary and postcards in WH Smith in Muscat airport last night and wanted to pay in US Dollars.  It came to $6 and I had a $5 note and a $50 note.

I knew I would get the change in Rivals but I agreed to pay with the $50 note.

I hadn't seen her but suddenly a woman in the queue behind me said, you don't want to break that $50 note and handed over an Oman Rial note.

That was so kind and it has never happened to me before. I thanked her profusely and for the record, English accent.

DW

True Kindness

I was buying a diary and postcards in WH Smith in Muscat airport last night and wanted to pay in US Dollars.  It came to $6 and I had a $5 note and a $50 note.

I knew I would get the change in Rivals but I agreed to pay with the $50 note.

I hadn't seen her but suddenly a woman in the queue behind me said, you don't want to break that $50 note and handed over an Oman Rial note.

That was so kind and it has never happened to me before. I thanked her profusely and for the record, English accent.

DW