ExcelIsFun shows you how to detect if a cell has a number or text. The first thing he explains is to find out what are the different types of things that can go into a cell. Next he talks about the use of "OR" and "IsNumber" to make it possible to determine if a cell has a num ...more
This video demonstrates how to send and receive text messages on your iPhone. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to send and receive text messa ...more
In this video tutorial, you'll find a step-by-step guide to how a n00b hacker (like you?) can get usernames and passwords easily through one of the security flaws of the Ethernet ADSL router. More than half of Internet users never change their default password which makes this ...more
If you're having a little trouble operating your newly purchased Samsung Instinct cell phone, let Sprint help you out. This Sprint video mobile phone tutorial takes you through every step necessary to fully familiarize yourself with the Instinct cell phone by Samsung. This ins ...more
Check out this tutorial that teaches you how to make a cotton reusable grocery bag out of bandanna. All you need is 2 bandanas, sewing thread, a sewing machine, scissors, and marking pens. This is a great, fashionable way to go shopping and cut down on plastic bags. Watch this ...more
Print what you want, how you want. While browsing, choose the content you want then edit and print exactly what you see on your screen.. Often when printing content you find on websites, you don't have much control over what is printed. You end up wasting paper and ink on irr ...more
Have you always wanted to spread your mark on urban society, but were a bit of a scaredy-cat? Well now you have the chance of convincing anyone and everyone you're the next great graffiti artist by creating graffiti in Photoshop. If anyone asks just say the local council came ...more
Don't you hate it when you go to print your term paper or document and find that paragraphs or sentences are cutoff? Well, this tutorial will show you how to link text together using Quark Express so each page will start and finish just where you want it to. A must for any pag ...more
¬¬Just about every business has a website these days but very few businesses know how to effectively use their websites to get more customers. There are two different things that a business owner needs to do to increase their website traffic: optimize their site so that search ...more
Before you go running off to the Apple store, you may want to educate yourself. DVICE is kind enough to compile the 20 biggest complaints about the iPad from a whole slew of reviewers. 1. Upscaling makes old iPhone/iPod Touch apps ugly. "Here's the problem: It looks terrible ...more
A playlist is simply a list of songs which can be played in sequential or shuffled/random order. Many people tailor-make playlists to suit a particular style of music or atmosphere, so being able to share these between people is great. There are a great many places on the Int ...more
Friday's Community Byte was weird. The intent was to do a HackThisSite mission, but upon time to begin, everyone in there was programming without my assistance, with the help of Sol Gates. This is great! It's really awesome that everyone enjoys programming that much and will m ...more
This Null Byte is a doozey. On Sunday, September 19th, an exploit for the latest Mac OS X 10.7 "Lion" was discovered by Patrick Dunstan. This exploit allows for an attacker, even remotely, to request to have the root user's password changed without knowing the password to the ...more
So you want to learn the basics of the fantastic language Java, but you don't want to search the Inter-webs looking for a great tutorial. Well you came to the right place, now may I present to you JAVA. Before We Begin You must have the latest version of Java Development Kit ...more
In my Wireshark article, we talked a little bit about packet sniffing, but we focused more on the underlying protocols and models. Now, I'd like to dive right back into Wireshark and start stealing packets. The filtering capabilities here are very comprehensive. You can filte ...more
Download the Software Go to the Antiprism downloads page. Download and install Antiprism 0.20. Run the Programs You need a method of running programs on the command line. In Windows, that could be a DOS box, on other systems a terminal emulator (e.g. xterm). Start this up. ...more
Last Friday's mission was to accomplish solving HackThisSite, realistic 4. The fourth in a series of realistic simulation missions was designed to be exactly like a situation you may encounter in the real world. This time, we are told "Fischer's Animal Products is a company th ...more
Haven't you ever wanted to live in a futuristic home? I think that homes are headed towards an era where they will be controlled by our computers and smartphones. No longer will you have to find your keys to unlock your door, or wait until you get home to monitor your security ...more
Google announced a lot of great feature updates this week! Most of them are content-related, and help you more easily find out what's going on in the overall Google+ community. Google+ Finally Available for Google Apps Users One of the most aggravating issues with Google+ si ...more
At GDC 2011 this past March, three of the world's best game designers participated in a contest called Game Design Challenge. Each presented their vision for a game that fit the prompt "Bigger than Jesus: games as religion" before an audience, with applause to determine the wi ...more
This week, Google held back on introducing a slew of new Google+ features, and introduced new Chrome extensions instead. The new additions won't replace of your favorite Chrome extensions, but they are very useful, and elegant. Google+ Chrome Extensions From Google +Timothy ...more
For those who need security on their Android devices, the standard swipe lock screen just isn't enough, so it's necessary to install applications like GOTO and WidgetLocker to enable either pattern, password or PIN protection. This protection is great overall, but when you're ...more
If you need to build a SQL query, you can choose one of two alternatives. The first and a rather old way is using a console. But if you build your queries in MySQL console, you have to remember all the commands and keys. This is not a convenient way, because query execution is ...more
If you have tried answering services like KGB or ChaCha than you love Weegy.com. I don't know about you guys but when I worked for ChaCha, my approval rating was constantly going down on questions that were accurate. It got so frustrating to the point that I quit and looked fo ...more
Everyone in the world uses tablets these days, so it's no wonder that the Samsung Galaxy Tab has different languages built right in. To change your language on the Android tablet, all you need to do is navigate to the Settings menu. Instructions for Older Tab Models This fir ...more
First double click on the image in layer window then name it and click on OK. Now if you use magic tool on the image and delete the background, it will also delete some of the image part. So to fix it you need to find that kind of places of the image and use brush tool to fill ...more
It's like magic. Creating a .LOG file has never been easier. And all you need is Notepad on your Windows PC. After creating this LOG file, Notepad automatically inserts the current date and time after the last line. Check it out. If you've ever wondered about LOG file types, t ...more
Starting up a website can be daunting if you know nothing about web design or setup, but there are some tips to get the right people finding, looking, and returning to your site. A good landing page gives visitors exactly what they are looking for, and converts them from brows ...more
This walkthrough will help your through the entire gameplay of Lost Planet 2 for the Xbox 360. Lost Planet 2 is the sequel to the third-person shooter Lost Planet: Extreme Conditions, and besides the Xbox 360, is also available for the PlayStation 3 and Windows. It takes place ...more
What's the quickest way to get to an application on your Android phone? It's a shortcut icon, much like on your Windows and Mac computers that take you to the application quick without having to dig in your applications folder. So how do you add a shortcut on your phone? Best ...more
Here the New Boston shows you some tips about using the Spry Validation Text Field. To begin you will go to the Spry Validation Text Field, on Dreamweaver CS4. Looking at the bottom of the page notice the various options that are available for Properties. You find drop-down bo ...more
This video is a Microsoft Word 2007 tutorial on working with pictures. To insert a picture in your document, click on Insert and select Picture, then find the picture, select and insert it. To resize the picture without distorting it, click and hold on the corner circles. You ...more
If you have just purchased a new Ford Taurus, you may have noticed the new SYNC feature. SYNC is a GPS built right into your dashboard. If this is your first time using a global positioning system, you may need a few pointers. Check out this video and learn how to access step ...more
Heartbroken? If your girlfriend threw in the towel before you were ready, there are a few ways you can try to win her back. Follow along with this tutorial and try to mend your broken heart. You Will Need • Empathy • Professional help • Friends • Pen and paper • Patience ...more
Change the Snow Leopard login screen with this video tutorial. Download and install the application Ravissant, an app that lets you customize the login screen in every aspect. Have a background image ready and an Apple logo image, if you want. Modified Apple logos can be found ...more
So you want to party with celebrities. Whatever you do, don’t cry. You won’t just look silly—you’ll look unstable. Follow these steps to get you one step closer to hanging with the stars. You Will Need: • Self-restraint • Composure • Discriminating taste Step 1: Be cool B ...more
Everyone benefits from positive coping strategies when dealing with divorce – learn how. Step 1: Stay in touch with both parents Stay in regular contact with both parents. Call, send text messages, or e-mail to ease feelings of missing each other. Step 2: Develop a plan for ...more
Watch this instructional magic card trick tutorial to learn how to perform the binary routine. This is an original series of user-created moves. There are 9 phases of the Binary Routine, 6 of which are false, and the other 3 are closers that involve a color card change at the ...more
Making your own circuit boards can be a daunting challenge. You have to design a schematic, test it on a breadboard, design the board layout, and then after all of that, you still have to print and etch a board! Luckily, we have Fritzing. Fritzing is a free open-source PCB d ...more
Since the invention of the printing press, books have been a dominant and iconic paradigm in our culture and throughout the world. During my years in elementary and high school, the digital world was on the rise sparking the conversation: Are Books Obsolete. Over the last year ...more
Technology: The Less You Know the Better? I'm sure everyone is now aware of GPS technologies and tracking techniques these days, with the release of numerous documents (even lawsuits) on big name companies like Apple, Microsoft, and Google. Yes, 2011 was a good year for eye-o ...more
Graffiti is a great way of getting your message out to the masses. The earliest known graffiti dates back to 30,000 years ago and used the traditional apply-paint-to-wall technique. Though our paint now comes in cans and not from scavenged berries, the actual graffiti process ...more
Homemade circuits are amazing. You can build any kind of circuit on a simple perfboard, as we have seen in previous projects. However, some projects require very tiny circuit boards. We could special order some boards from a printed circuit board (PCB) factory, but that will m ...more
Today's digital cameras record not only the images themselves, but also the metadata behind the scenes, like camera settings, location, date, time, etc. But there's a lot more to say about a photograph. What's the subject? Is it night or day? Outside or inside? Person, place o ...more
In this article, I'll show you how to create a simplistic AES python based text encryptor. You'll need python 2.7 and PyCrypto (found here). The code is fairly simple, a user enters an encryption key (which basically tells the program how to scramble the text, using an algorit ...more
TCP/IP Client / Server Application Hello! Today's blog post will be about coding a very rudimentary Client and Server application duo, which will communicate by using TCP Sockets. It is, as illustrated, in principle, just two cans and a string that ties them together. The se ...more
There is a near-infinite amount of ways a computer can be broken into. But that does not mean that there isn't a reason to secure our computers as best as we possibly can. It's like the principles of a secure house. Which are the most secure houses? The ones with locks and adv ...more
Welcome to the second Goonight Byte! Our second coding session was kindly hosted by th3m, so props to him for letting this happen. Our task this time was to hack the bot that we made the week prior, which was only capable of connecting to the channel and then printing message ...more
Our first Community Byte went well! We had around 8 people in the room coding collaboratively and watching to learn. LukeStav did the kind task of hosting it on Gobby for all of us, so big thanks to him! At minimum, our task was to create an IRC bot for #nullbytez that could ...more
I've seen numerous tutorials on how to create a "strong" password. This makes me laugh. These titles imply "one" password, which is wrong in and of itself. A person should have many passwords, all different, and all extremely long. People may ask how they're supposed to rememb ...more
When your business is in constant communication with different companies using letter paper, one of the more essential things that you need is your own stationery set. This is made up of business cards, envelopes and letterheads which you need when you do corporate mailing. A ...more
Hard drive space is one of the cheapest things you can add to your computer. But people take it for granted, thus game developers have given up any efforts in keeping games compact. With all of its expansion packs, World of Warcraft takes up more than 60 GB of hard drive space ...more
Video games are the newest major expressive media. As such, their role in society is still being defined continuously. A monumentally important example of this took place yesterday at the US Supreme Court. After a long deliberation, the highest court in the land handed down a ...more
There's an epidemic on the Internet, and the disease—Facebook. It's an addiction comparable to a hot cup of coffee in the morning or a soothing cigarette throughout the day—in worse case scenarios, a hit from the crack pipe. If you're on Facebook, you know what I'm talking abo ...more
Just how private is your Facebook profile? To some extent, that's up to you. Many Facebook users share and poke their days away, never knowing about the plethora of custom privacy settings that lie just a click away. Facebook's privacy menus can look a little complicated to th ...more
Okay, stop me if you've heard this one. You have a document that you want your co-workers' advice on. You attach said document onto a mass email. The first reply comes back with an edited version of the document. You begin to make changes, but another email comes in, with yet ...more
You and I know that everyone's lookin for a killer deal for cellphone service. A lot of us hear about good deals for the plans, or who's got the hottest phones at the moment. Though most of us these days are just looking for something simple, that has all we need, and is fairl ...more
Downloading images from Google Images search can be a time consuming and DANGEROUS process. On more than one occasion, while trying to save the full size image and being forced to the originating website, I have accidentally come across malicious websites. Because of this, a ...more
Without Richard Channing Garfield the world would be a much grayer and less interesting place today, at least for all of us. He created Magic in college, playtested it throughout, accidentally found a publisher for it, and wound up the the most well-known and successful paper ...more
WELCOME & THANKzZz For Your Contribution, Support And Time...! ...Hello, zZz~AKA~StanDP Here...; There are many ways to tweak, change, enhance your internet experience to suite your needs, I will discuss a few things I did to enhance my online experience along with Fire-Fox ...more