Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using VLOOKUP to look up values located in a table. To learn more about VLOOKUP, watch this MS Office Excel how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using calculated field to work out the tax payable on an item, then adjusting item value. For more, and to get started using calculated queries yourself, watch this MS Access how-to.
This web building software tutorial shows you how to use XSitePro to change an existing XSitePro website template with a new XSitePro template. Don't worry if clients, or you, change your mind about what you want your XSitePro website to look like. This tutorial will show you how easy it is to change from one template to another for an existing website in XSitePro.
With Adobe Acrobat 9, creative professionals can take InDesign, Illustrator, Flash, Photoshop iles and more and convert them to PDF or a unified PDF portfolio making it easier to share files with clients and others. This tutorial shows you how you can use Acrobat 9 Pro easily with Adobe CS4 documents and convert them to PDF's or create portfolios. Learn how to review files, brand PDFs, add multimedia, and use print production tools in Acrobat 9 Pro.
Medicine balls have been used for strength training for thousands of years. Athletes in many sports can attest to their value. Learn how to use a medicine ball in this exercise tutorial. When exercising with a medicine ball you should intensify with faster reps, choose a safe weight, work upper body, and attempt 30-second intervals.
This 3D modeling software video covers multiple tools that will help you be more accurate and precise when building in SketchUp. SketchUp has many tools that make it easy to be creative when designing buildings or models, but it's just as important that they be accurate. Learn how to use numeric values and SketchUp tools to add accuracy and realism to your work.
In this video editing software tutorial you will learn how to create a television simulation effect in Sony Vegas 7. All you need to do is add the Sony TV Simulator Media FX tool, input the right values and you'll have a cool TV simulation effect on your video footage in Sony Vegas 7.
Whether you're a first day beginner or have been playing the drums for several years, learning the fundamentals of technique, rudiments and music reading is very important. In this installment from his video tutorial series on the fundamentals of snare drumming, Mark Wessels will teach you a new note value, the dotted quarter note.
This video is an instructional tutorial on how to make thermal curtains. Thermal curtains are a low cost method of reducing your heating bill by increasing the R value of your windows with an aesthetic, insulative curtain. Watch and learn how easy it is to keep the cold out and the warmth in with homemade thermal curtains.
You don't have to check the settings for every control individually — you can use the Logic Inspector to see a form's business logic displayed in a single window, grouped by features such as data validation, calculated data values, rules, and programming. Take a look at this instructional video and learn how to view the logic in a form template with Microsoft InfoPath.
This how to video guides you through making an easy, delicious and elegant spinach quiche. You can serve this eggy dish for breakfast lunch or dinner. Dress up or dress down quiche with your favorite ingredients. However this delicious quiche has frozen spinach to add nutritional value.
Take a look at this instructional video and learn how to control the Mac with either your iPod Touch or the iPhone. This is done by setting up VNC client on your iPhone/iPod touch and your Macbook.
Add value to the shoulder tender by cutting it properly. This how to video demonstrates the proper way to clean and cut a beef shoulder tender. Learn to cut a shoulder tender to get beef medallions or a small roast.
If you still happen to have one of those old Apple iPod Classics, then it apparently has some sentimental value, otherwise you would have upgraded by now. But since you still have it, that probably means there's a few things broken on it, like the screen.
In this video tutorial, Chris Pels will show how to persist and restore information in the ViewState of a custom user control. First, learn how to persist simple values containing .NET primitive types such as String, Int32, Boolean, etc. Then see how to persist complex types such as Class which contain properties storing information. The sequence of processing View State information during the lifecycle of an ASP.NET page is also discussed.
Learn how to draw and paint snowy, rocky mountains for manga, anime, comics and illustration in Photoshop. This step by step video shows you how to do so by laying down the base color, blocking in shape for painting, assigning value and color composition, and refining detail for the final concept painting.
Make copy-and-paste chores a snap with this quick Firefox tweak from Tekzilla. Just type about:config into the address bar, find "middlemouse.paste," the double-click on the value to change it from false to true. That's it. Anything you cut in Firefox you can paste back into Firefox by clicking on the scroll wheel in-between the buttons on your mouse.
This video shows you how to use the Free Internet Chess server and the BabasChess client for it. This video covers some basics, and hopefully some of you who haven't tried FICS will find it beneficial.
Today's word is "amicable". This is an adjective which means friendly or peaceful.
A basic instruction for electronic enthusiasts. I use an RGB LED and a 510 ohm resistor as I may change from 6 to 9 volts later, but with my LEDs i could go as low as 330 ohms. I sacrifice some brightness for the sake of longer life. To choose your resistor, the value in ohms = voltage of your batteries or power supply / (as in divided by) the amperage that your LED needs to run.
Use the Filezilla FTP client to publish files to your web server.
One of the uses of an ISA Server is to act as a proxy server. A proxy server allows your Windows XP and other desktop computers to make requests to the ISA Server and the ISA Server will then go and fetch the results from the internet or, if the ISA Server has cached the page(s), it can serve the pages from cache thus speeding up client browsing.
Bridging movements are some of my favorite Swiss ball exercises. They generally offer a wide progression difficulty. I've used the bent knee bridge with de-conditioned clients in their seventies and challenged young athletes with the advanced variations.
Planning on starting a Taco Tuesday tradition with your family? Then don't try to weasle your way out of keeping the meal healthy by purchasing premade taco shells. Usually these taco shells are made from refined, overprocessed flour that has very little nutritional value.
This knot is handy is you are saving on gear. Quite often I will choose to tye in over clipping in with biners. I often tyed clients in because I did not want them unclipping and running away without paying their bill.
A video on the basics of bittorrent technology and how to get started downloading a Bittrorrent client and torrent files.
This video explains how to make your bittorent client download faster. To increase torrent downloads increase your upload capacity to max, enable port forwarding if you have a router hub or firewall that blocks ports, and download torrents with a lot of seeds.
It might take Einstein to help explain the complex physics of bending light, but when it comes to bending pixels, it is an art commonly referred to in Photoshop as displacement. Displacement can let you use the lumonosity values of one image to bend the pixels of another; a "relativity" of sorts. Bert explains how this all works in this episode.
If you're going to make a really fast TAS keeping your character moving as fast as possible is crucial. This video features two Super Mario World TAS tips: how to use ZNES9 to set Mario's running speed as a high constant, and how to do walljumps impossible in the standard game.
The cold time of Christmas is upon us, and Icy Town is a winter-ific game you can play… and hack. With Cheat Engine and a little patience, you can hack and unlock floors in the game easily.
It's Christmastime, so what better of a game to play than the winterized Icy Tower? And what better game to hack with Cheat Engine?
Use this rigged game to cheat your friends twice in a row! The game functions just like 31, only this time you'll always win if you follow the instructions in this video.
For SQL injection, the next step after performing reconnaissance and gathering information about a database is launching an attack. But something seems off .. in the real world, it's usually not quite as simple as passing in a few fragments of SQL code to an input field and seeing all that glorious data displayed right in the browser. This is when more advanced techniques are needed.
Welcome back Java programmers! In this tutorial we'll being going over Variables/DataTypes and Type-casting
Hello again, reader! In this post, we are going to cover some data types and how to declare variables. It shouldn't be too hard so just sit back, relax, grab some popcorn and enjoy the ride (while you still can!).
You need a good microphone on your computer in order to make audio recordings, voice chat, or use speech recognition. However, not every computer comes with a built-in mic, and not every built-in mic works great.
As you already know, Hong Hong has been rocked in recent weeks by protests against their Beijing overlords. Promised free and fair elections, Beijing has reneged on this promise and is now telling Hong Kongians (that's what they're called, aren't they?) that they will only be able to vote on Beijing-selected candidates. All that is interesting from a political perspective, but from a technological perspective, the more intriguing story is how the protesters are communicating. Faced with their...
Video chatting over the Internet is an inexpensive way to keep in touch with your family and friends. This video will show you how to set up web video chat.
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
In this article, I'll be explaining the basics of how microcontrollers work, physically and virtually. First off, microcontrollers are no simple thing, so don't be discouraged if you find it mind-boggling! The world of microcontrollers is fascinating, engaging, and an awesome hobby; it never gets boring. I'll be focusing more on I/O and analog based microcontrollers, such as those running Arduino, and using Atmel chips as examples (these are most commonly available, and easy to program).
