From the Excel 2010 CORE Exam 77-882

1. Managing the Worksheet Environment

1.1. Navigate Through a Worksheet Keyboard: Hot keys, Pg 283


1.3. Personalize the Excel Environment by Using the Backstage

Quick Access: Add a Command, Pg 220

Backstage: Ribbons, Tabs, Groups, Pg 184

Data: Import Data to Excel, Pg 276

Data: Export Data From Excel, Pg 290

Backstage: Workbook Properties, Pg 223

Backstage: Save, Save As, Pg 71


2. Creating Cell Data

2.2. Apply AutoFill

Format Same as Above or Below, Pg 252

Microsoft Excel 2010 Study Guide: Advanced Excel

             Microsoft Office Specialist (MOS): Exam 77-882 and 77-888 for Excel 2010


From the Excel 2010 EXPERT Exam 77-888

1. Sharing and Maintaining Workbooks

Backstage: Advanced Properties, Pg 223

Data: Import and Export XML, Pg 276

Review: Protect Sheet, Pg 206

Review: Protect Workbook, Pg 207

Backstage: Protect Workbook, Pg 229

Backstage: Encrypt with a Password, Pg 232

Compare and Merge Workbooks, Pg 219

Review: Track Changes, Pg 211



Keep going. There's more...