In this how to video, you will learn how to create a diagonal sum in Microsoft Excel 2007. First, open the program and make a large selection. Type in =int(rand()*500) and then press control enter. This will create random numbers for the cells in the selection. From here, click conditional formatting and select new rule. From here, type in =column(A1)-row(A1)=$H$1. For the format, choose a contrasting look, such as a purple background and bold numbers. Click okay. If you type -1 or -2 in this...
This video shows the method to turn off pop-up blocker in Internet Explorer and Firefox. Firstly, open Internet Explorer and go to 'Tools' option. Go to 'Internet Options' and click on the 'Privacy' tab. You will see an option of 'Block pop-ups' at the bottom of the window. You must uncheck it and hit 'Apply' to turn it off. For Firefox, go to 'Tools' and 'Options'. You will see 'Block pop-up windows' as the first option. Uncheck it and the pop-ups will not be blocked. You can also set except...
In this video tutorial, viewers learn how to burn ISO-format disc images to a DVD from Windows. Users will need to download the program, DVD Decrypter. Download it from this link: DVD Exact Copy/] and double-click the file to install it. Users will also need a blank DVD disc. Open the program, go to ISO and select Write. Now click on the folder icon to locate your ISO file. Now click on the disc image and wait for the decryption to finish. This video will benefit those viewers who have downlo...
Torrents are a wonderful technology to share your files over the internet. If the data that you are sharing is confidential you may need to encrypt these files before sharing. To encrypt torrents in Azereus, go to tools and select options. From the left hand side menu select the connection option. Select the 'Transport Encryption' option from the connection sub menu. This section is intended for intermediate mode or higher and it is not available in beginner mode. So go to mode and select the...
Get your mouse to right click on a Macbook Pro Setting up your mouse:
Video is demonstrating a tutorial on how to tweak the settings in CamStudio. After downloading CamStudio there are a few things to be done. First Region option in the menu selected and in that full screen is selected. Then in the Options, Video Options is selected. In that both the frame rates are auto adjusted exactly to 30 frames per second. Now from the Options menu, Record audio from the microphone is selected. Now go to the Program Options, in that select minimize program on start record...
This video explains how to bold, italicize, underline or center text in a MySpace bulletin to those of us who are used to simply pressing a button in Microsoft Word. The instructor explained and demonstrated how to post in each of these styles in a clear and concise manner. In order to include one of these styles in your post, you must bookend the text your want formatted with codes to start and end the formatting. For example, to bold the phrase "I'm done!" you would enter the following text...
In this video tutorial, viewers learn how to unzip and zip files. The ZIP file format is a data compression and archive format. To unzip a file, right click on the file and select "Extract All". Continue by pressing "Next" and wait for the file to extract. To zip a file, right click on the file, select "Send To" and click on "Compressed (zipped)" folder. This video contains voice narration and a visual demonstration for viewers to easily understand and follow along. This video will benefit th...
This video will show you how to use video and audio to hide your identity. After you have your audio and video you will need a converter program, for example Format Factory which will convert the audio and video into the necessary formats. You will be encoding your clip as an AVI Video, as well as MP3. To start you will need to change the pitch of the audio track. A good program to use for this is Audacity. Play around by making the pitch either higher or lower. Save it as a Wav file To edit ...
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.
This tutorial will show you how to set up your college essay using MLA style formatting in Microsoft Word. Follow these steps to set up MLA style formatting: Open a new document and change your margins to 1". Set your font to 12 point Times New Roman. Set the header by typing your name, your professor's name and your class and section. Add the date from the Insert Menu. Set your spacing to double. Enter your title in the center of the page. New paragraphs are indicated by indents, and not spa...
The key to repairing bad credit is to write a properly formatted letter of dispute to one or all of the credit bureaus and send them out via registered mail. Here's a step-by-step guide to writing a letter of dispute to get rid of those black marks off your credit report for good. Remember, it's your right to file a dispute.
Just happen to have some video footage in AVCHD format? That would be "Advanced Video Coding High Definition"—you know—HD video files. If you've got some of those MTS files (like from a Canon HG10 camcorder) you want to open in a program that doesn't support them, like QuickTime or Premiere Pro, then you're going to have to convert them to a different format. Here's a way to convert them without losing the quality. You'll be converting the MTS files into HD WMVs at 4,000 kbps with a program c...
When you upload your videos onto YouTube, you will need to have your video in wide screen format, if you want to avoid having black bars on either side of your video. In order to do that, with Sony Movie Studio, you will need to go to "project". Click on "properties".
Plagiarism is a serious offense, even if you are copying from the web. With this tutorial, learn how to cite websites properly using MLA format and avoid any trouble.
In this video the instructor shows how to user printer options in Microsoft Word 2007. To do this go to the Microsoft button and click it. Form the drop down menu select the print option. Now you are presented with the three options of Print, Quick Print and Print Preview. Print is used to directly send documents to the printer by selecting the necessary settings. Quick Print is used to quickly send the documents to the printer using the default settings. Print preview is a useful way of seei...
Tutvid shows you how to add flare and dramatic color to your raw camera images (usually the format of a DSLR). In a step-by-step guide with narration, Tutvid takes you through the process of using CameraRaw (used as an extension of Photoshop but never really brings it in photoshop) to add desired colors to your picture. Pull up your raw file in CameraRaw, and press "Command" or "Ctrl + R" to open up the editing panel. With an example, he shows you how to bring out lights in underexposed (dark...
Clearinfo.com helps us how to change the keyboard and mouse settings in windows operating system. The video actually shows us the tutorial in windows vista but this can be applied also in windows xp. First go to Start button then click on control panel and on the Control panel Home view, select Hardware and Sound where you will get the mouse and keyboard setting options. Under the Classic view there will be keyboard and mouse option. Under the Keyboard options, it will show various settings a...
Record desktops with RecordItNow! on Ubuntu Linux Ever wanted to record your desktop screen? Well, it's entirely possible on Ubuntu Linux. This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to record desktops with RecordItNow! on Ubuntu Linux.
Pull off this easy prank, and – without causing any permanent damage – watch your coworker squirm with frustration.
Apple added the option to install custom fonts and use them in different apps on iOS 13. The rollout has been a bit confusing, with Apple announcing partnerships with vendors such as Adobe, but also limiting the feature to work with only certain apps. Nonetheless, you can now download and install custom fonts on your iPhone.
Ever since iOS 7, you could ask Safari on iPhone to show you the desktop version of a website, and in iOS 9, it became even easier to do. However, it's always been a hidden feature, something you wouldn't know is there without reading articles or tips online telling you what to do. Apple's iOS 13 update shines a light on it so everyone will know it's there, ready to use.
As expected, Apple revealed today at the WWDC keynote that ARKit 2.0 will support multiplayer gaming support and persistent content, which will arrive this fall with iOS 12.
With iOS 11, Apple's very own Notes app will now come standard with a number of new features that aim to make it significantly more user-friendly and help it compete against more popular notepads like OneNote and Evernote.
Up until now, if you wanted to record videos of the apps on your screen, you had to rely on a third-party option. However, Windows 10 changes this thanks in part to the new Xbox app. One of the new features of the Xbox app is the Game bar, which allows you to record footage of your gameplay.
Editing a video by trimming or adding audio is fairly simple on Galaxy devices, but if you want to include other clips or transition animations and really get those creative juices flowing, you might find the standard editing tools limited—unless you know how to unlock Samsung's hidden video editor.
The buttons on most Android devices are laid out (from left to right) in a Back, Home, Recent Apps format. Samsung is the lone exception to this rule, which flip-flops them, so this can make for an inconsistent experience if you own multiple Android devices.
If you utilize strong passwords—which you absolutely should be—you've probably had to go back and forth between keyboard screens multiple times to input various letters, numbers, and symbols.
How do you begin to explain the nostalgia that's felt when you play a game from your childhood? You can't. The only thing that will alleviate this feeling is experiencing it again.
Want to make sure your collection of home videos is preserved? Or convert that movie collection you spent the 80s building into something more lasting? There are several ways to get content from a VHS cassette onto a DVD, including getting a VHS/DVD recorder.
Turn your iPad into a portable reader. While epub files are easy to read, .pdfs are far more common formats for files. To get the most out of your device, you'll want to set it up to turn it into a .pdf reader. This tutorial shows you how
Purchased an app for your iPhone that was actually designed for an iPad? Apple provides for purchasers to get a refund for apps you don't want or you bought in the wrong format. Make sure not to abuse this feature!
In this clip, you'll learn how to prepare and format a USB thumb drive for use with an Apple iPad. Whether you're the proud owner of an Apple iPad or perhaps just considering picking one up, you're sure to benefit from this free video tutorial. For more information, including a detailed overview, watch this iPad user's guide.
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 685th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MOD and ROW functions for applying formating to every other row in your chart.
You want the best quality photos you can get, and the Canon EOS 7D digital SLR camera makes perfecting your pictures easy. There is a range of technologies to enhance image quality. This video shows you the many options you can use.
One of the advantages of using the Adobe family of creative products is that its many programs can be combined easily to create cool digital multimedia projects. This video tutorial teaches you how to integrate .swf files from Flash into .pdf files in Adobe Acrobat Pro 9. Including Flash in pdf files makes it easier for people who don't have the appropriate Flash players on their desktop to view the great images that you've made in Flash.
For those of you who have grown tired of the Playstation 3's user interface and are proficient with Linux, this video is a must-see. It demonstrates how to install Linux on your PS3 operating system without reformatting its hard drive or needing to pay for the USB keyboard for you PS3. Download the necessary file here.
Working with both Macs and PCs covers all bases, but it also adds new problems. If you fall into this category, you probably work with file formats that are not incompatible with the other computers. One of these file types in XML files. This tutorial will show you how to open XML on your Mac.
If you're one of the many people who work with Macs and PCs, the odds are you work with file formats that are more often than not incompatible with the other computers. This can be a major problem if you run into it with your Word documents. This tutorial will show you how to open Word docs on either computer.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 4nd installment of his "YouTubers Love Excel 2007" or YTLE2k7 series of free video MS Excel lessons, you'll learn how to use conditional formatting to add red to negative numbers and green to positive numbers using a single True/False formula!
