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're Apple computer needs a little cleaning, not the hardware, but the software, then MacKeeper is the way to go. This application will help protect your hard drive from junk and other useless data, freeing up much needed space on your Mac. Also, you can recover files, hide private files, clean up your login items, apps and plugins, and more! Watch this video to see how to use MacKeeper.
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...
At the moment, the iPad is officially locked to the AT&T network in the USA. If you would like to use your iPad but do not intend on leaving your current mobile carrier, check out this video.
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 92nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the TINV and TDIST functions to test a hypothesis.
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 85th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals for proportions using NORMSINV function and other formulas.
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...
This video will show you how to install custom firmware onto your PSP (Playstation Portable). Being able to install your own firmware will allow you to change the way your PSP operates. Follow these instructions, but be careful! It's always a good idea to back-up your PSP to prevent data loss.
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 video tutorial, users of the Ubuntu Linux operating system will learn how to use the Simple Backup application to either manually or automatically back important data. For more, or to get started using Simple Backup on your own Ubuntu Linux system, watch this handy how-to.
Outlook is one of those applications that has 100 ways to do the same task. Today I’m going to show you how to automatically extract data from an email and have it populate fields in various modules in outlook (Contacts, Tasks, Calendar)
Watch this software tutorial video to learn how to use HijackThis to find malware hiding in the alternate data stream. This how-to video will make finding hidden malware easy and help you protect your computer.
Look at this video tutorial to see how to remove viruses from your computer if you live in Charlotte, or anywhere else in the world. This will help you remove viruses from your computer yourself, without paying mega bucks to get it fixed. You'll see how to get a free virus scanner, for virus removal. This could take up to an hour or two, depending upon the data information on your PC.
