Kepo'o Named Search Results

How To: Name cell ranges and use names in formulas in MS Excel

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 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;

How To: Choose a web hosting company

In this video about choosing a web hosting company. The narrator begins by saying that web pages are hosted on servers; the files that make up a web site are hosted or stored on a server. The narrator recommends a service called Host Gator. He indicated they are reliable and provide reasonably priced web hosting services. He briefly discusses the process they charge for their different levels of hosting services. Next he shows the steps to hook your domain name to the host account. He demonst...

How To: Use calculation and summary fields in FileMaker Pro 10

If you are a user of FileMaker Pro then this video teaches you how to use calculation and summary fields in it while making new files. In Filemaker you can create a various kind of fields that you want your file to contain. In Filemaker a calculation is a data that gets computed depending up on the formula that is set in the Filemaker database settings. Calculations are very critical in file management. Open the Manage Database and there you can find some of the calculation fields. There in t...

How To: Change the carrier name on iPod Touch/iPhone

In this video from iPT2gGeec we learn how to change the carrier name on your iPhone. You can make it say anything you want. You need a jailbroken iPhone. Open up Cydia and select the search tab. Type in MakeItMine. Click on it and install and confirm. Now press the home button and click on the app for it. Now you'll get a very simple dialog box. In that box, type in whatever you'd like to change your carrier name to. You can select it to change the carrier or the banner which would replace th...

How To: Name amines in physical chemistry

In this free video science lesson from Internet pedagogical superstar Salman Khan, you'll learn how to name amines. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For more information, including detailed, step-by-step instructions, take a look.

How To: Use names and wildcards with Excel's COUNTIF function

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.

How To: Extract first, middle, & last names 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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.

How To: Set & insert a formula name into an Excel print area

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 215th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a named formula with OFFSET & COUNTIF functions that defines a print area, and then insert the formula name into the print area name.

How To: Check for fake Uggs

In this video, Yourpick09 shows viewers how to distinguish real from fake Ugg brand shoes. The characteristics of a real pair of Ugg shoes include real Ugg fur, which is fluffy and has thick fur. Real Ugg shoes are made in China and has tags stating so. Another indication of an authentic pair is to look at the Ugg logo, which should have an encircled "R" next to the name brand. This apples to the label tag as well as the imprint of the brand name. Fake Ugg shoes have fur that is thin and skim...

How To: Set up a network printer on Windows XP

The video describes sharing of printer with other computers. There is no need of any cable. Can be connected to desktop or laptop. Open (System Properties) from (My Computer) and check computer name. Open (printers and faxes) window. Select the printer to work on. Activate the box named (share this printer) under sharing in printer properties. To use this feature in laptop open (printers and faxes) again from printers and other hardware options in control panel. Open the (Add Printer Wizard)....

How To: Create a defined name for a dynamic range in MS 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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).

How To: Make your own board game for 99 cents

In this tutorial, we learn how to make your own board game for 99 cents. First, trace out a name onto the board spelling out each letter. After this, break the letters down into different spaces, and color code them for different moves on the board. Write down the key for the colors underneath the name so you know what the colors mean. After this, draw the name onto a piece of paper, measuring out everything so all the spaces are the same size. Then, color in the spots on the board. Next, use...

How To: Design and carve a Chinese name chop seal stamp

Any artist who excels enough in his profession will create some sort of signature on his painting to notify other it's his work. Some painters, like Jan van Eyck, are cryptic with their inscriptions, putting it in almost impossible to see areas in the painting, while others, like Chinese painters, put their literal stamp on paintings with a carved seal stamp.

How To: Use a focus group for new brand name candidates

Focus groups strike fear into the hearts of even the most season marketer, and with good reason. In a world where everything is subject to change based on public opinion, from movie endings, to popcorn flavors, to logo colors, focus groups can make or break a new idea, but it doesn't have to be that way. A focus group is just a way to gather opinions in a vigorous way and can be very useful. Watch this video tutorial to use a focus group to develop and test a new brand name or corporate ident...

