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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.
If you still own and use an original XBox console, good for you! You've got a little piece of history right there that most people just tossed or sold to a game store for $10. This video will show you how to replace the paltry 8gb hard drive that the console came with with a big honking 120gb drive. This will allow you to store more data, and since hacking the original XBox is the best reason to keep it around at this point, you should probably make sure that you can do that.
If you are unfortunate enough to own one of the XBox 360's that shipped with a 20gb hard drive, then you've realized that that is way to little storage for everything that you want to have on your XBox. If you've decided to buy a larger drive from Microsoft, this video will show you how to transfer your precious saves and other files from the old hard drive to the new one using a transfer kit. Now you can buy as many downloadable games as you want or even install your disc games on the hard d...
When you need a website to showcase your product or service, it can be quite confusing. Follow these easy steps to gather everything you need to have a successful website. Start your search for a domain name in the domain name registrar. (Example: www.companyname.com) Rent space from a hosting company to hold the files for your website. Set up an email account for your company. Create the content for your website (example: products, prices, services, etc). Get internet security to protect sen...
This instructional video shows you how to make a RSS ("Really Simple Syndication") feed using the free program RSS builder. RSS is a script that can be put up on a website that other users can subscribe to in order to get notified when the website gets updated. The xml code behind creating RSS feeds is explained. The code should be entered as shown and the file should be saved as "feed.xml" and upload it to a web server. Go to the URL mentioned, download and install RSS builder. Launch the pr...
Check out this informative video tutorial from Apple on how to use iWork.com to share documents and spreadsheets.
Check out this informative video tutorial from Apple on how to work with sections in Pages '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to create a table of contents in Pages '09.
Check out this informative video tutorial from Apple on how to use outline mode in Pages '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to use full-screen view in Pages '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to add citations and equations in Pages '09.
Check out this informative video tutorial from Apple on how to track changes and add comments in Pages '09.
Check out this informative video tutorial from Apple on how to use Mail Merge with a Numbers document in Pages '09.
Check out this informative video tutorial from Apple on how to add images to documents in Pages '09.
Check out this informative video tutorial from Apple on how to create and edit charts in Pages '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to create and edit tables in Pages '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to work with Word users in Pages '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to get started using Pages '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to get started using Keynote '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to organize your slides in Keynote '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to add audio and video to presentations in Keynote '09.
Check out this informative video tutorial from Apple on how to create and edit shapes in Keynote '09.
Check out this informative video tutorial from Apple on how to create and edit charts in Keynote '09.
Check out this informative video tutorial from Apple on how to create and edit tables in Keynote '09.
Check out this informative video tutorial from Apple on how to remove backgrounds with Instant Alpha in Keynote '09.
Check out this informative video tutorial from Apple on how to add shadows and reflections in Keynote '09.
Check out this informative video tutorial from Apple on how to crop and compose images using the mask tool in Keynote '09.
Check out this informative video tutorial from Apple on how to add a transition between slides in Keynote '09.
Check out this informative video tutorial from Apple on how to animate objects between slides with Magic Move in Keynote '09.
Check out this informative video tutorial from Apple on how to use advanced builds to animate objects on and off slides in Keynote '09.
Check out this informative video tutorial from Apple on how to set up presenter notes in Keynote '09.
In this Software video tutorial you will learn how to install & use CDBurnerXP: Free CD/DVD burning software. It is compatible with Windows XP and Vista. Open up a browser and go to CDBurner. Click on downloads, download and install the file. Open it up and select your language. Then the main menu will pop up. Here you can choose exactly what you want to do. After you select your action, say Data disc, click OK. On the next screen you get to select the files. Just drag and drop them in to the...
In this, the latest family-friendly recipe from the Food Network's Neely's, you will make garlic grilled lamb chops. These chops are irresistible and you will put them together from scratch. You won't have any leftovers after serving this great Southern style recipe. Enjoy!
What could be more perfect for a summertime barbecue than an All-American flag cake? This sponge cake is easy to make and covered in berries to give it a fresh, warm-weather flavor. If you need a dessert for Memorial Day or the Fourth of July, this is the perfect one for you. Start from scratch with the Food Network's Ina Garten, aka the famous Barefoot Contessa, in this clip.
The beauty of the iPod Touch is that it is not only for music. With the iTouch, you can access the Internet as well. You can use this Internet capability to download from iTunes, get e-mail, surf the web and many more options. In this tutorial, learn exactly how to turn your iPod on to a WiFi network so that you can take advantage of all the features your new device has to offer.
Ready to do some deep south cookin'? In this video, learn how to make fried mac & cheese with owner of Lady and Sons and Food Network's resident top southern chef, Paula Deen! ...And this isn't just any mac & cheese! This is mac & cheese wrapped in bacon and fried for a delicious crunchy finger food!
In this tutorial, learn how to make delicious French profiteroles for dessert with Ina Garten of the Food Network's Barefoot Contessa.
Not 100% familiar with all the awesome features that make facebook a great storytelling medium? Check out this instructive how-to video from the cast.
Network sharing lets other iPhoto users view your photos and albums from their computers.
Need some help figuring out how to switch BlackBerry devices? This clip will teach you everything you'll need to know. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this official video guide from the folks at Blackberry. For detailed information, including step-by-step instructions, take a look.
