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.
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.
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.
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.
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.
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.
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.
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.
Sick of seeing that little AT&T logo in the corner of your iPhone screen? Looking for a way to personlize your device even further? Well, you're in luck!
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.
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...
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...
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 ...
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...
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...
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 keep talking when you run out of things to say
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...
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.
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.
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...
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...
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...
In this video, learn how to make a cute baby blanket with nothing but a piece of fabric and a pair of scissors.
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...
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...
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...
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 ...
Remember those delicious candy necklaces from childhood? Well, in this tutorial, learn how to make a healthier alternative.
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!
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.
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...
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 test your graphic frame rate in iTunes
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.
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...
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...
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...
This video is about making a bookmark for your web browser in Visual Basic 2008.The videos begins with a simple web browser which consists of simple web components, a textbox and a go button. Pull the sides of the browser to stretch it and put in a listbox. Enlarge the listbox and use two buttons below the listbox. Enter the text for the buttons as "Enter current page" and "clear". Now go to selection explorer, double click "my project" and go to settings. Add a new setting called "Bookmarks"...
This video demonstrates how to turn your favorite songs into ringtones for your Blackberry Curve. You will need a USB cable to connect your Blackberry to your computer. After connecting your Blackberry, a message will ask you if you would like to turn on "Mass Storage Mode". Select yes. On your computer, open the Blackberry in a window, and then open "music". Then click-and-drag songs from your computer onto your Blackberry. You can transfer files to either music or ringtones (as long as its ...
