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...
A new profile on Apple's exiting design chief Jony Ive, the man behind many of the company's most successful products, paints a fuller picture of what led to his departure.
What better way to enjoy the beauty of the blocky world of Minecraft than by flying across the land? If you want to fly in the new release of Minecraft 1.8, take a look at this tutorial on how to download and install the Fly Mod, a part of Zombe's mod pack, with the help of MC Patcher HD. The guide will also inform you on how to bind keys to the different flying controls.
Mac OS X has convinced many traditional PC users to switch platforms. While Windows 7 may do something to stem that tide, a lot of you PC users reading this have probably thought about switching right? If you have, watch this video. It will give you a PC-user centric rundown of OS X and allow you to make a more informed decision about what operating system is best for you.
Most of us only see our screen savers in passing, as some sort of slide show or animation as we glance up at the screen or walk by the computer. Usually, anything is better than a boring blank screen—even the classic Pipes screensaver is better than nothing.
While the App Store is filled with news aggregators, Apple News is a solid choice when it comes to keeping up with current events. Apple recently made it easier than ever to stay informed, thanks to a daily newsletter sent straight to your inbox. The problem? It's unclear how to sign up for this newsletter, and it's equally unclear how to unsubscribe.
There are a couple of options available to you when it comes to navigation on your new HTC EVO 4G. In this clip, you will learn how to use the two most popular options: Sprint Navigation and Google Navigation. These apps are similar but each have their own pros and cons, so check out this clip before you choose so you can make an informed decision.
Want to try your hand at reupholstering a seat cushion? This breezy how-to video will take you the reupholstery process from start to finish as well as inform you of everything you'll need for a succesful project. Watch this video to learn how to rejuvinate your antique chairs.
It appears a privacy lawsuit that began five years ago is about to come to an end, and you might get some money out of it.
Need some help figuring out how to select a workspace in Adobe Flash Builder 4? This clip will teach you what you'll need to know to make an informed decision. Whether you're new to Adobe's popular Flash IDE (previously titled Adobe Flex Builder) or simply wish to become better acquainted with the program, you're sure to find benefit in this free video software tutorial. For more information, including specific, step-by-step instructions, take a look.
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 the QUOTIENT and MOD functions. Note that, in urder to use these functions, you'll need to install the analysis ToolPak. For more information, watch this Excel how-to.
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 LEN to count word length. To get started using the LEN function for yourself, watch this how-to.
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 a pivot table to summarize data.
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 adding hidden comments (and metadata more generally) to data cells. For more information on commenting, watch this Microsoft Office Excel how-to.
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 COUNTIF function to count the number of As, Bs and Cs. For more on using the Microsoft Excel COUNTIF fucntion, watch this how-to.
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 the HLOOKUP function to generate adaptable grades from marks. For more on using HLOOKUP across multiple documents, watch this Microsoft Office how-to.
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 concatenation using LEFT and RIGHT functions. For more information, watch this Microsoft Office how-to.
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 concatenation using cell references only. For more on textless concatenation, watch this MS Office how-to.
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 stringing text and data together by using an ampersand (&) concatenation. To learn more, watch this MS Office how-to.
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 conditional formatting in Excel to change background color. To get started learning about conditional formatting, watch this MS Office how-to.
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 VLOOKUP in one worksheet to look up values located in a second worksheet. For more on using VLOOKUP across Excel worksheets, watch this MS Office how-to.
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 VLOOKUP to look up values located in a table. To learn more about VLOOKUP, watch this MS Office Excel how-to.
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 nested IF functions to calculate a grade from an average mark. For more information on using conditional statements, watch this MS Excel how-to.
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.
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.
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.
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.
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.
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.
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.
Tell someone they said something racist? Yea. It could be tough. You want to have a helpful and informed conversation rather than the 'I think you are a racist".
If you are new to Trapster, and wish to help your fellow users by submitting a speed trap, check out this quick clip. In it, you will learn how to submit a trap to the application so everyone in your area gets an alert. This app depends on users helping other users, so stay informed and join the Trapster revolution.
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...
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...
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?
No one wants or needs a flat tire. If you do get one, however, don't get all flustered — changing a tire is as easy as buying groceries or going to the gym.
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...
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...
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...
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...
