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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...
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 606th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that can look up two 2 lookup values using the INDEX & MATCH functions and concatenated (joined) columns for the lookup value and lookup table.
The riffle shuffle is the most basic of card shuffles, one that most card players and magicians can perform easily. False riffle shuffles, however, are difficult to perform convincingly, but essential for the effective performance of card magic or for cheating your friends at the card table. Whether you are a magician or a gambler, this trick will aide you in deceiving whoever it is you plan on deceiving for fun, profit, or both. The card trick master in this video performs the move three tim...
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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to do basic statistical analysis in Excel. Specifically, this video covers the following topics:
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 41st installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate deviations, variance and standard deviation for a sample and a population using Excel tables and the VAR, S...
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 10th installment in his "Excel Statistics" series of free video lessons, you'll learn how about data sets and the nominal, ordinal, interval and ration scales/levels of measurement and see two Pivot Tables that...
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 588th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine whether an employee is exempt from a tax using a VLOOKUP in an IF function, and if not use a second VLOOKUP lookup query to look in tax tables to look up and calculate the tax
This video describes how to make Thai Pasta Noodles. The commentator first lays out all of the ingredients on the table and tells the amounts required for the recipe. The cooking begins with the preparation of the sauce by combining chicken broth, soy sauce, and peanut butter in a measuring cup. Then, garlic and ginger are added in a pan with vegetable oil along with the red pepper, red chile flakes, and finally, the chicken breasts. Once the chicken is almost done, the cilantro and green bel...
In this Arts & Crafts video tutorial you will learn how to make an origami Kusudama Venus. For this project, you need square sheets of paper of different colors. First you fold a sheet diagonally across to form a triangle. Then fold it again to form a smaller triangle. Open up one triangle and fold it in to a square. Repeat this step with the other triangle also. Now the paper folded in to a square; ¼ the original size. Holding one square flat on the table, lift up the other and squeeze it d...
This is a great instructional video on how to make sauteed garlic asparagus. The main ingredients required to make this wonderful food are three table spoon unsalted butter, two cloves garlic chopped,one bunch fresh asparagus, quarter teaspoon kosher salt and quarter teaspoon ground black pepper. First melt the butter in a big skillet over medium-high heat. Once the butter is melted add the garlic. Then add asparagus spears and salt. Finally add pepper to it. Now cover it and cook stirring oc...
Kale makes the perfect basis for a raw, vegan salad. It is rich and leafy and has an almost meaty texture. In this tutorial, learn how to make a delicious Mediterranean Kale salad as a side dish for your raw dinner. This salad includes kale, red peppers, pine nuts and olives and will definitely please even the most picky eater. So, whether you follow a raw lifestyle or are just looking to add a little green to the table, try this recipe - you won't be disappointed!
Patricia Aaron shows us how to safely pickle peppers. Pickling is one of the earliest known methods of preserving food. She starts by describing the various types of peppers.
310tutoring shows viewers how to easily convert Grams to Moles for Chemistry. If you have 120 grams NaOH and we want this in moles we need a periodic table. Now, you need to figure out what the mass is of each individual element in NaOH. You need the mass of Na, O and H. Na mass is 23, O has 16 and H is 1. Add all of these up to get the molar mass of NaOH is 40 g/mol. Now use this to convert 120 g to moles. Now take 120 grams NaOh and multiply this by 1 mol NaOH/ 40 grams NaOH. You can cancel...
This video demonstrates how to make a loud and annoying paper popper. Prepare a regular sheet of paper and lay it down on the table or a flat surface. Fold the lower portion of the paper at about an inch and a half (1.5") or two inches (2"). Fold it the second time at about the same length you did with the first. Then, fold the paper right in the middle in the opposite direction with your first two folds. Your paper should now be folded to resemble a nurse's hat. Hold one corner of the folded...
This video shows how to make a paper "popper" that you can use to make a loud popping noise. Start with piece of paper. first fold it in half the skinny way, then fold it in half again the other way. Set the paper down on a table or flat surface so that the flaps of the paper make an "M" shape. Now take the paper in your hands and grab the outer sheets of the "M" with the index finger and thumb of your right hand. Pull the inner sheets out with your other hand. Take the popper in your right h...
Corn dogs are a great staple of boardwalks and summer. Unfortunately, they're also incredibly unhealthy. If you're on a diet but simply cannot live without corn dogs, make this healthier alternative from Rachel Ray.
Olivia and Andrea created a song to the tune of "I'll stand by you" by the Pretenders to teach you how to balance chemical equations. A chemical equation requires coefficients in order to be balanced. You can balance a chemical equation by making use of the Periodic table. The example reaction in the song is that of aluminum and oxygen to produce aluminum oxide (Al + 02 -> Al203). You can systematically add coefficients to the reactants and products to balance the equation. A chemical equatio...
Learn how to use bent handled trimmers: Kenneth D. King of ThreadBanger Quickies and NextNewNetworks explain how to use bent handled trimmers for working with fabric projects. Bent handled trimmers are great for cutting out fabric patterns and designs. The scissor itself slides along the smooth plane of the cutting table and it lifts the fabric just enough to successfully cut the pattern out. Bent handled trimmers make a very accurate cut. Never ever use your fabric scissors for cutting paper.
This video shows you how to break a yardstick with atmospheric pressure. The instructor first lays a ruler halfway on and off of a table. He then covers half the ruler with newspaper. The instructor states that you can chop the ruler in half with your hand because the air holding down the paper will keep the ruler in place. The experiment does work correctly and he did break it in half perfectly. This instructor seems to have many similar videos on the subject.
Would you like to craft perfect 3D origami works of art? In this helpful tutorial, Jewellia7777 demonstrates how to use recycled paper to create your own elegant "green" works of art in no time. Learn to easily construct a stunning table centerpiece of paper that would let you contribute your own artistic touch to any special event, formal or informal. This great video will have you stunning your guests in no time with the impossibly beautiful flair of this fun project.
Today, see how to use GoLive CS2 to create pure CSS layouts. That's using CSS to lay your website out, which is a really nice way to layout your webpages. It's laying it out without tables, and allows the site to change based on the users resolution. In this video tutorial, see how to create website layouts made entirely of CSS using GoLive's new CSS tools and the new liquid layouts available in GoLive CS2.
Watch this cooking video tutorial on how to make chocolate Nutella tarts - kids can cook! You will get all the necessary information to make this chocolate Nutella tart recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to make salsa - kids can cook! You will get all the necessary information to make this salsa recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to bake a party pizza - kids can cook! You will get all the necessary information to make this party pizza recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to make a frozen fruit smoothie - kids can cook! You will get all the necessary information to make this frozen fruit smoothie recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to make a French crêpe - kids can cook! You will get all the necessary information to make this French crepe recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook basil pesto for pasta - kids can cook! You will get all the necessary information to make this basil pesto for pasta recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook macaroni and cheese - kids can cook! You will get all the necessary information to make this macaroni and cheese recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook a hearty hamburger - kids can cook! You will get all the necessary information to make this hearty hamburger recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook kickin' chicken - kids can cook! You will get all the necessary information to make this kickin' chicken recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to make a popover balloon dessert - kids can cook! You will get all the necessary information to make this popover balloons dessert recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook a ham and onion omelet - kids can cook! You will get all the necessary information to make this ham and onion omelet recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to make a fruit smoothie - kids can cook! You will get all the necessary information to make this fruit smoothie recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook beef skewers - kids can cook! You will get all the necessary information to make this beef skewers recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook crazy quesadillas - kids can cook! You will get all the necessary information to make this crazy quesadilla recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook chicken wings - kids can cook! You will get all the necessary information to make this chicken wings recipe, including a list of all the ingredients needed, all right in the video.
Did you know your fine furry friend can get Lyme disease too? Giving your dog a once-over tick check will not only protect him from infection, but can help keep you and your family safe too.
The multiple award-winning card game Sixteen is packed with head-to-head action. If you can you count to 16 and take calculated risks, then you can force your opponent to bust. But play your cards defensively at the right time or the tables will turn! Win the most sets and you'll win the game. It sounds simple (and it is), but Sixteen's unique strategy and cribbage-like counting will hold the attention of even the most seasoned game players.
Want to see whether your PC is being accessed by hackers? Netstat (network statistics) is a command-line tool that displays network connections (both incoming and outgoing), routing tables, and a number of network interface statistics. It is available on Unix, Unix-like, and Windows NT-based operating systems. This video tutorial presents a basic introduction to working with the netstat tool. Determine whether you've been hacked with this how-to.
With iOS 11, Apple's very own Notes app will now come standard with a number of new features that aim to make it significantly more user-friendly and help it compete against more popular notepads like OneNote and Evernote.
