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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.
The iPad, though much bigger than an iPod Touch, is every bit as easy to jailbreak. And with the Spirit jailbreaking tool, the process is easier than ever. It's so simple, in fact, that this hacker's guide can present a complete overview of the process in just over 3 and a half minutes' time. For more information, and to get started jailbreaking your own Apple iPad watch this free video lesson.
This video shows you how to fix the annoying "Open Tray" error that you will occasionally get when you turn on your XBox 360 console. You turn your system on and even though the tray is shut and has a disc in it, it says you left it open. This is easily fixed though. Start by turning on your XBox 360 console, and wait for it to load. Then start to gently knock on the top of your system, if you have it laying down, and eventually it should start to load your disc. If this doesn't work, either ...
If you made it all to the end of Dark Souls, you'll need to defeat Gwyn, the Lord of Cinder. He's the last boss in the game. This Giant Bomb guide will take you through what will likely be a lot of trial and error so you can finally kill him.
If you are the proud owner of a Dodge Neon with a check engine light on and it's showing error code P0141 on your scanner, you probably need to replace the rear oxygen sensor. This video will show you how to do that as easily as possible.
A short introductory theremin lesson to playing notes, executing dynamic vibrato, and dynamic volume with the theremin. Playing errors included to demonstrate how difficult it is to play the theremin well.
Faced with an "Unable to create directory" error when attempting to upload an image to WordPress? This clip offers instructions on how to fix it. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about its features through videos like this one. Take a look.
In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window opens, click on the Error tab and deselect "Show error alert after invalid data is entered". Then click on OK. Now simply type in the data into the selected cell. This video will benefit those viewers who use Microsoft Ex...
Need a quick primer on how to solve type-1 error problem in stats? Let this video be your guide. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. For all of the details, watch this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
If you've programmed a few Windows Mobile applications, you might need to perform some troubleshooting and debug the program to weed out all the problems. You can do this with AppVerifier. Marty Larson demonstrates installing, configuring and using the "AppVerifier" Application Verifier tool to debug Windows Mobile applications.
A quick tutorial on how to effectively removed corrupted files from your USB pen drive Insert USB drive into computer. Click on "My computer". Right click on your USB drive (e.g., Removable Disk Drive E: )Go to "Properties" and select "Tools". Under "Error Checking" select "Check now". On the "Check Disk Options" menu select "Automatically fix file systems errors and scan". Click start. Once completed the corrupted files should be removed. It is advisable to also get virus software to scan yo...
Learn how to edit form fields in Adobe Acrobat 9 Pro. Start by looking at a automated form that has some errors in the field of gender and marital status. To correct click on forms add or edit fields. Click on the field that needs correcting and figure out the error. Rename the fields to reset them and correct the field. Double check that the name an tool tips have been fixed. Create a cross hairs that you can type over with the correct values you want. You can also shift over boxes. A specia...
In this video tutorial, Chris Pels will show you how to implement tracing in an ASP.NET web site to monitor or measure the performance and to diagnose errors. Learn how to add tracing to an entire web site as well as individual pages. See how to add custom trace messages in pages and business objects to aid in assessing site performance and in diagnosing errors. Learn the differences between tracing in an ASP.NET page and in using System.Diagnostics.Trace for tracing information in business o...
The success or failure of your sewing project relies only in part on your skill - if you choose the wrong fabric, it won't matter how good you are. But picking the right fabric will forgive many small errors you might make. Also, learn the difference between woven and knit fabrics.
If the speedometer on your car isn't working and the check engine light is on, get your scanner out and look for code P0500. If you get that code, watch this video to learn a quick easy fix for the problem.
Are you tired of getting annoyed that your computer is running Windows XP too slowly for you? Increase your computer's speed by checking your disks for errors and defragmenting your hard drive, or updating your hardware to more advanced technology.
One of the most annoying of the many annoying types of errors on Windows computers is when you computer won't recognize parts that have always been a part of it, like the drives or keyboard. If your computer has stopped recognizing your CD or DVD disc drive, watch this video. As long as the drive is still connected, the steps in this video should allow you to fix the problem and continue using your drive.
Learn how to prevent fallying prey to cmmon careless errors when doing fiscal analysis in MS Excel. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to to troubleshoot errors and exceptions when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.
New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel 2010 video tutorials, you'll learn how to use Excel's new CONFIDENCE.T function to calculate the margin of error for a T distribution confidence interval.
Oftentimes when preparing squash, people will remove the seeds and immediately compost them. This, of course, is a great error as the seeds are themselves quite delicious when roasted for 15 minutes in a 275°f oven with a little bit of sea salt.
One of the great things about recording your podcast episodes with Garageband is how easy it is to edit out your mistakes and add professional radio touches.
If you've received the "hal.dll is missing or corrupt" error message from your Windows machine, then you're in luck! This video will show you how to correct that problem with the Recovery Console tool that comes with the Windows 2000 and XP CDs.
One of the easiest ways to measure body fat is by using hydrostatic weighing. It is based on Archimedes' principle, the law of buoyancy. It works by calculating body fat from measuring the amount of displaced water after a person has been immersed under water. Since muscle is denser than body fat, a person who has more muscle will displace less water than a person of the same weight with more body fat. This test is usually performed for a couple times for averaging accuracy. If the test is do...
This how-to video explains how to fix DVD/CD player related issues with error code 31,32 or 19 in the computer that is having either Windows Vista or Windows 7 as their operating system.
A new study confirms that antibiotics can prevent surgical intervention if your child's appendix becomes inflamed, potentially saving his or her life.
Want to optimize your computer for peak performance so you can avoid error messages and hiccups when using Pro Tools? This tutorial shows you how to go into your computer's system directly and set the power option to customize it for using Pro Tools.
This tutorial shows you a very simple thing you can do to your computer in order to maximize Pro Tools' performance on your hard drive and cut down on the number of error messages you might receive - just by making a a few changes to user account controls.
This tutorial is aimed at users of Pro Tools, but anyone interested in improving their computers' performance can use it, too. It's possible that an incompatible network adapter might give you an error message in Pro Tools, and this tutorial shows you how to disable it.
Looking for a guide on how to factor trinomials the brute force way? See how it's done with this free video algebra lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).
If you've ever received that grim error message from your iPod that tells you that you have to restore it, then you know what it feels like to stare down the threat of losing all your hard-acquired music files. This video teaches you how to make your iPod work again without having to restore it, preserving both the functionality of the iPod and your extensive MP3 and video library.
When the interior of your Xbox overheats, damages to your GPU can occur, resulting in various errors. This video tutorial shows how to fix an Xbox 360 gaming machine that exhibits E74 and Red Ring of Death symptoms. Opening your Xbox 360 voids the warranty, but this method could save you loads of money in the repair department.
When performing this iPod hack, make sure to turn off your iTunes and keep it from popping up after you've plugged in your iPod via USB. Take a look at this tutorial and learn how to hack into you iPod on your Mac with the program Alterpod. With luck, no error log will pop up once you click restore.
Have an error in your video? Fix it with Cut Away shots! Israel Hyman, an Arizona-based videographer, will show you how.
Need help figuring out how to troubleshoot and resolve an 0x7A stop error on a Microsoft Windows desktop computer or laptop? This clip will teach you everything you'll need to know. 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 two minutes. For more information, including detailed, step-by-step instructions, take a look.
Nothing in life is perfect, including video game systems. For the Xbox 360, it was the dreaded RROD and for the PS3 one of the most common problems has involved the blu-ray disk drive and/or laser. So in this particular tutorial, you'll find out how to fix game and blu-ray disc loading errors by using the hidden recovery menu. It's pretty easy to do and it may result in reseting it to factory settings. So good luck and enjoy!
Check out this instructional RV video that illustrates how to maintain and inspect your RV or motorhome roof. What you want to look for is that all plastic components are not dry, rotted, and are in place. What happens if something on the roof is missing, like a lid to the sewer valve, is debris will go down in there and possibly clog up your tanks. So you want to make sure all caps are replaced. The next thing to look for is cracks in your ceiling; this can cause a potential leak area. So wh...
In this tutorial video, we show you how to jailbreak Apple's latest device the iPhone 3G to start the process you need to do the following:
When you look at the top corner of your phone, what do you see? Upon upgrading to Android 11 or iOS 14, you'll see either "5G," "5G+," or "5G E" if you're connected to the right network. But what exactly do these symbols mean? They indicate not only if you're using 5G, but also what type you're connected to.