Sale!

Excel 2007 For Dummies 1st Edition by Greg Harvey ISBN 0470037377 9780470037379

Original price was: $50.00.Current price is: $35.00.

Excel 2007 For Dummies 1st Edition Greg Phd Harvey Digital Instant Download

Author(s): Greg PhD Harvey
ISBN(s): 9780470037379, 0470037377
Edition: 1
File Details: PDF, 5.24 MB
Year: 2006
Language: english
SKU: EB-1988528 Category: Tag:

Excel 2007 For Dummies 1st Edition by Greg Harvey – Ebook PDF Instant Download/Delivery: 0470037377, 9780470037379
Full download Excel 2007 For Dummies 1st Edition after payment

Product details:

ISBN 10: 0470037377
ISBN 13: 9780470037379
Author: Greg Harvey

Master the Ribbon, powerful graphics capabilities, and more!

Your one-stop guide to great-looking spreadsheets that actually mean something

Create colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more!

Discover how to

  • Create dynamic spreadsheets with style galleries
  • Work with more than 40 new cell styles
  • Automate formatting with Live Preview
  • Share Excel data with other programs
  • Use VBA to write custom Excel functions
 

Excel 2007 For Dummies 1st Table of contents:

Part I: Getting Started with Excel 2007

  1. Excel 2007: An Introduction

    • Exploring the New Excel Interface

    • Understanding the Ribbon

    • Understanding the Excel Workbook

  2. Your First Workbook

    • Creating a Workbook

    • Entering Data

    • Saving Your Work

  3. Navigating Excel

    • Using the Ribbon

    • Customizing the Quick Access Toolbar

    • Moving Around a Workbook

Part II: Entering and Formatting Data

  1. Entering Data Efficiently

    • Using Keyboard Shortcuts

    • Autofill and Flash Fill

  2. Working with Data

    • Formatting Numbers, Dates, and Text

    • Editing Cells and Ranges

    • Using the Clipboard and Paste Special

  3. Formatting Your Spreadsheet

    • Formatting Cells (Fonts, Colors, Borders)

    • Using Themes for Consistency

Part III: Formulas and Functions

  1. Creating Simple Formulas

    • Understanding Formulas and Operators

    • Using Cell References

  2. Using Functions

    • Common Excel Functions (SUM, AVERAGE, etc.)

    • Working with Date and Time Functions

    • Error Checking in Formulas

  3. Advanced Formulas

    • Using IF Statements and Logical Functions

    • Nested Functions

Part IV: Managing and Analyzing Data

  1. Sorting and Filtering Data

    • Sorting Data by Multiple Criteria

    • Filtering Data for Quick Analysis

  2. Creating Charts

    • Creating Basic Charts

    • Customizing Chart Types

    • Working with Data Labels and Legends

  3. Using PivotTables

    • Understanding PivotTables

    • Creating a PivotTable

    • Summarizing and Analyzing Data with PivotTables

Part V: Working with Multiple Worksheets and Workbooks

  1. Working with Multiple Worksheets

    • Managing Multiple Sheets

    • Grouping Sheets for Simultaneous Editing

  2. Linking and Consolidating Data

    • Linking Data Across Worksheets and Workbooks

    • Using External Data Sources

  3. Printing and Sharing Your Work

    • Preparing Your Workbook for Printing

    • Printing in Excel 2007

    • Sharing Workbooks with Others

Part VI: Advanced Features

  1. Using Excel 2007’s Data Analysis Tools

    • Creating and Using Data Tables

    • Analyzing Data with Goal Seek and Solver

  2. Customizing Excel

    • Customizing the Ribbon and Quick Access Toolbar

    • Adjusting Excel’s Settings for Your Needs

  3. Automating Excel with Macros

    • Recording and Running Macros

    • Editing Macros

Part VII: The Part of Tens

  1. Ten Excel 2007 Shortcuts You Can’t Live Without

  2. Ten Tips for Making Your Excel Workbooks Look Great

People also search for Excel 2007 For Dummies 1st:

excel 2007 workbook for dummies greg harvey
    
excel 2007 vba programming for dummies
    
excel 2007 functions
    
excel 2007 for dummies pdf
    
excel 2010 for dummies pdf free download

Tags: Greg Harvey, Excel