Excel 2007 Workbook For Dummies®

by Greg Harvey (Mind Over Media, Point Reyes Station, California)

• ISBN13: 9780470195802
• ISBN10: 0470195800
• Format: eBook
• Copyright: 2007-11-01
• Publisher: For Dummies

Summary

From formulas to functions to the latest features - practice and plan Excel tasks with ease Confused by Excel? Want to make the most of its capabilities? No worries - this hands-on workbook gets you up to speed in a step-by-step manner. From navigating the new user interface and creating your first spreadsheet to using formulas, working with charts and graphics, managing and securing data, and creating macros, you'll do it all with the help of practice files and more than 30 walk-throughs of Excel features on the CD-ROM. Plus, you get full coverage of all the new and enhanced features of Excel 2007! See how to * Set up, format, and edit basic spreadsheets * Manage and secure your Excel data * Create formulas and functions for finance, date and time, math, text, and more * Master data analysis with pivot tables * Save and share your spreadsheet data Quick refresher explanations Step-by-step procedures Hands-on practice exercises Tear-out Cheat Sheet A dash of humor and fun All this on the bonus CD-ROM * Dynamic video walk-throughs demonstrate Excel features and tasks * Practice files let you work through the exercises in the book For details and complete system requirements, see the CD-ROM appendix.

Table of Contents

Introduction

Creating Spreadsheets

Getting Familiar with the Excel 2007 Interface

Entering the Spreadsheet Data

Formatting the Spreadsheet

Printing Spreadsheet Reports

Modifying the Spreadsheet

Using Formulas and Functions

Building Formulas

Copying and Correcting Formulas

Creating Date and Time Formulas

Financial Formulas and Functions

Using Math Functions

Using Common Statistical Functions

Using Lookup Functions

Using Logical Functions

Text Formulas and Functions

Working with Graphics

Charting Spreadsheet Data

Adding Graphics to Spreadsheets

Managing and Securing Data

Building and Maintaining Data Lists

Protecting the Spreadsheet

Doing Data Analysis

Performing What-If Analysis

Generating Pivot Tables

Macros and Visual Basic for Applications

Using Macros

Using the Visual Basic Editor

The Part of Tens

Top Ten Features in Excel 2007

Top Ten Tips for Using Excel Like a Pro

Appendix: About the CD

Index

Table of Contents provided by Publisher. All Rights Reserved.