New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.
In this two-part video tutorial, learn how to paint a neon orange & silver nail art design with the help of a nail professional. Although this orange & silver color scheme is used, one can choose any two colors they like to complete this look. Use this video as a guide and get this simple nail manicure done in no time!
In this video tutorial, viewers learn how to use a green screen in iMovie. Begin by opening iMovie and click on Preferences. In the General tab, make sure the Show Advanced Tools is checked. Now film your video with your green screen. Then import the video(s) onto your computer from your camera. In iMovie, click on File, go to Import and select Movies. Place the video(s) in your project. Drag the green screen clip onto the project clip. When the menu pops up, select Green Screen. This video w...
Learn how to enable JavaScript and cookies in the Opera web browser. 1. Open Opera. 2. Click on tools. 3. Click on "preferences" to open the preferences pane. 4. Select the "advanced" tab. 5. Click on "content" and then check the "enable JavaScript" checkbox. 6. Click "cookies" and then click "accept cookies". 7. Click "ok" to close the preference pane and save the settings. Now you should be able to fully enjoy the web on your favorite browser !
Customizing Window Vista's glass borders is relatively simple. In order to expand the borders, right click and choose properties, then choose appearance. Scroll down and click on 'open classic appearance properties'. Under Windows Aero, choose advanced settings, and click on desktop and choose border padding. You can then increase the size to your choosing and click 'ok' and 'apply'. After a few short seconds, you will notice that your borders are fatter than they were before! You can also us...
This video shows how to make this spicy chicken dish. The chicken breasts are marinated in advance for 24 hours. They are grilled with the skin down first, which helps preserve the moisture and flavor of the chicken.
Dr. Cook discusses the best ways to pack your food for a camping trip. When it comes to packing food for your camping trip, the best way is simply to pack everything into Tupperware. Everything will be held neatly in one place, and certain items can even be organized in Ziploc bags, and then put into the Tupperware. These bags are also great for keeping the food dry, and can also be used to pack individual meals. Removing the food from its original packaging and placing it in a Ziploc bag als...
In this video tutorial, viewers learn how to seal gaps in houses using DAP foam sealant DAP 3.0 Weather seal caulk. The DAP products are designed to meet the tough standards demanded for professional window & door installations while effectively sealing large cracks, gaps and voids. Users learn to use the foam sealant to seal in gaps from inside the house. The gaps found behind wall trims. The seal caulk is used outside around windows. This video will benefit those users who want to learn how...
Tony Reale shows you how to mod a pro-sumer Canon HV30 camera rig in order to give it a more professional setup. Here are the items he uses:
This video is to show how to install a glass tile backsplash. Because installing glass is a little different then installing ceramic, knowing what to do is important. Use painter's tape to protect your surroundings wherever you are installing your glass and use only a white thin set mortar recommended from the glass manufacturer to adhere your tiles. Since the glass is see through, unlike ceramic tiles, you need to make sure there is no discoloration and smooth out the ridges on the mortar fo...
In this video, you will learn how to wear a bold flower print skirt in three different ways for going to school, a job interview or going out to a club.
The first step to treating acne spots is to start with a good skin care regiment to help prevent acne from happening in the first place. The regiment consists of cleansing, exfoliating, moisturizing, and protecting (which is the sun protection factor). Protecting is very important because the sun is very strong and can add to build up and make acne worse. To treat specific acne spots a glycolic or salicylic serum is recommended. These can be purchased from a beauty store or professional that ...
This is a tutorial to get XBox live without paying $100 for the router. You need an Ethernet cable and a laptop or computer with a wireless internet connection. To begin, go to the start menu and click on control panel. Change the control panel view to classic view. Then click on network connections and go to your wireless connection under the heading 'LAN or High Speed Internet'. Right click on the wireless connection icon and select properties. In the properties window, go on to the advance...
The tutorial shows you how to make a professionally looking Google Chrome logo in Photoshop CS4. To start, download the Google Chrome logo, as well as an Earth picture, in a Zip file from Inteltuts. Next, open the logo file in Photoshop CS4, turn the white background layer into transparent, and transform the logo by de-saturating the picture, but make sure you leave the blue center area untouched. The last step is to transform the Earth picture so that it fits right into the center of the des...
This is a great instructional video on how to cleanse your skin. It is true that cleansing the skin is a very simple process and it is centered around finding the most appropriate cleanser for a specific skin type. you can learn about cleansing dry skin, normal skin or oily skin with help from a professional skin care specialist. This video teaches the mom to cleanse the skin. If you have a dry hair you can use moisturizers for cleansing your skin. If you have oily skin you can't use moisturi...
Be warned before hand that by making changes your router settings that you know nothing about can damage your router. Start off by opening your internet browser and then in the address bar either type 192. 168. 1. 1 or www.routerlogin.com. A prompt will come up in which you have to fill in "admin" in the first box and "password" in the second one. Look for the "Advanced" option and under it will be "WAN", click it. Now change your "NAT filtering" to "open". Make sure that "Disable SPI Firewal...
In this art tutorial, you will learn how to draw and then paint an orchid. You will need a Chinese paintbrush, a plate for the paint, water and paper. For paint colors, you should make sure you have red, yellow, black, green, blue and purple. First, dip your brush into the water and then mix yellow, red and black, dabbing some of each color onto the brush. When doing this, do not actually mix the colors on the brush. You want the red on one part of the brush, the yellow on another part, and t...
Learn how to fix or recover a corrupt windows registry following the steps outlined in this video tutorial. To begin, take the hard drive out of the computer with the corrupted registry and connect to another computer. To find the files you need to replace go to Start and My Computer. Look for the hard drive that you just added and double click on it. Go to Tools and Folder Options. On the View tab under Advanced Settings click Show Hidden Files and Folders, and unclick Hide Protected Operati...
Rather than spending money at a professional salon, learn how to get inexpensive highlights at home. This technique will give you a very natural look with no orange tones. You need a product called Jolen. Mix about 1/4 teaspoon of this powder. Pull your hair back and take small sections about 1/4 of an inch thick and apply product to that section. You should make sure to wear regular gloves as you are applying the product. It is okay if the product mixes with other products. Continue this wit...
Adobe Photoshop CS4 is a common and popular tool for logo creation. In this video the finer details of using CS4 to create logos, specifically for use on YouTube, are explained. Lighting effects, glossing, and glowing are covered thoroughly with step by step instructions on using layers and shading are provided, and the video carefully demonstrates each process before moving on. Many options are shown, as well as detailed examples of each technique and even the basic tools inherent to Photosh...
You’ve got the basic head structure down and now it’s time to learn how to draw a detailed face of woman. It can be a little tricky to draw an angled view of a face but you can use sketching and shading tools to give depth, angle and form to create a realistic woman.
In this video molly1216 explains her method of repairing a hardcover book hinge. She mentions that this method should be used for inexpensive books that are not worth being sent to professionals.
An two part introduction or overview of English articles: a, an, the, and the zero article. This is for the advanced or intermediate student. Part one presents basic rules or guidelines for using English articles. Part two summarizes the basic rules for using English articles and offers practice.
This video shows the viewer how to draw a cartoon reindeer. This is done by building up the character of the reindeer gradually -drawing different features in a set order to create the whole cartoon. The first stage is to draw the eyes and eyelids. The eyelids are crucial as they add character to the drawing. Next is the mouth and the nose, followed by the cheek and the eyes. The antlers complete the reindeers head. The body is very simple and simply compromises of four legs and a tail drawn ...
This video shows the viewer how to rejuvenate damaged hair with a few simple techniques. The first stage is to not let the hair get damaged in the first place. One of the most common causes of damaged hair is excess use of heat on the hair – either through a blow drier, straightening iron or a curling iron. Another cause of damaged hair is allowing the hair to become matted. This can be sorted out by simply combing the hair. If the hair has become damaged the recommended approach is to get it...
Windows Movie Maker can be used to make HD movies. This step by step clip shows you how. The first step is to import your picture or video and make sure they're in your timeline. When you've finished editing, go to tools and options and choose the advanced tab. In video properties there's video format and aspect ratio. Select NTSC and 16:9. If you're using a cell phone or video camera, you'll be using 4:3 which is pretty small for YouTube and similar sites in order to get full screen. Save th...
The video first opens up with a muscular man standing in a well lit weight room. He begins with a quick description explaining how he will be performing the stretches and then begins to do so. He swings his leg back behind him and bends it and pulls it up to his behind, he continues to do so for some time. Next he brings the same leg forward and stretches it over his other knee. After that, he bends over and exhales and touches his toes. He then gets a foam pillow and stretches his legs out c...
This is another video in the helpvids series of technology videos. The video describes how to set power options in Microsoft Windows XP. These options control when the monitor is turned off, when the computer goes to sleep, and when the computer will go into a hibernation state. Laptops will have more options than desktop computers since there are battery options on a laptop. Click on the Start Menu and then Control Panel, then Power Options. The first screen offers the option to turn off you...
This video shows the viewers how to create a simple but well done Halloween text in GIMP. Starting from a simple white background you will end up creating a creepy text perfect to use every year on the 31st of October . The video is actually a easy to learn walk through , showing your each and every step you need to make . Advance users but also beginners can benefit from this short clip . At the end of the video you will surely create the type of text you usually see only in horror movies su...
This is a tutorial on how to clear your Skype call history and chat history. The option for clearing call and chat history is difficult to find in Skype. To begin, click on Tools and select Options from the Menu. In the pop up box, click on the Privacy button. By showing Advanced Options, you will be able to access the button which enables you to clear your call and chat history. Please note that when you click the Clear History button, you will not only delete your call and chat history, but...
This video discusses the number zero in division. When dividing numbers, there are ways to check your math, like multiplying the two numbers. When you multiply zero with any other number, it still is zero. The video goes on to discuss indeterminate answers. If you were to divide a zero by a zero, your calculator would come up with an error message. But there are real results to these odd equations and they are indeterminate. The indeterminate doesn’t really show up in everyday living, but in ...
This is another HelpVids video on technology. In this segment we will learn how to set appearances and themes in the Microsoft Windows XP operating system. The videos starts by right-clicking on a blank area of the desktop, then selecting ‘Properties’. The presenter then clicks on the ‘Appearance’ tab. Clicking on ‘Advance’ will open some very detailed options such as changing the font in a title bar window. You can also change the size of the fonts in this window. The options are truly endle...
This is a presentation of how to build up confidence on the red carpet. According to this interview section , being confidence is an important for any games or activities. And if you have talent, that’s the one thing which builds up your confidence. If you have talent and you are really confident about that talent then, you are really on the right track. Young persons can build up confidence by understanding and practicing their abilities. Among kids confidence can be build up by respecting p...
A video from Helpvids.com that shows how to Insert and edit text in Microsoft Word 2007. There are many ways to do document editing tasks in any of today's advanced word processing programs and MS Word 2007 is no exception to it. There are many ways to do the same task in word (For Ex. from the menu, using mouse gestures, using shortcuts etc).
Learn to make two different delicious chicken recipes, chicken royale and chicken cushion, from a professional butcher in this video. Watch the demonstration of how to carve a whole raw chicken into two boneless breasts and two boneless legs. The legs will become chicken cushion, a bacon wrapped dark meat dish filled with stuffing and sauce. The second recipe shown is chicken royale. It is similar to the first recipe with stuffing and sauce, but the bacon is draped over top instead of wrapped...
In this video a professional boxer demonstrate the basics of boxing so that you can protect yourself. First of all, you should stand in such a manner that your left foot is in front and the right foot is in back (if you are right-handed). Make a fist, put both hands in front of your face. The distance between both the hands should not be much so that in any case, you can cover and protect your face. Your left hand should always turn up and pull back. For punching, take your right hand fist ne...
Diane Morgan shows us how to make a delicious marinade for salmon and grill the salmon on a wooden plank.
This quick and easy tutorial is going to show you how to curve ball like many of the professional baseball players you see do. To begin you want to take a baseball in your dominate throwing hand and hold it so you have your middle finger on the seam where the two seams come closest together. If done correctly you should have your index finger just outside of the seam, it should be to the all the way left or right of both seams not in between. Now, just take your regular pitching motion and in...
Darin Stein from Fat Loss Lifestyle demonstrates how to build your pectoral muscles with exercise tips. Put two medicine balls into the butt of your palms, not your fingertips, for pushups. Lower your body for two seconds, keeping your elbows apart. Get a real nice stretch in the chest and push your body up. Do fourteen pushups. For an advanced workout, elevate your feet when doing the pushups. Walk a 65 millimeter resistance ball to your toes and continue doing the pushups. In addition to to...
