Listing Spark Search Results

How To: Create bulleted or numbered lists in MS Word 2007

This video explains how to add a bulleted or numbered list in Microsoft Word 2007. The shortcut to create a bullet-list is simple holding Shift and pressing the "A" key. After you hit the space bar or type a character the bullet will appear, and when you hit the Enter key it will continue the bulleted list. For numbering you just need to type the number you want and a dot after it and it should begin a numbered list. The list will continue if you press enter just like a bullet-list will. If y...

How To: Make a shrinking data validation list 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, the 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.

How To: Change spark plugs

In this series John explains how to read spark plugs, how to diagnose when they are bad or need replacing and then how to replace and test them. It's a pretty simple task, and it'll save you money if you learn to do it yourself. Please make sure to check your car's repair manual as specifics may be different.

How To: View a hidden friends list on MySpace

MySpace gives users the ability to hide their friends list. This video walks you step by step through being able to view this list. First, go to the desired profile. You'll see the hidden friends list. Now, click on "Edit with notepad" and code will pop up on your notepad. Because the list is on the page, editing the source code will make the list appear on the page. Next, type the command >table border=0 cellspacing=0 align="center">. Now you'll be instructed on how to delete the source code...

How To: Sort Excel data in custom order

This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...

How To: Merge two list tables and delete duplicates 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 381st installment in their series of digital spreadsheet magic tricks, you'll learn how to merge two lists into one list while keeping unique items from list 1 and list 2 and removing duplicates.

How To: Create your favorites list on an iPhone

In this video, we learn how to create a favorites list on an iPhone. Doing this will make it easier and quicker to speed dial! First, just tap on the "favorites" button. Then, click on the "+" button to add a new favorite from your contacts. You can then click "edit" to rearrange or remove favorites from your list. Click on the blue arrow next to a name to see the full contact details for that person. As soon as you add or remove someone from your favorites it's saved. That's all you need to ...

Rules Thrown Out the Window: Ogilvy & Mather's Scrabble Trickster Video Spot

Despite the controversy over Scrabble Trickster across the word world, Mattel's modern take on the classic crossword board game is out in stores— but not in the United States. It's only available in and around the UK, but you can snag your copy just in time for Christmas from Amazon UK. You can also visit the official Scrabble Trickster website. I imagine this is going to be a hot item in the United Kingdom this holiday season, but as for me— it's the one Scrabble game I refuse to add to my c...

How To: Build a successful fire in the snow

In this outdoors how-to video from fitclimb.com we're shown how to make a fire in the snow. The first step is to find a good flat spot, or make a flat spot yourself. Next, we look for trees with dead branches and break those dead branches off for the wood. The key here is to be organized because you'll have to carry this wood back to your camp. Next, you want to make a platform for your fire to keep it from sinking down as the snow melts. Here, we're using the bark from a dead stump for a pla...

How To: Change the oil and spark plugs on an MTV snowblower

It's still pretty snowy out there, thanks to winter's desperate need for attention. But thankfully you've ditched the snow shovel and got yourself a snowblower to help you remove all that blizzard snow from your sidewalks. Unfortunately, like all snowblowers, you'll eventually have to perform an oil change. But no worries, if you have an MTV snowblower, then this video will help you change both the oil and the spark plug in your engine. Plus, see how to gap your spark plug. This also is handy...

How To: Repair a Ford triton spark plug thread

This video illustrates how to repair a Ford F150 with a Triton V8 park plug thread. Get it into the garage and check out the engine. The Noise is all about the spark plug thread is blown out of the cylinder head. This problem is very common in the Triton V8 engines. To repair this spark plug thread the materials you need, Materials: 1. Cylinder head repair kit from Napa. 2. RED Thread locker. Procedure: Before the repair, remove the negative cable from the battery. Fit the adapter to the sock...

How To: Create a nested unique list via a pivot table 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 250th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales representatives using a pivot table (PivotTable).

How To: Create a list of hyperlinks 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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.

How To: Add Fireworks to Any Night Picture in Photoshop

Going to miss the fireworks extravaganza this Fourth of July? Doesn't mean you can't fake the experience, and that's exactly what we're going to do here—in Photoshop. You're going to learn how to take any night photograph and insert fireworks into it. It's the next best thing to watching some fireworks display firsthand.

How To: Work with dropdown lists in Microsoft Office Excel

This how to video shows you how to use drop down lists in Microsoft Excel. This will be useful for stores and avoiding people ordering items that are not available. First, type the items in a column. Select them and then click in the name box. Type the name of the list. Note that it must be one word. Now, go back to the order sheet. Select the cell where you want the list to be placed. Go to data and select validation. On the settings tab, choose list and type in = and list name. You can pres...

How To: Draw dynamite

First of all use a grey color shade to draw the outline sketch of the figure. First draw the trapezium in the front. Now draw a rectangle at the side of the trapezium. Make a flat top to the figure. From the middle of the trapezium draw a string protruding downwards. Now divide the figure into three equal sections. Now you have to darken sections on the rectangular side. Draw the vertical lines of the rectangular side curved outwards at the far end. At the front end of the rectangular side ma...

How To: Storyboard, make a shot list, line your script, and schedule a film production

Measure twice cut once applies to filmmaking as well as construction or any other complex process really, and that's why preproduction is they key to actually finishing your film on time and budget. This video will help you with several preproduction tasks, including storyboarding, making a shot list, lining / timing your script, and scheduling the actual production of the film.

How To: Create bulleted and numbered lists in AutoCAD 2011

Want to create a bulleted or numbered list in AutoCAD 2011? This clip will teach you everything you'll need to know. Whether you're new to Autodesk's popular 3D drafting application or a seasoned professional just looking to better acquaint yourself with the newest iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.

How To: Style list items with Cascading Style Sheets (CSS)

With help from this free video tutorial, you'll learn how to style list items with CSS. Whether you're using a fancy WYSIWYG (or what-you-see-is-what-you-get) page editor like Adobe Dreamweaver CS5 or a barebones text editor like Notepad, if you want to build websites, you'll need to have some understanding of HTML (for the structure of your web pages) and CSS (for their style). And this free coder's guide will get you started along that path.