Subject Addressed Search Results

How To: Use Mail Merge in Pages for Mac

A step-by-step guide that will walk you through Mail Merge on a Mac computer. You will gain how to prep and print envelopes, letters or any document that you need to send to different names and addresses on each item. You can pull the data from your address book or from a Numbers Spreadsheet and will see how to modify and merge the information you will need to successfully set up your documents.

How To: Use the ADDRESS function in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 98th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the ADDRESS function to make labels in templates easier for users to understand.

How To: Pose people for photos with Erin Manning

When it comes to working with people, the photographer can face quite a challenge. Everyone has a mind of their own, and with these few tips you will know how to advise your subject so they look fantastic in a picture. Join Erin Manning, professional photographer, as she shows us 5 handy tips for working with people.

How To: Properly light a green screen and create the illusion

Ever wonder how to create movie magic right in your own home? This video shows you step by step everything you need to know and do to create the green screen effect, from properly setting up your green screen, to lighting it, as well as your subjects for a successful effect. Filled with tips and instructions this is a great video to watch for filmmakers, and special effects artist of all kinds.

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: Quickly find your MAC address

In this tutorial, we learn how to quickly find your MAC address. This is the address that identifies your computer on a network. When you go to a campus, you will need to register your computer with a resnet so you can access the internet. To find the address, you will head to the Apple menu, then click 'about this MAC'. Click on the 'more' button and then click on 'network' and 'built in Ethernet'. This is the MAC address that you will need to register your computer, you may have a few of th...

How To: Find the IP address of your computer

In this video we learn how to find the IP address of your computer. First, go to your desktop and click on the network in the lower right hand corner. The network and sharing center will now pop up on your computer. Click on the link that says "local area connection". Then a new window will pop up, click "details". Once the information comes up you will be able to see your IP address along with a ton of other information about your network. Another way to find your IP address is to go to the ...

How To: Change your IP address in five different ways

In this tutorial, we learn how to change your IP address in five different ways. First, go to your security settings and clear all cookies, then start to browse the internet with private browsing from your internet browser. You can change your IP address by going onto your internet browser and changing the LAN settings. Type in your address and port, then bypass the proxy server. Next, go to options and then advanced on your browser. Type in the proxy and port, then click where it says no pro...

How To: Take better indoor portraits

James Barry teaches us how to take better indoor portraits. When you are taking these, you want to make sure you have the lighting that is directly onto the subject and the subject's face can be seen. You will have to work with the light and often you will have to add in several lights to get the facial features to all show. Work with your camera to see what it sees and how the light looks through the camera. It will take several minutes to get the portrait to come out correctly. Place the li...

How To: Find your local IP and MAC address

In this video Guides4tech teaches the secrets of finding your local IP and MAC address in simple steps. First click 'Start' and select 'Run' on your computer. Now type 'cmd' to open the command prompt. In the command prompt type 'ipconfig/all' and press 'Enter'. Your IP address will displayed under the 'Ethernet adapter local area connection' menu. Your MAC address will be displayed as 'Physical address' under the same menu.

How To: Change your IP address using a Linksys router

Learn how to change your IP address using a Linksys router in simple steps. First search for your IP address in the internet and find it from any of the websites available. Now go to your Linksys setup page by accessing it with your username and password. Go to Mac address code and change the last set of digits by increasing or decreasing a value. Now save the settings and reset your modem and router. Finally check your new address to finish.

How To: Find the IP address of a computer in Command Prompt

Now you can find your IP address if you need it and you don't know it, it very easy. Or if you have problem with a person on the internet, now you can discover who that person is. You can find her/his IP address and after that you can find her/his real name. But after you find the IP that you were looking for, you have to check if the person who own this computer is in your network, because if you want to find his/her name, the program works only if the owner is on your network. So if you are...

How To: Distribute one cell across multiple cells in Excel

Storing information, such as a full address, in one column can limit what you can do with that information. For example, you can't easily filter or sort by part of the address, such as country/region or city. However, if you break up the address into its parts — street address, city, state/province, postal code, country/region — one for each column, you can remove those limits. Watch this instructional video to see how to use the Convert Text to Columns Wizard to automatically break up a sing...

How To: Do advanced green screen tricks

Interested in learning how to do advanced green screen tricks to show a subject flying? After this tutorial, you'll be a pro. How to launch: Light the screen and the subject. Frame the subject so that you do not see their feet on the ground. Do this by cutting off the lower 1/3 of the subject. Sell the effect by using a fan from above. Add in a background which works with the flying that you are trying to achieve. How to fly: Have a prop that you can use for effect that can be cut out later (...

How To: Make Texts & iMessages Stand Out on Your iPhone with Bold Subject Lines

The subject line is a crucial part of an email, but you don't see it very often in texts. That's mostly because many people don't even know it can be done, and even if they do, why would they use it? Just like with emails, subject lines can make iMessages and SMS texts seem more important and more professional. Plus, they can help with organization and searching past messages, as well as make text bold.

How To: Understand & Use IPv4 to Navigate a Network

