Optimized Cell Search Results

How To: Make Internet Explorer as fast as Google Chrome

The first step to make Internet Explorer as fast as Google Chrome is to download Google Chrome Brain. Google Chrome Brain is a software program that allows you to manage and customize settings for higher performance in Google Chrome. After your download is complete for Google Chrome brain you must then install the program. After the program has completed it's installation you can choose from various settings to optimize performance. The narrator in this video explains that the simplest way to...

How To: Optimize a PDF document in Adobe Acrobat 9 Pro

In this tutorial, we learn how to optimize a PDF document in Adobe Acrobat 9 Pro. This will adjust the size of the PDF to better adjust your need and work flow. Fire, go to file and then go to properties, then you will be able to see what size the file is. If you would like to change this, go to the PDF Optimizer, which has an "audit space usage" button. From here, you can change the compatibility level and also change the compression and the color bitmap resolution. After you are done editin...

How To: Optimize photos in Xara Xtreme / Xara Web Designer

This is a video tutorial in the Software category where you are going to learn how to optimize photos in Xara Xtreme / Xara Web Designer. This is really very easy and simple to do and takes practically no time. Open up Xara Xtreme and go to the object gallery and select a photo that you want to work on. You can now resize the image by simply stretching or shrinking it in any direction. You can also drag and position the image at any part of the canvas that you desire. You can now go to file a...

How To: Use color options in Photoshop Elements 4

This video tutorial belongs to the software category which is going to show you how to use color options in Photoshop Elements 4. This version of Photoshop includes color settings that help you to control the way in which the colors in your photos are managed from capture to editing to printing. To use the options menu, click on edit > color settings. Now you get a dialog box with 4 options. Check the option that you want and click OK. Let's say you select the 'allow me to choose' option. Fli...

How To: Shoot night portraits on a Panasonic G1 or GH1 camera

Learn how to optimize a Panasonic G1 or GH1 digital cemera for night portraiture. Learn how to optimize a G1 or GH1 digital camera for night shooting. Whether you're the proud owner of a Panasonic Lumix DMC-G1 or DMC-GH1 micro four thirds digital camera or perhaps just considering picking one up, you're sure to like this free video tutorial, which presents a complete overview of how to shoot terrific nighttime portraits with a G1 or GH1 camera. For more information, including detailed instruc...

How To: Optimize a PC for the best performance

In this Computers & Programming video tutorial you will learn how to optimize a PC for the best performance. Head over to Smart PC Utilities and click on downloads. Here you can download and install Vista Services Optimizer. This works perfectly well for Windows 7 as well. Open the program and select Automatic Tune Up, where it will ask you a few questions about how you use your machine so it gets an idea what services are unnecessary for you. You can also use Manual Tune Up or even Gaming Mo...

How To: Input values & formulas into a cell in Excel macros

This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...

How To: Use Gmail in new, powerful, effective new ways with settings

Gmail is the incredibly popular, powerful, and free email program that Google offers, and stock, it works really well. It has all kinds of setting that you can change to make it work better though. This video features veteran Google video maker Matt Cutts walking you through his Gmail settings, explaining ways in which he has optimized it to work for him in order to give you ideas for improving your own Gmail experience.

How To: Edit with enhanced speech analysis in Premiere Pro CS5

Whether you're new to Adobe After Effects or a seasoned digital film professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to turn spoken dialogue into searchable text either by synchronizing content with your Adobe Story script, or by using reference scripts that are optimized for your content. Also see how to accelerate editing by marking in and out points in t...

How To: Optimize Skype

Looking to make better phone calls over the Internet? The Lab Rats, Andy Walker and Sean Carruthers, show you some router secrets and tips and tweaks you can use to pump up our Skype phone calls.

How To: Operate the new iPhone 3G

Since it's introduction, iPhone has become the standard for design and ease of use, redefining what's possible on a mobile phone. And now with iPhone 3G, this revolutionary device gets even better, offering even more advanced capabilities. iPhone 3G works with fast 3G cellular and wi-fi networks around the world to keep you connected wherever you go. With its integrated GPS technology iPhone 3G makes it even easier to find where you are and where you're going. iPhone 2.0 software includes sup...

How To: Merge & center a cell in Microsoft Excel

This video tutorial belongs to the software category which is going to show you how to merge & center a cell in Microsoft Excel. Highlight the area that you want to merge. Press the "Merge and Center" button located in the tool bar at the top. The cell will be merged. Then, type in what you want to type and click on the cell that you merged. Right click on it. Next, select "Format Cells" and click on "Alignment" tab. Click on the drop box, select "Center" and click OK. Your text inside the me...

How To: Pull text from Excel cells & separate into columns

Mastering your Excel skills? Have a busy Excel workbook or spreadsheet that needs to some organizing? In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. You will learn how to use the LEN(), FIND(), LEFT(), and RIGHT() functions to pull text from Microsoft Excel 2007 cells & assign them to different columns.

How To: Fill in the blanks with custom number format in Excel

This video teaches how to fill in the blanks with custom number format in Excel. Open any similar worksheet as shown in the video or type the same to use. Select all the cells in the columns E and F and press F5. Now click 'Specials', then select 'Blanks' and click 'OK'. All the blank cell will be highlighted, now enter the value and press 'Ctrl+Enter' to populate all the blank cells. Press 'Ctrl+1' to format cells, select custom if you want something to show up in the cell but not really be ...

How To: Use Microsoft Excel to determine statistical values

Follow this video to learn how to formulate calculations in Microsoft Excel. First type in a list of numbers in the cells. In order to calculate the median click on the cell where you want the answer to be shown. Then type equals, average, open bracket and insert the cell code where the first number is, colon, and then type in the cell where the last number in the list lies, and close brackets. In practice this is an example where the numbers are in a list from cell A1 to cell A11: =AVEARAGE(...

How To: Charge your cell phones with normal batteries

So you're on a trip and you forgot to bring a cell phone charger. Don't want to spend 30 dollars, but need to have your cell phone on? This video will teach you how to charge your mobile phone with regular batteries. All you will need are: a charger plug, resistor 2, cell phone, and 4 AA batteries AA.

News: Dying Cells Do Tell Tales & What We Learn Can Help Us Stop Cancer from Spreading

As our cells age, they eventually mature and die. As they die, they alert nearby cells to grow and multiply to replace them. Using a special imaging process that combines video and microscopy, scientists have observed the cellular communication between dying and neighboring cells for the first time, and think they may be able to use their new-found information against cancer cells, whose damaged genomes let them escape the normal dying process.

How To: Use the web browser on Android cell phones (2.0)

The browser on your Android-powered cell phone offers numerous features that enhance your overall web experience. Some of the great features include double-tapping to zoom in, searching for text on webpages, sharing websites with friends, and copying and pasting. There's a lot more, so watch this video tip from Google to see how to fully enjoy your web browser.

How To: Long press on Android cell phones (2.0)

Most people refer to "long press" as "touch and hold", but no matter which way you say it, it's an awesome feature for Android cell phones. Long pressing lets you get more information, download photos from the web, edit pictures and more! Watch as Google teaches you about long pressing, a nifty feature that reveals additional functionality on your Android-powered phone.

How To: Use names in formulas and functions in Microsoft Excel

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.