Microsoft Excel 2016 Step by Step

This is learning made easy. Students will get productive fast with Excel 2016 and jump in wherever they need answers--brisk lessons and colorful screen shots show them exactly what to do, step by step.

Auteur
Curtis Frye is the author of more than 30 books, including Microsoft Excel 2013 Step by Step for Microsoft Press and Brilliant Excel VBA Programming for Pearson, UK. He has also created and recorded more than three dozen courses for lynda.com, including Excel for Mac 2016 Essential Training and Excel 2013: PivotTables in Depth. In addition to his work as a writer, Curt is a popular conference speaker and performer, both as a solo presenter and as part of the Portland, Oregon ComedySportz improvisational comedy troupe. He lives in Portland with his wife and three cats.

Résumé

Now in full color!

The quick way to learn Microsoft Excel 2016!

This is learning made easy. Get more done quickly with Excel 2016. Jump in wherever you need answers--brisk lessons and full-color screen shots show you exactly what to do, step by step.

• Quickly set up workbooks, enter data, and format it for easier viewing
• Perform calculations and find and correct errors
• Filter, sort, summarize, and combine data
• Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver
• Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps
• Build data models and use them in business intelligence analyses
• Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps
• Look up just the tasks and lessons you need

Contenu
Introduction xiii
Who this book is for xiii
The Step by Step approach xiii
Download the practice files xiv
Sidebar: Adapt exercise steps xviii
Ebook edition xx
Get support and give feedback xx
Errata and support xx
We want to hear from you xx
Stay in touch xx
**Part 1: Create and format workbooks
Chapter 1: Set up a workbook 3
Explore the editions of Excel 2016 4
Excel 2016 4
Excel Online 4
Excel Mobile Apps 5
Become familiar with new features in Excel 2016 6
Create workbooks 7
Modify workbooks 13
Modify worksheets 18
Merge and unmerge cells 23
Customize the Excel 2016 app window 26
Zoom in on a worksheet 26
Arrange multiple workbook windows 28
Add buttons to the Quick Access Toolbar 30
Customize the ribbon 33
Skills review 39
Practice tasks 40
Chapter 2: Work with data and Excel tables 43
Enter and revise data 44
Manage data by using Flash Fill 48
Move data within a workbook 51
Find and replace data 56
Correct and expand upon data 60
Define Excel tables 65
Skills review 69
Practice tasks 70
Chapter 3: Perform calculations on data 73
Name groups of data 74
Create formulas to calculate values 77
Sidebar: Operators and Precedence 88
Summarize data that meets specific conditions 90
Set iterative calculation options and enable or disable automatic calculation 96
Use array formulas 98
Find and correct errors in calculations 100
Skills review 106
Practice tasks 107
Chapter 4: Change workbook appearance 111
Format cells 112
Define styles 118
Apply workbook themes and Excel table styles 121
Make numbers easier to read 127
Change the appearance of data based on its value 130
Add images to worksheets 138
Skills review 142
Practice tasks 143
**Part 2: Analyze and present data
Chapter 5: Manage worksheet data 147
Limit data that appears on your screen 148
Manipulate worksheet data 153
Sidebar: Select list rows at random 154
Summarize data in worksheets that have hidden and filtered rows 155
Find unique values within a data set 161
Define valid sets of values for ranges of cells 163
Skills review 165
Practice tasks 166
Chapter 6: Reorder and summarize data 169
Sort worksheet data 170
Sort data by using custom lists 176
Organize data into levels 179
Look up information in a worksheet 184
Skills review 187
Practice tasks 188
Chapter 7: Combine data from multiple sources 191
Use workbooks as templates for other workbooks 192
Link to data in other worksheets and workbooks 197
Consolidate multiple sets of data into a single workbook 202
Skills review 205
Practice tasks 206
Chapter 8: Analyze alternative data sets 209
Examine data by using the Quick Analysis Lens 210
Define an alternative data set 212
Define multiple alternative data sets 216
Analyze data by using data tables 218
Vary your data to get a specific result by using Goal Seek 221
Find optimal solutions by using Solver 223
Analyze data by using descriptive statistics 229
Skills review 231
Practice tasks 232
Chapter 9: Create charts and graphics 237
Create charts 238
Create new types of charts 248
Customize chart appearance 252
Find trends in your data 260
Create dual-axis charts 263
Summarize your data by using sparklines 264
Create diagrams by using SmartArt 266
Create shapes and mathematical equations 271
Skills review 277
Practice tasks 278
Chapter 10: Create dynamic worksheets by using PivotTables 281
Analyze data dynamically by using PivotTables 282
Filter, show, and hide PivotTable data 290
Edit PivotTables&…