Lessons Search Results

How To: Use text functions (TRIM, PROPER, SUBSTITUTE) 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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to transform bad data into useful data using formulas and text functions such as TRIM, PROPER, SUBSTITUTE, REPLACE, FIND and LEFT. Also see how to use the ampersan...

How To: Create simple math formulas in Microsoft Excel

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 2nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to create math formulas in MS Excel using addition, subtraction, multiplication, division, exponents, and parentheses. See how 2+2*2 is not equal ...

How To: Use relative & absolute cell references in MS Excel

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...

How To: Work with cost & selling price markup in MS Excel

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 48th installment in his "Excel Business Math" series of free video lessons, you'll learn about the basics of markup on cost and markup on selling price. Markup on cost uses the base cost. Markup on selling price uses the base selling price.

How To: Calculate markup on selling price in Microsoft Excel

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 50th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make calculations for markup on selling price in MS Excel.

How To: Solve for rate of change in Microsoft Excel

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 29th installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve for rate, amount of change and rate of change.

How To: Round to the penny or dollar in Microsoft Excel

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 9th installment in his "Excel Business Math" series of free video lessons, you'll learn about when you must use the ROUND function in Excel. Round to the penny or dollar with this free video lesson.

How To: Add and subtract numbers with Excel's SUM function

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 10th installment in his "Excel Business Math" series of free video lessons, you'll learn how to add and subtract using the SUM function.

How To: Create a contribution margin income statement in Excel

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 very first installment in his "Beauty of Excel" series of free video lessons, you'll learn how to create a contribution margin income statement across various units sold.

How To: Build confidence intervals & test hypotheses in Excel

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 47th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values. Compare building confidence int...

How To: Find confidence intervals without the sigma in Excel

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 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...

How To: Use Microsoft Excel 2007 for statistics

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 very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.

How To: Extract records with an advanced filter in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Retrieve data from many tables on many sheets in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...

How To: Clean up a bad data set for a pivot table 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 70th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to clean up a bad data set with the TRIM function before building a pivot table (PivotTable) to calculate an average. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Calculate variable commission totals in MS Exce

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...

How To: Convert a text formula/function to a number in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 44th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use 4 different tricks to convert a text formula or function to a number. Also see how to convert text to numbers. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Extract the top 5 values from a given list 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 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Hide columns and select only visible cells 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 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Sort and extract by cell color in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Cool down after belly dancing

It's always important after every form of exercise to cool down. In this video, learn how to cool down after belly dancing and temper the body back to its normal state. Learn how to stretch out your worked out muscles during a cool down with help from a belly dancing 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: Incorporate floor work into your belly dancing

If you thought belly dancing was all about wiggling your hips, you were wrong. Expand your horizons and learn some belly dancing floor moves. It's important to wear knee pads in the beginning until you master the moves. Learn about the various ways to incorporate floor work into your belly dancing from this 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 Wond...

How To: Do ballet exercises at home

Increase your flexibility, elongate muscles and strengthen your feet with a thera-band and these at home exercises. Continue practicing ballet at home between lessons with the following instruction from a pro. Mikael Monson is an instructor specializing in ballet and pointe at the Virtuosity Performing Arts Studio/Vancouver Elite Gymnastics Academy in Camas, Washington. Learn more ballet from this expert by searching WonderHowTo! You're only practice time away from ruling the dance floor!

How To: Do easy, good-looking street dance moves

Everyone hopes their dance moves come off lookin' cool and you are no exception. (You are searching the Internet or free dance lessons, right?) In order to do easy, good-looking street dance moves, it's important to add swagger to street dance moves, such as the running man. Learn from two experts how to do street dance moves.

How To: Survive a hangover

TVLesson has created a video on how to survive a hangover in two simple lessons, lesson one is drinking knowledge and preparation, and lesson 2 is drinking tips and hangover remedies. Lesson one breaks down what alcohol does to your body and how to prepare for heavy drinking. Lesson two breaks down what to do after you've had a lot to drink and that all you'll need to prevent yourself from having a bad hangover is patience, juices, ibuprofen, and a lot of rest. So if you're looking to prevent...

How To: Do a plie ballet position

The plie, many times misspelled as "plea", is commonly used ballet technique and is usually used to warm-up at the barre. When learning how to do a plie, it's important to note the differences between the demi-plie and the grand-plie, which is a deep knee bend taking your body all the way to the floor. Get your plie skills down with help from this dance tutorial.

How To: Do an arabesque in ballet

Getting into ballet? The arabesque ballet is a fairly difficult move and is usually put off until a dancer is conditioned and ready for such a move, usually around the third year of their training. Find out the proper way to do an arabesque with help from a ballet instructor in this video tutorial.

How To: Make a ballet tutu

Be a prima ballerina and get a tutu! Not sure which kind? Ballet tutus have taken on a variety of different forms over the years. Learn about all the different styles of tutus from an expert in this ballet video.

How To: Clean ballet slippers

Got a pair of dirty ballet slippers? Learn the best & most effective way to clean your shoes up to make them look new. When cleaning ballet slippers, you need to take into consideration what type of ballet slipper it is. Determine the best way to clean your ballet slippers with help from this video.

How To: Get in the 5 basic ballet positions

Before you learn anything, the five basic ballet positions are what is needed first. In this video tutorial, learn the five basic ballet positions: first, second, third, fourth & fifth - and how to do them correctly with the right footwork & posture.

How To: Teach preschool level ballet

Interested in taking your ballet skills to the classroom? In this video, learn how to go about teaching preschoolers how to dance and how to get your youngsters excited about this new form of exercise and skill in their life! Get some great tips on games to teach your preschool students to keep them occupied and keep that smile on their face!

How To: Do traveling Bachata steps in Bachata

Want to learn the Bachata? All you need is some space, a partner and some Bachata music! In this dance tutorial, learn specifically how to do traveling steps which follow a four beat pattern. Get on your way, learning the most basic of Bachata moves with help from this video tutorial.

How To: Do a reverse cross-hands Bachata turn

Looking to learn the Bachata? We've got a string of videos that will get you on your way. In this dance tutorial, learn the reverse cross-hands turn, which starts with the ladies on the left and ends with the ladies on the right. Learn how to do the reverse cross-hands turn with guidance from a professional dance instructor.

How To: Do basic partner Bachata dance

The Bachata dance originates from the Dominican Republic and is made up of four basic Cuban dance moves to do with a partner, both while in open & closed positions. Learn how to get these four basic steps down before you hit the dance floor with help from this dance video.

How To: Do basic Bachata dance steps

Before you become a pro, it's important to get the Bachata basics down! When doing these basic steps, ladies will emphasize her hips more, and the male dancers will emphasize their legs. Learn the basic foundation of Bachata dance with help from this dance tutorial.

How To: Do pivot Bachata dance steps

Switch things up with the Bachata dance with pivot dance steps! For women & men, the Bachata pivot dance steps are slightly different, so be sure to watch carefully! Get your pivot down with help & tips from a professional dance instructor.

How To: Do forward & backward Bachata dance steps

Most can move forward, but can you move back? The forward-back Bachata dance steps are done by starting in the closed position and making sure your hips are as close as possible to your dance partner's. Master the forward-backward Bachata dance steps in no time with a little help from this dance tutorial.

How To: Put Bachata dance steps together

Not really the choreographer type? Have no fear - In this Bachata dance tutorial, learn how to put together Bachata steps to make your dance floor experience a fluid one. No more jerking, stopping, or stepping on one's toes... Learn how you can master your Bachata moves with help from a professional dance instructor.