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 392nd installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly generate 1, 0 and blank values with the CHOOSE, RAND, RANDBETWEEN and INT functions.
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 385th installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random letters without RANDBETWEEN function using the formula =CHAR(65+INT(RAND()*26)).
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 377th installment in their series of digital spreadsheet magic tricks, you'll learn how to add every other number with the SUMPRODUCT, MOD and ROW functions in one formula.
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 370th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to even and odd numbers using a TRUE/FALSE formula with the MOD function.
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 347th installment in their series of digital spreadsheet magic tricks, you'll learn how to round to an increment when you do not have MROUND function.
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 11th installment in their series of digital spreadsheet magic tricks, you'll learn how to measure variation in a spreadsheet using functions like STDEV.
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 332nd installment in their series of digital spreadsheet magic tricks, you'll learn how to insert text into a test string with the REPLACE function as well as how to insert a part of a product ID into a longer product ID.
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 19th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE and RANDBETWEEN functions to randomly generate words.
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 328th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP when you do not have a first column to use for lookup.
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 319th installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP in reverse order using the INDEX & MATCH functions and custom number formatting.
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 321st installment in their series of digital spreadsheet magic tricks, you'll learn how to match text substrings with an array formula that uses the AND, ISNUMBER and SEARCH functions.
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 323rd installment in their series of digital spreadsheet magic tricks, you'll learn how to run a partial text lookup query using a VLOOKUP function with wild card criteria.
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 277th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUBSTITUTE and Morefunc EVAL functions to take a text string series of numbers and add them.
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 191st installment in their series of digital spreadsheet magic tricks, you'll learn how to how to extract part of a text string using a formula with the functions MID, LEFT and FIND.
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 579th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MOD function and date math to create a column of dates where each successive date is repeated twice.
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 578th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to grade student answers where more than one possibility exists using the IF and OR functions.
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 181st installment in their series of digital spreadsheet magic tricks, you'll learn how to count words (case sensitive) using the SUM and EXACT functions in an array formula.
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 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.
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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the median when you have more than 1 criterion.
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 Excel tutorial from ExcelIsFun, the 554th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to weekends and holidays with Excel's NOT and NETWORKDAYS functions.
New to 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 Excel tutorial from ExcelIsFun, the 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel formulas.
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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
We’ve all had the problem of a toilet that just won’t stop running. You can fix this problem yourself with a few tools from the local hardware store. The part that is causing the excess running is an old fill tube and stopper valve. You will want to shut the water off to your toilet and then flush the toiled to drain out the water. You will have to unscrew the supply line so that you can replace the fill valve. The process only takes a few minutes and it will save you money from wasted water ...
This video walks you through the steps of graphing quadratic funtions. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.
Yanik Chauvin demonstrates how to do Non Destructive Dodging (lighten) and burning (darken) of images using the tools in Photoshop. He shows the image of a man lying on earth with his camera. To start the work he wants to make a new layer which can be done in two ways either by clicking on the ‘layer’ button on top of menu or by pressing down the alt key and clicking on the new layer at button of the layer palette. It will bring up the dialogue box. He named it “dodge and burn” and from the l...
Decorating Tips demonstrates how to use the star tip to decorate a cake or cookies. Use a medium consistency icing and position the bag at a 90 degree angle. Hold the tip 1/4 of an inch above the surface of the cake or cookie. Use the count squeeze, stop squeezing and stop to create a delicate star look with a size #13 star tip. With a size #18 star tip, shorten the count and put the icing stars right next to each other to fill in a cake. Use different colored icings as accents. You can also ...
One of the first things you may want to know when learning how to animate in Flash is how to orient an object to a path — the path, in turn, serving as a sort of metaphorical track for your Flash element.
Canon recently released a firmware update to fix a lot of the v.1 bugs. This tutorial explains the process of updated the firmware from downloading on the Canon site to easily installing it on your camera.
You got a hold of some old vintage "sound transferring thing" on eBay... If it's a Goko, you're in luck. In this video, learn the basic functions of a Goko TC-20 Super 8mm sound film transfer machine.
Watch this video tutorial to learn how to use hand signals on a bicycle. Bicycles don't come with turn signals and brake lights. Fortunately, there's already a universal language for indicating turns and stops on a bike.
The EVMODE electric only option is a must have Toyota Prius Hybrid accessory. Prius owners, improve hybrid MPG, activate the factory EV MOD option for electric only mode. Known as EV Mode or EVMODE allows you to switch to electric-only mode for increased fuel efficiency and performance up to 34mph. Easy installation with no wire cutting necessary. Make your green car more eco-friendly. Stop using gas!!
A below elbow arm amputee demonstrates the device he uses in the gym. He shows you how to use a prosthetic for working out at the gym when you've suffer a limb amputation. This video is very helpful in describing utilities available for enabling individuals with amputations to workout or get around and function in a gymnasium setting. This is a video that addresses adaptive equipment for handicapped or disabled people.
Towel Hooks add function and a casual elegance to any style bathroom. AsktheDecorator.com host Meghan Carter demonstrates how to position all towel hooks and complete a towel hooks installation job. Why settle for messy towel bars when towel hooks keep a bathroom neat and tidy, while being stylish? Watch this how to video and learn how to install towel hooks when remodeling your bathroom.
Watch this instructional science video to observe the Barus effect in action. A dyed solution of POLYOX (polyethylene oxide - it is the stuff used as the lubricant on the strip found in all modern razors) is extruded from a 50 mL syringe. On exit, a marked swelling in the liquid stream several times the diameter of the orifice is observed. The effect is referred to as the Barus Effect, but it also goes by several other names including the Merrington Effect, Die Swell, and Extrudate Swell.
Have you just installed Windows or are you looking to improve Window's performance. Learn how to make Windows function faster and more efficiently by adjusting system settings and using a few free tweaking programs.
Do you have an old computer that may be too slow to play video games? You may think it's totally useless, but CNET Video teaches you how to turn it into a network server that functions as a centralized depository for your files!
Want a buddy in Fallout: New Vegas? Sure you do. In fact, you probably want a couple New Vegas companions.
In this tutorial, from Zappos, learn how to make a simple stop motion video. This process is a lot easier than you would expect and this video is here to give you a step by step.
First of all you have to check the root which has started circling. Then notice that there is a dark portion at the bottom of the trunk. You can prevent this problem by avoiding to plant too deeply and not to leave in the pot for too long. You have to plant it at the right depth. Now check the roots of the bigger tree that has died. You shall notice that the roots have started circling around a part and then they stop the circulation to the top of the tree and then the tree dies because it wa...
In this how-to video, you will learn how to stop your dog from barking excessively. Dog's bark naturally. It becomes a problem when your dog barks too much. First, determine the reason why your dog is barking in the first place. From this, you can determine the next step. If your dog looks like he or she is barking at nothing, the dog is definitely barking at something because of heightened sense of hearing and smell. You must communicate to your dog what is acceptable behavior. Never reward ...
