Learn Excel 2016 for OS X

✍ Scribed by Guy Hart-Davis (auth.)

• Publisher: Apress
• Year: 2015
• Tongue: English
• Leaves: 409
• Category: Library

✦ Table of Contents

Front Matter....Pages i-xxiv
Front Matter....Pages 1-1
Learning the Secrets of the Excel for Mac Interface....Pages 3-47
Configuring Excel to Suit the Way You Work....Pages 49-65
Creating Effective Workbooks and Templates....Pages 67-99
Formatting Your Worksheets Quickly and Efficiently....Pages 101-142
Front Matter....Pages 143-144
Performing Custom Calculations with Formulas....Pages 145-165
Using Excel’s Built-In Functions....Pages 167-205
Creating Clear and Persuasive Charts....Pages 207-243
Using Data Bars, Color Scales, Icon Sets, and Sparklines....Pages 245-260
Illustrating Your Worksheets with Pictures, SmartArt, and More....Pages 261-281
Front Matter....Pages 283-283
Creating Databases Using Tables....Pages 285-304
Solving Business Questions with What-If Analysis, Goal Seek, and Solver....Pages 305-327
Analyzing Data with PivotTables....Pages 329-359
Collaborating and Sharing with Macs and Windows PCs....Pages 361-389
Back Matter....Pages 391-399

✦ Subjects

Computer Science, general; Computer Applications