Read more
Many experienced users may initially find Excel 2007 rather disorientating. But Excel 2007: Beyond the Manual will introduce those who are already familiar with Excel basics to more advanced features, like consolidation, what-if analysis, PivotTables, sorting and filtering, and some commonly used functions.
You'll learn how to maximize your efficiency at producing professional-looking spreadsheets and charts and become competent at analyzing data using a variety of tools. The book includes practical examples to illustrate advanced features. It also covers new features of Excel 2007 along with ways to access old features. You'll even gain timesaving tips and shortcuts.
List of contents
What's New in Excel 2007?.- Customizing Excel.- Excel Essentials.- Styles and Formatting.- Sorting and Filtering.- Analyzing Data Using Subtotals, Consolidations, and Tables.- Creating PivotTables and PivotCharts.- Editing PivotTables and PivotCharts.- What-If Analysis.- Formulas and Functions.- Charts.- Adding Graphics to a Worksheet.- Preventing and Correcting Errors.- Protection and Security.- Getting Data from External Sources.- Sharing, Reviewing, and Distributing Data.- SharePoint and Excel Services.
About the author
Helen Dixon works for Queen's University in Belfast, U.K., training staff and students in IT and providing a consultancy service for staff. Her qualifications include a bachelor's degree (with honors) in business studies and a master's in computing and information systems. She is studying for a Ph.D. in electronic commerce.
Summary
Many experienced users may initially find Excel 2007 rather disorientating. But Excel 2007: Beyond the Manual will introduce those who are already familiar with Excel basics to more advanced features, like consolidation, what-if analysis, PivotTables, sorting and filtering, and some commonly used functions.
You'll learn how to maximize your efficiency at producing professional-looking spreadsheets and charts and become competent at analyzing data using a variety of tools. The book includes practical examples to illustrate advanced features. It also covers new features of Excel 2007 along with ways to access old features. You'll even gain timesaving tips and shortcuts.
