Apress Access

Learn Excel 2011 for Mac

By Guy Hart-Davis

  • eBook Price: $20.99
Buy eBook Buy Print Book
A practical, hands-on approach to creating and editing spreadsheets, data charts, and more using Excel 2011 for Mac OS X.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-3521-7
  • 488 Pages
  • User Level: Beginner to Advanced
  • Publication Date: March 22, 2011
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • Data Visualization in Excel 2016
  • Essential Excel 2016
  • Mac OS X For Absolute Beginners
  • Beginning Xcode: Swift 3 Edition
  • OS X App Development with CloudKit and Swift
Full 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 for 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

Table of Contents

  1. Learning the Secrets of the Excel:Mac Interface
  2. Configuring Excel:Mac to Suit the Way You Work
  3. Creating Effective Workbooks and Templates
  4. Formatting Your Worksheets Quickly and Efficiently
  5. Performing Custom Calculations with Formulas
  6. Using Excel’s Built-In Functions
  7. Creating Clear and Persuasive Charts
  8. Using Data Bars, Color Scales, Icon Sets, and Sparklines
  9. Illustrating Your Worksheets with SmartArt, Pictures, and More
  10. Creating Databases Using Tables
  11. Solving Business Questions with What-If Analysis, Goal Seek, and Solver
  12. Analyzing Data with PivotTables
  13. Collaborating and Sharing with Macs and Windows
  14. Automating Tasks with Macros and VBA
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. Dashboards for Excel


      View Book

    2. PowerPivot for Business Intelligence Using Excel and SharePoint


      View Book

    3. Pro Excel Financial Modeling


      View Book