In Depth Analyses Search Results

How To: Use the RANK and PERCENTRANK functions 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 38th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the RANK and PERCENTRANK functions as well as the Data Analysis add-in's Rank & Percentile tools.

How To: Use export plug-ins in Aperture

Aperture's extensible architecture supports third-party export plug-ins that make it easy to export your photos directly to various web publishing sites, print service providers, and other software applications. You can find many of these plug-ins on www.apple.com.

How To: Create 3D text in After Effects without plugins

ChadandToddPodcast shows how to create 3D text in after-effects without plug-ins. This can be accomplished by an effect called shatter. First turn off the text layer, then apply shadow to your text image. Change your pattern to custom; it will go blank. Take the custom to text layer then increase extrusion depth. If you take up extrusion you can play with the style of the text. If you play around with fronts your whole image can also be 3-D.

How To: Install plug-ins on a Joomla website

In this tutorial, we learn how to install plug-ins on a Joomla website. First, download the AllVideos plug-in through extensions.joomla.org. To upload, go to the extension manager and then enable to plug-in. Now, go to extensions, then plug-in manager. Once here, you will have access to all your plug-ins. From here, you can control which ones you want enabled and disabled. After you do this, you will be able to use the plug-in that you just uploaded to your website. Do this with all the diffe...

How To: Add a Battery Meter & System Stats to the Information Stream on Your Galaxy S6 Edge

Exclusive to the Samsung Galaxy S6 Edge, "Information stream" is a screen feature that lets you see quick, at-a-glance information with a simple swipe while the screen is off. It also supports plug-ins, or additional streams of information that can come from third-party sources. So developers are starting to come up with nifty little add-ons for Information stream, and the team at 3C has some cool new system feeds that might come in handy.

How To: Understand electrotonic & action potentials in a cell

Maybe you learn best by seeing things worked out in front of you and what you just saw in class today about Electronic action potential of neurons didn't quite sink in. Not to mention the test that you have coming up this week is going to be an in-depth analysis of your knowledge on this material. Let Khanacademy be your guide! For less than half the time it takes to sit through the Professors class, he explains the function of Neurons, how action potential works and sends you on your way to ...

How To: Use & understand depth of field in photography

In this video, we learn how to use and understand depth of field in photography. If you look at a photo, the depth is how deep the picture looks. You can change the depth by changing the aperture to make the depth of field look shorter or longer. The lighting can also change the depth of field and what you can see in the background. A big aperture will give you a large depth of field, with a small amount of light. If you want a big depth of field in a landscape, then you will use a maximum ap...

How To: Check spelling and grammar in MS Word 2010

This video tutorial is a quick explanation of the ins and outs of spell and grammar check when using MS Word 2010. One of the main things highlighted in this video is that unlike previous additions, this year's version offers more contextual correction. For example, when the word their was used in an article, it was spelled correctly but used in the wrong context. The spell and grammar checker will underline this to let you know that it is incorrect. If you hit the spell and grammar check but...

How To: Use image-based lighting & depth of field in Cinema 4D

In this tripartite video tutorial, you'll learn how to create image-based lighting and depth-of-field effects within C4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.

How To: Create a lightning bolt effect using After Effects and the Trapcode Suite

The Trapcode suite is a set of plug-ins for After Effects that allow video artists to create a variety of effects for inclusion in video and film productions. This particular guide demonstrates the power of Trapcode Particular and Trapcode 3D Stroke. Specifically, Wes Ball from OddBall Animation reveals how Trapcode was used in the creation of 'Eye of the Storm' - a music video by Lovett which can be seen here.

How To: Use variables and strings when programming in Python 2

In this clip, you'll learn the ins and outs of using variables and strings when writing code in Python 2. Whether you're new to the Python Software Foundation's popular general purpose programming language or a seasoned developer looking to better acquaint yourself with the features and functions of Python 2, you're sure to benefit from this free video programming lesson. For more information, including detailed, step-by-step instructions, watch this video guide.

