AnnMatt Erasmus
AnnMatt Erasmus
  • 121
  • 3 807 495
Excel selective highlights with conditional formatting
This video tutorial explains Excel conditional formatting to beginners and intermediate levels. Shows how to selectively format certain cell in your spreadsheet according to the cells content or value.
Comments are most welcome, if you decide to try this please send us some feedback☺️ Why not visit our channel and browse through our other videos? ua-cam.com/users/AnnErasmus
Short Disclaimer/disclosure: My videos/articles are for informational and educational purposes only, you should consult with a professional before attempting anything seen or done in my videos/articles. Please read full disclaimer here: basiclowdown.com/category/disclaimer-disclosure/
Переглядів: 66

Відео

Samsung galaxy screen record
Переглядів 1654 місяці тому
Screen recording is an ideal way to share instructions on 'how to' do stuff on a smart phone and can be easily sent by email or social media to a recipient. Here is how to use Samsung galaxy screen record feature. Step by step tutorial for beginners 1. Swipe down from the top of the screen with 2 fingers to open the control panel 2. Select ‘screen recorder’ button 3. Choose sound and touch opti...
Samsung phone wireless powersharing
Переглядів 505 місяців тому
Samsung phone wireless power sharing is a very convenient feature that allows you charge Samsung devices (phones, watches or ear buds) when the specific chargers are not available. Step 1. Switch on your Samsung smartphone Step 2. Swipe down from the top of the screen to revel the hidden icons Step 3. Swipe down again to revel more icons Step 4. Swipe left to reach the end of these icons and se...
Twist drill sharpening
Переглядів 2098 місяців тому
In this video tutorial, I demonstrate a Twist Drill Sharpening technique for beginners, that is quick, simple and highly accurate. All you will need is a bench grinder and a protractor. Step 1. Be aware of the correct angles of a sharp twist drill. Step 2. Set up some guidelines on the bench grinder. Step 3. Use the guidelines on the bench grinder to achieve the correct twist drill angles while...
Excel calculate age
Переглядів 1149 місяців тому
Calculating the age of a person or object in Excel is a very useful feature. This can be applied to any need to calculate the time elapsed between 2 dates. There are several ways of doing this depending on your needs. In this video I demonstrate the most useful formulas for calculating age in Excel. All you need is the start date or date of birth (DOB) (which is fixed) and the end date which wi...
Rapid drill bit sharpening for beginners
Переглядів 1 тис.10 місяців тому
Here is how to sharpen drill bit rapidly for beginners 1. Dress the grinding wheel to make sure that the working surface is flat and parallel to the guard or stage . 2. Set the grindstone stage about a millimetre or less from the wheel . This is for safety so that nothing gets pulled in between the grindstone and the stage . Also for safety do not wake loves or any loose clothing around a grind...
Excel time and date functions
Переглядів 22111 місяців тому
In this tutorial I am going to discuss Microsoft Excel time and date functions To see all Excel’s functions related to time and date : Formulas tab (on top ribbon)-Date & Time drop down- select. If you know the syntax just select a cell and start typing then double click the option you want from the list of suggestions. I am going to demonstrate how useful some of popular functions can be in an...
Excel drop down lists and data validation tutorial
Переглядів 428Рік тому
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 only the approved parameters for the data or terminology thus eliminating con...
Excel transpose columns and rows
Переглядів 197Рік тому
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 new transposed set of data does not update when the original or source data is updated. The second met...
Setting up a garden wicking bed for beginners
Переглядів 443Рік тому
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 plastic liner. It is also possible to use a waterproof plastic or metal container to construct a wicking bed thus avoiding t...
Find tank water level and capacity
Переглядів 5 тис.Рік тому
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 off to fill the tank using first an empirical or practical method and then a theoretical method. Both methods of calculation arrive at t...
How to move a garden shed
Переглядів 625Рік тому
How to move a garden shed by hand and in one piece. In this video ‘How to move a garden shed’ I demonstrate an easy low tech way to move a small garden shed in one piece, no dismantling required. Here are the steps I went through to complete this task successfully. Step 1. Prepare a suitable site to move the shed onto. Remember these small shed need to be secured to the deck to prevent them fro...
How to weave a riempie chair with rope
Переглядів 1,4 тис.Рік тому
How to weave a riempie chair with rope. This video tutorial is for beginners and shows, step-by-step, how to restring or weave a riempie or thong dining room chair with rope. Step1. Remove the seat of the dining room chair from the chair frame Step 2. Remove the old material, riempie or chord from the chair seat Step 3. Measure and cut a length of woven cotton rope needed for half of the seat S...
Replace Ikea Maximera drawer front
Переглядів 17 тис.Рік тому
In this video tutorial we will demonstrating how to replace an Ikea Maximera drawer front and how to install and remove the drawers from an Ikea Metod kitchen cabinet. The only tool needed for this task will be a star or Phillips screwdriver. First remove the drawer from the Metod cabinet by simply lifting the front of the Maximera drawer front then jiggle the drawer as you pull it towards you ...
How to mark and cut PVC pipe
Переглядів 1,7 тис.Рік тому
This video tutorial shows how to mark and cut PVC pipe neat and square. Marking pvc pipe square and accurate can be a challenge. Here are 2 quick and easy hacks for marking and cutting PVC pipe accurately. This video shows how to use an ordinary PVC pipe wall bracket to obtain consistently accurate marking and a second method using an off-cut of the pipe to make a simple jig for accurate markin...
Enlarge a spade drill hole in wood
Переглядів 8 тис.Рік тому
Enlarge a spade drill hole in wood
Economical tuna patties keto and gluten free
Переглядів 286Рік тому
Economical tuna patties keto and gluten free
Quick way to enlarge a hole saw hole
Переглядів 8 тис.Рік тому
Quick way to enlarge a hole saw hole
How to hide messy wires
Переглядів 889Рік тому
How to hide messy wires
Building a workshop shed
Переглядів 257Рік тому
Building a workshop shed
Delicious roast onion in under 10 minutes
Переглядів 3472 роки тому
Delicious roast onion in under 10 minutes
Transplant from pot to garden with zero transplant shock
Переглядів 3002 роки тому
Transplant from pot to garden with zero transplant shock
How to solder copper pipe and avoid 13 common beginners mistakes
Переглядів 1,4 тис.2 роки тому
How to solder copper pipe and avoid 13 common beginners mistakes
How I fitted Ikea Metod doors to a Billy cabinet
Переглядів 4,4 тис.2 роки тому
How I fitted Ikea Metod doors to a Billy cabinet
How to adjust Ikea kitchen cabinet doors
Переглядів 50 тис.2 роки тому
How to adjust Ikea kitchen cabinet doors
How to fit countertop to Ikea kitchen cabinets
Переглядів 20 тис.2 роки тому
How to fit countertop to Ikea kitchen cabinets
How to fit Ikea plinth or kickboards to kitchen cabinets
Переглядів 56 тис.2 роки тому
How to fit Ikea plinth or kickboards to kitchen cabinets
How to assemble and fit Ikea kitchen drawers
Переглядів 35 тис.2 роки тому
How to assemble and fit Ikea kitchen drawers
How to make a template for fitting Ikea cabinet door or drawer handles
Переглядів 5 тис.2 роки тому
How to make a template for fitting Ikea cabinet door or drawer handles
How to assemble an Ikea cabinet flat pack beginner’s tutorial
Переглядів 4,3 тис.2 роки тому
How to assemble an Ikea cabinet flat pack beginner’s tutorial

