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 stringing text and data together by using an ampersand (&) concatenation. To learn more, watch this MS Office how-to.
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 conditional formatting in Excel to change background color. To get started learning about conditional formatting, watch this MS Office how-to.
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 in one worksheet to look up values located in a second worksheet. For more on using VLOOKUP across Excel worksheets, watch this MS Office how-to.
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.
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 nested IF functions to calculate a grade from an average mark. For more information on using conditional statements, watch this MS Excel how-to.
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 '$' to prevent excel from changing formulae when copying or filling ranges. For more on absolute cell referencing, watch this Microsoft Excel how-to.
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 Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, watch this how-to.
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 simple addition, subtraction, multiplication and division in Excel. For more on using simple formulae, watch this video how-to.
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 Excel tutorial, you'll learn about simple formatting, background colour, gridlines, alignment. For more information on formatting spreadsheets within MS Excel, watch this helpful how-to.
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. This Microsoft Office video tutorial presents an extremely introduction to Excel. In it, you'll learn about names of bits and really simple formatting. To get started using Excel for yourself, take a look.
OnTime is such a flexible tool and it can be used in a variety of ways, with completely different methodologies. One of the methodologies that works well with OnTime is Scrum. This week we walk through a quick demonstration of setting up a new OnTime database for use with a Scrum methodology.
Remote Server is a very handy tool for users wishing to utilize OnTime Windows and OnTime VS.Net without having direct access to SQL Server. This installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite covers Remote Server in detail and how to set it up. Take a look.
Did you know that OnTime includes tools to help you backup and restore your OnTime database? This installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite covers the basics of restoring and backing up a database through the OnTime system. Take a look.
Interested in cutting masonry like concrete flags and bricks? This construction lesson will show you how, using a bolster chisel and club hammer. For detailed, step-by-step instructions on cutting your own masonry quickly and effectively using simple hand tools, watch this how-to.
Got a hole in your polygon object that the fill hole tool just can't fix? Check out this Maya video to learn how to quickly seal that object up. Learn how to not-so-magically fill polygonal holes in Maya.
This 3D modeling software tutorial shows you how to work with the Projection Master tools in Zbrush. You will learn how to work with proper UV textures and UV mapping as well as how to properly project textures on a model using projection master. This will give your Zbrush model fairly crisp and accurate textures without blurred edges, as you may get from other projection mapping methods.
ZAppLink 3 is a ZBrush plugin that allows you to seamlessly integrate your favorite image editing software into your ZBrush 3.1 workflow. In this tutorial you will learn how to open Photoshop while in ZBrush, use it to modify the active ZBrush document or tool, and then go straight back into ZBrush. See how to use Zapplink to seamlessly integrate your Zbrush workflow.
When building a reborn doll, you have an array of options for how to put the baby together. This how-to video demonstrates the process of putting eyes into a reborn baby doll. You will need the reborn baby doll head, a setting tool, and the eyes that are being installed. Watch this video doll-making tutorial and learn how to set eyes into a reborn baby.
This audio editing software tutorial will show you how to export and import OMF and AAF files with Logic Pro. Connor Smith also shows you how to export all tracks as audio files (for importing into DAWs like Pro Tools) from Logic Pro.
In this software tutorial you will learn how to manipulate images in Photoshop to remove the background and then bring that transparent background image into After Effects without loosing the transparency. The Photoshop section covers the use of the Magnetic Lasso tool and Quick Mask to remove a background. With the image adjusted, you will learn how to import your new image into After Effects with preserved transparency.
This Photoshop CS3 tutorial shows you how to create a wedding photography advertisement for a magazine. Using album design techniques in Photoshop, we create a collage-style ad for a bridal magazine. This tutorial is geared towards people who already use Photoshop and have a basic knowledge of the tools and interface.
This software tutorial is to show beginning Bridge CS3 users more tools to use to organize and manage files. Learn how to organize and filter the content panel in Bridge with keywords, ratings and labels.
This image editing software tutorial shows you how to use the image processor tool in Photoshop CS3 to convert your corrected RAW files to a format more suited for printing or retouching; jpeg and Tiff. The image processor is can be used in the Bridge as well as in Photoshop and allows you to convert multiple files at once. See how in this Photoshop CS3 tutorial.
This Photoshop tutorial explaine the simple use of Match Color Adjustment in any version of Photoshop. Before starting this tutorial please create a .PSD file and add at least a dozen or more high res, high quality, vivid color photos and place each photo into it's own layer inside the .PSD file. Once you have your Photoshop file ready, follow along with this tutorial and learn how to use the Match Color adjustment tool in Photoshop on color photos and black and white photos.
Using GPU processing, Photoshop CS4 does things like never before. Colin Smith shows you the new viewing options available in Photoshop CS4. Smoothly zoom, pan and move around your image with complete freedom. Discover how to use the Flick-Pan and pixel grid tools in Photoshop CS4 as well. If you think you know all there is to know about zoom and pan in Photoshop CS4, think again and watch this tutorial.
Check out this guitar tutorial on how to plug a screw hole in an electric guitar or guitar neck. Grab the necessary tools and follow the simple step by step instructions outlined in this instructional video. Plug a screw hole in an electric guitar with this how to video and customoize your personal guitar!
This 3D software tutorial was developed by Discreet (creators of 3ds Max) to show you how to use the shell modifier new to version 6 and up of 3D Studio Max. If you are a 3ds Max modeler, you should learn how to use this powerful tool. Great 3ds Max tutorial for anyone new to modeling in 3ds Max or needing to know how to use the shell modifier.
These big inflatable balls aren't gumballs on steroids—they're actually some of the most useful tools ever devised for building core strength and flexibility. You'll need to choose the right ball size for your height, and pick out the right exercises. Watch this video fitness tutorial and learn how to use an exercise ball.
Want to learn how to make offset bends? This video tutorial will walk you, step by step, through the process of making an offset conduit bend. For more, or to get started making your own offset bends with an EMT, or thin-wall, conduit bending tool, take a look.
Looking for an easy way to implement Ajax into your ASP.NET projects? This ASP.NET video tutorial takes a look at the Infragistics UltraWebGrid, which will allow you Ajax data access without writing any code. For more information on this handy UI tool, as well as to get started using UltraWebGrid for yourself, take a look.
This how-to video is an intro to Adope Photoshop. Get ready for an incredible 3D experience, as you view this quick-look at some of the new 3D features in Adobe Photoshop CS4 Extended. This video tutorial will take you through some of Russell Brown's favorite new tools for working, and experimenting, with 3D objects in Photoshop CS4 Extended.
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.
This is a video tutorial on how to make a box with a scalloped lid. You will need a large piece of cardstock to craft this box. Use double stick tape to hold the joints of the box together. You might need a stenciling tool to make accurate cuts. You can use store bought or use recycled scraps of paper ad ribbon to decorate the outside of the box.
Discover how easy it is to update your faucet fixture. Other topics covered in this video include faucet options (centerset versus widespread),finish options,tools you will need to complete the job, and tips to ensure your DIY installation is a breeze.
This photography video shows how to make a rewind helper out of an 35mm film canister. If you use a simple film camera with a small rewind crank, you can use this tool to make a more comfortable grip. Use a 5/32 inch drill bit to make a small hole in a film canister. This can easily slip over the small film crank for quicker film winding.
This photography tutorial shows you how to make a better shutter release lock for Diana Plus and vintage Diana cameras. This is helpful for low light situations and long exposures. You can make a replacement shutter release lock with a clothes pin and a file. Have fun taking night photographs with this handy tool.
The doors and windows in your home need to be properly sealed to ensure your home is not wasting energy and, in turn, money. Learn how to choose the right caulk and tools for the job.
Let the Home Depot show you what it takes to install an exterior entry door and the tools and supplies you'll need for this popular do-it-yourself project. Go step-by-step through the process and pick up a few tips along the way for extending the life of your new exterior door. For more, or to get staretd on your own exterior installation process, watch this video DIY guide.
Announce your arrival home in style by stepping in via a brand new door. Whether you're tired of your old one or it "fell" off during a particularly heated argument, installing a new door helps to instantly update a room.
Let The Home Depot show you what it takes to install a replacement window and the tools needed for this quick and easy job. Since replacement windows fit into existing window frames, it should take you less than an hour to complete this simple DIY project. For more, or to get started on your own window replacement project, watch this video tutorial.
