Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:
To solve a proportion for a variable you should employ cross multiplication. The basis of cross multiplication is the property which states that the product of the numerator of one fraction and the denominator of what it is set equal to is equal to the product of the remaining denominator and numerator. For example if you have x/15=21/45 you simply need to multiply x by 45 and 15 by 21 then set them equal to each other. The result of this is 45x=315. To solve this new problem for x, divide bo...
Winter hair is usually lackluster and dry. Most of the time, we're just hoping that it doesn't resemble a thing of tumbleweed.
The beauty industry uses a lot of long, tricky words on their product labels. From paraben-free to noncomedogenic, it can get confusing trying to decipher just what it all means.
Household cleaning products are some of the most toxic things in your house. If you want to get them out and replace them with all-natural alternatives, watch this video to learn how to make alternative cleaning products yourself out of common household ingredients.
You don't need to be packing some in the wallet to create a dazzling makeup look. In fact, many drugstores offer great beauty products that work just as well to create intense eye or lip looks.
Learn how to optimize a Panasonic G1 or GH1 for product photography. Whether you're the proud owner of a Panasonic Lumix DMC-G1 or DMC-GH1 micro four thirds digital camera or perhaps just considering picking one up, you're sure to like this free video tutorial, which presents a complete overview of how to shoot terrific product portraits with a G1 or GH1 camera. For more information, including detailed instructions, watch this digital camera user's guide.
People think that chickens are like garbage disposals but chickens don't eat everything: you don't want to feed them meat or dairy products; processed foods aren't good for their digestion.
They may sound like awfully heavy things to be putting in your hair, but these products, used sparingly, are ideal for creating light, unstructured hairstyles. You will need a hairstyling product, a strong shampoo, and a towel. Watch this video hairstyling tutorial and learn how to use hair products to do your hair.
In the video Robert Steinken, who is a hair stylist tells that choosing a hair color is a very important task. Firstly it is important to go to a professional stylist who knows the products well. There are a lot of hair products in the market and each has a different effect on the hair. In the salon the professional can show you a color chart and show little pieces of hair which were colored to compare with your present hair color. They can tell what will happen once the product is applied on...
Need to shoot a product with a white background? Well, taking photos with a white backdrop can be tricky if your subject is white also. Watch this behind the scenes photography video to see how to photograph a white product with a white background. This style of shoot is quite standard for eshops which need product photos with a white background. It takes a couple flashes and a goo camera to get it down, just watch and see for yourself.
In this tutorial, we learn how to tease your hair using Bumpit hair products. This is a product that you put in your hair to give you lasting volume all day long. It has ridges on it so it holds onto your hair and creates a volumized look! Before you place the product in your hair, you will need to gently tease it. To do this, you will take a section of your hair and hold it up in the air. After this, spray it with hair spray and then brush it down to the root from the top. After this, you ca...
The video presents "How to start your own Clothing Line Business". The steps include getting the financing, designing the prototype outfit/s, producing the line of clothing, promotion and sales. A good way of financing for a small business such as this is to sell your idea to family, friends and even colleagues. Research and prepare the business plan for your clothing line and be passionate about it in your presentation to convince them to fund your business. The next step is to get the produ...
In this video tutorial, viewers learn hoe to apply Frontline for dogs. Be sure that you get the appropriate amount of dosage for your dog. Frontline is a topical flea intake preventive for dogs. Do not let your dog go into water 72 hours before and 72 hours after apply the product. Begin by apply the product in between the shoulder blades. Do this by parting the fur and apply the product onto the skin. Also apply the product at the base of the tail. This process needs to be done once a month....
In this tutorial video, YouTube user "inteltuts" discusses ways to use Photoshop CS4 to help make better looking product pictures, as a way to attract costumers to your online products. Using a black telephone as an example, he first shows how the opacity, linear dodge, and brush tools can help make a product image look shiner, sleeker and brighter. He goes onto create what he calls "glints", which are subtle reflections and areas of sparkling light that he places across the image. Lastly, he...
This video shows how to clean a stained washing machine. Stains are typically caused by brown dirty water in the washing machine. Water is usually brown because it contains high levels of iron. The narrator demonstrates a product called CLR, which can be purchased at Home Depot. It is a product designed to remove iron and lime. He shows how to apply a small amount of the product with a sponge to the inside tub of the machine. He advises to let it soak for about 5 minutes. He then wipes the in...
Looking to make a nutritious change in your life? By choosing the right foods in the right amounts, you can reap rewards that will benefit you in all aspects of your life. In this tutorial, learn how to eat healthy and make positive changes in what you consume.
Get the most out of your look, turn yourself into the beauty you are with just a little makeup. Watch this video tutorial on how to create a Barbie-inspired green, pink and purple makeup look. Yep, that's right... learn how to turn yourself into Barbie with this green, pink and purple face. Wow everyone with this new look.
Get the most out of your hair, turn yourself into the beauty you are with just a little hair-styling and a little makeup. Watch this video tutorial on how to create baby doll-inspired hair and makeup. Yep, that's right... learn how to make gorgeous curly hair and beautiful makeup that resembles a baby doll. Wow everyone with this new look.
In this scientific video tutorial, undergraduate students in a forensic chemistry lab demonstrate how to use a comparison microscope for bullet and bullet casing comparisons, and color developments tests for impression marking enhancement (such as for filed-off serial numbers). Learn how to perform ballistics comparisons! Just like in CSI.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...
In this clip, you'll see how to import XML into a completed Product Sheet in Adobe InDesign CS5. Whether you're new to Adobe InDesign or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by free video software tutorial. For more information, take a look.
The XBox 360 has mammoth cooling problems, and people have devised all manner of products and mods that address that. This video will show you how to install one of those products: heat sinks that will cool your motherboard directly. This will keep you XBox a lot cooler without making a lot of noise like a 12 volt fan mod.
It's one of life's little ironies that achieving beachy, messy hair requires not just riding a wave at the beach but rather staying in the shade, as it were, at home and spraying on zillions of gallons of hair products and using various curling irons and flat irons.
Vaseline has been around for generations and this simple beauty product can be used in many ways. In this tutorial, learn how to use petroleum jelly in 50 different ways!
Chances are, if you're a branding or marketing professional, you've been tasked to come up with a new name for a product, a service, or maybe even a company at some point in your career. Maybe you're trying to come up with a new brand name right now. Well, there are objective measurements for choosing new names, and if you need help figuring these out, watch this video tutorial to learn how to develop a new product or company name that will stand out among your competitors, presented by namin...
According to bhaufschild, cat urine smell is a major problem in houses these days. in this video he demonstrates how to get rid of the cat urine smell. One of the best is a product called odor fix plus which extracts the cat urine smell out of the house completely. To use this product you need a bucket, a watering can, a brick and water. it is mixed as 10 parts warm water and 1 part of the product. before you use the product you will have to smell out the urine to specific areas where the cat...
Doug Simms gives a demonstration of multiplying fraction in a simple and easy manner. The simplest problems have proper fractions to be multiplied by proper fractions, and the answer can be arrived at by simply multiplying the numerator (upper value) of one fraction with the numerator of the other, carrying out the same operation with the denominators (lower values) of the two fractions, and finally, reducing the resultant fraction by a common factor, if any. Doug also gives three other examp...
This instructional photography video with Jim Talkington explores various studio photography tricks. Whether shooting products or people, the whole reason for studio lighting is to be able to define the things you want to define and to minimize the things you don't want to see in the photograph. Practice these tips and improve your photography skills.
This instructional photography video explains how to problem solve small product issues. Two ways to tackle a particular challenge is through pre-production and the other in post-production. There are many different ways a photographer can approach and deal with a challenge. The more knowledge you have about different methodologies about photography, the better and easier you will be able to solve those problems when they occur.
This will allow you to find the CD product key or serial if you have lost it so you dont have to buy another CD.
After more than two years of teasing, augmented reality startup Mojo Vision has confirmed that "invisible computing" means what we've suspected all along.
Less than a month after the worldwide launch of HoloLens 2, call center consultant BellSystem24 has already prepared an augmented reality solution for one of its clients.
It sounded great on the surface when Microsoft announced that existing Windows 7 or 8 users would be able to upgrade to Windows 10 for free, but the execution so far has left a lot to be desired. Upgrading from an existing installation is relatively easy, but when you start with a clean install of Windows 10, you run into some problems.
Amazon makes it exceptionally easy to purchase anything you want in just a few minutes. From textbooks for school to live ladybugs, its more surprising when you can't have something delivered to your doorstep in a few day's time.
Thinking about going platinum blonde? There are many precautions and notes that should be taken before making the leap. In this video, learn how to take your hair from its natural state to platinum white blond safely with the help of product. Read the videomaker's notes below.
Apple is always coming out with stylish product designs, heck even the logos they use for their products are stylish. If you'd like to learn how to make the iCloud brushed aluminum icon in Photoshop, check out this helpful video.
Looking for an easy way to track price changes? Look no further. In this clip, you'll learn how to use Google Alerts in tandem with Google's Product Search comparative shopping tool to monitor price changes and find the best value. Fore detailed, step-by-step instructions, and to get started using this online shopping trick yourself, take a look.
With the spread of smartphones and free online games, the "Freemium" model of product distribution and monetization has become prevalent over the last several years. At it's essence, it is handing out software products for free and then allowing customers to pay for in-software services using microtransactions. This video features some businessmen who do business in iPhone apps discussing how they use "Freemium" systems in their apps to make the most money possible while providing great servi...
The FSA Mega Exo is a sophisticated integrated spindle external bearing crank. Like most elaborate bike products, it has several of its own quirks that make installing it different than installing any other similar product, like the Truvativ GXP. This video demonstrates the installation of the FSA Mega Exo system, listing all of the tools your will need and the step that you have to perform to integrate this high-performance part into your biking life.
