Personal References Search Results

How To: Prepare images for reference planes with Photoshop

This video tutorial takes front and side reference images in Adobe Photoshop and prepares them for use as reference plates in your 3D modeling package of choice, like Autodesk's 3D Studio Max. Distortions introduced by the lens, camera, and photographer are removed and key features are lined up for easy digital modeling in 3ds Max 8.

How To: Perform a master reset on a BlackBerry Curve

Alright BlackBerry users, it's time to wipe all that information before you sell, or pass on your BB to someone else. This simple how-to video will let you wipe it all, simply and easily. If you desire you can also choose to leave in your sim card and wipe the contents of that as well. The tutorial hose will guide you you step by step on how to remove your personal information from your Blackberry 8350i Curve. This instructional video is a simple but very detailed tutorial that instructs you ...

How To: Draw a house cat

The video shows how artists enlarge and copy from photographs. First grid lines are drawn on the reference photo. Then grid lines are drawn on the paper with enlarged or reduced grids. Now draw the lines from the reference photo to the drawing paper one square at a time. Now complete the outlines from the reference photo. Erase all the grids and you have only the outlines. Add details and area of tone. Darken the dark areas and you have a replica of the reference photograph. The same techniqu...

How To: Import reference files in Modo 301

Go beyond the traditional 3D workflow to an immersive creative experience with the software Modo, created by Luxology. Modo is the next evolution of 3D modeling, painting and rendering for Mac and PC. Modo includes 3D sculpting tools, animation and network rendering, and advanced features such as n-gons and edge weighting.

How To: Use Andrew Loomis's art for reference in Zbrush 3.1

Before you start sculpting in Pixologic's Zbrush 3.1 3D modeling software, you'll want to have references to follow by. So, check out this video to see how to use Andrew Loomis's art books for referencing while sculpting in Zbrush. You'll see where to get Loomis's books on the Internet and what best to work with for your 3D digital animation. Modeling with Zbrush will be a breeze if you have reference to go off of, because you need it.

How To: Reference worksheets and workbooks in Excel formulas

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 6th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create worksheet and workbook references in formulas.

How To: Use absolute and relative cell references in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 5th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use relative and absolute cell references to save time when writing formulas.

How To: Create simple formulas with cell references in Excel

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 very first installment in their series of digital spreadsheet magic tricks, you'll learn how to build your spreadsheet smartly, so it updates automatically by creating formulas with cell references!

How To: Add a workbook reference to an Excel VLOOKUP formula

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Do a cohesive personal statement

In this tutorial, we learn how to do a cohesive personal statement. If you are a student and need to write your personal statement, get started on it early so you have a while to work on it! Start out by working backwards, which means to start with your life now and then building up to how you plan to achieve further goals. You need to make sure this is short and you also need to make sure you don't brag about yourself. If you are wanting to travel abroad, make yourself stand out from other p...

How To: Jet ski safely

Check out this tutorial jet ski video that provides several safety tips on riding your personal water craft with caution. Personal Water Craft (PWC), also called Jet Skis and Wave Runners, are the fastest growing watercraft on the waterways. Along with their popularity has come increasing numbers of injuries and deaths. Commander Tom Martin of the U.S. Coast guard says riders need to follow the rules of the road, as well as wear life jackets and have other safety equipment on board. John Birk...

How To: Use Excel formulas with cell references

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 3rd installment in said basics series, you'll learn how to use formulas that make reference to the values of a cell or multiple cells.

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 installment in said basics series, you'll learn how to use both relative and absolute cell references in MS Excel.

How To: Add across sheets in Excel with 3D cell references

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 8th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add across sheets using 3-D cell References and the SUM function.

How To: Use sheet cell references in Microsoft Excel formulas

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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.

How To: Cite sources in the APA format

In this video, , peakDavid, demonstrates how to use and understand the APA (American Psychological Association) format for citing sources for references in papers, essays, and theses. You will learn the different types of citations used in APA format, and learn to understand how they are used to reference the works you used in your paper. Also, you will learn why you should use the APA format to cite your research, to avoid confusion by the reader, as well as any claims of plagiarism.

How To: Use absolute ($) cell referencing in Excel

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.

How To: Insert or delete footnotes & endnotes in MS Word 2007

In this video tutorial, viewers learn how to insert or delete footnotes or end-notes in Microsoft Word 2007. A footnote is a little reference which will place a small number in subscript and link it to a comment. A end-note is similar except it links the comment to the end of the document, rather than the end of the page. Begin by highlighting the text. Then click on the Reference tab and select Insert Footnote/End-note. Then just add a comment to the subscript. This video will benefit those ...

How To: Use relative & absolute cell references in MS Excel

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 6th installment in his "Excel Business Math" series of free video lessons, you'll learn about the importance of cell References in Excel formulas and functions. Learn about a relative and absolute cell references in Excel formulas with th...

How To: Make an Excel dynamic named range across multiple rows

Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...

How To: Side load private files (music/photos) onto your Nook

In this clip, learn how to add your own personal files to your Barnes and Noble Nook and make it a portable carrying device. This tutorial will show you all the steps you need to get anything from photos, videos, music files and personal documents onto your e-reader. This process is pretty easy and once you view the clip, you should be all set to start side loading. Who needs an iPad when you have a Nook?

How To: Style very short hair for the busy mom

For a mom, there is always so much to do that your own personal care routine may take a back seat. But in this video, top hair stylist Gary France offers tips on how to style very short hair for the busy mom. France shows us his process on a busy working mom. The client receives a lighter color to brighten up her look, a trim to texturize her hair and styles the hair without using a blow dryer, which is great for saving time. France shows us that just because you have kids to take care of doe...

How To: Make calculations in Excel with formulas & references

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...

How To: Write a personal statement to finish your application

In this video we learn how to write a personal statement to finish your application. This should not be a listing of all your qualities, it should be a story. This should have a lot of information about yourself to show how great you are. Write about anything that makes you different and focus on a strength you have. Think about everything you do outside of the classroom and be honest, because these people don't know you. Write with your heart and don't brag about yourself. Think about your a...

How To: Protect your privacy on Twitter

In this video, we learn how to protect your privacy while using Twitter. Your personal information can get stolen in an instant with the internet. With Twitter, when you are doing updates showing where you are and what you are doing, someone could try to find you and potentially create harm to you. To help you avoid situations like this, you need to go to the security settings of your Twitter account. When you go here, you can change the account so that it only allows people you want to follo...

How To: Stop your friends from sharing your personal information on Facebook

In this clip, you'll learn how to adjust your privacy settings to prevent your friends from sharing your personal information on Facebook. Share pictures with your friends by making photo albums on Facebook. This clip will show you how it's done. Whether you're completely new to the Facebook's popular social networking site or simply require a small amount of clarification on how to perform a particular task on Facebook, you're sure to benefit from this helpful video guide. For more informati...

How To: Subnet an IP address on your PC

This 5 part video tutorial series will show you how subnet an IP address on your personal computer. It's a thorough, detailed walkthrough of each step, with explanations on things as basic as "what's an IP address?" Watch the entire series to learn thoroughly about subnetting IP addresses on your personal computer.