| |
| |
| Introduction | |
| |
| |
| Who this book is for | |
| |
| |
| How this book is organized | |
| |
| |
| Download the practice files | |
| |
| |
| Sidebar: Adapting exercise steps | |
| |
| |
| Ebook edition | |
| |
| |
| Get support and give feedback | |
| |
| |
| Errata | |
| |
| |
| We want to hear from you | |
| |
| |
| Stay in touch | |
| |
| |
| Taking a Microsoft Office Specialist exam | |
| |
| |
| Microsoft Office Specialist certification | |
| |
| |
| Selecting a certification path | |
| |
| |
| Test-taking tips | |
| |
| |
| Certification benefits | |
| |
| |
| For more information | |
| |
| |
| Exam 77-420 Microsoft Excel 2013 | |
| |
| |
| Prerequisites | |
| |
| |
| Managing worksheets | |
| |
| |
| Managing worksheet content | |
| |
| |
| Managing Excel tables | |
| |
| |
| Managing data entries | |
| |
| |
| |
| Create and manage workbooks and worksheets | |
| |
| |
| |
| Create workbooks and worksheets | |
| |
| |
| Creating new workbooks and worksheets | |
| |
| |
| Reusing existing content | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Navigate through worksheets and workbooks | |
| |
| |
| Locating data and worksheet elements | |
| |
| |
| Inserting hyperlinks | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Format worksheets and workbooks | |
| |
| |
| Modifying page setup | |
| |
| |
| Inserting page elements | |
| |
| |
| Changing workbook themes and colors | |
| |
| |
| Modifying rows and columns | |
| |
| |
| Configuring data validation | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Customize options and views for worksheets and workbooks | |
| |
| |
| Displaying different views of worksheets | |
| |
| |
| Displaying multiple parts of a workbook | |
| |
| |
| Hiding and displaying workbook content | |
| |
| |
| Customizing the Quick Access Toolbar | |
| |
| |
| Customizing the ribbon | |
| |
| |
| Working with macros | |
| |
| |
| Modifying workbook properties | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Configure worksheets and workbooks to print or save | |
| |
| |
| Printing workbook content | |
| |
| |
| Saving workbooks | |
| |
| |
| Practice tasks | |
| |
| |
| Objective review | |
| |
| |
| |
| Manage cells and ranges | |
| |
| |
| |
| Insert data in cells and ranges | |
| |
| |
| Creating data | |
| |
| |
| Reusing data | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Format cells and ranges | |
| |
| |
| Formatting cell structure | |
| |
| |
| Formatting cell content | |
| |
| |
| Applying number formats | |
| |
| |
| Copying formatting | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Order and group cells and ranges | |
| |
| |
| Modeling data | |
| |
| |
| Creating named ranges | |
| |
| |
| Working with data groups and summaries | |
| |
| |
| Practice tasks | |
| |
| |
| Objective review | |
| |
| |
| |
| Manage tables | |
| |
| |
| |
| Create tables | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Modify tables | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Filter and sort tables | |
| |
| |
| Practice tasks | |
| |
| |
| Objective review | |
| |
| |
| |
| Apply formulas and functions | |
| |
| |
| |
| Utilize cell ranges and references in formulas and functions | |
| |
| |
| Referencing cells and cell ranges in formulas | |
| |
| |
| Defining order of operations | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Summarize data by using functions | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Utilize conditional logic in functions | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Format and modify text by using functions | |
| |
| |
| Practice tasks | |
| |
| |
| Objective review | |
| |
| |
| |
| Create charts and objects | |
| |
| |
| |
| Create charts | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Format charts | |
| |
| |
| Practice tasks | |
| |
| |
| |
| Insert and format objects | |
| |
| |
| Adding pictures to sheets | |
| |
| |
| Adding text boxes to sheets | |
| |
| |
| Adding SmartArt graphics to sheets | |
| |
| |
| Practice tasks | |
| |
| |
| Objective review | |
| |
| |
| Index | |
| |
| |
| About the author | |
| |
| |
| Survey page | |