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.
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.
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.
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.
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.