Posting Well Informed Search Results

How To: Use absolute ($) cell referencing in Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using '$' to prevent excel from changing formulae when copying or filling ranges. For more on absolute cell referencing, watch this Microsoft Excel how-to.

How To: Calculate averages in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, watch this how-to.

How To: Use simple formulae in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about simple addition, subtraction, multiplication and division in Excel. For more on using simple formulae, watch this video how-to.

How To: Format spreadsheets in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this Excel tutorial, you'll learn about simple formatting, background colour, gridlines, alignment. For more information on formatting spreadsheets within MS Excel, watch this helpful how-to.

How To: Get started using Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. This Microsoft Office video tutorial presents an extremely introduction to Excel. In it, you'll learn about names of bits and really simple formatting. To get started using Excel for yourself, take a look.

How To: Use British slang

Check out this instructional language video to learn a few definitions of British English slang words. Slang is the use of highly informed words and expressions that are not considered standard in the language. Understand and be able to use some informal British English words with this tutorial video.

How To: Enable blocked macros in Office 2007

Not sure what to do when you get a security warning about a macro? What are macro security settings, the Trust Center, and Trusted Locations anyway? Watch this instructional video to learn how to enable macros and make informed security decisions that can help you keep your computer safer while you work in Microsoft Office Excel, Outlook, Word, Publisher, PowerPoint, and Visio 2007.

How To: Make homemade dessert icing

While topping your cake or cupcake with icing is easiest done using storebought icing, we're sorry to inform you that most grocery store icing has high amounts of saturated fat and even trans fat, both of which clog your arteries and contribute to heart disease. Not so appetizing now, is it?

How To: Do Power Drift achievement in Sonic & Sega All-Stars

Achievement Hunter presents how to do power drift in Sonic & Sega All-Stars Cart Racing Part 1. To pick up the drifting achievement, all you have to do is drift for 15 seconds continuously. In order to drift, you hold down the left trigger. The narrator informs us that you can switch from drifting to the left to drifting to the right if you bounce off the wall, so it does not have to be all one direction. He said that the first time he did it, he drifted on the last few turns of the race. Tha...

How To: Listen to music with your whole body

In this soaring demonstration, deaf percussionist Evelyn Glennie leads the audience through an exploration of music not as notes on a page, but as an expression of the human experience. Playing with sensitivity and nuance informed by a soul-deep understanding of and connection to music, she talks about a music that is more than sound waves perceived by the human ear. She illustrates a richer picture that begins with listening to yourself, and includes emotion and intent as well as the complex...

How To: Build a stackable block post

In this how to video, you will learn how to build a post. Court yard posts create beautiful accents to your yards. They can be used as entry monuments and fence posts. When using corner blocks, make sure the long sides are at the outside of the post. First, place these corner blocks in a square. Align the blocks with the square. Next, place four more blocks on top of the original blocks. Make sure the blocks touch two blocks. Keep on stacking them to the desired height. Add two post caps. Sec...

How To: Build patio walls with posts

Instructions for building wall panels and posts using Alan Block materials. This is How-to Sheet #190, for the Courtyard Collection. Combine walls and posts in a three step process: build a post, build one wall off the post, then build a second wall off the first. Corner blocks help make perfect corners, and have one long and one short side. Offset the vertical seems by alternating. Blocks used for the wall include Dublin center-split, Dublin end-split, and York center-split. You will need to...

How To: Perform a "How'd you do that" card trick

This is a video that demonstrates how a card trick is done. It shows a trick in which the presenter does a card trick and then explains how it is done. The trick is one where the person guesses a card and it deals with a red deck and a blue card. The person guesses a number in the deck and that number is the card. In this case it was the queen of hearts. The card is then placed back into the deck and when the presenter lays out the cards, the blue card becomes the queen of hearts. The trick i...

How To: Survive in a Falling Elevator

The tragedy of a falling elevator is not unheard of. This could happen to you at any time, and you will most likely not be expecting it. Who would step into an elevator if they had an idea it might plummet to the ground? The best thing you can do is be prepared. First you want to stay calm. Next you want to lie, belly down, on the elevator floor with your hands behind your head. Make sure you do not panic. This is crucial in times of crisis. When all is over, you'll notice that you're still a...

