You are previewing Learn Excel 2011 for Mac.
O'Reilly logo
Learn Excel 2011 for Mac

Book Description

Microsoft Excel 2011 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2011 for Mac by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2011 in order to get work done efficiently on Mac OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks.

What you'll learn

  • The secrets of the Excel:Mac interface!

  • How to create effective workbooks and templates

  • How to quickly format worksheets

  • How to perform custom calculations and formulas

  • What kind of creative and persuasive charts

  • How to illustrate your worksheets with SmartArt, pictures, and more

  • What business problem solving can be done with Excel

  • How to analyze data with pivot tables

  • How to automate tasks with Visual Basic for Applications (VBA)

Who this book is for

Beginning and intermediate users looking to get up to speed quickly with the Excel 2011 application and use it productively, both online and offline.

Table of Contents

  1. Title Page
  2. Dedication
  3. Contents at a Glance
  4. Contents
  5. About the Author
  6. About the Technical Reviewer
  7. Acknowledgments
  8. Introduction
    1. Who Is This Book For?
    2. What Does This Book Cover?
    3. Conventions Used in This Book
  9. Part I: Becoming Proficient with Excel:Mac
    1. Chapter 1: Learning the Secrets of the Excel:Mac Interface
      1. Getting Ready to Learn Excel's Secrets
      2. Four Ways to Control Excel
      3. Secrets of the Ribbon
      4. Secrets of the Toolbars
      5. Secrets of the Menu Bar
      6. Driving Excel with Keyboard Shortcuts
      7. Making the Toolbox Work Your Way
      8. Navigating Quickly Through Worksheets and Workbooks
      9. Tools for Entering Text and Formulas Quickly
      10. Viewing Your Workbooks
      11. Using Custom Views
      12. Summary
    2. Chapter 2: Configuring Excel:Mac to Suit the Way You Work
      1. Opening the Excel Preferences Dialog Box
      2. Controlling How the Excel Window Appears
      3. Choosing Editing Options
      4. Setting Preferences for Creating and Saving Your Workbooks
      5. Creating Custom Keyboard Shortcuts
      6. Customizing the Toolbars with the Commands You Need
      7. Customizing the Menus and the Menu Bar
      8. Turning Off or Customizing the Ribbon
      9. Opening One or More Workbooks Automatically with Excel
      10. Saving the Layout of Open Workbooks as a Workspace
      11. Summary
    3. Chapter 3: Creating Effective Workbooks and Templates
      1. Creating Workbooks from Scratch or from Templates
      2. Saving Your Workbooks for Use with Older Versions of Excel
      3. Organizing the Worksheets in a Workbook
      4. Four Easy Rules for Laying Out Your Worksheets
      5. Entering Data on Multiple Worksheets at Once
      6. Identifying Parts with Named Ranges
      7. Creating a Collapsible Worksheet by Outlining It
      8. Making the Most of Templates
      9. Summary
    4. Chapter 4: Formatting Your Worksheets Quickly and Efficiently
      1. Working with Rows and Columns
      2. Formatting Cells and Ranges
      3. Using Paste Special to Paste Formatting and Perform Actions
      4. Identifying Unusual Values with Conditional Formatting
      5. Checking Input with Data Validation
      6. Formatting Quickly with Table Formatting and Styles
      7. Adding Headers and Footers to Your Worksheets
      8. Summary
  10. Part II: Performing Calculations and Presenting Data
    1. Chapter 5: Performing Custom Calculations with Formulas
      1. Understanding the Difference Between Formulas and Functions
      2. Referring to Cells and Ranges in Formulas and Functions
      3. Understanding the Components of Formulas
      4. Creating Straightforward Formulas
      5. Creating Complex Formulas
      6. Entering Formulas Quickly by Copying and Using AutoFill
      7. Choosing Preferences for Error Checking
      8. Troubleshooting Common Problems with Formulas
      9. Summary
    2. Chapter 6: Using Excel's Built-In Functions
      1. Understanding the Components of a Function
      2. Entering Functions in Your Worksheets
      3. Nesting One Function Inside Another Function
      4. Meeting Excel's Built-in Functions
      5. Choosing the Right Calculation Preferences for Your Needs
      6. Summary
    3. Chapter 7: Creating Clear and Persuasive Charts
      1. Learning the Essentials of Charts in Excel
      2. Choosing the Best Chart Type for Your Data
      3. Creating, Laying Out, and Formatting a Chart
      4. Copying a Chart's Formatting to Another Chart
      5. Reusing Your Own Designs by Creating Custom Chart Types
      6. Choosing Chart Preferences
      7. Using Your Charts in Word Documents and PowerPoint Presentations
      8. Summary
    4. Chapter 8: Using Data Bars, Color Scales, Icon Sets, and Sparklines
      1. Using Data Bars
      2. Using Color Scales
      3. Representing Data Graphically with Icon Sets
      4. Showing Data Trends with Sparklines
      5. Summary
    5. Chapter 9: Illustrating Your Worksheets with Pictures, SmartArt, and More
      1. Inserting Clip Art
      2. Inserting Pictures in Your Workbooks
      3. Adding and Formatting a Shape
      4. Rotating a Graphical Object
      5. Positioning a Graphical Object
      6. Making a Picture Look the Way You Want It
      7. Inserting SmartArt Diagrams
      8. Adding Decorative Text with WordArt
      9. Positioning Graphical Objects Relative to Cells
      10. Arranging Graphical Objects to Control Which Is Visible
      11. Summary
  11. Part III: Analyzing Data and Sharing and Automating Workbooks
    1. Chapter 10: Creating Databases Using Tables
      1. Creating Databases in Excel
      2. Using Database Functions with Tables
      3. Summary
    2. Chapter 11: Solving Business Questions with What-If Analysis, Goal Seek, and Solver
      1. Assessing the Impact of Variables Using Data Tables
      2. Examining Different Scenarios in a Worksheet
      3. Using Goal Seek
      4. Solving Multiple-Variable Problems with Solver
      5. Summary
    3. Chapter 12: Analyzing Data with PivotTables
      1. Understanding What PivotTables Are and What You Can Do with Them
      2. Creating and Laying Out a PivotTable
      3. Controlling the Design of a PivotTable
      4. Formatting a PivotTable
      5. Naming a PivotTable and Setting Options for It
      6. Sorting and Filtering a PivotTable
      7. Summary
    4. Chapter 13: Collaborating and Sharing with Macs and Windows PCs
      1. Making Your Worksheets Print Correctly
      2. Sharing Your Worksheets as PDFs
      3. Exporting Data to CSV Files
      4. Documenting Your Workbooks
      5. Sharing Your Workbooks with Your Colleagues
      6. Merging Multiple Workbooks into a Single Workbook
      7. Consolidating Multiple Worksheets into a Single Worksheet
      8. Summary
    5. Chapter 14: Automating Tasks with Macros and VBA
      1. Understanding Your Options for Automating Tasks
      2. Recording Macros
      3. Recording an Example Macro
      4. Running a Macro
      5. Deleting a Macro
      6. Editing Macros in the Visual Basic Editor
      7. Summary
  12. Index