Study Guide Page 1 -Page 2

Microsoft Excel 2013 Study Guide: Intermediate Excel

           Microsoft Office Specialist (MOS): Exams 77-427 and 77-428 Expert for Excel 2013

From the Excel 2013 Expert Exams
1. Manage and Share Workbooks,
1.2   Prepare a Workbook For Review

Formulas: Control Recalculation, Pg 226
Review: Limit Editors (Invitation only), Pg 209

1.3   Manage Workbook Changes
Formula Auditing: Find Errors, Pg 39
Review: Trace Formulas, Pg 41

2. Apply Custom Formats and Layouts
2.1 Apply Custom Data Formats

Custom Data Formats: Number, Time, Date, Pg 17
Advanced Fill Series, Pg 19

2.4 Prepare a Workbook for Internationalization and Accessibility
Modify Tab Order, Pg 186

From the Excel 2013 Expert Exams
3. Create Advanced Formulas
3.1   Apply Functions in Formulas

Formulas: the AND/OR Functions, Pg 100
Formulas: the IF Function, Pg 131
Formulas: the SUMIFS, AVERAGEIFS and COUNTIFS Functions, Pg 98
Formulas: Use Nested Functions, Pg 238

3.2   Look Up Data with Functions
Formulas: the LOOKUP Function, Pg 115
Formulas: the VLOOKUP Function, Pg 118
Formulas: the HLOOKUP Function, Pg 125
Formulas: the TRANSPOSE Function, Pg 140

From the Excel 2013 Expert Exams
3. Create Advanced Formulas
3.3   Apply Advanced Date and Time Functions
Formulas: the NOW and TODAY Functions, Pg 71
Formulas: Use a Function to Serialize Data, Pg 69

3.4   Create Scenarios  
Formulas: Enable Iterative Calculations, Pg 228
Formulas: Financial Functions, Pg 77
Scenarios: Use the Watch Window, Pg 227