How To: Use jQuery to improve your website and business

Isn't it amazing how quickly children can learn how to use technology that seems completely incomprehensible to older people? Nowhere is that more evident than in this video. It features a 12-year-old prodigy explaining the ins and outs of using jQuery, the popular Javascript library, in web development. At over an hour in length, this video goes into great detail and should teach you everything you need to get up and running in jQuery.

How To: Style a scarf cowl knot

Learn how to style a scarf into the cowl knot. Susan Wagner shows you the ins and outs of scarf-tying with her fashionable pink scarf. The cowl knot is a basic knot that can be used for scarves. For days when you're wearing a scarf for WARMTH, not just for fun.

How To: Soften the background by crushing the depth of field

In this Film and Theater video tutorial you will learn about depth of field and how to adjust it. Depth of field means how many objects are in focus in the frame at one focus setting. If the depth of field is large, more objects at various distances from the camera are in focus. The first factor is the amount of light. If the light is good, more objects will remain in focus. On the other hand if you zoomed in with a long focal length lens the depth of field will reduce and lesser objects will...

How To: Create depth map shadows in Maya 2011

Learn how to create depth map shadows when working within Maya 2011. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the Maya 2011 workflow, you're sure to be well served by this video tutorial. For more information, and to get started making depth map shadows in your own Maya projects, watch this free video guide.

News: Followup to Previous Post

So after I wrote my post yesterday, I got sent two links in response, both some pretty awesome and in-depth analysis of the costumes in Rapunzel. It's pretty awesome, I think, to see such detailed costumes in an animated movie - right down to the patch on Flynn's bag and the embellishments on Rapunzel's bodice.

How To: Apply depth of field to your photographs

Learn how to use depth of field with help from this photography tutorial. Although it may seem that depth of field is a confusing factor in photography, it's actually quite easy to understand & adjust once you've gotten the hang of it. Depth of field (or, DOF) is a great way to experiment with your photography & improve your skills as a beginner photographer. When taking your photograph using DOF, it is imperative to remember that the shutter speed and aperture (or F-stop) need to change at e...

How To: Use the regression analysis module

Are you in real estate? Take a look at this instructional video and learn how to run your excel spreadsheet over a regression analysis module. An appraiser who's appraising a house decides to run a multiple regression analysis as an addition to the direct sales comparison approach. The spreadsheet used in this tutorial was written in excel, but could be rewritten in another format. The spreadsheet was exported from an MLS. Once the excel sheet is downloaded, the appraiser will open up the reg...

How To: Understand depth of field while focusing a camcorder

Depth of Field (DoF) is easy to understand, but it is often extremely poorly explained. It's all about selective focus. For consumers with conveniently small camcorders, you only have two options: get your subject away from the background and then (1) zoom in or (2) get the subject close to the camera. No 35mm lens adapters, no secret techniques, no complex math: That's it!

How To: Walkthrough the "Fiery Depths" in Lara Croft and the Guardian of Light

This isn't Phlegethon, but it's just as dangerous! When you delve into the "Fiery Depths" in Lara Croft and the Guardian of Light, you may never come out! Unless… you follow this Mahalo walkthrough to see how to beat the "Fiery Depths" mission in the Lara Craft arcade game, available from the PlayStation Network or Xbox Live Arcade. Click here for more Lara Croft and the Guardian of Light walkthroughs.

How To: Understand your lens & its affect on depth of field

In this Fine Art video tutorial you will learn how to understand your lens and its effect on depth of field. The lens in the video has some inscriptions which are interpreted like this. 50mm is the focal length of the lens. The aperture is from f1.4, which is the widest lens opening to f16, which is the smallest lens opening. The higher the number the lesser the lens opening. Aperture determines the amount light that comes through the lens. Aperture also decides the depth of field. With a wid...

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: Create a two-variable data table in Microsoft 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 255th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a two-variable data table in Excel for what-if analysis. See the PMT function and learn about the formula equivalent to a data table.

Prev Page