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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...
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 and Mr. Excel, the 11th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create a formula that will randomly select a name from a list of names without having the list of names sitting in cells.
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 7th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with VLOOKUP function formulas in MS Excel. Specifically, you'll see the following:
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.
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 583rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF & IFERROR functions with absolute and mixed cell references to create a large table of conditional average calculations (averaging with criteria).
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 582nd installment in their series of digital spreadsheet magic tricks, you'll learn how to understand and fix the nine most common formula errors in Microsoft Excel. Specifically, you'll learn how to interpret and resolve #######, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Cell Reference, and #NULL! errors.
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 580th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE, MID, COLUMNS and SEARCH functions to extract numbers to the right of a decimal into their individual cells.
In this video you will learn how to setup a Bluetooth mobile phone in OS X. To do this go at system preferences select Bluetooth click on Discoverable, Open Bluetooth Setup Assistance and Show Bluetooth Status in the menu. Then click Sharing and mark all the options. Now go at devices, select set up new device, mark mobile phone, click continue, wait until the device will find your mobile device, click continue and you will get a pass key. Enter that passkey. A window will pop-up where you ca...
New to 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 Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
Curtis Smith of Yard and Garden teachers viewers how to protect outdoor plants and shrubs in the winter. For instance, Lilacs and be burned by the cold weather so it is advised to not place lilac to the South or the West against a wall in the winter. Next, with a privett plant there may be damage on the leaves but others are perfect - but this is normal. This plant is an evergreen and some cells in the leaf may die which will make the leaves look damaged. This will be shown on last years leav...
This video shows how to make a quick pivot table data filtering by using Excel 2010's ‘Slicer’ functionality. ‘Slicer’ delivers enhanced visual filtering method to allow you to get the data you need more quickly. When selecting a cell in the pivot table you will find ‘Slicer’ in the filter group of the ‘Insert’ tab. Click on ‘Slicer’ and an 'Insert Slicer' dialogue shows up where you can pick particular data fields from the slider list. Once you click on ‘OK’, the ‘Slicer’ objects with filter...
The Xperia Play is a Sony Ericsson smartphone on Verizon built for gaming on the go. The mobile phone features a slide-out gamepad that you can use to navigate the web and play different gaming apps preloaded on the phone or downloadable from the Android market.
The Xperia Play smartphone runs the Android OS and can be customized in many different ways. If you want to add icons, widgets, or change the wallpaper on the Sony Ericsson phone's homescreen, take a look at this walkthrough to make the mobile gaming device yours.
If you're looking to get a faster Android phone without resorting to installing a custom ROM, check out this helpful video to learn seven tips for speeding up an Android smartphone. There are a number of easy adjustments to the standard Android settings that will make the phone seem much faster.
If you've got an extra DVD drive laying around not being used, watch this video and learn how to give the lens new life—as a powerful macro lens for your camera phone! You'll be able to take incredible pictures on your camera phone using this clever mod.
If you're a MetroPCS user and would like to tether your phone to your PCS to use it as a modem, this video will show you how it's done. First of all, hit the subtitles button to make sure you're getting the instructions in english. Next, you'l want to go here to get the Samsun PC Studio link tool which will let the connection be made. Enjoy!
This how-to video shows what you need to know in order to tether your MetroPCS android smart phone. Follow the steps and use your phone's wifi with your laptop. This is a cool new feature and you should check it out.
In this clip, we learn how to download additional Ovi Maps-compatible maps when using a Nokia C5 mobile phone. The C5 is the first offering in Nokia's new "C" series of mobile phones. It runs on Nokia's Symbian OS and features a 2.2-inch screen and 3.2-megapixel camera. Want more? Search WonderHowTo's sizable collection of C5 video tutorials.
As any gourmet will tell you, you can't make gingerbread without an egg or two. Google's Gingerbread (Android OS 2.3) is no exception. In this video, we learn how to access a secret Gingerbread Easter egg by furiously tapping on the version number on your phone's About page.
Surf the web on your HTC HD7! This clip will teach you how to use the phone's built-in web browser. Whether you're the proud owner of an HTC HD7 Windows Phone 7 smartphone or are merely toying with the idea of picking one up in the near future, you're sure to be well served by this official video guide from the folks at T-Mobile.
Well, you've opened up your iPhone 4 and taken the battery out. Now, you want to remove the LCD display and the logic board and the phone's proximity sensor. Apple doesn't like you doing it, but this great, step-by-step guide shows you clearly just how to do it.
Sure, the iPhone is a phone, but why use your phone service to call people when VOIP is cheaper? This video will teach you how to use a new App called Viber to make free VOIP calls on the iPhone.
Learn everything you need to know about using a T-Mobile myTouch 4G Google Android smartphone. This video guide presents a general overview of the phone's hardware and software. For all of the details, and to get started using your own myTouch 4G, watch this video guide.
Interested in converting your mobile phone's SIM card into a MicroSIM card? It's easy! So easy, in fact, that this mobile phone hacker's guide can present a complete overview of the process in about eight minutes. For more information, including detailed, step-by-step instructions, take a look!
Get the most out of your Samsung Focus! This guide offers a software tour of the Samsung Focus Windows Phone 7 smartphone, which features a 4" Super AMOLED display. Windows Phone 7 novice? Not a problem. This exhaustive, eleven-minute guide will teach you everything you need to know. Become a WP7 pro with this video guide.
Get the most out of your HTC HD7! This guide offers a software tour of the HTC HD7 Windows Phone 7 smartphone. Windows Phone 7 novice? Not a problem. This exhaustive, eleven-minute guide will teach you everything you need to know. Become a WP7 pro with this video guide.
Learn how to load a custom ROM onto a rooted Motorola Milestone Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted Milestone, watch this nine-minute hacker's how-to.
Learn how to load a custom ROM onto a rooted HTC Desire Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted Desire, watch this three-minute hacker's how-to.
Learn how to load a custom ROM onto a rooted HTC Legend Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted Legend, watch this three-minute hacker's how-to.
Learn how to load a custom ROM onto a rooted Motorola Droid Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted Droid, watch this three-minute hacker's how-to.
Learn how to load a custom ROM onto a rooted Samsung Galaxy Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted Samsung Galaxy, watch this three-minute hacker's how-to.
Learn how to load a custom ROM onto a rooted HTC Tattoo Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted Tattoo, watch this three-minute hacker's how-to.
Learn how to load a custom ROM onto a rooted Acer Liquid Google Android smartphone! Custom ROMs — or firmware images — help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted Liquid, watch this three-minute hacker's how-to.
Learn how to load a cracked Hero ROM onto a rooted T-Mobile G1 Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted G1, watch this three-minute hacker's how-to.
Learn how to flash a custom recovery image and load a custom ROM onto a rooted Droid Eris Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted HTC Droid Eris, watch this three-minute hacker's how-to.
Learn how to load a custom ROM onto a rooted CLIQ Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted CLIQ, watch this three-minute hacker's how-to.
Learn how to load a custom ROM onto a rooted Nexus One Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted Nexus One, watch this three-minute hacker's how-to.
Learn how to load a custom ROM onto a rooted HTC Magic Google Android smartphone! Custom ROMs help you to unlock your phone's hidden potential and allow you to, among other things, turn your mobile phone into a 3G wireless modem with free WiFi tethering. For all of the details, and to get started running custom ROMs on your own rooted HTC Magic, watch this three-minute hacker's how-to.
Want to get into both of the locked levels for the popular phone game Angry Birds? This video shows you how to access both of them when you're using a Droid phone. This is a very easy hack to replicate!
