Reference Search Results

How To: Your iPhone's Hidden Field Test Mode Finally Lets You Bookmark Network Measurements for Easy Reference

If you've ever used your iPhone's hidden Field Test mode to view your signal strength in decibel-milliwatts, locate the tower you're connected to, or find out the radio frequency in use, you no longer have to dig through all of the confusing-looking data every time you need to check. Apple updated Field Test's interface in iOS 15, and one improvement gives you more control of the Dashboard.

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: 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: Cite reference books in MLA format

In this video tutorial, viewers learn how to cite reference books in MLA formats. Citation is a reference to a published or unpublished source. Viewers will learn how to cite an article in an online reference book and an article in a print reference book. The format for the online reference book is:

How To: Retrieve cell references with INDEX & MATCH 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 341st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and MATCH functions together to retrieve a cell reference that the OFFSET function can use for its reference argument.

How To: Use reference words in reported speech in English

In this video, we learn how to speak English: Reported Speech/Reference Words. Reported speech is reporting another person's words or telling what someone else said. Indirect speech doesn't use the use the exact words that we use. Examples of reference words are: her, she, herself, him, and himself. Types of references can be pronouns or possessive adjectives. Listen to who the speaker is so you can change the reference words so that the statement is logical. Use this example as a reference: ...

How To: Build 3D reference plates in 3ds Max 8

This 3ds Max video tutorial will take you through the process of setting up reference plates for precision modeling in Autodesk's 3D Studio Max. So get those Adobe Photoshop reference images ready for 3d Studio Max so you can display those modified photographs. It can be done in just about any digital 3D modeling software out there.

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: 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: Embed a Wiki article reference in your WordPress blog

See how to insert a hyperlinked reference to a Wikipedia article in your blog post or page with this free video blogger's guide. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.

How To: Use Excel spreadsheet setup & cell references

In this Excel basic video the instructor shows how to setup a spreadsheet and use cell references. Cell references are used in Excel to refer to other cells in a formula. When a formula contains data based on the cell reference the formula auto generates the result each time the value in the cell changes as the formula contains only the reference to the cell and not the actual data present in it. In this video the tutor goes on and shows how to write a few basic formulas using cell references...

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: 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.

How To: Define topology lines on reference images in Photoshop

This video tutorial goes over methods for defining the topology of an organic object in Adobe Photoshop. This is helpful as a planning stage before you begin your 3ds Max 8 digital 3D modeling to make sure that your have proper distribution of faces and your target mesh will deform nicely. So, if you're using Autodesk's 3D Studio Max for awesome 3D graphics, this could help you out with Photoshop topology.

How To: Import reference in modo 301

The new Import Reference feature in modo 301 allows you to import meshes or entire projects into a master project. This is a powerful and efficient workflow enhancement for modo 301. The import reference system provides a powerful assembly based workflow as you will see in this tutorial. Import reference in modo 301.

How To: Use reference lines to control radial shapes in Revit

This CAD software tutorial covers how to use reference lines to constrain or drive radial shapes in Revit Architecture. This can be tricky when using Reference plane but with a reference line it is quite easy. David doesn't get too much into adding parameters but one could imagine using a length parameter to drive the length of the reference line as well as the ellipse. Watch and learn how to model and control radial shapes with reference lines in Revit Architecture. Use reference lines to co...

News: References As A Marketing Tool

One of the most important marketing tools we should always be developing to help reinforce our brand is our references. Just like many companies use their client list and client references to build credibility and confidence for their products and services, we should also leverage our references to build credibility and confidence in our capabilities and brand. Sometimes reference checks are just a formality, but in most cases potential employers (i.e., potential clients) use reference checks...

How To: Translate documents in Microsoft Office: Mac 2008

If you've ever had to work with documents written in other languages, you know how painstakingly difficult it can be if you're not a fluent speaker of the language. But now, with the help of Office 2008 for Mac, translating those documents is easy. You can know easily translate a PowerPoint presentation in almost any language to almost any language! And you can also translate Word documents, Excel spreadsheets, and even emails in Entourage! This translator is available right in the reference ...

How To: Purify Urine for Drinking with an Emergency Solar Still

It’s called Urophagia—the art of consuming urine. There could be any number of reasons for having the desire to drink your own urine (or somebody else’s). There’s the so-called term “urine therapy,” which uses human urine as an alternative medicine. In urine therapy, or uropathy, it’s used therapeutically for various health, healing, and cosmetic purposes. There’s also those people who drink urine as sexual stimulation, where they want to share every part of each other. And then there’s the o...

How To: Edit with enhanced speech analysis in Premiere Pro CS5

Whether you're new to Adobe After Effects or a seasoned digital film professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to turn spoken dialogue into searchable text either by synchronizing content with your Adobe Story script, or by using reference scripts that are optimized for your content. Also see how to accelerate editing by marking in and out points in t...

How To: Find the Left 4 Dead 2 easter egg in the Dead Rising 2: Case West DLC

Zombies have followed hot on the heels of vampires as the monster du jour in modern America, and this has been particularly pronounced in video games for some reason. Gamers dig zombies, we suppose. The zombie game folks are even developing some camaraderie amongst themselves, as evidenced by the easter eggs exchanged in Left 4 Dead 2 and Dead Rising 2: Case West. This video will show you where and how to find a Left 4 Dead 2 reference / easter egg in Dead Rising 2: Case West.

Prev Page