Cells Close Search Results

How To: Hack into the bootloader on the Motorola Droid X

With custom ROMs said to be impossible on Verizon's new Motorola Droid X, thanks to something called eFuse, many users will be deterred from trying to mod their Droid X mobile device. But it's only a matter of time before a hacker figures out a workaround for the Droid X, but if you want to try to hack it yourself, this video tutorial will get you started. It will show you how to get into the Droid X bootloader. It could possibly help you "root" the cell phone, if you're lucky.

How To: Disable quick fill handle & drag-drop Excel features

In this video tutorial, viewers learn how to disable the quick fill handle and drag and drop option in Microsoft Excel. This task is very easy, simple and fast to do. Begin by clicking on the Office button and click on Excel Options at the bottom. Then click on the Advanced tab and deselect "Enable fill handle and cell drag and drop" option under Editing Options. Finish by clicking on OK. This video will benefit those viewers who use Microsoft Excel for their work, and would like to learn how...

How To: Make & receive free phone calls with Google Voice

Google Voice was recently made available to the general public and now everyone will be able to use it. If you are looking for a way to stay connected to your friends and family for free, check out this clip. Voice will redirect calls straight to your home phone or cell and allows you to text, too! You can connect up to four phones to your account, as well, so you can use Google in the whole house. Enjoy!

How To: Simulate fisheye lens distortion using Premiere Pro

The fisheye lens is one of the oldest and most popular of effects lenses. They are also expensive, and you can't attach one to your cell phone! If you find either of those things to be a problem, this video will help you to alleviate them by teaching you how to simulate a fisheye lens effect using the Adobe Premiere Pro video editing suite. Don't waste your money, watch this video!

How To: Create value-based formatting using data bars in Excel

See how to create value-based formatting using data bars and color scales in Excel 2007. See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, w...

How To: Create horizontal subtotals for a data set in MS Excel

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 and Mr. Excel, the 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.

How To: Use functions and formulas in Microsoft Excel 2007

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 2nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to get started using functions and formulas in MS Excel. Specifically, you'll see the different elements of formulas (the equal sign, cell references, math operator...

How To: Create a budget with formula inputs in Microsoft 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 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...

How To: Use Microsoft Excel 2007 for statistics

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.

How To: Sort and extract by cell color in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Validate data & look up values in Microsoft Excel

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 5th installment in their series of digital spreadsheet magic tricks, you'll learn how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.

How To: Adding contacts to your Skype account

Skype is one of those programs that is not only easy and simple to use, but a great way to keep in touch with loved ones from across the globe. You have a couple different options to choose from when contacting someone. You can choose to have a live camera chat or you can even call them on their cell phone even if they're in a city like Paris! This video focuses on how to add contacts to your Skype account. Enjoy!

How To: Create a daily Gantt Chart 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 two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.

How To: Dynamically count unique words in a column in MS Excel

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 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...

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: Adjust screen timeout on your Android phone

Mike Callahan will show you the tricky process of changing the screen timeout on your Android cell phone. While some people like their screen to black out right after they finish using it others prefer it to stay lit for a while. Mr. Callahan shows you how to change the setting regardless of how you like it. First tap on settings. Next, tap on sound and display. Then, you are going to want to scroll down until you get to screen time out. After selecting the screen time out option, you will ha...

How To: Generate random numbers (integers) in Excel

1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...

How To: Create an Excel Gantt Chart by conditional formatting

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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT functions.

How To: Get free Redbox DVD rentals

Learn how to get free Redbox DVD rentals. Redbox movies can be found in large stores, usually supermarkets, where you can rent a movie, and return them to the same box when you are done. In order to get the free movie, you must obtain a code, which you will enter during the rental process. On the website, sign up for what is called "Free Movie Monday". Redbox will send a code to your cell phone on the first Monday of every month. One thing to remember is to not be late returning the movie, or...

How To: Shrink an enlarged skin pore

Robert Scot, from ModernMom, shows viewers how to shrink an enlarged skin pore. Scott reminds us that genetics and aging do contribute to enlarged pores and skin condition, but there is still a way to deal with this. There is no way to permanently shrink enlarged pores but you can handle them with time. You can use cleansers and exfoliation to do the trick. Your cleanser should be for oily skin that will naturally purify your skin. You really want to focus on exfoliation and use exfoliates wi...

How To: Make copper sulfate and zinc batteries

Watch this science video tutorial from Nurd Rage on how to make copper sulfate and zinc batteries. They show you how to make the classic copper sulfate and zinc battery using the incredibly easy "gravity" battery design approach. Great for science fairs and similar projects this battery can be used to explore many basic concepts in batteries.

How To: Convert VHS tapes to DVD with Roxio Easy VHS to DVD

This easy-to-follow video tutorial walks you through steps of converting old VHS tapes to DVD. Roxio Easy VHS to DVD is a combination of software and hardware that allows you to easily and quickly digitize old analog recordings. You simply attach the included hardware to a free USB 2.0 port on your computer, then capture from virtually any analog video or audio source.

How To: Make a rechargeable, solar-powered USB battery

An emergency battery charger for your mobile phone comes in handy, but it's not the ultimate solution; once it's dead it's useless (what a waste). If you want to really get off the metaphorical grid, you can follow the steps in this video to construct a more robust circuit that will not only bail you out of an inconvenient situation but also recharge in between uses. The simple addition of a low voltage solar panel and rechargeable batteries makes this possible. Enjoy!

How To: Turn a Webcam and Phone into a Security Spy System

Watch this video tutorial, and learn how to turn an ordinary inexpensive webcam into a hidden home security system, viewable anywhere in the world from your cell phone! With a cute and cuddly teddy bear and a cheap webcam, you can make the perfect homemade security camera, or just a camera to spy on your sister and her friends during sleepovers. Follow along with the steps in this how-to video and learn how to set up this spy system. Note: this video is NOT recommended for people who are perv...

Instagram 101: How to Share Posts & Stories to All Your Close Friends' Feeds Only

Instagram is a great platform to share photos and videos with the world, but sharing with smaller groups is near impossible. You can directly message pictures, stories, or post links to friends, but that only works for one person at a time or in group chats you create. To share your content with a small group of people you care about the most, you'll want to use the "Close Friends" list.