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 528th installment in their series of digital spreadsheet magic tricks, you'll learn how to check two data sets (lists & tables) to see if there are discrepancies using the MATCH and VLOOKUP 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 471st installment in their series of digital spreadsheet magic tricks, you'll learn how to sort horizontally with 3 different formulas that use the LARGE, SMALL, COLUMNS, IFERROR and IF 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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.
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.
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 study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to use statistical range, variance and standard deviation to measure dispersion in a data set.
Network mapping lets PC users organize multiple computers into a system that provides informational data access. This video tutorial shows how to set file sharing permissions and assign users designated privileges within a network. Establishing a network provides functionality within a workplace and facilitates virtual communication among users.
In this video one of the ultimate iPhone hackers, Jonathan A. Zdziarsk, demonstrates how to use a forensics toolkit to recover deleted text messages on an iPhone. But wait - there's more! Not only can you access text messages, but almost any other data on an iPhone as well. We can't be responsible for what you find though!
Accidentally deleted your address book? Got some sneaking suspicions you want to clear up? Got something to hide - permanently? In this video you'll learn what hardware and software you need and how to use it to recover deleted text messages, or, conversely, how to delete data permanently from your SIM card. Don't worry - we won't judge.
This shows a step by step method for using the Wii controller to output MIDI control to Apple Logic Pro and "conduct" MIDI with the Wii stick! This is a way cool Wii hack that makes the bluetooth controller work with Logic. You need to install another program to receive and control the data.
Here's a demo which shows a way to produce WAV sound files with TEXT using Photoshop or any photo editing software.
The Nessus vulnerability scanner, is the world-leader in active scanners, featuring high speed discovery, configuration auditing, asset profiling, sensitive data discovery and vulnerability analysis of your security posture. Nessus scanners can be distributed throughout an entire enterprise, inside DMZs, and across physically separate networks. In this network security video tutorial, you'll learn how to hack a network using Nessus 3.
Using morphs to pre-process UVs is a great trick for any version of modo. You can leverage the embedded morph data to massage a model in 3D prior to UV projection. If that doesn't make sense, watch the video and learn how to pre-process UVs using morphs in modo.
Learn how to use MapForce to map or transform XML data in a visual way, creating XSLT 1.0 or 2.0 transformation stylesheets, XQuery 1.0 documents, or program-code in Java or C# in this tutorial, which demonstrates a simple mapping from one XML schema to another. Take a look!
MapForce includes a powerful visual function builder that lets you create new data processing functions in a graphical way using existing functions and libraries. Learn how to combine multiple separate functions that returns a single result with this tutorial.
In this ASP.Net video lesson, you will learn how to display data in your ASP.NET 2.0 Web applications through some of the new databound controls.
How to use Microsoft Excel as a simple database and how to organize and sort data on the fly.
How to use or mount a TrueCrypt volume to access the data that you have encrypted with the program.
Learn how to browse the Internet at work and get away with it. Load Excel (Any version will do). Click on the Data tab. Click 'Import External Data'. Click 'New Web Query'. Once the window has loaded, click through the prompts, selecting Yes. When the window has loaded completely, go to your favorite website in any browser you want. For this example, Twitter is used. Go to the RSS Feed and copy the link that appears at the top. Paste the link into Excel and click the Import button. Accept any...
There are several reasons to add an alias to your Apache server. If you want some extra room, add a drive or make the data on an external drive accessible, then setting up an alias will make this possible.
Use the AutoFill feature in Safari to quickly fill in web forms for sites that you visit again and again and save time when logging in. Form entry data is stored in your address book contacts, and from information you have filled out in web forms before. You can see the passwords used by AutoFill in the OS X keychain, and you can also specify and limit general access to those passwords.
Amazon provides an inexpensive and useful data storage service that nearly any web admin can find useful. CloudFront is another valuable resource for admins, and this tutorial shows you how you can use both to increase the effectiveness of your own websites.
Pixlr.com is a free image editor, but how can you save your image with a transparent background? This is a quick tutorial that shows you how to save your image file as a .png, which will retain all the data you need.
Arrays are little pockets of data distributed throughout your program. They're useful because having arrays keeps you from needing to work with hundreds of variables when programming. This specific tutorial shows you how to work with arrays when you're using Java to program.
You will need the latest version of Eclipse for this tutorial to work. You will also, of course, need an Xbox and a data transfer cable. Extract your profile to your computer hard drive, and then mod it however you would like!
You can change your gamerscore, get unrestricted access and do much more with this hack! All you will need is an Xbox hard drive and a data transfer cable. Then just follow along with the video to hack your own Xbox 360!
Quartz Composer is a Mac program that helps you manipulated motion capture video, and you can hack your Xbox Kinect to send motion captured data to your Mac OSX. This tutorial shows you precisely how you can use the Kinect tools to pull this off!
This tutorial shows you how to get started hacking your Xbox Kinect. You will need a high quality USB analyzer between the Kinect and the Xbox for this to work, and then you can start streaming data from your Kinect onto your computer.
This technique is a simple way to get easy, perfect circles when trying to build in MineCraft. You can make a good template or stencil just by using the circle tool available in MS Paint. Then transfer the pixel data from Paint to MineCraft!
If you want to expand your storage capacity in your new Samsung Galaxy Tab, it's easy thanks to the microSD slot on the side. Installing your microSD memory card is as easy as removing the slot's cover, inserting the microSD card in, pushing to make sure it locks, and recovering the slot. Adding storage makes your Android experience even better, plus you can transfer files and data easily!
Share your HTC Desire Z's data connection with other WiFi internet-enabled devices like your laptop. See how with this quick, official guide from HTC.
Want to transfer all of your data from an old phone to your new HTC Desire HD? Learn how with this quick, official guide from HTC.
Share your HTC Desire Z's data connection with other WiFi internet-enabled devices like your laptop. See how with this quick, official guide from HTC.
Re-entering contact information every time you upgrade to a newer mobile device is pain, but the Android software on the Samsung Galaxy Tab allows you to copy over your existing contact information from a SIM card. This video will show you the steps to importing that data. Go to APPLICATIONS < CONTACTS < MENU < IMPORT/EXPORT < IMPORT FROM SIM CARD < MENU < COPY TO PHONE. Choose SELECT ALL to copy all of you contacts and then DONE.
Sometimes it's necessary to do a complete restore of a device, even an Android one like the Samsung Galaxy Tab. To reset the Galaxy Tab to its factory settings, hit MENU < SETTINGS < PRIVACY and click on FACTORY DATA RESET. Lastly, click on RESET PHONE (it's okay that it's not a phone) and then ERASE EVERYTHING.
If you have an iPad, you can hack a Kinect and connect them together so you can redefine the Kinect's planes of interest. You can even used the accelerometer in the iPad to transfer data to your Kinect and display the results on a computer screen.
Learn how to solve r-squared problems. Whether you need help studying for that next big stats text or just a hand finishing your homework, you're sure to be well served by this free video math lesson from Salman Khan, which presents a detailed overview of how to calculate r-squared in statistics.
Minimize loss of quality when you're changing a video from one format to another. This tutorial shows you how to take a film clip in high definition mp4 format and convert it into an avi format with minimal loss of data or quality.
In this clip, you'll learn a trick for reading and writing NTFS data on an Apple computer running Mac OS X. With NTFS-3G, it's an easy process and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to.
In this clip, you'll learn how to create and join XML files with the Flash Builder Data Wizard. Whether you're new to XML or a seasoned developer merely looking to improve your chops, you're sure to be well served by this free video lesson. For detailed instructions, take a look.
Tired of always having to charge your phone? Don't want to pay for an expensive upgrade? This tutorial shows you how to get the most out of your phone's battery life. Make sure your data and Internet features are under control, those will suck the most juice.
