Psychological Conditions Search Results

How To: Sum & count with array formulas in Microsoft Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.

How To: Identify problems with evergreen trees

This will illustrate us how to identify problems with evergreen trees. Here are the following steps:Step 1: First of all look for all the evergreen trees.Step 2: Now look for the problems that is whether there is any fungal or bacterial infection occurring.Step 3 : Now look for the climatic requirements as well as the water requirement for the plant.Step 4: Look whether the conditions are available to your surroundings or not.Step 5: Also find out whether the soil type is idle for the plant g...

How To: Remotely access the a/c in a 2010 Prius

Prius models that are equipped with tilt-slide moon roof have a remote control button on their smart keys for the remote air-conditioning system. Before leaving the vehicle, make sure the headlights are switched off or set to auto. All windows are closed and check the temperature setting of the AC system. As you return to the Prius, press the remote AC button on the smart key remote to activate the air conditioning system. The cabin will cool to the pre-set temperature without turning on the ...

How To: Use a "do while loop" for Java programming

Learn how to use a 'do while loop' in your Java programming. 1. Set up an 'int' variable named 'counter' and assign it a '0' value. 2. Set up a standard 'do' loop. Make sure to add a counter, so the loop will end 3. Then write the 'while' condition. Make sure that you set the condition to the same variable name that you used in the counter from step 2. Set the variable to '=' 10 (or any number desired)

How To: Make your own conditioning hair mask

Healthy, shiny hair is just an avocado away. In this tutorial, Roni Proter, host of Simply Beautiful, shows you how to make a conditioning hair mask using ingredients at home. All you need is some honey and a ripe avocado. Watch this how to video and you will have stronger, silkier hair in no time.

How To: Pick the right tool for weeding the garden

This is a "Southwest Yard and Garden" episode that details the proper selection of gardening tools for fighting seasonal weeds. Horticulturist and host Curtis Smith takes us to meet with Ron Jobe, an Albuquerque Master Gardener, to discuss the options available for such a task. Ron covers the various conditions a gardener is faced with, including the soil and the weeds themselves. Some suggested tools are: the Wing Hoe, Skimming Hoe, Raker, Pointed Hoe, and Stirrup Hoe. The use of each is off...

How To: Make homemade deep hair conditioners

In this Beauty and Style video tutorial you will learn how to make homemade deep hair conditioners. Robert Steinken, hair stylist from Los Angeles presents this video. Take mayonnaise; depending on the length of your hair take half a cup to up to a cup. Take two eggs, add to the mayonnaise and mix them up well. If you want some more shine to our hair, add some olive oil. Olive oil is fantastic for hair conditioning. Mix well and apply it to your hair evenly. Then wrap up your hair. It keeps t...

How To: Setup your HP TouchPad using the initial webOS wizard

If you were one of the lucky individuals to score a TouchPad before HP discountinued them, you will need to proceed through the initial setup wizard when you turn on the device for the first time, or after performing a data wipe and reset on the tablet. This guide will walk you through everything from accepting the terms & conditions, connecting to a Wi-Fi network, and creating a webOS account for the first time.

How To: Perform a vulval disease or cancer check

Around 1000 cases of vulval cancer are diagnosed every year in the UK, mainly in women who have been through the menopause. However, there are also a range of other vulval conditions that affect all women – highlighting how important it is to self-check your vulva. Although it may seem daunting if you haven’t self-checked before, Dr Dawn Harper’s guide will show you exactly how to conduct the check – so grab that mirror! Watch this video tutorial and learn how to perform a vulval self-examina...

How To: Handle mistakes while singing

In this video, Ian Castle tells us tips on how to handle mistakes while singing. The key to making sure you are staying in great focal condition is to warm up and warm down. Next, make sure you don't do too much talking on the day of a performance. Also, don't drink alcohol on the day of or day before you have a performance, as this can alter your voice and make it coarse and dehydrated. Remember to drink plenty of water and avoid breathing in cold air. Also, purchase a portable steam inhaler...

How To: Take care of relaxed hair

To take care of your relaxed hair, you will need to choose your relaxer carefully. Lean towards relaxers that aid tensile strength rather than deplete it. The hair has to be conditioned properly and regularly. Relaxed hair has been processed, and it requires a lot of moisture. Try using a hair mask. The Moroccan masks are a good choice for your hair. Make sure that you deep condition the hair at least once a week. Try to avoid blow drying your hair. Blow drying dries out the hair. It pulls th...

How To: Clean and condition your leather car interior

In this tutorial, Car Care Products shows us how to clean and condition leather car interior. For this you will need leather shampoo, a soft bristle brush, a clean soft microfiber clothe and leather conditioner. First, take your leather shampoo and spray it onto your seat. Then, take your soft bristle brush and work the shampoo into your seat, make sure to get into crevices and on the side panel. Now, wipe the solution off with your clothe, making sure you don't leave wet spots. Finally, appl...

How To: Make home hair protein treatments

In this video, the user gives some suggestions on how to make at home hair protein treatments. She emphasizes that every good treatment consists of two components: a conditioning element, and a protein element. She suggests eggs, avocado, almond butter and soy milk for protein and yogurt, mayonnaise, nut and olive oils, and honey for the conditioning portion. She explains the importance of including both elements for moisturized hair and also that you should choose ingredients in response to ...

How To: Repair damaged hair with proper conditioner care

Macherie has an excellent method for conditioning hair. No matter what texture, deep conditioning is essential for healthy hair. Shampoo with hydrating/detangling shampoo. When drying focus on removing the excess moisture from your hair. Conditioner works best and penetrates hair that's not sopping wet. Using her fingers, she separates her hair, as she doesn't use a comb when its in this fragile state. Use approximately a quarter size amount of conditioner starting from the roots to the end. ...

How To: Make a basic survival shelter from a Mylar blanket

In this video tutorial, viewers learn how to make a basic survival shelter using an emergency blanket. The materials required for this shelter are: an emergency blanket, paracord and duct tape. This is a basic shelter that would be great for certain conditions. This setup would be ideal for the following conditions: light to medium rain, low wind, and above freezing temps. This video is very descriptive and clearly explains all the instructions. This video will benefit those viewers who are c...

How To: Keep your vinyl LPs in perfect condition

Do you have an old collection of vinyl records but can't keep them in good condition? First, take an empty syringe and fill it with clean water. Add the water from the syringe as the record plays. The water will spread throughout the record and increase the sound quality. The stylus also has to be properly cleaned. This will help you clean your old and dusty records, as well as help with recording music on your CDs.

How To: Keep RV batteries in good condition

The RV Doctor, Gary Bunzer, tells us tips on how to keep RV batteries in good condition. •If you stay in camp grounds a lot or leave the couch plugged in during periods of non-use, one of the things you need to know is the boiling out the electrolyte on the auxiliary battery.

How To: Check and replace belts in your automobile

Many of your cars engines critical components are driven by belts. Belts operate in tough conditions, such as high heat, high speed, and are under considerable tension. Since rubber is an unpredictable material, even under ideal conditions, belt failure is one of the most common causes of auto breakdowns on the road. Vehicle belts are easy to check, like serpentine, drive, and multi rib belts, and to replace them at home is relatively easy and inexpensive. This is the best way to take care of...