Specialists Learn Search Results

How To: Use rounding functions & paste special values in Excel

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 28th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use Excel's rounding functions, how to paste special values – and quite a lot more besides. Specifically, this video addresses each of the following topics:

How To: Work with Microsoft Excel's order of precedence

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 24th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn see exactly how Excel calculates/evaluates formulas including things like intersections, unions, negation, text operators and comparative operators. Knowing the o...

How To: Create charts and set up pages for analysis in Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create seven types of charts — X-Y scatter diagrams, pie charts, column charts, bar charts, stacked bar charts, line charts, and column and line chart combined. ...

How To: Value assets & analyze cash flows in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 50th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to value an asset as well as perform discounted cash flow analysis with the Excel functions PV, NPV & XNPV.

How To: Run advanced VLOOKUP queries in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 40th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform eleven VLOOKUP tricks including how to use VLOOKUP with the TRIM function to remove spaces from first column of lookup value.

How To: Set data up for sorting & filtering in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 14th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.

How To: Fix common Excel spreadsheet problems & errors

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.

How To: Import different types of data in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 23rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to import data into Excel from text files, web sites, Excel files and Microsoft Office Access files. Also see how to import currency rates and major indicies from ...

How To: Create a budget with formula inputs in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...

How To: Apply conditional formatting to a row in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Calculate monthly sales with Excel's SUMPRODUCT & TEXT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Make a tea bag fly experiment at home

In this video tutorial, viewers learn how to make a tea bag fly with a home experiment. Viewers learn how to make a tea bag fly using convection. The materials required for this experiment are: tea bags, matches, tin foil and scissors. Begin by cutting the top of the tea bag and open it. Empty out the tea. The tea bag should be a cylinder shape. Place the tea bag on top of a piece of tinfoil and use your matches to light the top of the tea bag. This video will benefit those viewers who enjoy ...

How To: Say I love you in French

In this how to video, you will learn how to say "I Love You" in French. French is known as the language love, so it is very appropriate to learn how to say this properly. First, remember that "I Love You" is written as "Je t'aime" in French. Practice saying the pronunciation until you can easily say it. To answer "I love you too," note that it is written as "Mio aussi." Keep on saying this words until you learn the correct pronunciation. Once you can say both of these consistently and with th...

How To: Edit and split clips in Sony Vegas

Sony Vegas is a cool new video editing program. In this tutorial, you will learn some simple editing techniques in Sony Vegas. You will learn to detach the sound from your movie clip, as well as how to split your movie to remove any unwanted footage. You will learn how to merge both clips and use the fade in and fade out tool to create a smooth transition.

How To: Care for a fresh tattoo

Ever wondered how to take care of that tattoo after you've just been inked? In this video, learn from one tattoo expert his aftercare advice. There are many people who suggest different practices after a tattoo, but learn from one man who's speaks from experiece.

How To: Perform easy dance steps for kids

Learn a few easy dance steps to teach young aspiring ballerinas including the tombe, pas de bourree, pirouettes and releves. In this video, choreograph a simple ballet routine for children with help from an expert: Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more ballet from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Do ballet barre routines

Learn an effective ballet routine to practice your ballet. Easy dance routines are those done at the barre in each of the five positions, and they can include plies, grande plies, tondues and releves. In this video, learn how to choreograph a simple dance routine with help from an expert: Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more ballet from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Do Jive dance steps

Want to learn how to do the jive? Jive dance steps consist of triple steps and rock back steps while always keeping your body weight on the balls of your feet. Practice your jive dance steps with guidance from a pro: Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more ballet from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Sew ballet shoes

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!

How To: Do ballet barre exercises

A few basic ballet barre exercises include tondues, plies, frappes, degages and pirouette preparations. Learn some of the foundational barre exercises for classical ballet with help from an 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!

How To: Teach ballet techniques

Are you an aspiring ballet teacher? Much of teaching ballet techniques to students comes from demonstration & physical correction so that the student's muscles can learn the proper form. Learn how to teach ballet techniques from a pro teacher!

How To: Do a belly dancing routine

Learn an entire belly routine with help from a pro! In this video, learn belly dancing moves, such as the chest circle, hip slides, undulations, figure-eights and belly rolls, which can be combined into complete dancing routine, taught here, by an expert: Sahira began her career as a Middle Eastern dancer in Houston, Texas under the direction of Thalia and Shakira Masood-Ali. Get advice & more belly dancing lessons by searching Wonder How To!

How To: Perform baroque dance

Learn a few of the essential Baroque dance steps, originated in the court of King Louis XIV as theatrical entertainment. Later, Baroque developed into both ballroom dancing and classical ballet dancing. Quick a quick and free lesson from a pro: Rosario Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Do the cha cha

