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 231st installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP on 3 tables on 3 different sheets.
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 176th installment in their series of digital spreadsheet magic tricks, you'll learn how to get the last number or word from a column on a different sheet.
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 174th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup up the last value in an unsorted list.
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 172nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create running total with a formula or a pivot table.
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 170th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to hide or show items in a list using a TRUE/FALSE formula.
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 153rd installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to the MAX value in a set of three incentive pay plans.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS functions.
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 Excel tutorial from ExcelIsFun, the 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
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 246th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a waterfall profit chart from a stacked column chart.
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 101st installment in their series of digital spreadsheet magic tricks, you'll learn how to use IS functions (ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF &ISTEXT).
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.
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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
New user to Windows 7? Microsoft has put out a series of video tutorials explaining how to maximize your Windows 7 experience. Follow along with this computer lesson and learn how to:
In this installment from the Unorthodox Hacking series of computer security videos, you will explore a few of the areas in Windows that most Sysadmins don’t even know exist. See how to become Local System through the Task Scheduler and abuse long filenames. Take a look at some of the features within Windows—registry—that many system administrators don't know exist with this hacking how-to.
Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the sort icons just under the menu bars. There is a sort ascending and sort descending icon. Click on the icon and Excel will sort the list. When sorting multiple columns the data must be in columns next to each other. If the...
Chronology in Microsoft Word is convenient when it comes to organizing your documents. Thankfully, you don't have to manually edit the document to put things in alphabetical order! This video shows you how to do it in a few clicks.
Batting a ball back and forth while you're barefoot on the beach is a fun way to get some exercise. Get started with these basic rules. Watch this video to learn how to play beach volleyball.
Mozilla Firefox is one of the Big Three web browsers, beloved for it's open nature and lack of affiliation with Microsoft or Google. Firefox 4 has been in a rather cranky Beta for some time, but has finally reached Release Candidate (RC) status! Watch this video for a guide to the new features you can play with in the RC, then click the link below to download it.
In this handy home-computing how-to from WonderHowTo favorites Tekzilla, we learn how to use CleanHaven, an application that will remove unwanted formatting from snippets of text. For details on how to download, install and run CleanHaven on your own Microsoft Windows PC, watch this video guide.
In this tutorial, we learn how to use ten handy and easy-to-remember keyboard shortcuts on an Apple Mac OS X or Microsoft Windows PC. They're easy to use and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to.
In this tutorial, you'll learn how to set up and use remote disc (DVD or CD) drive sharing for an Apple MacBook Air netbook. This can be done between Macs or between your MacBook and a Microsoft Windows PC. In any case, it's an easy process and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to.
In this clip, you'll learn how to make VOIP (or voice over IP) phone calls over your Windows PC. For more information, including a complete demonstration and detailed, step-by-step instructions, and to get started making phone calls over your own Internet connection, watch this handy home-computing how-to from the folks at CNET TV.
Forget the password to your Win 7 PC? Recording it is easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over six minutes. For more information, including step-by-step instructions, take a look.
Looking for a quick guide on how to flash your PC's BIOS? It's easy! So easy, in fact, that this home-computing how-to can present a complete overview of the process in just over five minutes. For more information, including detailed, step-by-step instructions, and to get started using this trick yourself, watch this video guide.
Want to simulate XP on a Win 7 computer? With Virtual PC, it's easy! So easy, in fact, that this home-computing how-to can present a complete overview of the process in just under five minutes. For more information, including detailed, step-by-step instructions, and to get started using this trick yourself, watch this video guide.
Interesting in adding custom shortcuts that appear when you right click on the XP Start Menu button? It's easy! So easy, in fact, that this home-computing how-to can present a complete overview of the process in just over two minutes. For more information, including detailed, step-by-step instructions, and to get started using this trick yourself, watch this video guide.
Need some help figuring out how to enable or disable Aero Snap on your Win 7 computer? It's easy! So easy, in fact, that this home-computing how-to can present a complete overview of the process in just under two minutes. For more information, including detailed, step-by-step instructions, and to get started using this Windows 7 trick yourself, watch this video guide.
Want to know how to permanently display the Windows 7 build number on your desktop? It's easy! So easy, in fact, that this home-computing how-to can present a complete overview of the process in just under two minutes. For more information, including detailed, step-by-step instructions, and to get started using this trick yourself, watch this video guide.
Interesting in personalizing the IE 8 title bar? It's easy! So easy, in fact, that this home-computing how-to can present a complete overview of the process in just under two minutes. For more information, including detailed, step-by-step instructions, and to get started using this trick yourself, watch this video guide.
Wish there were an easy way to turn a folder into a virtual hard drive? With Windows 7, it's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just under two minutes. For more information, including step-by-step instructions, take a look.
Want to decide which applications start up automatically upon booting your Windows PC? With Advanced Startup Manager, it's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over a minute. For more information, including step-by-step instructions, take a look.
Play the Sad Mummy as your champion! This video goes into strategies and tips when you play the League of Legends character Amumu the Sad Mummy. Watch Amumu in play and see the best way to use his unique and passive abilities to ensure victory for your team!
The new version of Microsoft Office has a feature which allows you to batch create PDFs. You can easily convert whole folders or specfic selections of Word, Excel or PowerPoint files into PDF files. You also have the option of converting the files into individual PDFs, or turn them into one large file.
One of Microsoft Excel's capabilities is to allow you to graph Normal Distribution, or the probability density function, for your busines. This is a quick and easy tracking feature you can learn in just a few minutes.
Looking for instructions on how reset passwords on a Windows XP? With Winternals ERD 2005, it's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over five minutes. For more information, including step-by-step instructions, take a look.
Want to know how to map FTP server shortcuts on a MS Windows 7 PC? It's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just under five minutes. For more information, including step-by-step instructions, take a look.
Looking for instructions on how to use TestDisk to recover files from a formatted hard drive on a Microsoft Windows PC? It's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over six minutes. For more information, including step-by-step instructions, take a look.
Interested in optimizing OS processes in your Win 7 install? With the SMART tool, it's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over seven minutes. For more information, including step-by-step instructions, take a look.
Looking for instructions on how to quickly cycle between resolutions on a Win 7 PC? It's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just under two minutes. For more information, including step-by-step instructions, take a look.
Want to know how to delete locked, undeletable files on a Microsoft Windows PC? With FileASSASSIN, it's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over five minutes. For more information, including step-by-step instructions, take a look.
