Favorite Search Search Results

How To: Sort data with sorting functions 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 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:

How To: Use database functions in Microsoft Excel 1997-2003

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.

How To: Speed up calculations with helper cells in MS Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.

How To: Use helper columns with concatenated fields in Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.

How To: Calculate running total by formula in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.

How To: Create fast formulas for huge Excel spreadsheets

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.

How To: Find confidence intervals without a sigma in MS 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 84th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma is NOT known using the Descriptive Statistics data analysis add-in.

How To: Format whole & decimal numbers 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 8th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with whole and decimal numbers. See how to write words to represent numbers (for checks). See how formatting can hide decimals.

How To: Solve markup & markdown math problems 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 32nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve simple markup (mark-up) & markdown (mark-down) business math problems.

How To: Use the RANK and PERCENTRANK functions in MS 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 38th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the RANK and PERCENTRANK functions as well as the Data Analysis add-in's Rank & Percentile tools.

How To: Group quantitative data into classes in MS 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 20th installment in his "Excel Statistics" series of free video lessons, you'll learn how to take raw quantitative (numerical) data and figure out how to group it into classes so that you can have categories an...

How To: Build confidence intervals given the sigma in MS 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 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...

How To: Work with skew and histograms in Microsoft 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 23rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with skew in histograms for quantitative Data. Learn how to skew left (negative) and skew right (positive) with ...

How To: Create a relative frequency distribution in MS 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 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...

How To: Make calculations in Excel with formulas & references

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

How To: Play "Hotel California" by the Eagles on the ukulele

Want to play the Eagles' "Hotel California" on your ukulele? Learn how with this free video ukulele lesson. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "Hotel California" on your own uke, wa...

How To: Be less quiet and more talkative

Marie was asked by a viewer how to go about being more orally engaging with other people, as most attention he gets is attributed to the fact that he is very quiet, which doesn't sit well with him. Just like anyone else, he would like to get attention for the things he says, not for being quiet! He is under the impression that "cramming," or being knowledgeable on current events and other trivia will give him more to talk about and thus help him to be more talkative. Marie suggests, though, t...

How To: Put Youtube videos on your iPod touch

Whether you have YouTube favorites or want to keep track of your own uploads on the run, check out this video and learn how to put YouTube videos onto your iPod or iPhone. This video will explain how to use a free program called KeepVid that you can download online and use to rip videos and save them anywhere. This is useful if you are interested in offline viewing, or saving your best clips.

How To: Recover a chair with custom fabric

If that old chair is covered in holes or stains, or boasts a pattern that can best be described as "70s chic" it may be time to update it a bit. In this video learn how to save your favorite comfy chair and recover or reupholster it like a pro. By recovering your furniture yourself you can avoid the cost of buying a new one or paying a professional, with the added bonus of holding on to a long-loved piece of decor.

How To: Play the Beatles' "Penny Lane" on the ukulele

Want to play the Beatles' "Penny Lane" on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "Penny Lane" by Paul McCa...

How To: Make Cajun-style fried shrimp with crab étouffée

In this tutorial, Beryl Stokes shows us how to make fried shrimp with crab etouffe. First, make some crab etouffee from any favorite recipe you have. Once you've made this, prepare your batter for your fresh shrimp. First, take a package of Fish Fry and add in a spoonful of flour, 1 tsp of seasoning, 1 tbsp sea salt and mix this together. Now crack 1 egg and milk into a separate bowl for an egg wash. After this, grab your fresh shrimp and dip it into the egg wash then the dry flour and then f...

How To: Make a caper garlic butter sauce

In this video, we learn how to make a caper garlic butter sauce. First, take a white butter sauce (preferably a homemade fresh white butter sauce) and mix in chopped parsley, tomatoes and garlic. Mix all of these together until they are well combined with the white sauce. Pour the mixture into a serving dish and serve on top of your favorite dish. It works well with fish dishes and tastes great when it is made fresh. Make sure you use warm and fresh ingredients. To store this, keep in a tight...

How To: Toast walnuts to bring out their flavor

In this video, we learn how to toast walnuts to place into your favorite recipes. First, you want to put the walnuts on a single layer of a baking sheet so they bake nice and evenly. Now, place the walnuts in a preheated 350 degree oven for about 7-10 minutes until they are golden brown. When finished, remove from the oven and let these cool. You can now place these walnuts into any recipe you like! This will bring out the most flavor that is in your walnuts and taste much better than using u...

How To: Create custom screensavers from movies in Windows

This video is a tutorial on how to create your own custom screen savers from your favorite movies on a Windows computer. The first step is to download the Movie Screen Saver Software from www.vijusoft.com. When the program is finished downloading from the website then you will have to open the installer package and follow the instructions. The download should only take a few minutes and then you might have to restart your computer when it is finished. The second step, once the program is down...

