Absolute and Relative

Use MS Excel cell references : relative & absolute

If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 8th in ...more

How To : Use macros in Microsoft Excel 2007

Looking for an introduction on how to work with macros in Microsoft Excel 2007? Learn how to create linkage formulas in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself ...more

How To : Fix other people's Microsoft Excel spreadsheets

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 26th installment in his "Highline Excel Cla ...more

How To : Use Excel mixed cell references in formulas

Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same ...more

How To : Record and use macros in Microsoft Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52nd installment in his "Highline Exce ...more

How To : Use the selective color dialogue in Photoshop

This is a tutorial that (tries to) demonstrate the power of the Selective Color dialogue in Photoshop. This video uses the dialogue on absolute instead of relative, but it works out anyway. For better results use relative. It also explains how Curves actually works, (especial ...more

How To : Use the Scale Node in the Blender 2.5 Compositor

In this tutorial, you'll see how to use the Scale Node in the Blender Compositor to manipulate an image. You'll see how to stretch it, spin/rotate, and have all sorts of fun with uniform linear distortion. The clip discusses the difference between resolution handling between t ...more

Next Page
Prev Page
  • Hot
  • Latest