Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 350th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting and the COUNTIF function to highlight values that are repeated a given number of times.
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 333th installment in their series of digital spreadsheet magic tricks, you'll learn how to fix errors with the Excel 2007 IFERROR and the Excel 2003 IF & ISERROR 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 266th installment in their series of digital spreadsheet magic tricks, you'll learn see how COUNT and COUNTA have trouble counting only words or text and how to use a handy workaround.
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 17th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the RANDBETWEEN function to randomly generate whole numbers as well as how to randomly assign numbers to employees.
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 15th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF and COUNTIF functions to add and count above some limit.
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 331st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract individual characters without extracting the leading zeroes through use of the MID, VALUE and COLUMNS 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 310th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DSUM and DMAX with date 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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create sequential numbers in formulas using the ROWS 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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS 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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.
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 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
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. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.
If you've ever wanted to do card magic tricks or just want to know how a certain magic card trick is done then watch and learn how to perform the slip cut sandwich card trick. This is a simple card trick can be done by anyone regardless of experience, you want to being by stating that the two jacks are going to assist you in finding the card. Then have a spectator tell you when to stop when your riffling through the deck. When told to stop just pull two cards out as one and place at the top o...
In the new Photoshop CS4, there are some minor improvements to the Photomerge function, including the new collage option. Jay Kinghorn goes over the different ways of bringing your images into photomerge, the layout options, and some quick tips for creating better quality panoramas in Photoshop CS4. The following how-to video walks you through the entire process.
This Reason 3.0 tutorial explains use of the Import Midi function and some of ways to use it for practice or remixing a popular song. Also, get tips on spicing up flat MIDI files while learning MIDI remixing and EQing in Reason 3.0
Here is a Final Cut Studio software suite tutorial on how to use the green screen function in Final Cut Pro. Footage that has been shot on a green screen can be brought in and isolated with Chroma Key settings. Once you have your subject removed from the green screen background, you are ready to apply hundreds of effects and transitions in Final Cut Pro.
This video will show you how you can trace IP address or websites to a specific location using Windows command functions.
Final Cut Express makes it easy to convert or capture your videotapes into digital video files. All you need to do is set the desired capture format and destination for your clips. The Final Cut Express menu also provides an Easy Setup function.
Watch this instructional video to learn how to use Google Hacks. Google Hacks is a collection of software that explores Google's search function. Hacks is meant in this definition. "A Hack is a modification of a program or device to give the user access to features otherwise were unavailable to them. Watch this how-to video and find out how to use Google to access free media.
Lawrence Perez, from Saddleback College, and his assistant Charlie, give this two-part calculus lesson on integrating with special substitutions; rational functions with sine and cosines: Karl Weistrass method.
This Microsoft Word tutorial discusses some tips and tricks for speeding up your work and adding extra function to Microsoft Word.
Did you know that you can make a Nintendo Wii Wiimote function as a mouse or joystick on your PC? Here's how you can use your Wiimote as a PC controller using a bluetooth adaptor or card and some specialty software called GlovePie.
In this video, we learn how to stop binge eating & get healthy. Food often acts like a buffer that helps people overcome their emotions. If you are not eating enough during the day, you will be more likely to binge eat at night when your body is most craving nutrients. Late night and dinner time is when the cravings and the binge patterns most occur. When you eat more during the day you will not want to binge at night because your body doesn't crave anything. Don't skip breakfast and eat a go...
Want to stop SVCHOST.EXE from eating all of your Microsoft XP computer's processing power? It's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over five minutes. For more information, including step-by-step instructions, take a look.
Most people get tired of being in the elevator, being in a rush, and having to stop at every floor to let people on. With the express elevator hack you will not have to stop any more. You can now ride straight up to your floor with ease. First, get into the elevator. Then, press and hold the button that has the floor you want to go to and the close button at the same time for five seconds. Just remember to press the close button and the floor button at the same time. Now, you can ride straigh...
This video will show you can create a good stop motion animation, just like Gumby.
Are you a fan of Gumby? This video will show you how to make your very own stop motion video with clay figures.
Fortunately, you do not have to face this horrible smell problem when you turn off the fridge. To easily stop it, simply put some crumbled-up newspaper inside before you have to turn off the fridge, or at least shortly afterward. Watch this video to learn more.
In this home improvement video Bob Schmidt shows you a simple, inexpensive, energy saving method of stopping air leaks and drafts around exterior wall outlets and switches.
Bonnie D.Stroir of the San Diego Derby Dolls breaks down how to do a power slide both on flat track and on banked track. This stop is great for making a really quick stop when skating at high speeds.
Does your 12" vinyl record wobble in the middle of the turntable spindel? Learn how to stop records from wobbling on the platter while you're DJing.
Have you ever noticed that the toilet tank is covered in perspiration or sweating? There is a reason for it and you can remedy it. In this video you will learn why toilets sweat and how to stop it.
Whether your training to be a doctor or a nurse, there is no doubt that this video lesson will help you better understand the procedure for musculoskeletal examinations. Musculoskeletal exams rely exclusively on inspection and palpation and tests using a combination of those techniques. The main purpose of this exam is to identify in your patient any signs of musculoskeletal disease, by way of pain, redness, swelling, warmth, deformity, and loss of function. Watch this video to see the entire...
There are some essentials you need to know when shooting with the Red One camera, here we go over start/stop, SD card, AV connector board, back focus, and installing PL lens.
Diet = Die or Eat As Biological definition, food is defined as; any substance consumed to provide nutritional support for the body. It is usually of plant or animal origin, and contains essential nutrients, such as carbohydrates, fats, proteins, vitamins, or minerals.
http://www.thecolorawards.com/img/index/logo-index.jpg Type: Traditional print and digital, color only
In this how-to video, you will learn how to stop while going backwards on roller skates. This will help if you are going too fast and want to stop without falling. Make sure your knees are not locked and you are not going too fast. Take the dominant leg and position it slightly behind you. Next, apply firm but solid pressure on the stopper. Be careful not to place too much, as this will turn you around. Another way involves immediately going back on both stoppers. Your knees must be bent with...
