Intermediate Microsoft Excel 2013: Index            Microsoft Office Specialist (MOS): Exam 77-427 and 77-428 Excel 2013

Add Worksheets to an Existing Workbook, Pg 28 Advanced Fill Series, Pg 19 AutoFill Data, Pg 18 Change Worksheet Order, Pg 186 Charts: Modify Chart, Pg 123 Conditional Logic Function: AVERAGEIF, Pg 104 Conditional Logic Function: COUNTIF, Pg 101 Conditional Logic Function: SUMIF, Pg 98 Copy and Move Worksheets, Pg 25 Custom Data Formats: Number, Time, Date, Pg 17 Formula Auditing: Display Formulas, Pg 44 Formula Auditing: Find Errors, Pg 39 Formulas: Control Recalculation, Pg 226 Formulas: Enable Iterative Calculations, Pg 228 Formulas: Financial Functions, Pg 77 Formulas: Order of Operations, Pg 223 Formulas: Relative and Absolute, Pg 37 Formulas: the AND/OR Functions, Pg 133 Formulas: the HLOOKUP Function, Pg 125 Formulas: the IF Function, Pg 131 Formulas: the LOOKUP Function, Pg 115 Formulas: the NOW and TODAY Functions, Pg 71 Formulas: the SUMIFS, AVERAGEIFS and COUNTIFS Functions, Pg 98 Formulas: the TRANSPOSE Function, Pg 140 Formulas: the VLOOKUP Function, Pg 118 Formulas: Use a Function to Serialize Data, Pg 69 Formulas: Use Named Ranges in Formulas, Pg 34 Formulas: Use Nested Functions, Pg 238 Hide Worksheets, Pg 188 Insert and Delete Rows and Columns, Pg 33 Insert Headers and Footers, Pg 159 Insert Hyperlinks, Pg 193 Insert Watermarks, Pg 155 Modify Page Setup, Pg 149 Modify Tab Order, Pg 186 Named Ranges: Create Named Ranges, Pg 89 Navigate with the Name Box, Pg 90 Print: Individual Worksheets, Pg 167 Print: Repeat Headers and Footers, Pg 156 Print: Set Print Area, Pg 157 Print: Set Print Scaling, Pg 166 Print: Setup Workbooks to Print, Pg 148 Review: Limit Editors (Invitation only), Pg 209 Review: Trace Formulas, Pg 41 Save Workbook in Alternative Formats, Pg 214 Save: Save to a Remote Location (SkyDrive), Pg 207 Scenarios: Use the Watch Window, Pg 227 Sparklines: Insert a Sparkline, Pg 178 TEXT Function: CONCATENATE, Pg 62 TEXT Function: RIGHT. LEFT, MID, Pg 230 TEXT Function: TRIM, Pg 236 TEXT Function: UPPER and LOWER, Pg 65 Worksheet Tab Color, Pg 187