Do the cha cha! In this free lesson, learn about the cha cha, which is a Latin dance that originated from a Cuban song. The cha cha is made up of a combination of triple steps and rocking steps. Learn the famous cha cha with a lesson taught by a pro: Rosario Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Do a slow foxtrot

Learn how to do a slow foxtrot with help from this free lesson. The slow foxtrot is a smooth and soft international ballroom dance that marked its place in history by the orchestral music of the late 1930s and '40s. Learn this timeless ballroom dance with help from a pro: Rosario Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Dance the cumbia

The cumbia is a hot Latin dance from Columbia and ready for you to learn! Practice the steps using three counts per measure of music with help from this free lesson taught by an expert: Rosario Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Do a sacred belly dance called Ayub

Who knew you could ward off evil spirits with belly dancing? In this free lesson, learn how to do the Ayub dance, also known as the Zaar, which is a scared belly dance that is supposed to repel evilness and bad energy. Learn the rhythm and steps to the Ayub dance with help from an expert: Yasmeen began dancing at the young age of 3 and studied ballet, flamenco, folkloric, hip-hop and modern dance styles, as well as tribal fusion belly dance and Oriental Classical Egyptian belly dance. Learn m...

How To: Do the MC Hammer dance at a party

It's Hammer time! Learn how to pull of the MC Hammer Dance at a dance party! This dance consists of three steps and with a little practice is super easy to pull off. Learn how to do the MC Hammer dance at a party with help from one expert.

How To: Do the robot dance

The robot dates all the way back to the early eighties... some even say late seventies. They key to learning the robot dance is to only move one muscle at a time. Learn how to do this old school dance move with help from an expert.

How To: Dance to rap music

Does the combination of rap music and a dance floor make you nervous? Don't fear. When dancing to rap music, a great move to learn is called the jerk, also known as the reject. Learn how to do this move and more from an expert.

How To: Do a Hula dance

Get your hips out and start learning how to hula with help from this free lesson! Hula dancing is a traditional folk dance of the Hawaiian islands, and it is similar to belly dancing in the hip and stomach isolation it involves. Learn about the proper techniques for hula dancing from a pro: Rosario Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling t...

How To: Break dance the three-step

Want to learn how to break dance? In this video, learn the beginning-level three-step, a break dancing essential. In order to become a break-dancer, an individual needs to get into good shape through exercise, and he also needs to take dance classes. Learn more about becoming a break dancer here.

How To: Street dance

Learn from two experts how to street dance in this free lesson video. Street dance is a term that is used to describe dancing that was brought to streets in order to keep young people out of trouble. Learn about battling as a form of street dancing here.

How To: Become a hip-hop dancer

So, you want to become a hip-hop dancer? In this video, learn from two experts what it takes: the style, including the clothing and the music. Bliss & Zetta are professional hip-hop dancers and choreographers. Learn more dance moves from these two by searching WonderHowTo! You're only practice time away from ruling the dance floor.

How To: Do break dance moves for beginners

If you're entering into the world of break-dancing you'll soon discover there are varying levels of skill. In this video, learn how to do some break dancing moves geared towards beginners with help from two dance experts. A basic break dance move that a beginning dancer can do is the top rock, which involves crossing, turning and coming out. Learn how to do all of the steps of beginning break dancing moves with help from this free lesson.

How To: Build muscle and increase testosterone

Don't fret any longer after watching this video you'll learn how to build muscles and increase testosterone in your body. Of course, in order to build the muscles you want you'll need to increase your testosterone. Here, you'll learn how to do exercises and increase your testosterone in your body.

How To: Prevent external parasites like fleas and ticks

In this video you'll learn how to end the cycle of those pesky fleas and ticks. You'll learn exactly what to use and what to do to stop these external parasites from invading your home or living on your poor innocent animal. After watching this video you'll be able to enjoy a flea and tick free enviorment.

How To: Properly shoot and sight in a compound bow

In this video tutorial, viewers learn how to properly shoot and sight in a compound bow. It is recommended that users use a release. Your body should be perpendicular to the target. Hold the bow vertically, and hold it with a relaxed and secure grip. When you are ready to begin shooting, learn a technique that will help you relax and steady the bow. When you draw the bow string back, you should be looking through the peephole on the bow string and where the target and pins come into view. Thi...

How To: Backflip on rollerblades

In this video tutorial, viewers learn how to perform back-flips on roller-blades. Before attempting this trick, users should be able to do a back-flip off the wall. For beginners, start by learning how to flip. Once you can flip, try flipping off the wall. Depending if you're right or left handed, run to the wall and push off with that foot. When you can wall back-flips, start trying to do them with roller-blades. Go on a ramp and launch off to the side. Once you can flip off the ramp, start ...