The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the 3 default sheets. This video puts the macro in a module. The procedure starts with typing sub and a name which can be easily recalled. The rules for naming the macro are also covered briefly. After the macro code is writ...
Learn how to make an e-mail server on your home computer to host your own web page and webmail service by following the steps outlined in this video tutorial. You will need a web server, an e-mail server, and a webmail interface. For the server, the most common program is WampServer, which you will need to download. Run through the installation process and grant the program access to your fire. Click on the new icon on your desktop and click Put Online and then Start All Services. This will g...
Learn how to make an animated GIF from a video clip using Adobe Photoshop CS4. You'll need to use an external editing program (like Sony Vegas) to create a small clip from your larger video beforehand. From Photoshop, go to "File" and select "Import" and then "Video Frames to Layers" from the pop-up menu and select your video clip. Choose "From Beginning to End" when prompted about range to import. The duration of the video clip will now be displayed in frames. By default, each frame is set t...
In this video the instructor shows how to change views in Microsoft word 2007 and navigate around the documents. In Microsoft word 2007 in the ribbon there is a view tab to the extreme right. Open the tab. Now in that bar the default layout selected is the Print Layout which is 'What you see is what you get' layout. Next to it the full screen reading option and clicking on it, the documents opens up as a two page book with all the other tool bars hidden. The next is web layout which is ideal ...
In this video tutorial, viewers learn how to make a batch render in Sony Vegas. Sony Vegas is a professional non-linear editing system. Viewers will learn how to use the batch render. At default, it is located on the toolbar. Begin by importing your clips or images into the time line. One of the batch render's features is to render regions. Begin putting regions around the clips by highlighting the clip, press R and press Enter. The add the Add Regions To Event script to automatically set reg...
Follow along as we are shown how to change the power settings for our monitor for Windows 7. -Begin by going to the Start menu and clicking on the Control Panel.
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...
Trevor4Ever595 teaches you how to hack the game Space Attack using Cheat Engine. You start the game, select a level and pause it using P. Open up Cheat Engine, open the process list, select Firefox or whatever internet browser you are using. Then you will want to use the search box to search for the amount of money you have in the game. A lot of values will come up to the left of the search box. Go back to the game, earn more money and then search for that new amount. Cheat Engine will only r...
In this video David Rivers shows that the conversation look of Excel 2010 has greatly improved. Tracking and managing related emails, saves your inbox space to enable you to manage large number of emails effectively. By default, the conversations are arranged by date. Email interactions will have an arrow displayed. You can easily expand and collapse the conversation. The major improvement is the function of ignoring or clearing up conversation with just a few clicks. The future conversations...
Many people speak from their chests by default. If you're serious about singing, however, you should make an effort to sing from your belly. Not only will you increase your volume, but your singing will take on a sweeter, more open tone.
This simple video tutorial teaches you how to change the pivot point position when using Flash. The tutorial handles drawing basic shapes, such as squares and rectangles and converting them to movie clips.
Bill Myers explains how to set your YouTube player to play high quality videos by default. Go to Account link (top right of page) after you login to your YouTube account,
Bejeweled Blitz is a Facebook game. Learn how to hack Bejeweled Blitz with tricks, cheats, hacks. Watch this video tutorial to learn how to cheat on facebook's Bejeweled Blitz (07/27/09).
This video tutorial will show you how to start animating using the basics in Adobe Flash CS4. This is basically just an introduction to Adobe Flash CS4. You will learn about the Welcome Screen, Defaults, Properties, Layouts, and Tools.
Go beyond the traditional 3D workflow to an immersive creative experience with the software Modo, created by Luxology. Modo is the next evolution of 3D modeling, painting and rendering for Mac and PC. Modo includes 3D sculpting tools, animation and network rendering, and advanced features such as n-gons and edge weighting.
Microsoft Windows Vista Tips - Finding Information with Instant Search in Microsoft Office Outlook 2007 - Somewhere in the hundreds, or perhaps thousands of messages in your Microsoft Office Outlook 2003 mailbox is the one that has the information you need about that client meeting on Thursday. So how do you find it without reading through every one of your messages? The new Instant Search feature in Microsoft Office Outlook 2007 allows you to find the information you need instantly. For more...
In this clip, you'll learn how to make use of the new Global Search app on the BlackBerry Torch 9800 smartphone. 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.
Google Instant has made searching on the main page of Google faster than ever before. Did you know that there are several keyboard shortcuts that you can use to make it work even faster? This video will show you how to use shortcuts to go to results more quickly and add more time to your day.
Looking for instructions on how to rebuild the MS Windows 7 Search Index? 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 three minutes. For more information, including step-by-step instructions, take a look.
In this quick iPhone 4 user's guide, you'll learn how to customize the Spotlight search application. Whether you're the proud owner of an Apple iPhone 4 or perhaps just considering picking one up, you're sure to benefit from this free video tutorial. For more information, including complete, step-by-step instructions, take a look.
Whether you're new to Adobe InDesign or a seasoned digital video professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to create a more engaging experience with web DVDs that include a search interface for viewers to jump directly to content of interest.
Learn how to submit your website to the Google search engine in simple steps. 1. First go the Google home page and type in the address bar '/addurl'. 2. Now type the URL of your website in the text box correctly and enter some details about your website in the Comments area. 3. Now type in the verification code to finish and add your website to Google. 4. You can even submit your website to many other search engines like Google.
Aperture's advanced filter and search tools make it easy to find an image or a group of images within a single project or album, a folder of albums, or across your entire library.
With iTunes, you can quickly find any song in your library and start listening to it in a matter of seconds using the search bar, alphabetization tools, and browse pane.
A quick tutorial on how to completely remove your Google search history from your computer.
How to avoid being tricked by police into consenting to a search. First rule, do not consent to any searches. From BUSTED: The Citizen's Guide to Surviving Police Encounters.
Unhappy with your rooted T-Mobile MyTouch 3G or HTC Magic Google Android smartphone? Put it back as it was by unrooting it! It's easier than you'd think. So easy, in fact, that this two-minute guide can present a complete overview of the entire process.
In this clip, you'll learn how to turn off dock reflections on an Apple computer running the Leopard operating system. With a little know-how, it's easy. So easy, in fact, that this video guide can offer a complete overview of the process in a matter of a few minutes. For more information, including a complete demonstration and detailed, step-by-step instructions, take a look.
In this video, we learn how to use the Wiiflow forwarder channel. First, go to the Wiiflow USB loader on your Wii. After this has loaded, click on the game that you want to use. Once you click this, go to the settings button and click through until you find the defaults for the game. You can use this Wiiflow forwarder channel to play a ton of different games in just seconds. You can view the games using different views, making it easier for you to see what games are available. When you are fi...
Everyone who owns or runs a website needs to know how they can improve traffic, and search engine optimization is the answer. This 13-part video series on SEO basics and strategies will give you more traffic for your site. It's jam-packed full of tons of great SEO tips! Check out each video in the series:
In this tutorial, Brian teaches us how to make your wireless network secure. First, go to the start menu, then go to run and type in "cmd", then type in "iconfig /all". Now a new window will pop up and you will look for the default gateway. Find the IP address to log onto the routers you have. Now, type in your IP address into your address bar on your internet browser. You will be asked to log into your account with your password and user name, which you can find at the manufacturers website....
In this Computers & Programming video tutorial you will learn how to easily open your NAT on a ZyXel router. There are three steps involved in doing this. Open your web browser and type in the router IP address which is normally http://192.168.1.1. Then you will get the log in page. The password is either 1234 or admin. It will be written on the packaging of the router. On the next page click on UPNP, then check all three boxes and click 'apply'. Then you click on NAT and set the start and en...
In this video tutorial, viewers learn how to restore the desktop icons in Windows XP. Begin by right-clicking on the desktop and select Properties. Then click on the Desktop tab and click on the Customize Desktop button. In the General tab, under Desktop Icons, users are able to check the 3 desktop icons to place onto the desktop. These 3 desktop icons are: My Documents, My Computer and My Network Places. Users are also able to change the icon or restore to default. When finished, click on OK...
In order to insert Word Art, into your document, using Microsoft Word 2007, you will need to begin by opening your document. Next, find "Insert", at the top of your screen. Click on it. This will take you to the Insert Tool Bar. Find Word Art. Choose the style that you would like to use, from any of the styles in the style gallery. When the window opens, you can choose your font style at the top, if you want to change from the default setting. You can also change the font size. Write the word...
In this video tutorial, viewers learn how to make a shiny glass ball in Adobe Photo-shop. Begin by creating a new document with the default size and a transparent background. Then paint the entire background in black. Now select the marquee tool and create a circle anywhere in the background. Now go to filter, click on Render and select Len Flare. Make the lens flare 105 mm prime with 141% brightness. Then go to Filter, click on Distort and select Spherize. Use normal mode and set the amount ...
If you have a tendency to play small games on your computer while listening to a lecture or playing an audiobook, those sounds from the game can be really intrusive to your learning anything. Well, on Windows 7, there's a way you can adjust the sound without messing with hard-to-find sound settings in each application. Windows 7 allows you to adjust the sound of multiple programs at the same time, as well as devices and system sounds. Learn how to change the default startup volume for these a...
Check out this tutorial and make Windows 7 you're own by customizing the log in screen. This is fun to do and will, no doubt, make you feel more connected to your PC.
For some users, a search bar can be a really annoying thing. With Internet Explorer 7 and on, most people are interested in getting rid of the search bar. So in this tutorial, find out how to remove the search bar in Internet Explorer 8 using some simple steps. Enjoy and good luck.
Oh no! Has something happened to your iPod Nano and you can't seem to fix it? If this is the case, you may need to perform a total restore of your device. Restoring your iPod is a last resort and by doing so you will wipe the memory of your MP3 player and bring all of its settings down to default.
In this tutorial, we learn how to change an IP address in Windows Vista. First, open up cmd on your desktop and a new window will pop up. When the black window comes up, type in "ipconfig". You will now see your IP address, leave this window open and open up the control panel. Once in the control panel, click "view network status and tasks", then click on "view status". After this, click "properties" then click "internet protocal version 4" and click on "properties" again. Now, type your IP a...