You can use the vlookup function in MS Excel to create a dynamic table in your document. Creating a new dynamic table and a new dynamic lookup area enaables you to add new data or new columns to the lookup table. You can also create dynamic named ranges by using offset, vlookup table and the match table. This function is very useful to businesses working on Excel. This video will show you to create a dynamic table for vlookup in Excel.
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...
Recuva is a freeware data recovery program. Recuva recovers files deleted from your Windows computer, Recycle Bin, digital camera card, or MP3 player. Begin by downloading and installing Recuva. Open up the program and select the type of file you wish to recover. Input the information that is asked and start the scan. It will the provide a list of the files. Simply select the file and click Recover. This video will benefit those viewers who lost or deleted old files and wish to recover them u...
mybigleftnut90 teaches you how to burn Wii backup games for Mac. After you get a backup game for the Wii, you need to make sure the DVD you'll be burning it too is DVD-R as these work best. Also make sure that the size of the backup game is not larger than the blank DVD you have. Right click on the image and click on "Open with-Disk utility." In the new program window, you click your image file name and click the button "Burn" at the top. Your speed should be 2x or 4x. Unclick verify burned d...
In this video the instructor shows how to use the drag-and-drop feature in Microsoft Word 2007. You can use drag-and-drop to copy and move information within the Word document. This is particularly useful when you want to move and copy information within one page. However, if you want to move information between different pages, use the normal copy-paste feature. If you want to move any information, first highlight and select the data. Now click and hold down the mouse button in the middle of...
EggBram walks you though changing background colors in Xara3D and shows where to find the transparency setting. This is a simple walk through in high detail, very visible. Xara has been a part of internet development from the very beginning. Xara one of the original Internet service providers when it came about in the 1990s. Xara does most of its work online and has millions of customers online around the world. Xara Online is a leading edge online web service that gives you solutions for a m...
Watch as iblogtutorials teaches you how to speed up your Windows XP and Vista shutdown times. To speed up your Windows shutdown time, do the following: Go to Start and select Run. Type in "regedit". Click the triangle next to "HKEY_LOCAL_MACHINE" and then click "SYSTEM" current control set. Click the Control folder. Wait to kill service timeout. Change the Value data to 0.2 seconds. Restart your computer and from now on your shutdown time will be much faster.
Steps to clear the cache on Firefox and delete unnecessary temporary files from your computer. In your Firefox browser go to TOOLS. Click on OPTIONS. Then go to PRIVACY tab. Click on PRIVATE DATA section and click on SETTINGS. Now you can clear the following items: browsing history, download history, saved form information, cache, cookies, saved passwords, authenticated sessions. Check what you'd like to remove, specially the cache option. Mow click on OK button. click on CLEAR NOW and click ...
A PDF Portfolio is a bundled collection of content compressed into one PDF file. Watch this 5 minute overview and learn how you can bundle documents, e-mail, drawings, flash presentations and even video into one sleek package that can be used for presentations or project management for your organization. Your portfolio can include introductory text and sets of data that can be sorted geographically by being linked to clickable maps. Not only can the entire portfolio be branded with your logo ...
In Access 2010 you can now create a navigation form (like a home page) for your database without writing a single piece of code or logic! Great for busy people who need to organize their database quickly, but who don't have code writing skills. It's just drag and drop. There are predefined layouts which help you design the form and then simply drag the information you want into the form. Reports can be added and accessed quickly from the navigation form so you can analyze the data simply and ...
In this video tutorial the instructor shows how to calculate the acceleration of a car on an inclined plane. He goes on to solve a problem he came across which is based on the acceleration of a car on an inclined plane. He shows how to solve this problem by showing how to extract the data from the question and draws a diagram to get a clear understanding of the problem. Now he marks the forces acting on the vehicle and goes on to specify his axes and how to split the components of force along...
iTunes offers the ability to extract and copy data with its rip and burn functions. Ripping lets you import songs into your iTunes library from a variety of sources. Burning lets you write audio files on to a CD. Once you customize the audio file playlist that you wish to have on CD, simply initiate the program's burn function, and you'll have a music CD in no time.
In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...
ClearTechInfo presents a how-to video on clearing Internet Explorer 8's browser history. Computer users are reminded that the only silly question is the question not asked. In the video, the viewer is shown that by clicking the button marked "Safety" in Internet Explorer 8 the "delete browser history" option is revealed. As long as each option is clicked, the history for the computer user is deleted. The browser history, cookies, cache, and passwords can all be deleted with the click of the b...
This academic tutoring video, made by BrainKindle, defines acceleration in simple to understand terms and shows how to measure acceleration. He shows how a plain cardboard box, pencil and string are used to make a simple pendulum, which moves as the car accelerates. Using data from the arc of the pendulum, he shows how to calculate acceleration. This is an easy method to use if you do not have an iPhone with an application to measure acceleration. A great trick for a budding scientist or phys...
Burn downloaded movies onto a DVD. Open your browser, go to the Google website and type axxo torrents in the search bar. Then select the homepage of axxo torrents, and download the favorite video in to your computer. Then open the DVD flick, you select burn a DVD. In that you select the files to be burned on to a DVD, and then click ok. Then the general settings appear on screen, about the name of video. Then also select how to burn and writing speed, and check the box of verify the data on w...
In this video tutorial the instructor shows how to submit your website to Google and its search engines. To do this first you need to have an account with Google. If you do not already have one go ahead and sign up for an account with Google. Now search Google for the webmaster tool. Then it opens the Google webmaster website which you can enter with your Google user name and password. Now inside there is an option to add a new website. You can type in the URL of the website and submit. Now G...
This video shows how to use a special tool to redact or remove sensitive information from Adobe Acrobat 9. This includes hidden metadata, file attachments, comments, hidden text and layer elements within a PDF file. You can also set it up when you're emailing. The Examine Document function highlights information that you may want to remove. You can then select the different types of data and choose which things you want to remove.
Excel Fun will show you how to get the most out of your Excel experience by learning about pivot tables. With Excel and the latest Excel 2010 you can learn how to create a pivot table. Learn where in the system to go to find the table. Learn how to add our numbers and create a calculation and watch it being solved. Your instructor will go through a detailed equation so that you can see how to do your own calculation.
This video shows how you can reformat your hard disk and reinstall Windows XP. WARNING: Do not attempt to do what is shown in this video unless you are comfortable with changing BIOS settings and installing Operating Systems. Also it is recommended that you have a backup of all the important data on your computer.
This is kind of scary! This video demonstrates just how easy it is to hack into an iPhone to access the data on it - including recovering deleted photos. You only think you've deleted those naughty photos you sent to your girlfriend.... Fortunately, there is a way... However, this particular process requires software available only to law enforcement. But that's never stopped a hacker - or a jilted ex - before!
You know how it goes - every year they've got new and better technology available and you're left wondering how you're going to afford it. You could always sell your current stuff, of course, but how do you sell your iPhone without selling all your friends' information? In this video you'll learn how to reset your iPhone to wipe its SIM card which will also delete your contacts from it. If you're feeling extra paranoid, you can even go ahead and remove the from the phone. Now all you have to ...
Twitter has consumed the world, so make sure you're up to date on your Tweets. One way to do that is with Gwibber 2.0 on Ubuntu Linux, the computer operating system that could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to retrieve unlimited tweets with Gwibber 2.0 on Ubuntu Linux.
Windows users probably remember the system resource tab in the task manager which showed you your resource usage. Well, in Windows 7, this feature has been revamped. This tool will give you real-time reports for CPU, disk, network, and memory usage.
Check out this video to learn how to get MMS on iPhone 3G for T-Mobile on 3.0 firmware. This works on T-Mobile's Network only!
This video tutorial shows how to get MMS on iPhone 3G for Tmobile on 3.0 or 3.0.1. Not that this works on T-Mobile's Network ONLY
Create a black brute with changing cloth on http://tobeburtan.mybrute.com. Before you start you will need to have 1: Monzilla firefox 2: Temper data.
MAKE brings the do-it-yourself mindset to all the technology in your life. Make Magazine celebrates your right to tweak, hack, and bend any technology to your own will.
Notorious hacker Chris Tarnovsky opens his underground laboratory to WIRED, providing a peek into the world of satellite television smart-card hacking. This complicated process involves nail polish, a pin head and various acids -- so don't try this at home (unless you're Chris Tarnovsky)! Chances are you won't even know what's going on here, but that's not going to stop you from watching this video tutorial on how to reverse-engineer a satellite TV smart card, is it?
PCs are quickly becoming the center of our digital universe. With PDAs, cell phones, portable media players and other electronic devices; keeping your content synchronized has been a challenge. With the new feature, Windows® Sync Center in Windows Vista™, you now have a single place to keep all of your devices and information up to date. For detailed instructions on using Sync Center for your own data syncing needs, watch this how-to.
This image editing software tutorial covers resampling an image down to an optimal print size in Photoshop CS3 so you can bring it to a lab for printing. It's nice to take pictures as large as possible, but it's not always so easy to get that data out of your computer and into print. If you don't have a nice photo printer at home and need to transfer your images, you may want to watch this video and learn how to resample them down to a good print size in Photoshop CS3.
This is a simple Adobe Flex Photo Viewer. It uses a number of techniques that are not found in any one place in the literature - data shorting, tile repeater, xml http services, inline mxml actionscripting, click on double functions, use of CDATA Tags, tooltip, glow and fade effects - all done in less than 100 lines of code (once you take out the blank lines). This was created by Mike Lively Director of Instructional Design at Northern Kentucky University for the Over The Rhine project.
If you want to submit information to a user, you build a website; if you want to receive information from that user, you use a web form. As such, it's crucial that your web forms be well designed. One easy way to design web forms is with CoffeeCup's Web Form Builder.
This experiment uses a ballistic pendulum to determine the launch velocity of a metal ball. This is compared to a measurement of the launch velocity found using projectile motion. You may wish to emphasize why energy is not conserved in the initial impact of the ball into the ballistic pendulum, but momentum is, and conversely why energy is conserved as the pendulum rises but momentum is not conserved.
This video tutorial will show you how to take an old computer keyboard and use its circuitry as a physical computing input device. Once you have this device, you can then use it to interface with programs that you write using software such as pure data processing, MAX/MSP, and Ableton Live to name a few. What you are doing is replacing the switches within your keyboards with others for input devices. Make sure the interface is plugged in when you are testing but it's probably a good idea to u...
This software tutorial shows you how to set up your FTP server using Dreamweaver. FTP servers are a great way to share and transfer data, especially when it is too large for email. So if you have a website, make it easy on yourself and set up an FTP server with Dreamweaver and this tutorial.
With PivotTable reports in Microsoft Office Excel 2007, your sales report will sparkle with power, flair, and functionality. Take a look at this instructional video to learn how to show the big picture, show all the details, or show anything in between. Easily create multiple worksheets to switch back and forth between the various versions of your report. Sort, filter, and summarize your data any way you like. Show the details of any summary value in your report.
Learn how to add color, shape, and emphasis to your text and data in Microsoft SmartArt graphics in this tutorial. See which one works best for getting your point across. An organization chart? A time line? A process with sequential tasks? Non-sequential items? Pick one, and optionally customize it with colors, animation, effects such as shadows, bevels, and glows, and more.
Check out this tutorial and learn how to create chars in Excel 2007. In Office Excel 2007, you just select data in your worksheet, choose a chart type that best suits your purpose, and click. Want to try a different chart type? Just click again and select a new chart type from a huge range of possibilities. Then work with the new Chart Tools to customize the design, layout, and formatting of your chart. You can see how various options would look just by pointing at them.
In this video tutorial, Chris Pels will show how to extend the standard set of ASP.NET configuration settings with your own XML configuration elements. First, see how to create a configuration section handler which is required to interpret and process the information in custom XML configuration elements. During this learn how to use declarative model for defining the behavior of a configuration section handler. Next, see how to add a custom section handler and custom elements to an ASP.NET co...