How To: Generate a dynamic list from a table in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...

How To: Do a Business Part 2 of 5

Although a business plan is a technical document, remember that this first draft will not be. The audience and author of this document will be the owner/manager of the small business. The purpose is to get as much information written as possible so this draft can be used as a starter for versions of the business plan that are crafted for other audiences. It eliminates the possibility of the first business plan you write for other audiences actually looks like your first attempt. Since the lat...

How To: Add a file to your PBwiki page

This video shows us the method to add a file to your PBWiki page. Go to Edit on the top left corner of the page. Click on 'Images and files' on the right side of the screen. Now upload the file from your computer. Now you may need to name the file something else on your page. Type the new name of the file on your page. Select the name and then click on the file name on the right hand side. Save the name by clicking on the Save button at the bottom left corner of the page. Thus you have succes...

How To: Simply change your user name on Facebook

Steps on how to change your user name on Facebook. 1. Click to open your internet browser. 2. Open your Facebook account. 3. Bring cursor to the Account tab found on the upper right corner. 4. Click Account tab to open. 5. Point cursor to Account Settings and click it. The My Account page will open. 6. Click on the Name tab so that your name will appear. 7. Delete your First and Last Names and replace with the new First and Last Names that you want to use. 8. Click on Change Name. 9. Click Hi...

How To: Pronounce Linus Torvalds in Swedish, Finnish & English

Linus Torvalds, creator of the Linux operating system, often raises eyebrows with a name that may not flow easily off the tongue. As a finlandsvenskar/suomenruotsalainen, or a Swedish-speaking Finn and as a sought-after international engineer, Linus is used to pronouncing his name in at least three different languages. Watch this video language tutorial and learn how to correctly say Linus Torvalds's name in his mother tongue of Swedish, his homeland's language of Finnish, and the internation...

How To: Change Your Profile Picture & Display Name for iMessage in iOS 13

For quite some time, popular messaging apps such WhatsApp and Skype have let you set a profile picture along with a display name to make you more instantly identifiable to loved ones and colleagues. Apple has finally caught up with this fad in iOS 13. That means you can set a custom name and profile image within iMessage so others can quickly view who's messaging them at a glance.

How To: Customize Your Apple TV's Name

Your Apple TV is just that — your Apple TV, which means you probably want to personalize it a bit, to make yours stand out from everybody else's. And the easiest way to do this is by renaming it. If you live in an apartment building, this will help differentiate your Apple TV from your neighbors' when trying to use AirPlay.

Siri 101: How to Make Siri Correctly Recognize & Pronounce Contact Names on Your iPhone

Siri makes it easy to call almost any contact on your iPhone with just a quick verbal command. I say almost because counterintuitive name pronunciations such as Caoimhe, which is actually pronounced "Keeva," will confuse the hell out of Siri. Luckily, there's a way to get Siri to understand pronunciations for the tricky names in your contact list ... it just takes a little grunt work on your part.

How To: Name an alkyl halide (or haloalkane) in organic chemistry

What's in a name? Well, your chemistry grade, for one. In this free video science lesson from Internet pedagogical superstar Salman Khan, you'll learn how to name alkyl halides. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For more information, including detailed, step-by-step instructions, take a look.

How To: Remove your name & photo from anything you've shared on Facebook

In this clip, you'll learn how to disable your Facebook profile, removing your name and picture from shared media in the process. 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 information, including detailed, step-by-step instructions, take a look.

How To: Get a new domain name from Google

In this video, we learn how to get a new domain name from Google. First, go to the Google domain website and search for a domain name that you want. After this, check the availability of it, then continue to register it. Once you get the registration page, enter in your information and pay for the service. After you do this, you will get to choose your e-mail preferences, then finish your purchase. There will be a link to retrieve your purchase at the end, then you will create your first admi...