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 279th installment in their series of digital spreadsheet magic tricks, you'll learn how use the ADDRESS, LEFT, ROW, ROWS, and COLUMN functions to create the series AA, AB, ZZ with a 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 220th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula with the SUMPRODUCT and EOMONTH functions that count the dates in each month for a given range of dates.
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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.
Mike Callahan with Butterscotch demonstrates how to work with tables in MS Word 2007. Tables are useful for creating information charts and address lists. First, open up Microsoft Word. To create a table, click on the insert tab on the top tool bar. Highlight the elements that you would like to appear in the table by selecting the desired number of columns and rows. Pressing enter inside of a table, it will increase the side of the cell all the way across the table. It will not just increase ...
In this video, Lance Sisiolo draws a beautiful house using Microsoft Paint. He uses line tool to draw most part of the house. He uses different types of lines. He also uses curve tool to draw sky and the entrance of the house. The unwanted part of the picture is erased using erase tool. Then he uses fill with color tool and airbrush tool to paint the picture. He uses different colors to increase the beauty of sky and the house. Then some trees are added. Using airbrush tool he increases the b...
By watching this lyndapodcast tutorial you learn how to use the quick file function in Microsoft OneNote 2010. This feature eliminates to regroup information, so you can send notes obtained from multiple sources to a selected page of a note book. This method called quick filing lets you send the information from the program that your using directly to One Note seamlessly.
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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LARGE and SMALL functions to retrieve the 1st, 2nd, and 3rd largest values from a list. You'll also see how to do each of the following:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 48th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the RATE, EFFECT, NOMINAL and NPER Excel functions to solve the following problems:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the INDEX & MATCH functions.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 50th installment in his "Excel Statistics" series of free video lessons, you'll learn the basics of probability:
This video shows you how to take apart a Microsoft Zune HD. To take it apart, you will need a tri-wing screwdriver. Using the screwdriver, remove the four screws at the corners. Once the screws are removed, you can easily remove the back cover. To remove the bottom cover, slide it off with your fingers. Next use a T5 screwdriver to remove the three screws, one on each side and one in the middle. There is one more tiny screw near the bottom that has to be removed. Using a prying tool to remove...
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.
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.
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.
Looking for a guide on how to tether your Android phone to your Windows PC, creating an ad-hoc Internet connection? This guide will teach you everything you'll need to know. It's easy! So easy, in fact, that this guide can present a thorough overview of the process in just over four minutes. For more information, including detailed, step-by-step instructions, watch this clip.
Want to know how to organize your desktop icons in Windows 7? This tutorial will show you how it's done! It's easy! So easy, in fact, that this home-computing how-to can present a complete overview of the process in just under a minute's time. For more information, including detailed, step-by-step instructions, watch this Win 7 user's guide.
Want to encrypt your thumb or flash drive? This Windows 7 tutorial will show you how it's done! It's easy! So easy, in fact, that this home-computing how-to can present a complete overview of the process in just under a minute's time. For more information, including detailed, step-by-step instructions, watch this Win 7 user's guide.
Want to search your entire hard drive rather than just a designated segment of it? This Windows 7 tutorial will show you how it's done! It's easy! So easy, in fact, that this home-computing how-to can present a complete overview of the process in just over a minute's time. For more information, including detailed, step-by-step instructions, watch this Win 7 user's guide.
Interested in burning an ISO disk file file to a CD, DVD or Blu-ray disc? This Windows 7 tutorial will show you how it's done! It's easy! So easy, in fact, that this home-computing how-to can present a complete overview of the process in just over a minute's time. For more information, including detailed, step-by-step instructions, watch this Win 7 user's guide.
Want to delete your data once and for all? This clip will show you how it's done. It's easy! So easy, in fact, that this home-computing how-to from the folks at Butterscotch can present a complete overview of the process in about three minutes' time. For details, and to get started erasing your own PC hard drive, take a look.
Windows Live Mail makes it easy to manage multiple email accounts. The accounts are laid out on the main screen and are easy to access, making Windows Live Mail a convenient email client. For more information, including detailed, step-by-step instructions, and to get started using multiple email accounts with Windows Live Mail yourself, watch this helpful video guide from the folks at Butterscotch.
Interested in centering icons within the MS Windows 7 taskbar without third-party software? It can be done! And quite easily. So easily, in fact, that this home computing how-to can present a complete, step-by-step overview of the process in about five minutes. For complete instructions, and to get started using this Win 7 trick yourself, take a look.
Did you know that you can use a USB flash drive to speed up a sluggish Windows XP computer? It's easy! So easy, in fact, that this free home computing how-to can present a complete (and somewhat talky) overview of the process in just over a minute's time. For specifics, and to get started speeding up your own Windows Vista computer, watch this PC user's guide.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to solve an equation for a variable in algebra.
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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel formulas.
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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
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 537th installment in their series of Excel magic tricks, you'll learn how to drill through a spreadsheet to speed up formatting, formula creation and editing.
Wish there were an easy way to give your digital photos the appearance of an old Polaroid picture? Well, there is. And 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, and to get started applying a Polaroid effect to your own digital photos, take a look.
When learning to use a computer, as with anything else, it's important to start with the fundamentals. This clip for new Windows users does just that. Fortunately, you'll find it's easy to browse files and folders. So easy, in fact, that this home-computing how-to can present a complete overview of the process in just over a four minutes and a half. For more information, including step-by-step instructions, take a look.