You may not know it, but the IPv4 address of your computer contains tons of useful information about whatever Wi-Fi network you're on. By knowing what your IPv4 address and subnet mask are telling you, you can easily scan the whole network range, locate the router, and discover other devices on the same network.

How To: Take a woman's portrait

Taking a woman’s portrait isn’t just about photographic skill, it’s about flattery. You will need a single lens reflex camera, a female subject, a backdrop and a hurricane of compliments. Tip: to isolate the subject from the background, use a long telephoto lens at the widest aperture possible, and stand a minimum of 10 to 15 feet in front of the subject making sure she fills the frame.

How To: Create shorthand link aliases

If you like to share websites via email, are a writer who needs to share email in her stories, or just need to make a quick written note of a website address, you need to know how to use web address shorthand. Some URLs can be hundreds of characters long and therefore too tedious to reproduce in writing. To make an easier-to-communicate link, you'll need to use a URL minimizer, like TinyURL. Learn how with this address-minimizing how-to!

How To: Change your IP address from the Windows command line

Need to change your IP address? In this how-to, you'll find instructions for changing your IP address from the Windows command prompt with the ipconfig console application. For step-by-step instructions, take a look. NB: Changing your IP will not protect your identity; it's merely a simple expedient for getting around certain problems ones might encounter while using the Internet.

How To: Shorten URLs and hide your email address

In this tutorial, Gary Rosenzweig of MacMost.com takes a look at two tiny, but nevertheless very useful, Web services. The first, tinyurl.com, will take a long Web address and shorten it to make it easier to send in email. The second, http://tinymail.me, will hide your email address. For more information consult this great how-to.

How To: Use ipconfig to determine an IP address in Windows XP

This video will show you how you can easily find out what your IP address is for a computer which is running the Windows XP operating system. You will first need to go to the start bar and click on the button which says "Run". Choose to run a program called "cmd" by typing this into the bar that appears. This will then open up a black box, where you should type in "ipconfig/all". Typing this in will offer you a list of information about the internet service you are currently using and one of ...

How To: Learn the forms of address in Russian

Check out this instructional language video to learn how to address someone in Russian. Learn basic Russian grammar with Viktor Dmitriyevich Huliganov in his 2nd lesson. Some other objectives in the lesson include 1a verbs and common adverbs. Watch this tutorial video that is great for language nerds and advanced Russian speakers who need to polish their skills or looking to improve their proficiency in Russian.

How To: Set or Change Your Home & Work Addresses on Apple Maps

Having your home and work addresses set in Apple Maps makes them incredibly easy to navigate to no matter where you're located. If you move to a new house, stay in a hotel or resort while vacationing, report to a different office, or have multiple job sites to visit regularly, updating these addresses isn't only straightforward — there's more than one way to do it.

How To: Find your IP address with 3 different methods

In this video, we learn how to find your IP address with 3 different methods. First, go to the bottom of your screen and click on the computer icon you see. The next way is to go to WhatismyIP. When on the site, you will be given your IP address. The last way is to go to start, then run, and type in "CMD". Now, type in "ipconfig" and press enter. Once on here, you will be given your IP address. All of these will give you the same number, just use whichever option is easiest for you to use!

How To: Isolate your subject to get better photos

In this tutorial, we learn how to isolate your subject to get better photos. If you are taking a picture in an area with a lot of people or surroundings in the background, have your subject stand up on something. After you do this, you can take the shot and have nothing in the picture with your subject but the background. You can also have a child go on a playground and zoom in on them if you are taking a picture of a child. On the playground, you can find tons of spots where the child can be...

How To: Hack into a compuuter, the easiest way

In this Computers & Programming video tutorial you will learn how to hack into a compuuter, the easiest way. Go to start > run, type in ‘cmd’ > OK. To find the IP address of a website, type in ‘tracert myspace.com’. This example is to find IP address of myspace.com. Then all the IP addresses of the website will be displayed. If you want to shut down a computer, now you type in ‘shutdown’. A remote shutdown dialog box will open up where you put in the IP address. That’s all. The ...

How To: Setup a new e-mail account in Outlook 2003

Tool is selected, followed by email accounts and a selection is made at the "add new email account" option , the "next" button is clicked. Pop3 is selected and the next button. The required information is filled in such as name, amail address, incoming and outgoing mail server, username; which is the same as the email address and the password is entered. The "remember password" option is selected, along with the "more settings" button. Within the more settings window, the company name and a r...

How To: Find someone's IP address

In this tutorial, we learn how to find someone's IP address. First, log into What's their IP. Once you open this, enter your email and click the links that can be sent to your friends. Once they click on these links, the website will email you that person's IP address. You can now look this IP up to see the exact location of that person. There are several different options of pages that can be sent to your friends if you want to track their IP addresses. There is also a page that can be sent ...

How To: Easily change your IP address

This video discusses how to change your IP address in Windows XP. Start by clicking on the Start Button and then Run. Type in "cmd" and press enter. This will open a Command Prompt box. From here type in "ipconfig" which will show your current IP configuration, including your IP Address, Gateway, DNS Servers, etc. Next type "ipconfig /release". This will release all IP information from your current network adaptor. Next open up network connections, right click on Local Area Connection and sel...