Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 93rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to create a Gantt cell chart.
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 319th installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP in reverse order using the INDEX & MATCH functions and custom number formatting.
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. In this Excel tutorial from ExcelIsFun, the 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to prevent Excel from displaying a 13-digit number ID in scientific notation using the number formatting tool.
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. In this Excel tutorial from ExcelIsFun, the 537th installment in their series of Excel magic tricks, you'll learn how to drill through a spreadsheet to speed up formatting, formula creation and editing.
In order to be able to work with Canon DSLR footage (as from a 5D Mark II or 7D), you need to convert the h.264 into a more edit friendly format such as Apple ProRes 422. This tutorial shows you in detail how to ingest and convert this footage.
Watch this video to learn how to upload and play video on your LG enV3 phone. Now you can watch your favorite videos at the gym, on the bus, or share them with friends. You'll have to first compress your video to about 400MB, format it, and use a card reader to move the files from your computer to your phone, but once they're on there, you'll never have to part with them again. The quality ain't so bad either!
Here is a quick tutorial on how to install Perian video decoder on OSX. This is a plugin that you install through Mac OSX utility. This will expand the video codecs and formats you can play via QT Quicktime.
In this episode of Web Design TV Paul Wyatt tackles page layout in Dreamweaver. In this web development software tutorial we cover basic CSS layout, working with Divs to create a simple site template. This episode follows on from last week’s Dreamweaver primer on formatting text with CSS.
This video editing software tutorial shows you how to export an image sequence from Final Cut Pro. This isn't usually the format people export in, but if you are planning on using the frames for animating or further editing, you may want to export your work on a per frame basis. If this is the case, watch and learn how to export an image sequence from Final Cut Pro.
See how to use CSS and JavaScript to visually design style sheets for publishing XML and database data in Altova StyleVision, a visual style sheet designer for rendering XML and relational data in multiple formats. In this video, you'll learn more about how StylevVision interfaces with CSS and JavaScript.
Use this freeware program from Bill Myers to prevent bandwidth theft of your videos - any format and stored on any site - including Camtasia videos stored on Amazon S3.
SUPER Converter is a program for Windows XP that can convert a variety of audio and video formats. Here's how to download and install it.
Here's how to find and use Free Public Domain Movies and old TV commercials in your work. Also in this episode, a few inexpensive utilities that will convert video formats so they are ready for editing in your editing program of choice.
In this episode of Ask the Techoes, D.Lee and Brandon answer viewer questions on how to defrag a Mac hard drive, erasing an NTFS hard drive on Mac OS 10.4, how to uninstall programs and their related files on a Mac, questions with Parallels, and how to create a wireless USB hub. Send us your questions at askthetechies@gmail.com Hosts: D.Lee Beard & Brandon Jackson http://AskTheTechies.com
Wondering if you can change the format of the clock in Linux 11.04 Lubuntu? Well, you can! Check out this helpful video to learn how to change the way the clock looks in Lubuntu. Whether you are a Linux vet or a new user this video will help you get set on time.
Looking for the best way to find and download new music? Check out this video to learn how to use the Google search engine to download music. You'll learn what search operators will help you find the artists and songs you are looking for, in the file format you want.
Load JSON (JavaScript Object Notation) data from an existing database file into jQuery by following along with this informative and illustrative video tutorial from JREAMdesign. Here, a database query is used and the results are returned to jQuery via AJAX formatted in JSON.
Handbrake is a free application that will read DVDs and convert the video footage for usable formats that you can open on your Macintosh, your iPhone, your iPod or Apple TV. The imported video footage can also be edited in iMovie.
A stylesheet helps keep the design elements for your website consistent - such as making sure all your headings and links are formatted exactly the same way. This tutorial shows you how to set up an external stylesheet for your own HTML based website.
This tutorial shows you how to use some of the basic functions in Adobe Photoshop, including the ability to save an image in multiple file formats, to create a picture that you can easily use on your website or blog.
In this clip, we learn how to format ActionScript code using the Adobe Flash Professional Actions panel. Whether you're new to the Adobe's popular Flash authoring application or are a seasoned Flash developer merely looking to better acquaint yourself with Flash Professional CS5, you're sure to be well served by this video guide.
In this clip, you'll learn a trick for reading and writing NTFS data on an Apple computer running Mac OS X. With NTFS-3G, it's an easy process and this video presents a complete guide. For more information, including a full demonstration and detailed, step-by-step instructions, watch this helpful home-computing how-to.
Make your own small .gif animations on a Mac! This tutorial shows you how to use GifBuilder Carbon to take small movie clips and render them into your own .gif animations! This will work for any movie file except Windows Media Player formats.
If you only want to take a clip a few minutes long from a larger movie, or split a movie into smaller segments, you can use the freeware Virtual Dub video editing program to accomplish this task (just make sure the file you're working with is already in .avi format).
Handbrake is a free software program you can use to take video files off a DVD or CD and rip it into a format you can use to watch it on iTunes, your iPod.. or even watch them on your XBox 360! Make sure you're not trying this on an encrypted DVD, though.
A useful tutorial for those who like using the software program 3-D coat. If you have a Ptex file and want to keep your texture format, or use an existing UV map so you can work with your figure in Photoshop, this tutorial will demonstrate how you can 'bake' your texture.
When converting an Excel file to an Adobe PDF document, you might sometimes accidentally export several pages of empty space. This tutorial briefly explains how to use the Acrobat program to convert your spreadsheet or worksheet to PDF format and avoid the blank gaps.
In this clip, you'll learn some Final Cut Pro tips regarding multicam editing, HDV format, staying organized, and more. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the Final Cut Pro 7 workflow, you're sure to benefit from this free video tutorial. For specifics, watch this Final Cut Pro lesson.
In this tutorial on GIMP, the render-flame tool is looked over in detail. GIMP (the GNU Image Manipulation Program) is a free software raster graphics editor. It is primarily employed as an image re-touch and edit tool. It not only offers freeform drawing, but can also accomplish essential image workflow steps such as resizing, editing, & cropping photos, combining multiple images, & converting between different image formats.
Smooth shading and make all the difference in the quality of your graphics - this is especially true with the increasingly popular HD video and computer formats. If you would like to know how to use Maya to smooth and shade your objects, follow along with this video. You will get a step by step walkthrough.
This common problem that is easy to fix, but can be very difficult for some, involves saving a psd file as a jpg. In this tutorial, you'll find out how to do so, by using Adobe Photoshop. It's also a great way to save other files into different formats as well. So sit back and enjoy!
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 24th installment in his "Excel Business Math" series of free video lessons, you'll learn how to build a table of decimal, fraction and percent equivalents. See how fractional formatting can be misleading.
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 268th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply a conditional format that will highlight the maximum value in a row using a true/false formula.
Having trouble solving fraction word problems? Give this video tutorial from YouTube Excel guru, ExcelIsFun, your undivided attention. With it, you'll learn how to format fractions as decimals with up to 15 places, come to understand divisibility rules for numbers 1-9, and work with a number of real-world examples.
Nick from Greyscale Gorilla teaches you how to use audio files in After Effects. MP3 compression can cause problems so it's good to convert to a more edit-friendly format such as AIFF.
Paul from how-to-play-bass.com gives a great tutorial of a simplified bassline to "Moondance" by Van Morrison. Paul reduces the walking jazz bassline to an easier format for beginners.
This tutorial will show you how to determine the slope of a line if you are given two coordinates on a coordinate plane. You should first find the location of each point on the plane, remembering that the coordinates are in the format of x-axis (or horizontal movement), followed by y-axis (vertical movement). After plotting both these points, you should draw a straight line between these two points and then determine the slope of this line by taking the rise over the run of the line.
New user to Windows 7? Microsoft has put out a series of video tutorials explaining how to maximize your Windows 7 experience. Follow along with this computer lesson and learn how to:
The screenwriter Gene Fowler once said, “Writing is easy: All you do is sit staring at a blank sheet of paper until drops of blood form on your forehead.” Here’s how to make the process of writing your first screenplay a little less painful. You will need a formatting guide, a realistic set of expectations and source material. This video provides general knowledge on screenwriting.
