有用Mac Excel的同学们可以学习一下啊!
Contents .............................................................................................................. v
About the Author .............................................................................................. xiii
About the Technical Reviewer .......................................................................... xiv
Acknowledgments ............................................................................................. xv
Introduction ...................................................................................................... xvi
Part I: Becoming Proficient with Excel:Mac ....................................................... 1
■Chapter 1: Learning the Secrets of the Excel:Mac Interface ........................... 3
■Chapter 2: Configuring Excel:Mac to Suit the Way You Work ........................ 53
■Chapter 3: Creating Effective Workbooks and Templates ............................. 83
■Chapter 4: Formatting Your Worksheets Quickly and Efficiently ................ 117
Part II: Performing Calculations and Presenting Data .................................... 161
■Chapter 5: Performing Custom Calculations with Formulas ....................... 163
■Chapter 6: Using Excel’s Built-In Functions ................................................ 185
■Chapter 7: Creating Clear and Persuasive Charts ....................................... 225
■Chapter 8: Using Data Bars, Color Scales, Icon Sets, and Sparklines ......... 261
■Chapter 9: Illustrating Your Worksheets with
Pictures, SmartArt, and More .................................................... 275
Part III: Analyzing Data and Sharing and Automating Workbooks ................. 303
■Chapter 10: Creating Databases Using Tables ............................................. 305
■Chapter 11: Solving Business Questions with
What-If Analysis, Goal Seek, and Solver .................................. 327
■Chapter 12: Analyzing Data with PivotTables ............................................. 351
■Chapter 13: Collaborating and Sharing with Macs and Windows PCs ........ 381
■Chapter 14: Automating Tasks with Macros and VBA ................................. 409
Index ............................................................................................................... 429