2023 ← Basic Lowdown.. No waffle ← Page 2

Excel drop down lists and data validation tutorial

Jun

19

2023

In this Excel drop down lists tutorial for beginner’s video I demonstrate this extremely useful feature of Excel that everyone should know about. The drop down feature in MS Excel is most useful when multiple users are entering data into a shared Excel spread sheet. The drop down list ensures that all users must enter ...

Excel transpose columns and rows

May

22

2023

In this video tutorial on 2 methods to use Excel transpose columns and rows I run through the basics for beginners on how to transpose an Excel data set from columns to rows and rows to columns. The first method uses the paste and paste special tools and is called the static method because the ...

Setting up a garden wicking bed for beginners

May

10

2023

How to make a wicking bed In this video ‘Setting up a garden wicking bed for beginners ‘ I demonstrate how to construct and set up a garden wicking bed for planting seedlings. In his demonstration I take the option of building the garden wicking bed from timber and then lining it with a waterproof ...

Find tank water level and capacity

Apr

16

2023

In this video ‘find tank water level and capacity’ I demonstrate an easy low tech way to find the level of water in a garden tank by using a hose pipe. I also show how to estimate the amount of rainfall, in mm, that is needed to fall on a shed roof for the run ...