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.
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!
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 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.
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.
Google Earth is an amazing FREE application that allows you to view maps, satellite imagery, links, photographs, and 3D terrains. I am more amazed every time I use it.
I am redoing some of this video to answer some questions I have been getting. I hope this one is a little easier to follow -- AND it doesn't have the annoying clicks. :)
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 continue with part 2 of the "back to basics" Excel tutorial. I go into more depth with formulas, talk about changing column and row sizes, and reference other cells.
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.
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 will go over fixing some of the "features" that come with Excel, customizing menus, protecting worksheets, creating forms, and adding some "special effects".
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.
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.
Perhaps the most useful tool in Photoshop when enhancing or editing scanned photo's is the Levels tool. You can quickly enhance a photo, adding depth and richness. This works especially well with old images.
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.
![Photo Restoration #1: An Introduction & Example [PhotoShop]](http://img.youtube.com/vi/R4GYKqQq8UM/2.jpg "Photo Restoration #1: An Introduction & Example [PhotoShop]")
![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 Editing #1: The Magic of Levels [PhotoShop]](http://img.youtube.com/vi/Hs3v0zo8B2U/2.jpg "Photo Editing #1: The Magic of Levels [PhotoShop]")
![PhotoShop Tips: Magic Erasers and Transparent GIF\](http://img.youtube.com/vi/kuXd1JTKr4c/2.jpg "PhotoShop Tips: Magic Erasers and Transparent GIF\")
![Microsoft Excel #06: Using \"IF\" in Formulas](http://img.youtube.com/vi/GCQErmN0eOI/2.jpg "Microsoft Excel #06: Using \\"IF\\" in Formulas")
