Posts tagged “youtube”.

Testing Excel expressions with the IF function

I figured it was time for another Excel tutorial. This time I’m looking at the IF function. IF is really just like it would be in a sentence. If A=B then “something”, else “something else”. The syntax is :

=if(logical_test,value_if_true,value_if_false)

Check out the video for more.

Excel Tutorial – COUNTIF

Have you ever had a spreadsheet with 150 lines of data and you need to know how many times “Red” appears in a cell? The COUNTIF function in Excel is for you. Here is a run through of how you can use this in your spreadsheets.

Excel Tutorial – Using SUMIF

Welcome to my first, of hopefully many, tutorial on how to use Excel’s SUMIF() function. My first ever YouTube video too – how very geeky. This function works the same in both Excel 2003 and Excel 2007.

Varsity Veggies – a big success

My mum has been working hard over the last three years to organise a community garden in her local community. The official opening was today and Natalie and I went down to check it out. Natalie has even put together a video of our trip (and also a review of some new pens she recently bought). You can check out her other videos on YouTube as well.

It’s a space to allow people who don’t have the space, or who enjoy community company, to get together and grow their own veggies. There are around 40 plots of 3 meters x 3 meters which is plenty of space to grow enough veggies for yourself and to have some left to spare. There are even raised beds for the physically disabled to allow them to enjoy the fun in the sun.

I’m very proud of my mum and what she has achieved. She even had the audacity to ask for more money for more beds (as seen in the video). My mum is awesome. They estimated that over 300 people attended this afternoon’s opening. That’s amazing to be honest. Maybe it was due to her becoming a media tart in the last few days.

Lets hope we can get some stuff like this in our local area soon. I’d love a garden bed to get into a grow some veggies of our own!

Reproductive Rights and Family Planning – Hillary Clinton has the balance right

US Secretary of State Hillary Clinton has recently been asked to comment on her views regarding Reproductive Rights and Family Planning, including abortion. Rather than summarise, here is the YouTube video of the question and herĀ  answer.

There will be those who disagree with her view and you are entitled to that right. I am with Secretary Clinton on this one. It must be the individual’s right to choose whether abortion is suitable for them. Providing good family planning advice, including information about contraception and safer sex practices is important no matter where you live. Providing the tools for girls and boys, men and women to make sound and informed decisions is much more important than running scare mongering campaigns.

Teaching kids about sex is just as important as teaching them about other physical health issues and perhaps even more so in some cases. They are not resistant to hormones and need to have the information available to think for themselves. Providing them with age appropriate education in a safe environment is important. If parents want to opt their children out then we shouldn’t stop them. But we shouldn’t allow a group to force their views on abortion, sex education or family planning on anyone else.

If your deity, your moral values or your ideological view of society says that it is wrong to have an abortion, then you do what you need to do. Let other women decide for themselves and do whatever they decide they need to do.