Excel+2008

Site with lots of Data to work with.. http://www.gpoaccess.gov/usbudget/fy11/hist.html

=What’s New in Excel 2008?=


 * Elements Gallery** - The Elements Gallery is located below the toolbars in Word, PowerPoint, and Excel. It provides quick access to some of the most-used features.


 * Sheets** – In Excel, you can find preformatted ledger sheets in the Elements Gallery


 * Charts** - Create modern-looking charts by using new charting templates and tools that include special effects such as 3-D, transparency, and shadows. You can preview and insert any chart directly from the Charts tab in the Elements Gallery. After you create a chart in Excel, you can use it in other Office documents.


 * SmartArt Graphics** - Quickly create designer-quality diagrams, charts, and other information graphics by using SmartArt graphics. Choose from dozens of SmartArt graphics to visually represent lists, hierarchies, and other relationships.


 * WordArt** – Excel includes updated, modern-looking WordArt that you can use to apply 2-D and 3-D effects to text.


 * Formula Builder** - The Formula Builder helps you create formulas in a simple, step-by-step approach. You don't have to memorize functions or their syntax. Use it to create formulas, search for functions, insert functions and arguments in existing formulas, and get help on all Excel functions.


 * Formula Auto Complete** - Write and edit formulas without having to remember function names, defined names, or other elements of a formula. When you type a formula in a cell, you can choose valid functions, names, and named ranges in context.
 * Named Ranges** – Will also appear in the auto-complete list of choices.


 * Ledger Sheets** - Use these preformatted Excel sheets to balance your check book, track an investment portfolio, create an expense report, and perform other common tasks. Each ledger sheet addresses a specific scenario. For example, if you open an invoice ledger sheet, the sheet contains all of the formulas and columns appropriate for tracking and managing invoices.

When you save a Word document (.docx), a PowerPoint presentation (.pptx), or an Excel workbook (.xlsx), Office saves them in the new file formats.
 * New Format** - The new default file formats, called Open XML Formats, create smaller files and make it easier to recover damaged files and share files. The new file formats, which are used in Word, PowerPoint, and Excel, also help keep your files more secure. Open XML Formats are also the default file formats for the 2007 Microsoft Office system for the Windows operating system.
 * Compatibility Report**




 * Creating Venn Diagram -**
 * 1) Create a new workbook
 * 2) Select all cells
 * 3) Format all cells to pattern - white (Format, Cells, Pattern, Choose white)
 * 4) Draw circles for diagram - Open Toolbox, Object Palette, Draw Circle
 * 5) Format the circle to have "No Fill" - Format Shape, Fill, No Fill
 * 6) Copy Circle
 * 7) Add pictures if you like - Toolbox, Object Palette, Images
 * 8) Add labels
 * 9) Color only after all terms have been added.