How To: Take apart a Nintendo Wii
This video shows you how to take apart a Nintendo Wii. WARNING: this will void warranty. All time and date data will be reset, but the game save data should remain the same.
Accurate Data Search Results
How To: Use the JavaScript Client Library with Google Calendar
Austin Chau does a short tutorial about how to use the JavaScript Client Library with the Google Calendar Data API.
How To: Name ranges of data in Excel
Name ranges of data to make formulas a bit easier to read and write when working in Microsoft Excel.
How To: Use PHP to retrieve MySQL data
How to display the data in a MySQL database table in a web page using PHP.
How To: Protect your private search data in Firefox
One method you can use to protect yourself, is to ensure you clear your private data, such as your search history, and in this screencast tutorial, we show you how to do just that in Mozilla Firefox.
How To: Collect data in CINEMA 4D if you know After Effects
This tutorial covers gathering up all of your data. In AE: Collect Files. You can do the same in CINEMA 4D. If you're not familiar with collecting files in After Effects, the video hits the rough outline.
How To: Set up and use IDE / SATA to USB adapters
If you're a certified computer nerd along the lines of NASA scientist Howard from "The Big Bang Theory," then you know how frustrating it can be transferring large amounts of data between an external hard drive or other drive and your main computer, especially when you're in a rush to get experiment data in. Usually this requires mounting the drive into a system or external case first.
How To: Use text functions (TRIM, PROPER, SUBSTITUTE) in Excel
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to transform bad data into useful data using formulas and text functions such as TRIM, PROPER, SUBSTITUTE, REPLACE, FIND and LEFT. Also see how to use the ampersan...
How To: Retrieve data from many tables on many sheets in Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...
How To: Find the last row or column used in an Excel data set
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 135th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range when there are blanks in the data set. Learn also how to use an array formula to find the Last row or column used in a data set.
How To: Measure the spread of a data set with Excel's AVEDEV
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 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVEDEV function to measure the spread (variation) in a data set. Also see the STDEV function and learn how to measure whether a mean represents its data points fairly.
How To: Use the range property in Excel macros
Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...
How To: Summarize data from multiple sheets in Microsoft Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.
How To: Secure your sensitive data in Ubuntu with encryption
TrueCrypt is a free application that lets you encrypt designated programs on your Ubuntu system to prevent unwanted access. Provided you select a strong password, intruders will not be able to open your personal files and documents. This instructional video walks you through the process of installing TrueCrypt on your Ubuntu operated machine and demonstrates an example on how to create an encrypted volume within a select partition.
How To: Use Excel data analysis functions (max, min, average)
Create a table with sales data with this video.
How To: Import Zbrush data into modo
Devolped by the same team of engineers responsible for LightWave 3D, modo, lowercase, delivers the next evolution of 3D modeling, painting and rendering in a single integrated and accelerated package for the Mac and PC. And now, modo is a true end-to-end solution that includes true 3D sculpting tools, animation and network rendering! More than just features, modo is a truly elegant integration of technology, raw horsepower and refined workflow. With such a wealth of inbuilt features, however,...
How To: Give an accurate palm reading for someone who has a long hand
Peter John, an accomplished expert in palmistry, demonstrates how to properly understand what it means when your palm reading subject has a long hand and long lines on the palm. He indicates what to look for to indicate intelligence and good communication skills in your subject.
How To: Palm read someone who has a long hand and low heart line
This quick lesson helps a student of palmistry give an accurate reading for a subject who has a very long hand, especially if the heart line lies low on the palm. Learn the palmistry principles which indicate an analytical and mathematical person.
How To: Give a good palm reading
Peter John, an expert in palmistry, walks you through a sample reading of someone's hand. He explains how to interpret the various parts of the palm, such as the life line, head line and heart line, to give a full and accurate palm reading.
How To: Choose accurate paintballs for your paintball marker
There's a little trick to making sure you're getting the best paintballs for your paintball marker, and it takes hardly any work, except maybe hiding from the department store employees! The tip is to open the packaging and remove a couple paintballs. Then find a flat surface in the store and roll them to see if they're smooth or have dimples (which can cause inaccuracy in shooting).
How To: Properly measure flour with a scale
In order to properly measure flour with a scale, you will need the following: flour, a scoop, and a scale.
How To: Upgrade from Vista to Windows 7 with Cnet TV
In this video tutorial, viewers learn how to upgrade a computer from Windows Vista to Windows 7. Users are able to do an in-place upgrade as long as both the Windows Vista and Windows 7 versions are the same. Users will need to export all their data, erase the hard drive and then reinstall all the applications. To do an in-place upgrade, begin by backing-up your data. Then insert the install DVD and select run it. Then click on Install Now and wait for it to install and setup. This video will...
How To: Use the electronic level display on the Canon EOS 7D
The EOS 7D has an accurate level display, which you can activate on either the read LCD monitor or in the viewfinder. See how to work the electronic display on the Canon digital SLR camera. This is great for getting a steady shot wherever you need it.
How To: Make a custom shadow clone commando Lego minifigure
The Star Wars universe is vast and diverse, and for the Lego Star Wars-modeling enthusiast, knowing how to make the dizzying number of different types of figures from the series is key to creating accurate-looking scenes. This video features detailed instructions for making a shadow clone commando custom Lego minifigure. Complete your set!
How To: Calculate variance in a set of data
The video is about how to find the variance of the set of data. They found the variance by using the variance formula. Variance formula was represented by square of S, whereas S is the Standard Deviation.
How To: Undelete and recover your files
In this Labrats video tutorial the instructors Andy Walker and Seab Carruthers show how to undelete the deleted files and recover them. When you save data to your computer, the computer stores the data in the binary format on the hard disk. To keep track of the files, the Operating System maintains a file table that shows the location of the data on the hard disk for a specific file. There are many file formats like FAT, NTFS etc. So when you are erasing the file only the entry in the file ta...
How To: Hack RFID enabled credit card & steal money for cheap
Identity theft is a huge problem and one of he fastest growing crimes in America. A number of credit card companies now issue credit cards with embedded RFIDs (radio frequency ID tags), with promises of enhanced security and speedy transactions.
How To: Get started using Numbers '09
Check out this informative video tutorial from Apple on how to get started using Numbers '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
How To: Use tables, color, images and fonts in Numbers '09
Check out this informative video tutorial from Apple on how to use tables, color, images and fonts in Numbers '09.
How To: Create formulas with Quick Formula in Numbers '09
Check out this informative video tutorial from Apple on how to create formulas with Quick Formula in Numbers '09.
How To: Hide, filter and sort table cells in Numbers '09
Check out this informative video tutorial from Apple on how to hide, filter and sort table cells in Numbers '09.
How To: Group rows into categories in Numbers '09
Check out this informative video tutorial from Apple on how to group rows into categories in Numbers '09.
How To: Use conditional formatting in Numbers '09
Check out this informative video tutorial from Apple on how to highlight values with Conditional Formatting in Numbers '09.
How To: Print spreadsheets in Numbers '09
Check out this informative video tutorial from Apple on how to print spreadsheets in Numbers '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
How To: Create and edit charts in Numbers '09
Check out this informative video tutorial from Apple on how to create and edit charts in Numbers '09.
How To: Work with Excel users in Numbers '09
Check out this informative video tutorial from Apple on how to work with Excel users in Numbers '09.
How To: Read a hand-held light meter
When reading a hand-held light meter, make sure the ISO setting is correct and point the cone of the meter toward the subject to get an accurate reading. Learn how to read a hand held light meter with the tips in this free instructional video on photography tips from a professional photographer. After learning about the light meter, you won't make any aperature mistakes in the future.
How To: Miter a corner on quilt binding
Watch an experienced quilter show a quick and easy way to miter the corner on the binding of a quilt. Quilting is a precise craft, but a mitered corner works best with a some accurate estimation. Follow this two step process to sew a neat and sturdy corner on quilt binding.
How To: Use the flip command in modo 101
This 3D modeling software tutorial shows you how to use the Flip command in modo 101 and higher. The Flip command is one of those tools you can not live without. It inverts polygon normals on polygonal models and meshes. Combine the Flip command with the modo arsenal for accurate selection and it really is a life saver.
How To: Analyze Wi-Fi Data Captures with Jupyter Notebook
When it comes to sniffing Wi-Fi, Wireshark is cross-platform and capable of capturing vast amounts of data. Making sense of that data is another task entirely. That's where Jupyter Notebook comes in. It can help analyze Wi-Fi packets and determine which networks a particular phone has connected to before, giving us insight into the identity of the owner.