This is my first in a series of tutorials for Microsoft Excel. This will introduce some of the basic concepts and then demonstrate a couple practical uses.
One little trick that I like to do with Macromedia Flash is to add an invisible button over a photo or diagram. This button can help identify people in a photo, point out areas of interest on a map, quiz someone on a diagram (i.e. the heart), or just do silly things. :)
Creating charts and diagrams may not be the first thing you think of when you use Excel, but I use it all the time. In this example I use Excel to create a seating chart for my computer lab.
In this tutorial I discuss some tricks for speeding up your work, adding extra function to Word, and I through in some tips most people don't know about.
One of my favorite things to do is to take pictures with my digital camera and turn them into 3D images -- the kind where you use red and blue 3D glasses to see them. It's surprisingly easy and really fun.
I use Excel as something of a simple database. I use it to keep track of movies, collectibles, etc. because I like the interface, the ease of organizing data, and the ability to filter data on-the-fly with AutoFilters and Sorts.
I will go over fixing some of the "features" that come with Excel, customizing menus, protecting worksheets, creating forms, and adding some "special effects".
More advanced formula uses including the "IF" statement. For example, "IF someone earned over $200 then charge them $20... otherwise charge them $40." This is a very powerful tip.
The Forest is another quick and easy landscape using a "mountain" to create a simple model -- in this case, a forest full of trees. Experiment with different textures (trunk, terrain, etc.) to get different kinds of trees.
By Request: Formulas, Formatting, Auto-Formatting, Dates, etc. This was a request to go back to the basics and do some "Beginning Excel" video tutorials. I hope this helps!
I walk you through important a large amount of data (i.e. from the Internet) and converting it to columns. I then go over multiple graph styles and techniques.
This is a fun tip for quick changes in pictures. Instantly change the color of your car -- or your jacket -- or that ugly tie you had on at the Christmas party... (let's not go there). It's quick and easy!
This is an introduction to HTML using Notepad. While some prefer to use a WYSIWYG editor, HTML can be a great benefit if you want to modify your MySpace profile, embed video clips on your blog, etc.
A Pop Art effect which reminds me of 80's album covers. [For those who remember ALBUMS!] :) I use the Threshold with Halftone settings and then add color.
This is the effect you sometimes see on black and white posters of children with that slight touch of color. It's a pretty easy effect and it can be very beautiful for portraits of children or weddings.
I received a request to do a "start to finish restoration". This is a simplified start-finish restoration which should help, but I will begin a series of steps for a full restoration project in the near future.
We will go over formatting dates and using dates in formulas. We will calculate the number of days you've been alive, an employees seniority, etc. We'll learn the "today()" and "now()" functions.
This page gets folks up and running with their own blog in minutes using the Blogger site. I start from clicking "Register" and take you through adding pictures, editing the layout, etc.
A cool feature of Rhino 3D is the ability to draw a shape and then "extrude it" to a 3D object. Here we use that technique to draw a 50's or 60's style coffee table.
![Microsoft Excel #06: Using \"IF\" in Formulas](http://img.youtube.com/vi/GCQErmN0eOI/2.jpg "Microsoft Excel #06: Using \\"IF\\" in Formulas")
![Photo Editing #3: Soft Colorize of Black & White [PhotoShop]](http://img.youtube.com/vi/fYXZ8gS8kOk/2.jpg "Photo Editing #3: Soft Colorize of Black & White [PhotoShop]")
![Photo Restoration #1: An Introduction & Example [PhotoShop]](http://img.youtube.com/vi/R4GYKqQq8UM/2.jpg "Photo Restoration #1: An Introduction & Example [PhotoShop]")
