All about Microsoft Excel: excel 2007 tutorials

Excel 2007 is a spreadsheet program that helps you collect, refine and analyze huge amount of data. With its powerful interface, and even more powerful tools, it simplifies the complex job of maintaining and analyzing data. The new version of Excel, Excel 2007, is considered just so powerful because it brings with the following refinements.

Whole new data interface
Excel 2007 presents a whole new interface which differs from almost all of its predecessors. The new interface, Microsoft calls it the results oriented interface, places the most used commands first and functions as a one click tool bar. No need to navigate through the menu. Just do everything within a click. The new interface also provides you more space on the desktop than its previous version and a better tool bar customization

Increased data storage
Excel 2007 now has 1,048,576 rows and 16,384 columns which makes up to 17,179,869,184 cells. You read it right. Excel has 17 billion+ cells which is 1024 more than its previous version. Sure a big leap in data storage, hope your computer memory permits it.

Unlimited formatting
Excel 2007 now has a unique way to quickly format your data. The introduction of themes and styles would help you a long way to provide high printer friendly documents. You can now apply 64000 unique styles to cells and you have 16 million colors. So just apply the format you like. Now no two spreadsheets would look alike.

Easy file conversion
Perhaps, one of the biggest advancements in this version is the ability to convert your Excel file into a whole lot of formats. You can now have your file in XML, PDF, XPS formats. So no matter the platform, your Excel file would be viewed in any computer

Reduced file size
Excel now supports multi threading. Thus the Operating System can run several Excel processes at on time. Plus the new Excel algorithm keeps your file extremely small (you can test it out with your previous versions). You could also freely convert your files between any Excel version. What's more you can now have unlimited number of worksheets (though theoretically it is limited by memory)

New look 3D charts and smart art
Another big advancement is the new look 3D charts and graphs. Just turn your Excel into virtual dashboard with colorful and powerful graphs. The smart art service also looks quite good. Select your favorite shape in a single click rather than moving through menus. You can also use data bars and icon sets to further enhance your workbook. Now you can turn your workbook into a presentation

Improved sort and filtering
Excel now provides improved sort and filtering service. The auto filter option now provides for quick filtering of text, numbers and dates. The sort function has now unlimited keys. So you can sort your data through any number of rows and columns

Microsoft Excel 2007 presents a whole new interface and a host of whole new features compared to its previous versions. The new version replaces the old menus with tool bars and also has improved in speed and optimization. Though the old menus remain the same, a few improvements have been made, the most important being the huge number of rows and columns, unlimited colors and formats, easy conversion to XML and PDF and reduced file size.

This tutorial is intended for both users working for the first time in Excel and those who are moving from the previous version. With this tutorial, you can learn Excel within an hour. The chapters are presented in an easy to use manner and you may find it useful. So just browse through the topics to learn Excel 2007