Lasting Odour Search Results

How To: Solve a Rubik's Cube in 90 seconds

Learn how to solve a Rubik's cube in ninety seconds in this video. You'll learn that there are couple of common methods used to solve the cube. The Petrus method which starts with the corner and the Friedrich method which starts at the bottom and moves up. The presenter shows how he uses several methods and algorithms to create seven steps to a solved cube. The first step is to make a cross on the bottom layer. The second step is to correctly place the bottom corner pieces. The third step is ...

How To: Apply flattering makeup for TV news anchors

Who better to learn how to apply TV news makeup from than an actual TV news anchor? Emily Noel is a famous TV news anchor with several years in the biz, and she's here with this makeup tutorial to show you exactly how to get that flawless, shine-free TV anchor look you see in most news broadcasts.

How To: Create a sexy brown and gold cat eye with Urban Decay NAKED

Urban Decay has a nasty habit of releasing highly anticipated makeup palettes in very limited quantities so they sell like hotcakes. Their most recent palette, NAKED, sold out in seconds on their website, but if you were one of the lucky ones to snatch one of these up, then this tutorial will teach you how to create a smokin' hot look using the palette.

How To: Average the last three values for an entity 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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.

How To: Create a long-lasting sexy makeup look for clubbing

Dolling yourself up for a night out on the town clubbing is probably also half the fun of the whole clubbing experience: doing the big hair to make us look like goddesses, donning the impossibly long false eyelashes, slipping on that sexy dress from Bebe, and sticking our tooties into leg lengthening pumps is just as much of a delight as dancing the night away.

How To: Play "Last Kiss" by Pearl Jam on guitar

In this video, we learn how to play "Last Kiss" by Pearl Jam on guitar. Start with a G chord, then Em, C, and D. Once you have these, put them together to start the introduction to the song. You will move up and down with the chords of the song to create a different sound on the notes. On the breaks, play a G chord, then wait for a few counts and start the intro chords over again. This will make the melody for the song. Add in the lyrics to the melody, then you will have learned this Pearl Ja...

How To: Cite scholarly journal articles in MLA format

This video shows viewers how to properly cite scholarly journal articles in the MLA format. In your works cited page, the citation should begin by placing the author's last name first, followed by his first name. If there are multiple authors, all subsequent authors should have their first name first followed by their last name. Placing a period after this, the next item is the title of the article, placed in quotation marks and followed by a period. The name of the scholarly journal is place...

How To: Work with Microsoft Excel's LOOKUP function

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 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP function:

How To: Find the last row or column used in an Excel data set

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 135th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range when there are blanks in the data set. Learn also how to use an array formula to find the Last row or column used in a data set.

How To: Make Your iPhone Camera Open to Your Last Used Shooting Settings So You're Always Ready

Even though your iPhone's Camera app is fast and easy to use, its default settings prevent you from immediately accessing any other shooting mode aside from "Photo" with "Live Photo" on and no filter applied. But there is a way to make the Camera app remember what you prefer the next time you open it up.

How To: This Trick Shows You Exactly When You Clicked on That Purple Link

When you click a link from Google search, the link itself turns purple to let you know you've already visited this page. But let's say you're searching for something similar a few weeks from now and you see one of these purple links—you'll probably think to yourself, "What was I reading about on that site?"—and if you don't remember, you'll end up clicking the link again. And if you're a frequent Reddit user, you know this pain all too well.

How To: Fight as Amaterasu from Okami in Marvel vs. Capcom 3

Okami was one of the best games of the last decade, perhaps Capcom's finest, and it's heroine Amaterasu makes a much-deserved appearance in Marvel vs. Capcom 3. She isn't quite as powerful as you'd expect the God of Everything to be, but she kicks serious butt and this video will teach you the basics of fighting with her, including tips on all her normal attacks and special moves.