Nesting an IF, Then statement

Step 1 – Create a list of your cities

Step 2 – Create a picklist using cells from above
·    Select a cell for your picklist (I used A8) and click Data > Validation > Settings
·    Allow: List
·    Source:  For my example, A1 through A4.  (click the Source field and drag down your list)
·    Click OK.  Now your list is available.

Step 3 – Select a cell to display your statement (I use  D8)

Step 4 – Copy and paste the following into that cell

=IF(A8=A1,"Dallas Address Here",IF(A8=A2,"Fort Smith Address Here",IF(A8=A3,"Atlanta Address Here",IF(A8=A4,"OKC Address Here",""))))

Now, when you select Dallas from the drop down box, an address will populate.

  

Note – You will need to tweak the formula by changing the names in parenthesis.  For example, “Fort Smith Address Here” becomes “212 Elm Street”.

How to Save and Convert YouTube Movie Files

If you are wanting to  save a video from youtube and wish to be able to play it on your Mac or PC, follow these simple steps:

1. Go to www.keepvid.com which will allow you to paste the link to of the youtube video you want to save. When you paste it there, then click the download button.
2. It will allow you to download a FLV version of the video. Download it
3. If that format is not playable on your computer, I would suggest you go http://media-convert.com/ and select the input format (FLV) and output format to be what you need. You will be using that website to convert your FLV video that you downloaded in step 2. Be patient, as it will take several minutes to upload the video, and then convert it to the format you specify.
4. If you want to play it on a PC, then output the format to AVI or WMV. If you want to play it on a Mac, then output to MOV format.

Post questions in the comments. Thanks for reading!

How to Create Pictures From Videos

The simplest way to create a picture or still images from a video file is to literally take a picture of the video at the place you would like a photo. See below:

For PC users:
1. Open the video file and maximize it to full screen. If the video looks too blurry, then drag the video to be large enough where the quality of the picture shown is still acceptable.
2. Pause the video at the place you would like a picture.
3. Press the button on your keyboard that says Print Scrn = SysRq (it is in the upper right hand corner of most keyboards)
4. Open the application called MS Paint. On a PC it should be in the start menu usually in accessories.
5. Inside of Paint, right click in the white area and select Paste
6. You should now see a picture of the screen that you took when the video was playing. You can crop it by using the select tool. Select just the video area, then press edit>copy, then delete everything and select edit>paste
7. Click File>Save AS and select the type as JPEG

Questions? Post in the comments. Thanks for reading!

Creating Multiple Folders in Windows

Creating multiple folders in Windows is as easy as cut and paste.  Just follow these steps.

1. Open Notepad on your computer.
2. Copy and Paste the following code into Notepad:

@echo off
set /p name="Type folder name(s): "
md %1\%name%

     3. Click File > Save As.  Save as make_dir.cmd

Now, that’s the script.  The next step is to add this script to your right-click menu when viewing Windows Explorer.

1. Go to My Computer on your Desktop.  
2. Select Tools  >  Folder Options  >  File Types  >  File Folder
3. Click the Advanced button.
4. Click the New button.
5. In the Action field, type “Mult Folders”.
6. Next, use Browse to find your make_dir.cmd script. 

Finally, you’ll need to run your sript.

1. Locate the Folder where your new folders will be created.
2. Right Click on the Folder and click Mult Folders.

     3. In the CMD Prompt pop-up window, type or paste the names of your folders.  For example, typing in Dog Cat Mouse will create three folders.  For names with two or more words, use quotations.  For example, “John Smith” “Jane Doe” creates two folders.


And now you’re done!

Web Design - Where To Start?

Ever wondered how a web page is created? Would you like to learn how to create your own web pages?

For the true beginner, the thought of creating a web page, or especially a website, can be daunting if you have little or no understanding of how the web works.

This post will help you get started with getting started.

First things first: What is a web page?

A web page is what you see on your browser when on the internet. Right now, in fact, you are viewing my web page.

A web page is created via code. It starts with something called HTML. This code can be written within a word document and saved with the file extension ".html".

You could write your own code now if you'd like. But you would need to know the code, right?

If your interested, I suggest you go here:

http://www.w3schools.com

Once there, click the Learn HTML link to the left of the page.

The tutorials here are quick, simple, and very intuitive. There are examples for every step. You can even play around with them and create your own HTML code right there on the site. It's fun, it's fast, and it will be your first step in learning the do's and don'ts of web design.

Of course, HTML is only the building block of the web. There are many more yet to learn. Luckily,

http://www.w3schools.com includes tutorials for those as well.

Flash, CSS, JavaScript, and the list goes on.

So, if you've got an idea for a site, or are at least interested in how the web works,

http://www.w3schools.com is the place to start. Of course there are books upon books with this information at your local book store, but I'd suggest starting here.

And one last thing. The site mentioned above is good if you have the time to sit and play. But if you are like me, and spend most of your day in transit or at a workstation, you may have more time for something on audio. Like a pod cast?

If so, I'd suggest going to

www.ocdevel.com/podcasts. You won't learn much syntax here, but the content is designed for the noob's noob. I listen to it. And I think you should too.

Thanks for reading. Good luck!

How to Properly Eat a Cupcake

Ever wondered how do I properly eat this cupcake?



The main thing to remember when contemplating how to eat a fancy cupcake is that you must have a fork. Eating a cupcake with a fork is the only way to eat a fancy cupcake or any cupcake for that matter.

First thing you must do is peel down the sides of the cupcake cake foil or paper.



Then take your fork and slice down the side of the cupcake in a manageable bite size portion.



You can use a sideways cutting motion, or a stabbing motion.






When you're finished, just wrap up the paper and throw it away!

How to Get Your Toddler Down For a Nap

My toddler does not go down for naps very well. In the last few months I have established what I think is the best way to get your toddler down for a nap.

First of all, must put yourself in their shoes and ask: why don't I want to take a nap today? Because more than likely if your toddler is like mine, your toddler throws fits when it's nap time. Usually toddlers do not want to take naps because that means they mist stop playing, watching T.V. etc. They think they will miss out on something, so it is your job to convince your toddler that nap time is a fun time. It's fun to snuggle under the covers and read nap time stories. It's fun to lay down and dream about imaginary dragons or ice cream trucks or what the weather will be like when you wake up.

How to get my toddler down for a nap is hard, until I learn that they don't want to go down for fear of missing out on fun stuff. Then I just convince them otherwise.

Thanks for reading.