Learn Excel 2011 for Mac

ISBN-13: 9781430235217 / Angielski / Miękka / 2011 / 488 str.

Guy Hart-Davis

Opis

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.

Spis treści

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

O autorze

Guy Hart-Davis is the author of more than 50 computer books, including How to Do Everything with Microsoft Excel 2007 and How to Do Everything with Microsoft Word 2007.