КОМЕНТАРІ

  • @aidan8106
    @aidan8106 2 години тому

    Will be the last time I use a self service checkout 😒

  • @christophergin1534
    @christophergin1534 2 дні тому

    Excellent video; clear and informative with the two crucial tips about seating the washer and cleaning finally solving the issues I had been having! I will note that for the Caroma Hi-flow style mechanisms, I only had success when allowing the (official spare clear /thin) washer to flare up off the plastic base. Given it's meant to seal with the outlet and not the plastic part, this makes sense.

    • @AnnErasmus
      @AnnErasmus 2 дні тому

      Thank you for sharing 😊👍

  • @gregorioiacobelli9503
    @gregorioiacobelli9503 4 дні тому

    Bravo. Grazie from Italy

  • @chasmarischen4459
    @chasmarischen4459 8 днів тому

    Thank you! The best methods yet.

    • @AnnErasmus
      @AnnErasmus 8 днів тому

      You are most welcome 😊👍

  •  11 днів тому

    awesome--thanks!

    • @AnnErasmus
      @AnnErasmus 11 днів тому

      You are most welcome 👍😊

  • @sophiebright2801
    @sophiebright2801 13 днів тому

    This is exactly my toilet 😅. So grateful 🥳

    • @AnnErasmus
      @AnnErasmus 12 днів тому

      You are most welcome 😊👍

  • @andrewlarbi8544
    @andrewlarbi8544 13 днів тому

    Thank you

    • @AnnErasmus
      @AnnErasmus 13 днів тому

      You are most welcome 😊👍

  • @LaurieMcCammon
    @LaurieMcCammon 14 днів тому

    My tag didn’t start to separate by turning like yours did, so your method did not work for me. I was able to cut the back disk down to the center with the wire cutters, then was able to fit the wire cutters around the pin. But it took lots of cuts and took a toll on the fabric.

  • @judithmarshall1365
    @judithmarshall1365 15 днів тому

    I have reasonably good luck with my crispy crackling on pork by starting off properly preparing pork. First remove that mesh thing and use a sharp blade (knife or kitchen only box cutter/stanley knife to cut through rind but not the meat. Rub in cooking oil of choice (I use Rice Bran oil but reg olive oil sounds okay) rub in the salt so it goes all over rind, especially in the cuts. Start oven at closer to 215 degrees celsius for 30 minutes and then reduce heat to 180 and cook the rest of the time required by the size of your roast. 10 minutes before end of cook time check and if not crackled enough turn oven to grill mode (still at 180 degrees). Then if roast is ready remove from oven and crackling should be perfect or close. If crackling isn't quite there remove from roast. I return crackling to oven under grill for another 5 to 15 minutes, checking every 5 minutes... or you could try putting paper towel wrapped plate of crackling in microwave oven at about 70 percent power for 30 seconds. Pull out, will crisp up even more once cooled.

    • @AnnErasmus
      @AnnErasmus 15 днів тому

      Thank you for taking the time to share your knowledge 😊👍

  • @Edgunsuk
    @Edgunsuk 21 день тому

    built my own cabinets this was a life saver thanks m8

    • @AnnErasmus
      @AnnErasmus 20 днів тому

      You are most welcome. Well done 😊👍

  • @alpha1007
    @alpha1007 24 дні тому

    Very well explained ! Thanks it helped a lot

    • @AnnErasmus
      @AnnErasmus 24 дні тому

      You are most welcome 😊👍

  • @rangiferi
    @rangiferi 26 днів тому

    I’m adding a new floor which is a bit higher than the original. Can you cut the height of these ikea toe kicks. Or is there another solution? Thank you

    • @AnnErasmus
      @AnnErasmus 25 днів тому

      I don't know of any other solution, I have cut them before. As long as you do not damage the slot that the retaining clip fits into. Not a nice job, good luck 😊👍

  • @letsmakelifebetter114
    @letsmakelifebetter114 28 днів тому

    Hi. Quick question. Which side the groove side will be. Up or down?

    • @AnnErasmus
      @AnnErasmus 27 днів тому

      Good question, I don't really know but would suggest groove side up?

    • @AnnErasmus
      @AnnErasmus 27 днів тому

      Good question, I don't really know but would suggest groove side up??

  • @philtaylor3098
    @philtaylor3098 29 днів тому

    VERY useful. Was about to throw the PC through the windows....Did you see what I did there.... ahhhh Never mind.🤣

    • @AnnErasmus
      @AnnErasmus 28 днів тому

      I know very frustrating 😊👍

  • @JoesPhenomenal
    @JoesPhenomenal 29 днів тому

    To find the studs in the wall, I just use a strong magnet. It will stick to the drywall screws. Works like a charm.

    • @AnnErasmus
      @AnnErasmus 28 днів тому

      Thank you for sharing 😊👍

  • @NOELTM
    @NOELTM Місяць тому

    This video and the earlier one showing how you and Ann make the drawers are both excellent. I found the supplied instructions quite confusing in places but these videos made the whole process a breeze. IKEA should just put a link to your videos and save a ton of paper!!

    • @AnnErasmus
      @AnnErasmus Місяць тому

      Thank you for your kind words, much appreciated 👍😊

  • @mariorabottini5687
    @mariorabottini5687 Місяць тому

    Awesome content! Really enjoyed this! Cheers Mario!😀

    • @AnnErasmus
      @AnnErasmus Місяць тому

      Thanks for your support once again Mario 👍😊

  • @danshoe4758
    @danshoe4758 Місяць тому

    I was having some corned beef the other day and thought it might make a good biltong. Thanks for your informative video! I will be making this next time I see corned beef on sale

    • @AnnErasmus
      @AnnErasmus Місяць тому

      You are most welcome, good luck 😊👍

  • @masmala
    @masmala Місяць тому

    Thank you

    • @AnnErasmus
      @AnnErasmus Місяць тому

      You are most welcome 👍😊

  • @robertberlinguette3651
    @robertberlinguette3651 Місяць тому

    Is so cheap now. Made in china

  • @beast_boy_Khanna
    @beast_boy_Khanna Місяць тому

    yaaaa 69th comment

  • @matterasmus
    @matterasmus Місяць тому

    fantastic

  • @Mattdell-gc2oo
    @Mattdell-gc2oo Місяць тому

    cool

  • @Mattdell-gc2oo
    @Mattdell-gc2oo Місяць тому

    Fantastic thanks

    • @AnnErasmus
      @AnnErasmus Місяць тому

      You are most welcome 😊

  • @AnnErasmus
    @AnnErasmus Місяць тому

    Comments are most welcome, if you decide to try this please send us some feedback☺ Why not visit our channel and browse through our other videos? ua-cam.com/users/AnnErasmus

  • @dougwachs
    @dougwachs Місяць тому

    Thanks for the video mate! I'm in Kentucky, USA and no one around here has any experience with Caroma cisterns. I bought this years ago when dual flush was new here in the States and Caroma was the best at it. But I've had a time getting my new washer to seat properly. I'll try your advice and see how it goes. g'day!

    • @dougwachs
      @dougwachs Місяць тому

      well, looks like the soap and knife trick made it work. I also had not been really careful to keep the washer placed uniformly around the seat - it was mishapen a bit - I sorted that all out and it seems to be working. Thanks again - it was a real help - I love my 20+ year old Caroma and didn't want to replace it!

    • @AnnErasmus
      @AnnErasmus Місяць тому

      Well done 👍 Thanks for your feedback

  • @styhy
    @styhy Місяць тому

    Hey granpa its works :)) thanks

    • @AnnErasmus
      @AnnErasmus Місяць тому

      You are most welcome 😁👍

  • @youking4861
    @youking4861 Місяць тому

    Could you talk any slower?😊

  • @cjay233
    @cjay233 Місяць тому

    Thanks for this. I've been hating looking at the doors for years. It looks much better. It could probably use taking apart and squaring off the cabinets, but I'll leave that for some young person; I just can't go through that🙂. It's in a closed off room.

    • @AnnErasmus
      @AnnErasmus Місяць тому

      Well done, you are welcome 😊👍

  • @cjay233
    @cjay233 Місяць тому

    Thanks so much for this, particularly the information on the screws. I'm finally going to secure mine.

    • @AnnErasmus
      @AnnErasmus Місяць тому

      You are most welcome 😊👍

  • @Fussyfarro7
    @Fussyfarro7 Місяць тому

    🤣🤣🤣🤣

  • @juliedodd2867
    @juliedodd2867 Місяць тому

    Thank you. Good clear instructions. Been stressing about getting a plumber. 😊

    • @AnnErasmus
      @AnnErasmus Місяць тому

      You are most welcome 👍😊

  • @Fritsvrolijk
    @Fritsvrolijk Місяць тому

    Thanks Pro

    • @AnnErasmus
      @AnnErasmus Місяць тому

      You are most welcome 👍😊

  • @rusticrye5413
    @rusticrye5413 Місяць тому

    IKEA have done a really good job with these Metod plinths. Unfortunately, I have the old Faktum plinths which weren't nearly so easy to fit! I'm just about to start replacing the doors and side panels of my old Faktum units. I'd planned to replace the plinths too, but they're in decent condition so I've decided to prep them with ESP and then paint. A lot of the clips have broken, but they're still available on eBay, thank goodness. Quite a bit of work, but easier than cutting new plinth pieces to size and faffing around with the dreaded iron-on tape!

    • @AnnErasmus
      @AnnErasmus Місяць тому

      Good luck with your project 👍😊

  • @ricardofigueredo500
    @ricardofigueredo500 Місяць тому

    Muy bueno. Gracias por compartir

    • @AnnErasmus
      @AnnErasmus Місяць тому

      Eres muy bienvenido👍😊

  • @182gonza
    @182gonza Місяць тому

    Really appreciated it! I was going crazy about this.

    • @AnnErasmus
      @AnnErasmus Місяць тому

      Glad it helped!👍😊

  • @evebartolo792
    @evebartolo792 Місяць тому

    Tha k you for sharing .😊

  • @laurahughes1987
    @laurahughes1987 2 місяці тому

    I’m just going to take my jeans back, they can do it 😂

  • @alextran9895
    @alextran9895 2 місяці тому

    Wanted to say thanks Matt. You video helped a lot and it was the same type as my toilet. Saved me from having to replace the whole unit.

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      You are most welcome, pleased this helped 1👍😊

  • @TheHateSpeechChannel
    @TheHateSpeechChannel 2 місяці тому

    The 4th solution is to sand down the downlight to the size of your hole

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      Thanks for sharing 👍😊

  • @stevedonaldson.8579
    @stevedonaldson.8579 2 місяці тому

    KISS at it's best. Thank you.

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      You are most welcome 😊👍

  • @user-pm2dt8td9c
    @user-pm2dt8td9c 2 місяці тому

    Many thanks Uncle..I assumed your from South Africa..😊

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      You are most welcome 😊👍.yes. Rhodesia-south Africa-UK-Bahrain-South Australia in chronological order 😁

  • @emailshe
    @emailshe 2 місяці тому

    Thank you. All other channels that I saw somehow missed this part.

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      You are most welcome 😊👍

  • @germansaez9408
    @germansaez9408 2 місяці тому

    Thank you. It was very helpful.

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      You are most welcome 😁👍

  • @scotstoddard5640
    @scotstoddard5640 2 місяці тому

    Very helpful video. I was looking to identify which USB ports I have and learned a lot here. Thank you!

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      You are most welcome 👍😊

  • @keithd5181
    @keithd5181 2 місяці тому

    Thank you so much.

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      You are most welcome 😊👍

  • @peterbarlow8912
    @peterbarlow8912 2 місяці тому

    Method #4. Put the larger hole saw through a scrap of anything and secure it over the previous hole. Now the hole saw will be piloted by the rim. It doesn’t need to be concentric. Pilot blocks can be used with all kinds of drills.

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      Thanks for sharing 😊👍

  • @user-ke9bb3gq5c
    @user-ke9bb3gq5c 2 місяці тому

    Thank you so much for this explanation. Wasn't sure if we were going to need to replace the whole cistern as we couldn't figure out how to undo the bottom bit to get the washer off without breaking it. Details where crystal clear a $3 washer and no more leaks. You are the best.

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      Well done, you are most welcome 😊👍

  • @jillcoats905
    @jillcoats905 2 місяці тому

    As everyone has said, this was a terrific video. I followed your instructions carefully, and it worked like a charm!. Thank you so much!

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      You are most welcome, well done 😊👍

  • @iainfrom186
    @iainfrom186 2 місяці тому

    Thank you so much for this great video & instructions. Finally repaired a long standing leak by watching this. Cheers mate

    • @AnnErasmus
      @AnnErasmus 2 місяці тому

      You are most welcome 👍😊