Optimized Cell Search Results

News: How Gut Bacteria Could Set Off the Immune System in Rheumatoid Arthritis

As if the swollen, painful joints of rheumatoid arthritis weren't enough, the disease is the result of our immune system turning against cells of our own body. Ever since this realization, scientists have worked to find the trigger that sets the immune system off. Scientists believe that gut bacteria may have a role in initiating the abnormal immune response. Now, a team of researchers from Boston has figured out how that might occur.

How To: Create a rotating slideshow with Flash ActionScript

This tutorial shows you how to create a picture rotating slideshow, that fades in and out using Adobe Flash. Using optimized embedded photos is not the only way, but it is a very basic and easy method to create a slideshow picture rotator. Whether you're new to Adobe's popular Flash-development platform or a seasoned web developer looking to better acquaint yourself with Flash CS3, you're sure to benefit from this free software tutorial. For more information, including detailed, step-by-step ...

How To: Make watery ice glass text in Photoshop CS4

In this tutorial, learn how to make a very cool wet writing effect that you can use for graphics and logos. You will be creating this effect in Photoshop CS4. In this video, you will learn how to take tons of different layer styles and transform a basic text layer into a majestic piece of artwork. You will be shown the process step by step from the very beginning. This tutorial also shows the use of gradients and color corrections tools to optimize the full piece of work.

How To: Find & extract duplicate records from a data set

This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...

How To: Use the filter & sort feature in Excel

In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizontal lines. Now go back to the data set, click on a cell and click ctrl+shift+L and that will add the auto filter. ctrl+shift+L is for Excel 07. For earlier versions, see the commands listed in the video. This is a toggle...

How To: Sort data in Excel

ShowMeAcademy.com shows how to sort data in Excel 2007. Excel has many options for sorting data according to any given column. To sort your data, right click on a cell in the column that you want to sort by. A menu comes up where you will see the “Sort” option. Hold your mouse over “Sort” and another menu comes up showing the different ways to sort. For example, if you select “Sort Smallest to Largest” it will take all the data and sort it from the row that has the lowest figure u...

How To: Fix a wet cell phone or a jammed ipod

Today's Tech shows you how to fix a cell phone or computer that has gotten wet or jammed. With a wet cell phone, you must act quickly or it may be permanently damaged. The first thing you should do after pulling it out of the water is to take the battery and SIM card out. Dry both of them off. If you drop it in a liquid that is not water, rinse them off quickly. If you have a vacuum cleaner handy, you can use it to suck the water off. You can also place the phone on top of your cable box. Wai...

How To: Find the vertices of a polygon of constraints

In this tutorial the instructor shows how to find the vertices of a polygon of constraints. In any optimization problem after defining your polygon you need to find its vertices. First you will have a set of equations which represents the constraints in your problem. Now you have to find the coordinates of the vertex of it by solving the optimization problem. To do that you have to start with a point and check the lines that are passing through it. Now take those lines and solve them for the ...

How To: Send video via email with your Motorola Droid

Phil from droidboards.com demonstrates how to send a video file by email using a Motorola Droid. Before capturing the video make sure to change the settings on the Droid to optimize the quality of the video for distribution by email or MMS as shown in the video. This is essential to keep the video file to a smaller size as possible. Next after shooting the video select the video file using a file manager and send it via email as indicated. This allows you to instantly share videos shot on you...

How To: Solve common SketchUp problems

The guys at the SketchUp show have received some great SketchUp questions recently. After a careful board meeting with lots of people in suits and ties and plenty of donuts and coffee, they decided to answer those questions in this podcast. In this video, they tackle the following beginning and advanced SketchUp topics: Getting a grasp of your Keyboard Shortcuts, Optimizing Print Quality, and creating Tensile Structures using the famed Soap Skin Bubble plugin. So if you need any help with Ske...

How To: Use the KAM LED Swingfire sound to light unit

Want to mix and scratch like a professional DJ? To be a good DJ you need to understand the concepts of mixing tracks, adding cool effects, and of course you need a good sense of rhythm to line up the beats. This how to video explains how you can use the KAM LED Swingfire sound to light unit. This demonstration shows you how to optimize its performance. With 63 LED's, 7 lenses, and sound to light, watch the beams of light as the instructor controls the lights with some funky music. Watch this ...

How To: Set up a new BlackBerry Torch 9800 smartphone

Need some help figuring out how to set up and configure your BlackBerry Torch 9800 cell phone? This clip will teach you everything you'll need to know. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this official video guide from the folks at Blackberry. For detailed information, including step-by-step instructions, take a look.

How To: Customize the home screen on the HTC Droid Incredible

You can customize the seven home screens on the HTC Droid Incredible cell phone by adding widgets, changing the live wallpaper, and creating scenes to fit your lifestyle. Live wallpapers move and respond to your touch and changing scenes is a quick way to match the Incredible to your current status. Verizon Wireless shows you how to personalize your phone.

How To: Remove spaces from a Microsoft Excel formula

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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.

How To: Create an Excel inventory template with running totals

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Convert currency with data from a web query in 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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.

How To: Use dictation, voice command, & control on a Samsung

You know it's not safe to drive and oeprate your cell phone, so why not learn how to take advantage of the latest voice features on the Samsung Rogue? Just watch this video and you'll be dictating, and voice commanding and controlling in no time. Give your thumbs a break, dictate your texts - the Rogue even recognizes commands such as "smiley face" and translates them into the appropriate emoticon. Cool!

How To: Install & remove an iPhone cover

Want to protect your investment and add some personal style to your cell phone, but aren't quite sure how to install that cool new skin? We've got you covered - just check out this quick video on how to install and remove an iPhone case. If only getting ready for work could be so easy!

How To: Build a portable power pack

If you're a geek, then this power pack will give you a total techgasm. The power pack allows you to charge pretty much anything you can fit into a 12 volt power jack in your car (where the cigar/lighter receptable goes). The power pack is a portable battery, so no need for charging your gadgets - like your cell phone - at home first before you head off to work.