Tip Top Condition Search Results

How To: Keep your hair healthy

In this tutorial, we learn how to keep your hair healthy. For your shampoo and conditioner, you can use Aussie Miracle Moist, which will take care of the hair and make it feel moisturized. You can also use Aussie 3 minute miracle color treatment, which will keep your hair color vibrant without damaging it. Trevor Sorbie blow dry spray is very important to use before you blow dry to help protect the hair from heat. Aussie Duel Personality Straightening Spray is great to use before you straight...

How To: Use VLOOKUP to add a column of categories in MS Excel

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 646th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to add a column of categories using the VLOOKUP, RIGHT, LEN and SEARCH functions.

How To: Show file names in the Sony Vegas timeline

Use this simple tip to automatically show file names of all elements in your project's timeline. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Remove CD and DVD scratches with an apple

In this video tutorial, viewers learn how to remove CD/DVD scratches with an apple. This task is very easy, simple and fast to do. The material required for this task are an apple and cotton wool. Begin by butting the apple in half and apply the fresh apply onto the scratches part of the disc. Remember to rub gently on the disc. This should be done for 5-10 minutes. Now take the cotton and wipe the disc dry with it. This video will benefit those viewers who have a scratched CD/DVD, and would ...

How To: Use Excel to sort data & present data in a line chart

This video introduces how to use Excel to sort data, perform the Frequency function, and present data in line chart. See how to apply condition formatting when working in Microsoft Excel 2007. Whether you're new to Microsoft's popular word processing application application or a seasoned MS Office professional just looking to better acquaint yourself with the Word 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating your own li...

How To: Cross-Train Young Athletes with Tae Kwon Do

Football, soccer and baseball players, along with almost every sport can benefit from a little martial arts. Wait, what does martial arts have to do with playing a sport? Performance training usually makes people think of high-intensity drills, but what about Tae Kwon Do? Cross-training is actually a great way to keep youth players in shape and keep any young athlete in good playing condition. Watch this video for some warmup drills for Tae Kwon Do and some exercise and moves to keep your chi...

How To: Improve the performance of an underperforming employee

One of the trickiest parts of being a boss is handling an employee who isn't performing up to their potential. This video features tips from a business consultant on how to handle these situations, focusing on having a conversation with the employee about their performance, handling the situation calmly and effectively. Hopefully, if you follow these tips, then you won't have to take the unwelcome step of firing the employee.

How To: Get the best seat on an airplane

The politics of getting a good seat on a commercial flight are difficult to navigate and not fighting for a good seat can leave you uncomfortable for hours and wrecked when you arrive at your destination. This video features a travel expert outlining some tips for getting good seats on airplanes. Tips include joining a frequent flyer program and buying your tickets online, where you can often pick your seats.

How To: Build a skateboard half-pipe with Michael Strahan

Building your own skateboard half-pipe in the confines of your own backyard, is a great thing for anyone who enjoys a little challenge. Certain weather conditions or travel issues, can make it difficult for some skateboarders who are looking to spend some quality time trying new tricks and perfecting skills. In this tutorial, you'll find out how to build a skateboard half-pipe with the help of former NFL star, Michael Strahan. So good luck and enjoy!

How To: Count with more than 1 criteria in MS Excel

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 and Mr. Excel, the 27th installment in their joint series of digital spreadsheet magic tricks, you'll see ten different methods counting with more than 1 criteria.

How To: Decrease values in Microsoft Excel

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 and Mr. Excel, the 2nd installment in their joint series of digital spreadsheet magic tricks, you'll see two methods for subtracting 35% from a column of values.

How To: Extract items not having a given text value in Excel

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 and Mr. Excel, the 25th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract records from databases that do NOT contain a given text value.

How To: Control percentages with a scroll bar in MS Excel

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 and Mr. Excel, the 46th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create scroll bars that will control a percentage in a cell.

How To: Create a frequency distribution in Microsoft Excel

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 and Mr. Excel, the 15th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use a pivot table with grouping and a count function to create a frequency distribution.

How To: Find a mean for data set while excluding 0s in Excel

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 and Mr. Excel, the 13th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set.

How To: Add the difference between 2 number columns in Excel

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 339th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function to add the difference between two columns of numbers based on two criteria.

How To: Count dates with an array formula in Microsoft Excel

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 142nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a complex array formula that counts weekends between two dates with the SUM, IF WEEKDAY, ROW and INDIRECT functions.

How To: Retrieve data from a different workbook in Excel

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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic, two-way IF function lookup formula for pulling data from a different Workbook.

How To: Plan for a backpacking trip

Backpacking sounds like the most basic way to travel but it is actually quite a large undertaking. In this tutorial, learn all you need to know to plan for a backpacking trip, no matter where you're traveling to. This will help you stay safe and prepared for anything. Of course, before arranging backpacking gear for a trip, it's important to make a plan of the trip in order to determine which items are necessary. Learn about bringing backpacking gear that fits the climate and conditions of a ...

How To: Fix poorly set up data in Microsoft Excel

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 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.

How To: Count with two criteria in Microsoft Excel

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 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and COUNTIFS functions to count how many sales you made for a given product over the last 7 days.