Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 391st installment in their series of digital spreadsheet magic tricks, you'll learn how to use custom number formatting to insert symbols automatically.
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 350th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting and the COUNTIF function to highlight values that are repeated a given number of times.
Your Epson driver controls your printer to your computer. You can change options to more suite your work. This video will demonstrate how to use the Epson priter driver.
Cassettes take up quite a bit of space, and can sometimes start showing wear, which can affect the sound. This video shows you how to take this information from your cassettes, and move them on to a CD. Detailed instructions, and photos in this video, will have you transferring analog information into a digital format within just minutes. This allows you to be able to use the audio recording on your computer, as well as being able to listen to it in a regular CD player.
Databases allow you to store data in a systematic and organized format, making it easy for you to search, sort and edit.
When you've finished editing your images, Aperture lets you export your photos in a number of formats.
Aperture's book feature enables you to make elegant customized photo books in a variety of formats.
Final Cut Express makes it easy to convert or capture your videotapes into digital video files. All you need to do is set the desired capture format and destination for your clips. The Final Cut Express menu also provides an Easy Setup function.
Use LiveType to create professional titles in your Final Cut Express project. Match the properties to those of your Final Cut Express project, add text, choose a font, and format your text using the inspector. The title shows up on the canvas and in the timeline. You can also add sophisticated backgrounds, effects, and animation.
Learn how to write your movie to tape or store it as a digital file using Apple's Final Cut Express in order to share it with others. Using this process, you can play your movie on a VCR, website, iTunes, iPod, DVD, or any other device or format.
This is one of my favorite projects, a wide format pinhole camera that uses 35mm film and is made from $10 in crafts store items.
Learn to restore four different types of files: deleted files, files from a damaged CD or DVD, files from a formatted hard drive, and files from unbootable hard drives.
This video demonstrates how to make your own icon and use it in Windows. To do this, just make the graphic in Paint, save it as the right format, and create a shortcut using the icon you made.
In this tutorial, we learn how to use the Verizon Wireless Razzle TXT8030 camera. This is 1.3 megapixels and has a self-portrait option on it as well. To access the camera, press the camera key on the side of the phone. Now, you will be able to view the gallery, take a picture, or see your options. The options will change the color effects, self timer, and other options for each of your pictures. Once you have chosen all of your options, face the camera at the subject, then press the middle "...
Bates numbering can be used with Adobe Acrobat 9 Pro. Place all of the documents that you want to number in a single file. Then, go to the Advanced menu. Then, go to Documents Numbering. Then, click on Add.
There's a new LCD viewfinder on the Canon EOS 7D, and in this video, you get to see all about it. See how you can change your viewfinder options on this digital SLR camera with ease. You can display almost any information you want.
In this clip, learn how to use the Swype Key while texting with Swype on your cell phone. The Swype key is where all of your options are like dictionaries, tips and tricks, help menus and everything else you may need.
In this Computers & Programming video tutorial you will learn how to format a FAT32 partition larger than 32GB. For this you will need a program called Maxtor Maxblast. Download and install it. First, you will have to remove the existing partitions. So make sure you back up everything. Click on computer > manage > disk management. Find your partitions and delete them. Open up maxblast program and it will tell you it found an empty hard drive. Click ‘next’ a few ties and then choose ‘FAT...
This video tutorial from ozz3141 presents how to copy your DVD library to a Mac computer. To start, insert DVD you want to copy. It will mount on Desktop and DVD player will open. Close DVD player. Click File-New Finder window. From left pane select applications. Scroll down and select FairMount. The DVD will remount now.
This video illustrates the method of Removing Ubuntu Linux installation and the GRUB Loader. The process is composed of the following steps -Step 1Insert the Ubuntu Linux Live CD. Boot from CD and select the install option.Step 2Click on install button and wait until the next screen appears. Now , you would be presented with two options that would enable to either "Uninstall Ubuntu" or "Install it again".Step 3Choose the Uninstall option and check the Remove GRUB loader option. Also check the...
In this how-to video, you will learn how to get 720p quality videos in Final Cut Pro HD. This is useful if you want to take advantage of the higher quality video settings found on YouTube. First, have your film ready. Go to Export and press QuickTime Conversion. Now, name the file. Next, click options and uncheck internet streaming. Go to sound settings and change the format to AAC with a quality of Best. Now, go to the video settings. Change the size to 1280 x 720 HD. Change the frame rate t...
You can manipulate the AF fine-tune on your Nikon DSLR in order to optimize the sharpness and resolution of your lenses. This is a great tool for achieving the highest picture quality possible.
To start with you have to write the author's name, with the last name entered first followed by first name and then the period. Title of the article should be in quotation marks. Do not use italic format. Title of the actual journal must be written. After this there is a series of numbers the volume number, issue, year, pages number separated by a colon. Don’t write 'p' for pages as the number itself is a standard for it. Write the period and also the dates.
Jim Reppond of Coldwell Banker Bain demonstrates the way of getting postlets into Facebook. He says that by adding the postlets in your Facebook page, one can click on the link and directly go the postlets page if they are interested. He asks you to then go to the postlets page and log in using your username and password. Once inside, you can click on the 'My Postlets' tab to see your active postlets. Then chose the postlet you want to add to Facebook and click on the respective 'HOST' button...
In this video the instructor shows how to upload High Definition HD videos using Camtasia Studio. Here the instructor shows how to upload the videos that you recorded using Camtasia in HD to YouTube. Now to generate a HD video you will need to record in high resolution like 1280 by 800 pixels. Now record the video at full screen. Now after recording you will have your HD video. Open the video in Camtasia and add the clip to the time line by right clicking it and selecting the option from it. ...
In this Excel magic trick video the instructor shows how to stop automatic copyright symbol ©. While using Microsoft Excel when you type the letter c in between a pair of curved braces Excel automatically turns it into the copy symbol © even if we did not intend to use it. Now to get rid of this feature go to the file menu and then to the options menu. In the options window that pops up go to the proofing sub menu and there is a button for auto correct options. Go into it and it shows the lis...
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to build a motorcycle camera mount for under five bucks.
Don't want to shell out the big bucks for some fancy, expensive budgeting software? Well, if you have Excel 2008 for Mac installed, you can manage your budget right there. Personal financing doesn't get easier than this— even business finances are easy to keep track of. The Microsoft Office for Mac team shows you just how to manage your finances with pre-formatted Ledger Sheets in this how-to video.
Are you kind of befuddled by the new Google image search layout, with its grid features and lack of context? Well, you can revert back to the old format if you don't like the change. In this video, Veronica shows you exactly how to get the old Google image search results you know and love.
This tutorial is for PC users who have both iTunes and an iPhone, and shows you how to get iTunes ringtones on your phone for free. All you really have to do is convert your chosen track to the right format, then clip and download onto your iPhone!
You've finished your masterpiece, and now it's time to share it with the rest of the world! This tutorial shows you how to render your file into YouTube-friendly format, and then upload it onto the web for sharing on YouTube (or any other video sharing site).
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 720th installment in their series of digital spreadsheet magic tricks, you'll learn how to use filtering, the AND, TODAY and EDATE functions, and conditional formatting to show values between two dates.
In this video tutorial, viewers learn how to disable the quick fill handle and drag and drop option in Microsoft Excel. This task is very easy, simple and fast to do. Begin by clicking on the Office button and click on Excel Options at the bottom. Then click on the Advanced tab and deselect "Enable fill handle and cell drag and drop" option under Editing Options. Finish by clicking on OK. This video will benefit those viewers who use Microsoft Excel for their work, and would like to learn how...
Learn how to use CSS (cascading style sheets) to style pages created in Adobe Dreamweaver CS5. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started applying CSS formatting to your own pages, watch this free video guide.
Learn how to modify your old databases for use in Microsoft Access 2007. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using old databases in Access 2007 yourself, watch this free video guide.
You can change how the date appears on your Android phone. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial will show you how to adjust calendar display settings on your Android device.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 93rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to create a Gantt cell chart.
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 319th installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP in reverse order using the INDEX & MATCH functions and custom number formatting.