How To: Make chocolate truffles with Ina Garten

In this tutorial, Barefoot Contessa shows us how to make chocolate truffles at home. First, take a 1/2 cup of heavy cream and heat it up in a saucepan. Now, chop up bars of semi-sweet and bitter sweet chocolate (6 oz together) and put into a mixing bowl. Now, pour your warm cream into a strainer onto the chocolate. Stir the mixture until the chocolate melts the chocolate all the way. Now, add 1 1/2 tbsp of Frangelico liquer, 1 tbsp coffee and 1/2 tsp vanilla extract and stir. Chill this for a...

How To: Make a prawn and vegetable stir-fry

In this video, Bill shows us how to make a prawn stir fry. First, heat up an electric wok and add in 2 tbsp of canola or peanut oil. Then, add in a small bag of frozen prawns and cook until thoroughly cooked. Once finished, remove the prawns and place into a separate bowl. Once you're done, clean your wok and add in another 2 tbsp of canola oil and any vegetables you prefer. Once the vegetables are cooked until soft and tender, add your prawns back in. Mix these together and then add in your ...

How To: Quickly fix a skipping DVD with toothpaste

How annoying is a skipping DVD? Picture it: you're in the middle of your favorite flick, and suddenly the characters freeze and seemingly melt away right before your eyes. Sure, you can skip ahead and start watching again at another point in the film, but that's no fun. And it always seems like the disc skips at the best part, doesn't it? Well, this tutorial will show you how to do a quick fix with a tube of toothpaste. It's not just for your pearly whites anymore!

How To: Change hair color in Adobe Photoshop

Photoshop is an amazing tool to use to edit your photos. If you would like to see what you or someone else would look like with a different hair color then Photoshop is the place to do it. Try out something realistic or add a funky color to your favorite celebrity’s style.

How To: Treat acne prone skin with a homemade facial mask

In this video, we learn how to make a homemade facial mask for acne prone skin. First you will want to clean your face and make sure it's dry. You will need healing clay, water, a bowl and spoon. Now take 2-3 tbsp of healing clay and add desired about of water, mix together until you have a paste that's not too watery. Now you can apply your mask avoiding your eye and mouth area. After waiting for 10 minutes or until the mask is fully dry, you can wash the mask off with lukewarm water. Pat dr...

How To: Make a two-minute hollandaise sauce

In this tutorial, Mariko shows us how to make a quick Hollandaise sauce. First, take 2 egg yolks and put them into a large mixing bowl. Whisk these while adding 1 lb of melted butter and 2 tbsp brown mustard. Make sure you keep whisking as you add each of the ingredients, or your sauce will not turn out correctly. Whisk as quickly as you can and if you can, have someone else pour the other ingredients into the mixing bowl. Once you have incorporated the brown mustard, you are done! Pour this ...

How To: Prepare a vegan brown rice medley

This video demonstrates how to prepare a Brown Rice Medley. For this recipe, you will need the following ingredients: green lentils, brown rice, wild rice, and yellow and green split peas. You can find these ingredients in the bulk section, at the grocery store. You will want to combine them in equal parts in a container. Extract 2 cups of the combined mixture. Soak it in water. Let it sit for 6-12 hours. Rinse well. Drain.

How To: Identify problems with a ground covering juniper

This video illustrate us how to identify problems with ground covering junipers .Here are the following steps .step 1: First of all look through the whole plant and see whether there is any browning or fall of leaf, if so then this may be due to water logging as these plants are good for soil with well seepage and lots of sun.Step 2: Look whether the leafs are free of all the bacterial and fungal infection.Step 3: Look whether there are any spider mites present, if so remove them.Step 4: Look...

How To: Make homemade tortilla chips in the oven

In this video, we learn how to make homemade baked tortilla chips in the oven. First turn your oven on and preheat at 375. Then, take your favorite tortillas, a cutting board, a knife and a pan. Next, cut your tortillas into three sections, making triangle shapes out of them. As you cut, place them on your baking sheet and arrange as close together as you can without overlapping so they cook evenly. When you are done arranging your tortillas, sprinkle a light coating of salt and place into yo...

How To: Make French press coffee at home

In this video, the instructor shows how to make French press coffee. Generally, you will want to use 2 tbsp of coffee for every 6 oz of coffee. You will need water that is close to boiling or around 200 degrees. First, pour the hot water over your ground coffee and let it sit for a little over a minute. Now, stir the coffee and make sure the grounds are as wet as possible. Let this brew for another minute or two. Now, press the pot down and your French press coffee will be hot and ready to en...