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.
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.
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.
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 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.
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.
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.
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.
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.
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 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.
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.
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 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.
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.
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.
![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]")