How To: Search graphics, tables, and charts in MS Word 2010

This is an informative video tutorial on how to search graphics, tables and charts using MS Word 2010. The author informs that the earlier MS Word editions had fast and easy search options, but the same feature built into the 2010 edition is vastly improved. One simply has to click the ‘Find’ option at the top right-hand corner and a navigation pane opens on the left-hand side. In the search box, the keyword is typed in and all the instances of that word in the document are highlighted, while...

How To: Make a summery Suntan Lotion cocktail with rum

Bartending expert Derrick Schommer gives a graphic demonstration on how to make a Suntan Lotion cocktail with rum. Derrick informs us that this is a very simple cocktail, its ingredients being 1 oz. each of coconut rum, amaretto and cream. All three are shaken well together with ice, and then strained into a lowball glass full of ice cubes. In closing Derrick advises that instead of the regular thick cream, it would be better to use the thinner lye cream, since regular cream would make the co...

How To: Install post and dowel fencing

My how-to on Post and Dowel Fencing. My buddy Sven and I, with the help of landowner Rex, installing a massive post & dowel Fence. You need a level, post hill driller, rock bar, and stakes. There are terminator, corner and line posts that have holes specifically for its position in the fence. It's like Lincoln logs that snap together. Lengths of the post vary, but you want 1/3 of the post underground. This is great for lining your property or farm.

How To: Modify a Glidecam with a Steadicam arm and vest

The lady shows how to make the steadicam arm to work with glidecam stabilizer. The steadicam arm is made such as only a steadicam can be fitted on that. The video describes how to make the usable for glidecam with three simple tools ,a 10 ounce hammer ,a long nose player and a flathead screwdriver. First take out the circular clip with which the post is secured with the screwdriver unscrew and pull the post out .Using the hammer straighten the post .The post will have a scratch but the straig...

How To: Create a Post-it note in Photoshop

Now, instead of leaving Post-It notes on a monitor screen, you can create virtual Post-It notes in Adobe Photoshop! This is a quick tutorial for the intermediate to advanced user of Photoshop, showing you how to create a square, yellow graphic that looks strikingly like the Post-It notes you can find at office supply stores! Add to your website, incorporate in PowerPoint presentations, or use wherever you see a need for a virtual sticky note!

How To: Turn dates off in Blogger blog posts

Sometimes when making a blog post you'll want to post it without any date whatsoever. To do this is easy, and this short how-to from How to Mac, makes it easy as pie. This is a tutorial on how to turn off dates on your blogger blog posts. If you want to change the blog post dating system click on the formatting tab and change the first setting. To completely turn the dates off make sure you de select both the first and third option in the edit blog post window.

How To: Do stomach flattening exercises at home

This fitness video shows how to do stomach-flattening exercises at home. Our host, Kathy, Kaehler, informs us that the best exercise is a yoga-based exercise called the plank, because it focuses on your core. Your core is where your abs are. This exercise is best done on soft surfaces. Start out at 15 seconds, and build up to a minute or more. To do the plank, rest on your knees and 1 forearm, with your side facing the ground. Make sure your body is straight. If you want to make the exercise ...

How To: Start meditating like David Lynch

What would David Lynch do? Well, being a deep, deep man, David Lynch would meditate. Elephant Man, Eraserhead, the Straight Story, Blue Velvet, and so on, David Lynch has been writing and directing movies that have alternately scared, confused, and inspired an international audience and devoted fan base. Cinematic genius or no, Lynch is still just a man, who is filled with anxiety and wants happiness. Watch this video tutorial and learn how to get involved in transcendental meditation and how...

How To: Hack iPhone jack to support headphones

As any informed PopSci reader will know, the iPhone is definitely a game-changing piece of hardware, but it's not without its problems. Chief among those nagging little imperfections, for me, was the recessed headphone hack that rejected any headphones but Apple's trademark gleaming white buds. Apple's 'phones aren't that bad, but my Shure in-ear pair is better for blocking out noise on the subway (and my Grado SR60s are better for listening at home). Thankfully, an easy solution to this prob...