Excel 2013 On Demand is built from the ground up for today's beginning-to-intermediate-level Exceluser. Like every book in the On Demand Series, it teaches visually, using an easy, friendly, full-color format designed to "show you how," instead of "telling you how." But that's not all. This book:
* Combines step-by-step training with quick-reference material users can rely on long after they've mastered the core skills they need
* Provides easy-to-follow task-based coverage of the techniques you'll use most often, presenting most tasks in just one or two pages
* Offers in-depth coverage of all new MCAS (Microsoft Certified Application Specialist) and MCAP (Microsoft Certified Application Professional) exam objectives, so you can use it as a study guide to enhance your job prospects or current career
* Provides additional end-of-chapter workshops, plus even more hands-on projects online
* Includes a complete practical troubleshooting guide
* Helps you upgrade by presenting New Feature icons, plus a detailed list of new features indexed to the pages where they're covered
Simply put, no other book offers beginning-to-intermediate-level Excelusers this much simplicity, usable content, flexibility, and value.
Product Description
Excel 2013 On Demand is built from the ground up for today's beginning-to-intermediate-level Exceluser. Like every book in the On Demand Series, it teaches visually, using an easy, friendly, full-color format designed to "show you how," instead of "telling you how." But that's not all. This book:
* Combines step-by-step training with quick-reference material users can rely on long after they've mastered the core skills they need
* Provides easy-to-follow task-based coverage of the techniques you'll use most often, presenting most tasks in just one or two pages
* Offers in-depth coverage of all new MOS (Microsoft Office Specialist) exam objectives, so you can use it as a study guide to enhance your job prospects or current career
* Provides additional end-of-chapter workshops, plus even more hands-on projects online
* Includes a complete practical troubleshooting guide
* Helps you upgrade by presenting New Feature icons, plus a detailed list of new features indexed to the pages where they're covered
Simply put, no other book offers beginning-to-intermediate-level Excelusers this much simplicity, usable content, flexibility, and value.
Backcover
Need answers quickly? Excel 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.
Inside the Book
• Create workbooks more efficiently using the improved Ribbon interface
• Use data-analysis tools and techniques for better decision making
• Use organizing, processing, and presenting tools to create and analyze data
• Integrate data from external sources and add hyperlinks
• Use conditional formatting and Sparklines to visualize results
• Add impact to your data with PivotTable and PivotChart reports
• Organize information and add impact with online clip art and pictures, SmartArt diagrams, tables, and charts
• Use SharePoint and SkyDrive to collaborate and share documents online
• Use the Excel Web App to view and edit documents in a browser
• Prepare for the Microsoft Office Specialist (MOS) exam
Numbered Steps guide you through each task
See Also points you to related information in the book
Did You Know? alerts you to tips and techniques
Illustrations with matching steps
Tasks are presented on one or two pages
Introduction xvii
1 Getting Started with Excel 1
Starting Excel 2 New!
Viewing the Excel Window 3 New!
Using the Ribbon 4 New!
Choosing Commands 5 New!
Working with the Ribbon and Toolbars 6
Choosing Dialog Box Options 8
Using the Status Bar 9
Creating a Blank Workbook 10 New!
Creating a Workbook Using a Template 11 New!
Opening an Existing Workbook 12 New!
Converting an Existing Workbook 14
Using Task and Window Panes 15
Moving Around the Workbook 16 New!
Arranging Windows 18 New!
Getting Help While You Work 20 New!
Saving a Workbook 22 New!
Saving a Workbook with Different Formats 24 New!
Saving a Workbook to Online Services 26 New!
Working with Accounts 27 New!
Checking Compatibility 28
Checking Accessibility 29
Documenting Workbook Properties 30
Switching Views 31
Recovering a Workbook 32
Closing a Workbook and Exiting Excel 34 New!
2 Basic Workbook Skills 35
Making Label Entries 36
Selecting Cells 37
Selecting Rows, Columns, and Special Ranges 38
Entering Labels on a Worksheet 40
Entering Values on a Worksheet 42
Entering Values Quickly with AutoFill 44
Inserting Content with Flash Fill 46 New!
Editing Cell Contents 48
Clearing Cell Contents 49
Understanding How Excel Pastes Data 50
Storing Cell Contents 51
Copying Cell Contents 52
Moving Cell Contents 54
Inserting and Deleting Cell Contents 56
Finding and Replacing Cell Contents 58
Correcting Cell Contents with AutoCorrect 60
Inserting Information the Smart Way 62
Checking Spelling 64
Changing Proofing Options 65
Using Custom Dictionaries 66
Inserting Symbols 68
Finding the Right Words 69
Inserting Research Material 70
Translating Text to Another Language 71
Using Multiple Languages 72
Work with Touch Screens 73 New!
Undoing and Redoing an Action 74
3 Working with Formulas and Functions 75
Understanding Formulas 76
Creating a Simple Formula 78
Creating a Formula Using Formula AutoComplete 80
Editing a Formula 82
Understanding Cell Referencing 84
Using Absolute Cell References 85
Using Mixed Cell References 86
Using 3-D Cell References 87
Naming Cells and Ranges 88
Entering Named Cells and Ranges 90
Managing Names 92
Simplifying a Formula with Ranges 94
Displaying Calculations with the Status Bar 95
Calculating Totals with AutoSum 96
Calculating Totals with Quick Analysis 98 New!
Performing One Time Calculations 100
Converting Formulas and Values 102
Correcting Calculation Errors 103
Correcting Formulas 104
Auditing a Worksheet 106
Locating Circular References 107
Performing Calculations Using Functions 108
Creating Functions 109
Creating Functions Using the Library 110 New!
Calculating Multiple Results 111
Using Nested Functions 112
Using Constants and Functions in Names 114
4 Modifying Worksheets and Workbooks 115
Selecting and Naming a Worksheet 116
Inserting and Deleting a Worksheet 117
Moving and Copying a Worksheet 118
Hiding and Unhiding Worksheets and Workbooks 120
Selecting a Column or Row 122
Hiding and Unhiding a Column or Row 123
Inserting a Column or Row 124
Deleting a Column or Row 125
Adjusting Column Width and Row Height 126
Freezing and Unfreezing a Column or Row 128
Splitting a Worksheet into Panes 129
Showing and Hiding Workbook Elements 130
Zooming the View In and Out 131
Creating Custom Views 132
Setting Up for Personal Templates 133 New!
Creating a Personal Template 134 New!
Opening a Template 135 New!
Changing a Template 136 New!
5 Formatting a Worksheet 137
Formatting Numbers 138
Formatting Text 140
Applying Conditional Formatting 142 New!
Applying Specialized Conditional Formatting 144 New!
Creating Conditional Formatting 146
Clearing Conditional Formatting 147
Managing Conditional Formatting 148
Finding Conditional Formatting 149
Creating Sparkline Formatting 150 New!
Changing Data Alignment 152
Controlling Text Flow 154
Changing Data Color 155
Adding Color and Patterns to Cells 156
Adding Custom Colors 157
Adding Borders to Cells 158
Formatting Tabs and Background 160 New!
Copying Cell Formats 161
Understanding Color Themes 162
Viewing and Applying a Theme 163
Creating Theme Colors 164
Choosing Theme Fonts 166
Choosing Theme Effects 168
Creating a Custom Theme 169
Choosing a Custom Theme 170
Applying and Creating Cell Styles 172
Modifying a Cell Style 174
Finding and Replacing Cell Formatting 176
6 Viewing and Printing Worksheets and Workbooks 177
Setting Up the Page 178
Adjusting Page Margins 180
Adding Headers and Footers 182
Inserting Page Breaks 184
Customizing Worksheet Printing 186
Setting the Print Area 188
Previewing a Worksheet 189
Printing a Worksheet and Workbook 190
Creating a PDF Document 191
Creating an XPS Document 192
7 Inserting and Modifying Graphics 193
Locating and Inserting Online Pictures 194 New!
Inserting Pictures from an Online Service 196 New!
Inserting Pictures from a SkyDrive or SharePoint 198 New!
Inserting a Picture from a File 199
Inserting a Picture Screen Shot 200
Adding an Artistic Style to a Picture 201
Adding a Quick Style to a Picture 202
Applying a Shape to a Picture 203
Applying a Border to a Picture 204
Applying Picture Effects 205 New!
Modifying Picture Size 206 New!
Compressing a Picture 208
Correcting a Picture 209 New!
Recoloring a Picture 210
Cropping and Rotating a Picture 212
Removing a Picture Background 214
Creating WordArt Text 215
Formatting WordArt Text 216
Applying WordArt Text Effects 218
Modifying WordArt Text Position 219 New!
Creating SmartArt Graphics 220
Using the Text Pane with SmartArt Graphics 222
Modifying a SmartArt Graphic 224
Resizing a SmartArt Graphic 225
Formatting a SmartArt Graphic 226
Formatting a Shape in a SmartArt Graphic 228
Adding Pictures to a SmartArt Graphic 230
Creating an Organization Chart 231
Modifying an Organization Chart 232
8 Drawing and Modifying Shapes 233
Drawing and Resizing Shapes 234
Inserting Multiple Shapes 236
Adding Text to a Shape 237
Drawing Lines and Arrows 238 New!
Creating and Editing Freeforms 240
Copying and Moving Objects 241
Adding a Quick Style to a Shape 242 New!
Adding a Quick Style to Shape Text 243
Applying Color Fills 244 New!
Applying Picture Fills 246 New!
Applying Texture Fills 247 New!
A
Need answers quickly? Excel 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.
Inside the Book
- Create workbooks more efficiently using the improved Ribbon interface
- Use data-analysis tools and techniques for better decision making
- Use organizing, processing, and presenting tools to create and analyze data
- Integrate data from external sources and add hyperlinks
- Use conditional formatting and Sparklines to visualize results
- Add impact to your data with PivotTable and PivotChart reports
- Organize information and add impact with online clip art and pictures, SmartArt diagrams, tables, and charts
- Use SharePoint and SkyDrive to collaborate and share documents online
- Use the Excel Web App to view and edit documents in a browser
- Prepare for the Microsoft Office Specialist (MOS) exam
Numbered Steps guide you through each task
See Also points you to related information in the book
Did You Know? alerts you to tips and techniques
Illustrations with matching steps
Tasks are presented on one or two pages
* Combines step-by-step training with quick-reference material users can rely on long after they've mastered the core skills they need
* Provides easy-to-follow task-based coverage of the techniques you'll use most often, presenting most tasks in just one or two pages
* Offers in-depth coverage of all new MCAS (Microsoft Certified Application Specialist) and MCAP (Microsoft Certified Application Professional) exam objectives, so you can use it as a study guide to enhance your job prospects or current career
* Provides additional end-of-chapter workshops, plus even more hands-on projects online
* Includes a complete practical troubleshooting guide
* Helps you upgrade by presenting New Feature icons, plus a detailed list of new features indexed to the pages where they're covered
Simply put, no other book offers beginning-to-intermediate-level Excelusers this much simplicity, usable content, flexibility, and value.
Product Description
Excel 2013 On Demand is built from the ground up for today's beginning-to-intermediate-level Exceluser. Like every book in the On Demand Series, it teaches visually, using an easy, friendly, full-color format designed to "show you how," instead of "telling you how." But that's not all. This book:
* Combines step-by-step training with quick-reference material users can rely on long after they've mastered the core skills they need
* Provides easy-to-follow task-based coverage of the techniques you'll use most often, presenting most tasks in just one or two pages
* Offers in-depth coverage of all new MOS (Microsoft Office Specialist) exam objectives, so you can use it as a study guide to enhance your job prospects or current career
* Provides additional end-of-chapter workshops, plus even more hands-on projects online
* Includes a complete practical troubleshooting guide
* Helps you upgrade by presenting New Feature icons, plus a detailed list of new features indexed to the pages where they're covered
Simply put, no other book offers beginning-to-intermediate-level Excelusers this much simplicity, usable content, flexibility, and value.
Backcover
Need answers quickly? Excel 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.
Inside the Book
• Create workbooks more efficiently using the improved Ribbon interface
• Use data-analysis tools and techniques for better decision making
• Use organizing, processing, and presenting tools to create and analyze data
• Integrate data from external sources and add hyperlinks
• Use conditional formatting and Sparklines to visualize results
• Add impact to your data with PivotTable and PivotChart reports
• Organize information and add impact with online clip art and pictures, SmartArt diagrams, tables, and charts
• Use SharePoint and SkyDrive to collaborate and share documents online
• Use the Excel Web App to view and edit documents in a browser
• Prepare for the Microsoft Office Specialist (MOS) exam
Numbered Steps guide you through each task
See Also points you to related information in the book
Did You Know? alerts you to tips and techniques
Illustrations with matching steps
Tasks are presented on one or two pages
Introduction xvii
1 Getting Started with Excel 1
Starting Excel 2 New!
Viewing the Excel Window 3 New!
Using the Ribbon 4 New!
Choosing Commands 5 New!
Working with the Ribbon and Toolbars 6
Choosing Dialog Box Options 8
Using the Status Bar 9
Creating a Blank Workbook 10 New!
Creating a Workbook Using a Template 11 New!
Opening an Existing Workbook 12 New!
Converting an Existing Workbook 14
Using Task and Window Panes 15
Moving Around the Workbook 16 New!
Arranging Windows 18 New!
Getting Help While You Work 20 New!
Saving a Workbook 22 New!
Saving a Workbook with Different Formats 24 New!
Saving a Workbook to Online Services 26 New!
Working with Accounts 27 New!
Checking Compatibility 28
Checking Accessibility 29
Documenting Workbook Properties 30
Switching Views 31
Recovering a Workbook 32
Closing a Workbook and Exiting Excel 34 New!
2 Basic Workbook Skills 35
Making Label Entries 36
Selecting Cells 37
Selecting Rows, Columns, and Special Ranges 38
Entering Labels on a Worksheet 40
Entering Values on a Worksheet 42
Entering Values Quickly with AutoFill 44
Inserting Content with Flash Fill 46 New!
Editing Cell Contents 48
Clearing Cell Contents 49
Understanding How Excel Pastes Data 50
Storing Cell Contents 51
Copying Cell Contents 52
Moving Cell Contents 54
Inserting and Deleting Cell Contents 56
Finding and Replacing Cell Contents 58
Correcting Cell Contents with AutoCorrect 60
Inserting Information the Smart Way 62
Checking Spelling 64
Changing Proofing Options 65
Using Custom Dictionaries 66
Inserting Symbols 68
Finding the Right Words 69
Inserting Research Material 70
Translating Text to Another Language 71
Using Multiple Languages 72
Work with Touch Screens 73 New!
Undoing and Redoing an Action 74
3 Working with Formulas and Functions 75
Understanding Formulas 76
Creating a Simple Formula 78
Creating a Formula Using Formula AutoComplete 80
Editing a Formula 82
Understanding Cell Referencing 84
Using Absolute Cell References 85
Using Mixed Cell References 86
Using 3-D Cell References 87
Naming Cells and Ranges 88
Entering Named Cells and Ranges 90
Managing Names 92
Simplifying a Formula with Ranges 94
Displaying Calculations with the Status Bar 95
Calculating Totals with AutoSum 96
Calculating Totals with Quick Analysis 98 New!
Performing One Time Calculations 100
Converting Formulas and Values 102
Correcting Calculation Errors 103
Correcting Formulas 104
Auditing a Worksheet 106
Locating Circular References 107
Performing Calculations Using Functions 108
Creating Functions 109
Creating Functions Using the Library 110 New!
Calculating Multiple Results 111
Using Nested Functions 112
Using Constants and Functions in Names 114
4 Modifying Worksheets and Workbooks 115
Selecting and Naming a Worksheet 116
Inserting and Deleting a Worksheet 117
Moving and Copying a Worksheet 118
Hiding and Unhiding Worksheets and Workbooks 120
Selecting a Column or Row 122
Hiding and Unhiding a Column or Row 123
Inserting a Column or Row 124
Deleting a Column or Row 125
Adjusting Column Width and Row Height 126
Freezing and Unfreezing a Column or Row 128
Splitting a Worksheet into Panes 129
Showing and Hiding Workbook Elements 130
Zooming the View In and Out 131
Creating Custom Views 132
Setting Up for Personal Templates 133 New!
Creating a Personal Template 134 New!
Opening a Template 135 New!
Changing a Template 136 New!
5 Formatting a Worksheet 137
Formatting Numbers 138
Formatting Text 140
Applying Conditional Formatting 142 New!
Applying Specialized Conditional Formatting 144 New!
Creating Conditional Formatting 146
Clearing Conditional Formatting 147
Managing Conditional Formatting 148
Finding Conditional Formatting 149
Creating Sparkline Formatting 150 New!
Changing Data Alignment 152
Controlling Text Flow 154
Changing Data Color 155
Adding Color and Patterns to Cells 156
Adding Custom Colors 157
Adding Borders to Cells 158
Formatting Tabs and Background 160 New!
Copying Cell Formats 161
Understanding Color Themes 162
Viewing and Applying a Theme 163
Creating Theme Colors 164
Choosing Theme Fonts 166
Choosing Theme Effects 168
Creating a Custom Theme 169
Choosing a Custom Theme 170
Applying and Creating Cell Styles 172
Modifying a Cell Style 174
Finding and Replacing Cell Formatting 176
6 Viewing and Printing Worksheets and Workbooks 177
Setting Up the Page 178
Adjusting Page Margins 180
Adding Headers and Footers 182
Inserting Page Breaks 184
Customizing Worksheet Printing 186
Setting the Print Area 188
Previewing a Worksheet 189
Printing a Worksheet and Workbook 190
Creating a PDF Document 191
Creating an XPS Document 192
7 Inserting and Modifying Graphics 193
Locating and Inserting Online Pictures 194 New!
Inserting Pictures from an Online Service 196 New!
Inserting Pictures from a SkyDrive or SharePoint 198 New!
Inserting a Picture from a File 199
Inserting a Picture Screen Shot 200
Adding an Artistic Style to a Picture 201
Adding a Quick Style to a Picture 202
Applying a Shape to a Picture 203
Applying a Border to a Picture 204
Applying Picture Effects 205 New!
Modifying Picture Size 206 New!
Compressing a Picture 208
Correcting a Picture 209 New!
Recoloring a Picture 210
Cropping and Rotating a Picture 212
Removing a Picture Background 214
Creating WordArt Text 215
Formatting WordArt Text 216
Applying WordArt Text Effects 218
Modifying WordArt Text Position 219 New!
Creating SmartArt Graphics 220
Using the Text Pane with SmartArt Graphics 222
Modifying a SmartArt Graphic 224
Resizing a SmartArt Graphic 225
Formatting a SmartArt Graphic 226
Formatting a Shape in a SmartArt Graphic 228
Adding Pictures to a SmartArt Graphic 230
Creating an Organization Chart 231
Modifying an Organization Chart 232
8 Drawing and Modifying Shapes 233
Drawing and Resizing Shapes 234
Inserting Multiple Shapes 236
Adding Text to a Shape 237
Drawing Lines and Arrows 238 New!
Creating and Editing Freeforms 240
Copying and Moving Objects 241
Adding a Quick Style to a Shape 242 New!
Adding a Quick Style to Shape Text 243
Applying Color Fills 244 New!
Applying Picture Fills 246 New!
Applying Texture Fills 247 New!
A
Need answers quickly? Excel 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.
Inside the Book
- Create workbooks more efficiently using the improved Ribbon interface
- Use data-analysis tools and techniques for better decision making
- Use organizing, processing, and presenting tools to create and analyze data
- Integrate data from external sources and add hyperlinks
- Use conditional formatting and Sparklines to visualize results
- Add impact to your data with PivotTable and PivotChart reports
- Organize information and add impact with online clip art and pictures, SmartArt diagrams, tables, and charts
- Use SharePoint and SkyDrive to collaborate and share documents online
- Use the Excel Web App to view and edit documents in a browser
- Prepare for the Microsoft Office Specialist (MOS) exam
Numbered Steps guide you through each task
See Also points you to related information in the book
Did You Know? alerts you to tips and techniques
Illustrations with matching steps
Tasks are presented on one or two pages