Sunday, December 20, 2009

Microsoft Excel Tutorials-2

1. Create A Seating Chart

Creating charts and diagrams may not be the first thing you think of when you use Excel, but can be quite handy while working in Excel. In this example Excel is used to create a seating chart for a computer lab.


2. Cartesian Coordinate And Venn Diagram

In this video Microsoft Excel is used to produce a Cartesian Coordinate Plane and a Venn Diagram.


3. Excel As A Database

Excel as something of a simple database. It can be used to keep track of things like movies, collectibles, etc. because It has such amazing abilities like the interface, the ease of organizing data, and the ability to filter data on-the-fly.


4. Tips Tricks And Form Creation

Go over a few really useful tips to make your Excel spreadsheets soar. Using Excel to create forms and charts is also discussed in this tutorial video.


5. Using "IF" In Formulas

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


[<<] [<] 1 2 [>] [>>]

No comments:

Post a Comment

Your comments here!