Using the IF Function on Text in Google Sheets
The if function can be problematic if you want it to identify text. This video shows you how to easily teach Google Sheets to look for text. A powerful tool for making sense of data.
The if function can be problematic if you want it to identify text. This video shows you how to easily teach Google Sheets to look for text. A powerful tool for making sense of data.
How to use an add on called flubaroo to automatically mark Google Forms. If you like the video, please help me out by liking and subscribing! New stuff periodically. Thanks a lot!
How to generate drop down lists using Google Sheets. Make your data entry much easier.
A quick guide to finding the percentage of values automatically in Google Sheets. If you like the video, please help me out by liking and subscribing!
Inserting Comments in Google Sheets using VLOOKUP, a powerful function that lets you assign comments next to values automatically. Can be used for the basis of reports or forms and requires little or no work. I show you how to fill out the formula and explain what each step means so you don’t forget. If you like this video, please … Read More
This time I expose the secret life of teachers on holidays, Kayak and Bike the Yarra River near Mount Lofty, attend the speckle park sale at the Royal Show, update on our results in the Steer Comp and feed some of the Goats.
Make a no spill chicken feeder out of 90mm storm pipe, an end plug, step down adaptor and a 45 degree elbow for around 10 dollars. Sure beats the mess made by birds eating out of old style hanging feeders. These can also be mounted to anything using some wire or a downpipe clip. Please don’t forget to subscribe!
Drawing a VSP trellised grapevine and labelling the major parts for recognition.
How to tie the strainer knot. Used to join wire together when using chain strainers. Handy when constructing or repairing a fence and you don’t want to use expensive gimmicks. This is the third video in a three part series on fencing knots. The first video can be found here; https://youtu.be/qohPK7b0MqE Buy Chain Strainers Here https://amzn.to/2KvR8lf Buy Pliers https://go.magik.ly/ml/e365/
How to tie the figure 8 knot. Used to tie slack wire together when constructing or repairing a fence. This is the second video in a three part series on fencing knots. The first video can be found here; https://youtu.be/qohPK7b0MqE Buy chain strainers here https://amzn.to/2KvR8lf
First of three videos showing how to tie up and strain a fence without needing expensive gimmicks. All you need are a good set of strainers and some pliers. The second Video can be found here; https://youtu.be/b_76dtX1tUU
How to tie and end knot, then strain a fence and tie off the tensioned wire using a knot. Allows the construction of a fence using no crimps or gripples.
How to select canes and prune wine grapes using Vertical Shoot Positioned (VSP) Cane Pruning.
Standard Deviation in Google sheets plus some other tricks like Conditional formatting to make working with data easier.
Secateurs work best when sharpened and cared for. Short video on the basics of caring for this tool.
Interview with Fred Gaudion, retired fruit grower from Wandin in Victoria. Fred takes us through a modern orchard system and discusses some of the changes that have occurred over his time in the industry.
Creating a column chart from a table of data. Demonstrates how to set up a table for graphing, averaging of trial data and then how to exclude data from the final chart, as well as a walk around for problems with X axis labels.
Short Video How to lay out data and insert a chart using the chart tool in Google Sheets
This week I go to cattle handlers camp, decide to spend more time doing less and take a photo of a great old shed to celebrate the beauty of the everyday. The mid-life crisis continues!
This video is about creating a positive and creative middle aged crisis!