Scenario Feature in Open Office Calc

Here is a video I created describing how to use the scenario feature in open office calc.

Split Data in a Cell

Have you ever made a list of names in a spreadsheet and put the first and last name in one cell? Later on, you decide you want the first and last names to be in separate cells. Here is a video I created and posted on You Tube. Hope you enjoy.



For information on:
LEFT()
RIGHT()
LEN()
FIND()

you can see examples and explanations on my blog. Just look on the right hand side for the category the functions are in. They are grouped like they are in Calc.

Dangerous Path

This is a pretty cool video. I think I would do it. From the comments on You Tube, it seems to be in Spain.

Chris Matthews

I love this video. Matthews makes Mr. Watson look like an idiot.

How to Open Microsoft Office

Did you buy a copy of Microsoft Office? If so, here is a short video showing you how to open the box.

IFGA

International Fainting Goat Association (IFGA). The International Fainting Goat Association was founded in the fall of 1989 by a group of people who appreciated the Fainting Goat as a breed and wished to see them preserved. This task is being accomplished through registration, pedigree documentation, and educating the public about the uniqueness of the breed.

Never heard of this before. I was watching AFV, and saw a clip of a goat falling down. We were at the in-laws and my father-in-law said that is a fainting goat.

And here is a video.

Switch Pitcher

I linked to an article about a week ago about the switch pitcher. Here is the video.

Group and Link to External Data

I just posted a video on You Tube about grouping data in a spreadsheet. The data is from Yahoo! Sports. I got the data in the spreadsheet by Linking To External Data. I also have a video posted explaining this. Watch and enjoy. Learn how keep up with your favorite sports stats easily, in a spreadsheet.

Here are the links:
Linking to external data
Grouping the data

Validity video on You Tube

I just uploaded two videos on You Tube about using Validity in the Data menu. These are great videos showing you how to access list on another sheet and another file. It also includes using the OFFSET and MATCH functions in calc.

Here are the links. I hope you enjoy them.

http://www.youtube.com/watch?v=UVt6LiwbtEE

http://www.youtube.com/watch?v=N8YHWDTUshA

New Math

I like this video. Want to learn how to subtract? After watching this video, you will be an expert.