Chapter 3: Sharing and Collaboration

Take 1: Working Overtime, page 161
Watch the video

Objectives and Menu Map, page 162
Practice, page 194
Test Yourself, page 194

 

Take 2: Prepare to Share, page 195
Watch the video

Objectives and Menu Map, page 196
Test Yourself, page 244

 

Take 3: Working with Macros, page 245

Objectives and Menu Map, page 246
Test Yourself, page 278


Appendix: PowerPivot

Take 1. Introduction to PowerPivot, page 279

Objectives and Menu Map, page 280

Advanced Excel Skill Test, page 329

 Excel Skill Test, continued, page 330

Advanced Excel Skill Test (print)

Index, page 331 Index, continued

Level 6: Advanced Guide to Microsoft Excel 2013

pic1

Chapter 1: Tables and List

Take 1: Works for Me!, page 11
Watch the video

Objectives and Menu Map, page 12

Practice, page 45
Test Yourself, page 46
 

Take 2: Work Smarter, Not Harder, page 47
Watch the video

Objectives and Menu Map, page 48
Practice, page 81
Test Yourself, page 82

 

Chapter 2: Analyzing Data Visually

Take 1: What Happened? (Pivot Tables), page 83
Watch the video

Objectives and Menu Map, page 84

Practice, page 117

Test Yourself, page 118

 

Take 2: What Did You See? (Pivot Charts), pg 119
Watch the video

Objectives and Menu Map, page 120

Practice, page 159

Test Yourself, page 160