Excel 2007 on Your Side

Download or read book Excel 2007 on Your Side written by E. N. I. Publishing and published by Editions ENI. This book was released on 2008-01-07 with total page 382 pages. Available in PDF, EPUB and Kindle. Book excerpt: This practical guide teaches you how to get the most out of Microsoft® Excel 2007. After a description of the new environment, which has been improved from the previous versions, and learning how to manage files, templates and datasheets, you will quickly become familiar with entering and editing data (numbers, dates, calculation formulas, data series). You will then learn how to use the tools for formatting data (fonts, colours, borders, AutoFormats, styles, etc), create outlines, use worksheet auditing, and print your tables replete with various graphics and charts. The guide also explains the different ways you can use Excel to create tables and pivot charts by using datasheets. As a portion of this guide focuses on working with multiple users, it includes all you need to know about sharing and protecting your data. The latter chapters discuss techniques for improving data entry (creating custom data series or drop-down lists), and how to insert hyperlinks, import and export data, use macro commands, and create Web pages.