As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 6th installment in his "Excel Business Math" series of free video lessons, you'll learn about the importance of cell References in Excel formulas and functions. Learn about a relative and absolute cell references in Excel formulas with th...
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
The video shows us how to create bevels in Xara web designer. Firstly using the rectangle tool hold down the Ctrl key to create a square. The problem with the Xara web designer is that it hasn't got a convert to edit the shape features which actually means that you cant select individual nodes with the shape editor tool which may create some other line. However you can select individual nodes by going to arrange/combine shapes/add shapes with selecting the rectangle. And by doing changes the ...
Back in iOS 6, deleting individual text messages in a conversation was just a matter of tapping the edit button on the right-hand corner of the thread, selecting which texts to delete, and then pressing delete.
Bennett Froddy brought us the Flash game sensation QWOP, and now has released a free sequel called GIRP. You control you character's individual limbs with the keyboard as before, but this time you're controlling a rock climber and using keys to grab particular handholds. It's tricky at first, but this video will show you how to beat the first 25 meters. Damn that bird!
Back in the olden days, if a lock was, well, locked, you couldn't get in the door. At least, the average individual couldn't get in the door. But inventive and scheming folk (read: ye hackers of olde) devised crafty ways to pick lock keys and sometimes even created skeleton keys that opened any door or chest. This will let you unlock someones password on an ipod or iphone touch.
When you have to use 18 individual pieces to create an origami project, you know it's going to be hard. Thankfully, with this video you'll be guided through exactly how to maneuver every crease and fold.
Enhance your visual skills and demonstrate your manual dexterity as a magician by incorporating the "RockIt" card fluorish by Ayres into your repertoire. Playing card fluorishes are typically performed as part of larger magic performances and can also be shown on their own as individual exhibitions of skill.
A pilot that earns an instrument rating is a pilot that's mastered his or her flight skills to a level or precision and accuracy needed to safely fly an airplane through clouds, fog, and other adverse weather conditions. While flying in these weather conditions, known as IMC, or instrument meteorological conditions, a pilot is tasked with flying an airplane solely by reference to flight instruments. The pilot needs to be able to go from takeoff to landing, without having any outside visual re...
Mary Silva teaches us how to organize and research materials for writing. First, copy and past all of your different references from the exact order that you wrote about them. A great way to help you organize all of these is to use notecards. If you don't want to do all that writing, then you can make your notecards on the computer! With this, you can make different notes on the bottom of the cards to help you remember things, as well as different citations. This is a great tool to help you o...
See how to organize your email by creating categories and flagging individual messages within Microsoft Office Outlook 2010. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.
Even with all the technological advancements, iPhones and Blackberries look sleek but lack individual style, their backs a basic black or silver. Turn a blah cell phone cover into a fairytale work of art by watching this video.
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 331st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract individual characters without extracting the leading zeroes through use of the MID, VALUE and COLUMNS functions.
Here is a series of hot and complex sexy salsa dance patterns. This is a more complicated salsa pattern. It is a very long pattern, so take it in strides and small bites. We have named the individual moves to help you piece the entire salsa combination together.
How to use a can opener with one hand or without a prosthesis. This is an adaptive equipment tutorial for handicapped, disabled or individuals that have lost limbs to amputation. This trick is important to ensure healthy living and daily tasks like opening food in the kitchen. Live without limits!
A below elbow arm amputee demonstrates how to tie a shoe with his prosthetic hook. This is an adaptive equipment tutorial for handicapped, disabled or individuals that have lost limbs to amputation. The prosthetic arm outfitted with a hook or hand can be body powered or myoelectric. The operation is important to ensure healthy living and daily tasks like dressing yourself.
A below elbow arm amputee demonstrates how to turn a car key with his body powered prosthetic hook. This adapted equipment video is helpful for handicapped, disabled or individuals whom have lost limbs due to amputation. He's using a prosthetic arm outfitted with a hook to start the ignition of his car.
A below elbow arm amputee demonstrates how to hold and use a knife with his prosthetic hook. This is an adaptive living video that helps handicapped, disabled or individuals that have lost a limb due to amputation. Using a prosthetic hand or hook can be challenging in the kitchen. Using a hook to hold and use a knife is an important skill to learn when using prosthetic limb adaptive equipment.
This audio editing software tutorial will show you two different types of editing in Logic Pro. First, Connor Smith shows how to edit multitrack drums in a group (to fix timing of hits) in Logic Pro. Then he covers how to ungroup your drums and take out pops, clicks (etc.) on individual drum tracks in Logic Pro.
This science video tutorial includes step-by-step instructions for extracting DNA from wheat germ, the embryonic plant attached to the wheat seed. Individual wheat seeds, or kernels, separate readily from the plant. This kernels have a tough outer coating called bran. If you want to know more, just watch this science experiment.
You can give your song texture by adjusting individual tracks to become louder and softer to emphasize particular moments. With GarageBand, this process is easy and yields professional-sounding results.
You already know you can create photo pages by selecting a photos template and dragging in individual photos from your iPhoto library. Now there's an easy way to add entire photo albums to your site, each with their own dedicated photo pages.
Just like in the Spy Kids 3D movie, US soldiers may soon upgrade their mission planning from 2D to 3D. Welcome to the wonderful world of augmented reality, US Army.
If we had the time, we would totally make all of our own Valentine's Day cards. But if you have kids, then you know that crafting 36 individual cards for each student is more than a pain in the behind.
This tutorial assumes you've already set up your Facebook account, and are looking for tips and ideas on how to create a profile. Create a page for yourself, your business, your favorite group or any other organization you want to spotlight.
This tutorial shows you how to make chainmail following the tradition European four in one method. You'll need many small metal rings of uniform size and some metal pliers (work gloves are also recommended!) Afer you make each individual unit, you're also shown how to bring them together in a larger piece.
Access your favorite FM radio station with your Motorola Q! This tutorial also shows you how to load your favorite music onto your cell phone, and then choose segments to turn into ringtones, which you can personalize further by assigning them to individual callers.
The new version of Microsoft Office has a feature which allows you to batch create PDFs. You can easily convert whole folders or specfic selections of Word, Excel or PowerPoint files into PDF files. You also have the option of converting the files into individual PDFs, or turn them into one large file.
Not everyone has the "Sun" or "Apollo" line on their palm. For those lucky enough to have it, such a line indicates many potential gifts and popularity! Watch this video as Jim Winters explains how to identify the Sun line and what it indicates for the individuals who have them.
In this video, learn how to decorate beautiful cupcakes that are perfect for spring or summer parties. These little cakes look exactly like flower pots and in this tutorial, you will get a step by step walkthrough of the decorating process. These unique and delicious cakes will make a great addition to any table.
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 357th installment in their series of digital spreadsheet magic tricks, you'll learn how to pull data from individual sheets to a single master sheet given improper data setup.
Every new pair of ballet shoes needs their elastics sewn on to fit the individual personally. In this video, learn a few tips on sewing in the elastic and satin ribbons with help from a ballet expert: Lynda DeChane-Audette is the founding artistic director of the South Florida Ballet Theater and was born in Boston. Learn more ballet from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!
Veronica Belmont from Tekzilla shares a tip for finding lost podcasts without unsubscribing and resubscribing to the feed. To do this by a simple keyboard combo fist close the disclosure triangle so that the individual episodes are hidden, then hold down the 'Option key' in Mac or 'Shift' in Windows and toggle the disclosure triangle as shown. The iTunes feed will refresh and all the past episodes will reappear. Combine this with the "Get All" button to find lost podcasts.
A below elbow arm amputee demonstrates how to put on a dress shirt, fold the collar and tie a tie with his prosthetic hook. This is an adaptive equipment tutorial for handicapped, disabled or individuals that have lost limbs to amputation. The prosthetic arm outfitted with a hook or hand can be body powered or myoelectric. The operation is important to ensure healthy living and daily tasks like dressing yourself.
A below elbow arm amputee demonstrates how to open a jar with his prosthetic hook. This is an adaptive equipment tutorial for handicapped, disabled or individuals that have lost limbs to amputation. The prosthetic arm outfitted with a hook or hand can be body powered or myoelectric. The operation is important to ensure healthy living and daily tasks like opening jars, bottles and lids in the kitchen.
A below elbow arm amputee demonstrates how to don and operate his myoelectric prosthetic hook and hand. This is a first hand account of what goes into using prosthetic hands and hooks for individuals with arm amputations. This video is an overview of adaptive equipment for handicapped or disabled persons to assist them. The myoelectric hook and hand are very helpful in assisting persons with arm amputations or otherwise missing limbs.
A below elbow arm amputee demonstrates the device he uses in the gym. He shows you how to use a prosthetic for working out at the gym when you've suffer a limb amputation. This video is very helpful in describing utilities available for enabling individuals with amputations to workout or get around and function in a gymnasium setting. This is a video that addresses adaptive equipment for handicapped or disabled people.
This is the first drum editing video in Pro Tools from thestudiofiles.com.
Watch this video to learn how you can use folders to better organize your Mac dock. Group together applications in folders and add the folders to your dock instead of each individual app.
