Named Combinatorial Search Results

How To: Use names in formulas and functions in Microsoft Excel

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 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.

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: Perform the "name it" card trick

In this video Andy shows you how to perform the "Name it" card trick. The presenter suggests introducing yourself quickly and then ask someone in the audience for a name. Count up the number of letters in the persons name (for instance David is five letters). You then split and reverse five cards. You then ask the audience member to cut the deck in half. Then double under break the remaining cards. Then place the selected card under the reversed card. Then ask the audience member his name aga...

How To: Copy & paste a list of all names in an Excel workbook

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 12.66th installment in his series of Excel name tricks, you'll learn how to paste a list of all names in the workbook, both the name and the formula that defines the name.

How To: Evaluate a new product, service, or company name

Chances are, if you're a branding or marketing professional, you've been tasked to come up with a new name for a product, a service, or maybe even a company at some point in your career. Maybe you're trying to come up with a new brand name right now. Well, there are objective measurements for choosing new names, and if you need help figuring these out, watch this video tutorial to learn how to develop a new product or company name that will stand out among your competitors, presented by namin...

How To: Use dynamic range names in Excel 2007 tables

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 12th installment in his series of Excel name tricks, you'll learn how to use the built-in dynamic range names in Excel 2007 Tables.

How To: Name cell ranges with relative references in MS Excel

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 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.

How To: Translate your name into Japanese in 2 easy ways

This is a video that explains to a person how to write their name in Japanese. The woman shows two ways as to how to translate your name in Japanese. The first is how the name is pronounced, and the second way is to translate your name based on the meaning. Usually the name is translated based on pronunciation in the native language. The name is pronounced similarly but not exactly the same. For example Rachel is pronounced "Reicheru". She also shows a website where more information can be fo...

How To: Play "Where the Streets Have No Name" by U2 on electric guitar

Want to master "Where the Streets Have No Name" by U2? See how it's done with this free video guitar lesson, which presents a complete (and we mean complete) breakdown of the song and its constituent parts. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "Where the Streets Have No Name" on your own guitar, just tak...

How To: Build confidence by remembering people's names

This video describes how build your confidence by remembering peoples' name. This Confidence Quickbite explains that a person's name is the sweetest sound to him/her and will make them feel special if you remember it. If you don't remember a person's name he/she may think that he/she is not important enough for you to care enough to remember. To remember names a simple trick is to say the name back to the person in conversation right after he/she tells you it. Then try to think of anybody els...

How To: Use Excel names with pivot tables & data validation

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 5th installment in his series of Excel name tricks, you'll learn to use names with pivot tables, data validation & the VLOOKUP & COUNTIF functions and formulas.

How To: Create a name plaque in Photoshop

Your name may not be forever minted in stone or gold for all of posterity to gaze at, but you can certainly bling up your family name by making your own name plaque using Photoshop. This Photoshop tutorial will teach you how to put your name - or whatever word you want - in a shiny golden/wooden plaque with a brass plate. You'll be using filters as well as several other tools.

How To: Quickly change your user name in Facebook

This is a video tutorial in the Computers & Programming category where you are going to learn how to quickly change your user name in Facebook. Click on start and then click on all programs. Go to accessories and click on system tools. Now select character map. Write whatever you want in the character map window and minimize the window. You must write two words with a space in between. Go to your Facebook account and move your mouse over settings, but don't click. Click on account settings. N...

How To: Change the registered system owner name in Windows Vista

Mistakes can happen, and in Windows Vista, you can fix them without stress. What if you bought a PC with Windows Vista installed? The registered user name (owner/admin) would not be your name. So, how do you change it to reflect your name? This video will show you how to change the registered owner name in Vista, with just a few quick steps. This is also handy if your owner name is misspelled or just flat out wrong!

How To: Change name servers in GoDaddy

In this video, we learn how to change name servers in GoDaddy. First, go to GoDaddy and sign in with your username and password. After this, go to the side bar and click on the main manager option. Now, you will be able to see your domains. Click on the domain that you wan to change the name of, then click on "name servers". Now, click that you host your domains with another provider, and change the name server one and two. Once finished, click "ok", then your changes will be submitted. Withi...

How To: Replace your name on Facebook

In this video tutorial, viewers learn how to replace their name on Facebook. Begin by going to the Facebook website and logging into your account. Then click on Settings, located at the top right corner of the page. Under the Name headline, click on Change. Now under First Name, type in your new name. Users may also choose to change their middle and/or surname. Finish by clicking on Save Changes, and click on Confirm request to conform your name changing. This video will benefit those viewers...

How To: Create quick formulas with Excel names in MS Excel

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 4th installment in his series of Excel name tricks, you'll learn to use short Excel names to expedite the formula creation process. For detailed instructions, watch this free video Excel lesson.

How To: Change your computer name in System Properties (PC)

On your Windows computer you can change the name of your computer. After changing your name, when you turn off your computer you can make it display some thing else instead of the default "turn off computer" text. Do do this right click the My Computer icon on your desktop. Select properties from the menu. This brings up the System Properties window of your computer. Go to the Computer Name tab and in the description box insert a new name to your computer. Save the changes and exit the window...

How To: Use line segments in pre-Algebra

This video shows the way to name a line segment. A line segment begins and ends with an end point. We can name a line segment by naming the two end points of the line segment. The example shown in the video shows a line segment that ends with points named 'A' and 'C'. So, we can name this line segment as segment 'AC'. This can also be named as segment 'CA'. The example shown consists of a point 'B' in between 'A' or 'B'. We cannot name the line segment as segment 'AB' or 'BA' and segment 'BC'...

How To: Pronounce Hungarian names and surnames

Check out this instructional Hungarian language video to learn how to speak Hungarian! In this lesson, learn how to pronounce names and surnames in Hungarian. This video provides typical names in Hungarian without providing their English equivalents. This instructional language video is great for advanced and beginners who would like to pronounce names and surnames in Hungarian.

How To: Play "Say My Name" by Destiny's Child on ukelele

The ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the ukelele. This video will teach you how to play the hit song "Say My Name" by Destiny's Child on ukelele.

How To: Cite scholarly journal articles in MLA format

This video shows viewers how to properly cite scholarly journal articles in the MLA format. In your works cited page, the citation should begin by placing the author's last name first, followed by his first name. If there are multiple authors, all subsequent authors should have their first name first followed by their last name. Placing a period after this, the next item is the title of the article, placed in quotation marks and followed by a period. The name of the scholarly journal is place...

How To: Reverse first & last names by formula 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 292nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first and last names from an Excel spreadsheet and rearrange them using a formula.

How To: Make a dynamic named range in Excel (left to right)

Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...

How To: Play Matt Redman's "Blessed Be Your Name" on guitar

Grab your acoustic guitar, strap, and your pick and check out this free guitar lesson. This video tutorial will teach you Christian rock guitarists how to play a solo from a Matt Redman song. Not just any Matt Redman song, but one of his greatest: "Blessed Be Your Name." And just so you know, here are the lyrics to go along with this instructional guitar lesson:

How To: Randomly select a name from a list 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 and Mr. Excel, the 11th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create a formula that will randomly select a name from a list of names without having the list of names sitting in cells.

Prev Page