Excel 2016 in depth
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Indianapolis, Indiana
Que
[2016]
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV043377909 | ||
| 003 | DE-604 | ||
| 005 | 20160415 | ||
| 007 | t| | ||
| 008 | 160219s2016 xx a||| |||| 00||| eng d | ||
| 015 | |a GBB5B9906 |2 dnb | ||
| 020 | |a 9780789755841 |9 978-0-7897-5584-1 | ||
| 035 | |a (OCoLC)957968295 | ||
| 035 | |a (DE-599)BVBBV043377909 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1102 | ||
| 100 | 1 | |a Jelen, Bill |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Excel 2016 in depth |c Bill Jelen |
| 264 | 1 | |a Indianapolis, Indiana |b Que |c [2016] | |
| 300 | |b illustrations | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Includes index | ||
| 650 | 4 | |a Microsoft Excel (Computer file) | |
| 650 | 7 | |a Microsoft Excel (Computer file) |2 fast | |
| 650 | 4 | |a Electronic spreadsheets / Computer programs | |
| 650 | 7 | |a Electronic spreadsheets / Computer programs |2 fast | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028796670&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-028796670 | |
Datensatz im Suchindex
| _version_ | 1819771668512374784 |
|---|---|
| adam_text | Titel: Excel 2016 in depth
Autor: Jelen, Bill
Jahr: 2016
CONTENTS
Introduction 1
I The Excel Interface
1 What s New in Excel 2016
(and 2013) 5
Color Returns to the Excel Interface 5
The Data Model from Excel 2013 Is the Most
Important Feature in 2016 6
Clean Your Data with Power Query 7
Pivot Your Data on a Map with 3D Maps 8
View Your Data Using Six New Chart
Types 8
Forecast the Future Using a Forecast
Sheet 9
Important Features from Excel 2013 10
Displaying Two Workbooks on Two
Monitors 10
Dismissing the Start Screen
Permanently 10
Using the Subscription Model of Office
365 10
Using the Cloud for Storage and
More 11
Relying on the Cloud 11
Oddities Added to Excel 2016 11
Handwriting Equations 11
Touchable Slicers 12
Search the Internet from Excel 13
Find a Ribbon Command if You Know
the Exact Name of the Command 13
2 Using the Excel Interface 15
Using the Ribbon 15
Using Fly-out Menus and Galleries 15
Rolling Through the Ribbon Tabs 16
Revealing More Commands Using Dialog
Launchers, Task Panes, and More
Commands 16
Resizing Excel Changes the Ribbon 17
Activating the Developer Tab 17
Activating Contextual Ribbon Tabs 18
Finding Lost Commands on the
Ribbon 18
Shrinking the Ribbon 20
Using the Quick Access Toolbar 20
Adding Icons to the OAT 20
Removing Commands from the QAT 21
Customizing the QAT 21
Using the Full-Screen File Menu 23
Pressing the Esc Key to Close Backstage
View 24
Recovering Unsaved Workbooks 24
Clearing the Recent Workbooks List 24
Getting Information About the Current
Workbook 24
Marking a Workbook as Final to Prevent
Editing 25
Finding Hidden Content Using the
Document Inspector 25
Adding Whitespace Around Icons Using
Touch Mode 26
Previewing Paste Using the Paste
Options Gallery 26
Accessing the Gallery After Performing a
Paste Operation 27
Accessing the Paste Options Gallery
from the Right-Click Menu 28
Using the New Sheet Icon to Add
Worksheets 29
Navigating Through Many Worksheets
Using the Controls in the Lower Left 29
Using the Mini Toolbar to Format Selected
Text 29
Expanding the Formula Bar 30
Zooming In and Out on a Worksheet 31
Using the Status Bar to Add Numbers 31
Switching Between Normal View, Page
Break Preview, and Page Layout View
Modes 32
3 Customizing Excel 33
Performing a Simple Ribbon
Modification 33
Adding a New Ribbon Tab 35
Sharing Customizations with Others 36
Questions About Ribbon Customization 36
Introducing the Excel Options Dialog 37
Getting Help with a Setting 38
New Options in Excel 2016 38
Using AutoRecover Options 38
Controlling Image Sizes 39
Working with Protected View for Files
Originating from the Internet 39
Working with Trusted Document
Settings 39
Options to Consider 40
Five Excel Oddities 41
4 Keyboard Shortcuts 43
Using Keyboard Accelerators 43
Selecting Icons on the Ribbon 44
Selecting Options from a Gallery 45
Navigating Within Drop-Down Lists 46
Backing Up One Level Through a
Menu 46
Dealing with Keyboard Accelerator
Confusion 46
Selecting from Legacy Dialog Boxes 46
Using the Shortcut Keys 47
Using My Favorite Shortcut Keys 56
Quickly Move Between Worksheets 56
Jumping to the Bottom of Data with
Ctrl+Arrow 56
Selecting the Current Region with
Ctrl+* 56
Jumping to the Next Corner of a
Selection 56
Pop Open the Right-Click Menu Using
Shift+FlO 56
Crossing Tasks Off Your List with
Ctrl+5 56
Date Stamp or Time Stamp Using Ctrl*,
or Ctrl+: 57
Repeating the Last Task with F4 57
Adding Dollar Signs to a Reference with
F4 57
Choosing Items from a Sheer 57
Finding the One Thing That Takes You
Too Much Time 57
Using Excel 2003 Keyboard
Accelerators 58
Invoking an Excel 2003 Alt Shortcut 58
Determining Which Commands Work in
Legacy Mode 59
II Calculating with Excel
5 Understanding Formulas 69
Getting the Most from This Chapter 69
Introduction to Formulas 70
Formulas Versus Values 70
Entering Your First Formula 71
Building a Formula 71
The Relative Nature of Formulas 72
Overriding Relative Behavior: Absolute
Cell References 72
Using Mixed References to Combine
Features of Relative and Absolute
References 74
Using the F4 Key to Simplify Dollar Sign
Entry 75
Using F4 After a Formula Is Entered 76
Using F4 on a Rectangular Range 76
Three Methods of Entering Formulas 77
Enter Formulas Using the Mouse
Method 78
Entering Formulas Using the Arrow Key
Method 78
Entering the Same Formula in Many
Cells 80
Copying a Formula by Using
Ctrl+Enter 80
Copying a Formula by Dragging the Fill
Handle 81
Double-Click the Fill Handle to Copy a
Formula 82
Use the Table Tool to Copy a Formula 82
6 Controlling Formulas 85
Formula Operators 85
Order of Operations 86
Unary Minus Example 86
Addition and Multiplication Example 87
Stacking Multiple Parentheses 87
Understanding Error Messages in
Formulas 88
Using Formulas to Join Text 90
Joining Text and a Number 90
Copying Versus Cutting a Formula 91
Automatically Formatting Formula Cells 92
Using Date Math 92
Troubleshooting Formulas 93
Seeing All Formulas 93
Highlighting All Formula Cells 94
Editing a Single Formula to Show Direct
Precedents 94
Using Formula Auditing Arrows 94
Tracing Dependents 95
Using the Watch Window 96
Evaluate a Formula in Slow Motion 96
Evaluating Part of a Formula 97
7 Understanding Functions 99
Working with Functions 99
The Formulas Tab in Excel 2016 100
Finding the Function You Need 101
Using Tab to AutoComplete
Functions 101
Using the Insert Function Dialog to Find
Functions 102
Getting Help with Excel Functions 102
Using On-Grid ToolTips 103
Using the Function Arguments
Dialog 103
Using Excel Help 104
Using AutoSum 105
Potential Problems with AutoSum 106
Special Tricks with AutoSum 107
Using AutoAverage or AutoCount 108
Function Reference Chapters 109
8 Using Everyday Functions:
Math, Date and Time, and Text
Functions 111
Math Functions 111
Date and Time Functions 114
Text Functions 116
Examples of Math Functions 119
Using SUM to Add Numbers 119
Using AGGREGATE to Ignore Error Cells
or Filtered Rows 121
Rounding Numbers 124
Using SUBTOTAL Instead of SUM with
Multiple Levels of Totals 126
Totaling Visible Cells Using
SUBTOTAL 127
Using RAND and RANDBETWEEN to
Generate Random Numbers and
Data 128
Using = ROMAN () to Finish Movie Credits
and =ARABIC() to Convert Back to
Digits 130
Using ABB () to Figure Out the
Magnitude of Error 130
Using GOD and LCM to Perform Seventh-
Grade Math 131
Using MOD to Find the Remainder Portion
of a Division Problem 131
Using SORT and POWER to Calculate
Square Roots and Exponents 133
Using COUNT!F, AVERAGEIF, and SUMIF
to Conditionally Count, Average, or Sum
Data 133
Using Conditional Formulas with
Multiple Conditions: SUMIFS(),
AVERAGEIFS(), and C0UNTIFS() 136
Dates and Times in Excel 137
Understanding Excel Date and Time
Formats 139
Examples of Date and Time Functions 142
Using NOW and TODAY to Calculate
the Current Date and Time or Current
Date 142
Using YEAR, MONTH, DAY, HOUR, MINUTE,
and SECOND to Break a Date/Time
Apart 143
Using DATE to Calculate a Date from
Year, Month, and Day 144
Using TIME to Calculate a Time 146
Using DATEVALUE to Convert Text Dates
to Real Dates 147
Using TIMEVALUE to Convert Text Times
to Real Times 148
Using WEEKDAY to Group Dates by Day of
the Week 149
Using WEEKNUM or IS0WEEKNUM to Group
Dates into Weeks 150
Calculating Elapsed Time 151
Using E0M0NTH to Calculate the End of
the Month 154
Using WORKDAY or NETW0RKDAYS or Their
International Equivalents to Calculate
Workdays 154
Using International Versions of WORKDAY
or NETWORKDAYS 156
Examples of Text Functions 157
Joining Text with the Ampersand ( )
Operator 158
Using LOWER, UPPER, or PROPER to
Convert Text Case 158
Using TRIM to Remove Leading and
Trailing Spaces 160
Using the CHAR or UN I CHAR Function to
Generate Any Character 162
Using the CODE or UNICODE Function
to Learn the Character Number for Any
Character 164
Using LEFT, MID, or RIGHT to Split
Text 165
Using LEN to Find the Number of
Characters in a Text Cell 167
Using SEARCH or FIND to Locate
Characters in a Particular Cell 168
Using SUBSTITUTE to Replace
Characters 171
Using REPT to Repeat Text Multiple
Times 171
Using EXACT to Test Case 173
Using TEXT to Format a Number as
Text 173
Using the T and VALUE Functions 175
9 Using Powerful Functions:
Logical, Lookup, Web, and
Database Functions 177
Examples of Logical Functions 183
Using the IF Function to Make a
Decision 183
Using the AND Function to Check for Two
or More Conditions 184
Using OR to Check Whether One or More
Conditions Are Met 185
Using the NOT Function to Simplify the
Use of AND and OR 186
Using the IFERROR or IFNA Function to
Simplify Error Checking 187
Examples of Information Functions 188
Using the ISFORMULA Function with
Conditional Formatting to Mark Formula
Cells 188
Using IS Functions to Test for Types of
Values 189
Using the N Function to Add a Comment
to a Formula 190
Using the NA Function to Force Charts to
Not Plot Missing Data 190
Using the CELL Function to Return the
Worksheet Name 191
Examples of Lookup and Reference
Functions 192
Using the CHOOSE Function for Simple
Lookups 192
Using VL00KUP with TRUE to Find a
Value Based on a Range 193
Using the MATCH Function to Locate the
Position of a Matching Value 198
Using INDEX and MATCH for a Left
Lookup 200
Using MATCH and INDEX to Fill a Wide
Table 202
Performing Many Lookups with
LOOKUP 203
Using F0RMULATEXT to Document a
Worksheet 204
Using Numbers with OFFSET to Describe
a Range 205
Using INDIRECT to Build and Evaluate
Cell References On the Fly 207
Using the HYPERLINK Function to
Quickly Add Hyperlinks 209
Using the TRANSPOSE Function to
Formulaically Turn Data 210
Using GETPIV0TDATA to Retrieve One
Cell from a Pivot Table 211
Examples of Database Functions 213
Using DSUM to Conditionally Sum
Records from a Database 214
Using the DGET Function 219
10 Other Functions 223
Web Functions 223
Financial Functions 223
Statistical Functions 228
Trigonometry Functions 240
Matrix Functions 241
Engineering Functions 242
11 Connecting Worksheets and
Workbooks 245
Connecting Two Worksheets 245
Creating Links Using the Paste Options
Menu 247
Creating Links Using the Right-Drag
Menu 249
Building a Link by Using the
Mouse 250
Links to External Workbooks Default to
Absolute References 251
Building a Formula by Typing 251
Creating Links to Unsaved
Workbooks 252
Using the Links Tab on the Trust
Center 252
Opening Workbooks with Links to
Closed Workbooks 253
Dealing with Missing Linked
Workbooks 253
Preventing the Update Links Dialog from
Appearing 254
12 Array Formulas and Names in
Excel 255
Advantages of Using Names 255
Naming a Cell by Using the Name
Dialog 257
Using the Name Box for Quick
Navigation 258
Avoiding Problems by Using Worksheet-
Level Scope 259
Defining a Worksheet-Level Name 259
Referring to Worksheet-Level
Names 260
Using Named Ranges to Simplify
Formulas 260
Retroactively Applying Names to
Formulas 261
Using Names to Refer to Ranges 261
Adding Many Names at Once from Existing
Labels and Headings 262
Using Intersection to Do a Two-Way
Lookup 263
Using Implicit Intersection 264
Using a Name to Avoid an Absolute
Reference 265
Using a Name to Hold a Value 266
Assigning a Formula to a Name 266
Using Power Formula Techniques 267
Using 3D Formulas to Spear Through
Many Worksheets 267
Referring to the Previous
Worksheet 269
Combining Multiple Formulas into One
Formula 270
Turning a Range of Formulas on Its
Side 273
Coercing a Range of Dates Using an
Array Formula 276
III Data Analysis with Excel
14 Summarizing Data Using
Subtotals or Filter 295
13 Transforming Data 279
Using Power Query 279
Specifying the Data Source 280
Transforming Data in Power Query 281
Unpivoting Data in Power Query 283
Correcting a Mistake in Power
Query 284
Adding Columns in Power Query 285
Reviewing the Query 286
Loading and Refreshing the Data 287
Cleaning Data with Flash Fill 288
Coaching Flash Fill with a Second
Example 288
Flash Fill Will Not Automatically Fill In
Numbers 288
Using Formatting with Dates 289
Troubleshooting Flash Fill 289
Sorting Data 289
Sorting by Color or Icon 290
Factoring Case into a Sort 290
Reordering Columns with a Left-to-Right
Sort 291
Sorting into a Unique Sequence by Using
Custom Lists 291
One-Click Sorting 292
Fixing Sort Problems 293
Discovering Interesting Things in Your Data
Using the Quick Analysis 293
Adding Automatic Subtotals 296
Working with the Subtotals 297
Showing a One-Page Summary with
Only the Subtotals 298
Sorting the Collapsed Subtotal View So
the Largest Customers Are on Top 298
Copying Only the Subtotal Rows 300
Formatting the Subtotal Rows 301
Removing Subtotals 302
Suhtotaling Multiple Fields 302
Filtering Records 303
Using a Filter 304
Selecting One or Multiple Items from the
Filter Drop-Down 305
Identifying Which Columns Have Filters
Applied 307
Combining Filters 307
Clearing Filters 307
Refreshing Filters 308
Resizing the Filter Drop-Down 308
Filtering by Selection—Hard Way 308
Filtering by Selection—Easy Way 309
Filtering by Color or Icon 310
Handling Date Filters 311
Using Special Filters for Dates, Text, and
Numbers 312
Totaling Filtered Results 314
Formatting and Copying Filtered
Results 314
Using the Advanced Filter Command 314
Advanced Filter Criteria 316
Using Remove Duplicates to Find Unique
Values 317
Combining Duplicates and Adding
Values 318
15 Using Pivot Tables to Analyze
Data 321
Creating Your First Pivot Table 322
Browsing Ten Recommended Pivot
Tables 323
Starting with a Blank Pivot Table 324
Adding Fields to Your Pivot Table Using
the Field List 325
Changing the Pivot Table Report by
Using the Field List 326
Dealing with the Compact Layout 328
Rearranging a Pivot Table 329
Finishing Touches: Numeric Formatting and
Removing Blanks 330
Four Things You Have to Know When Using
Pivot Tables 332
Your Pivot Table Is in Manual Calculation
Mode Until You Click Refresh! 332
One Blank Cell in a Value Column
Causes Excel to Count Instead of
Sum 332
If You Click Outside the Pivot Table, All
the Pivot Table Tools Disappear 332
You Cannot Change, Move a Part of, or
Insert Cells in a Pivot Table 333
Calculating and Roll-ups with Pivot
Tables 333
Grouping Daily Dates to Months and
Years 333
Adding Calculations Outside the Pivot
Table 336
Changing the Calculation of a Field 337
Showing Percentage of Total Using Show
Value As Settings 339
Showing Running Totals and Rank 340
Using a Formula to Add a Field to a
Pivot Table 341
Formatting a Pivot Table 342
Finding More Information on Pivot
Tables 343
16 Using Slicers and Filtering a
Pivot Table 345
Filtering Using the Row Label Filter 345
Clearing a Filter 348
Filtering Using the Check Boxes 348
Filtering Using the Label Filter
Fly-Out 349
Filtering Using the Date Filters 350
Filtering to the Top 10 350
Filtering Using Slicers 351
Adding Slicers 351
Arranging the Slicers 352
Using the Slicers in Excel 2016 353
Filtering Dates 353
Filtering Oddities 354
AutoFiltering a Pivot Table 354
Replicating a Pivot Table for Every
Customer 356
Sorting a Pivot Table 356
17 Mashing Up Data with
PowerPivot 357
Joining Multiple Tables Using the Data
Model 357
Preparing Data for Use in the Data
Model 357
Building a Pivot Table from the Data
Model 358
Adding the Second Table and Defining a
Relationship 359
Understanding the Limitations of the
Data Model 360
Benefits of Moving to PowerPivot 361
Count Distinct Using DAX 361
Date Intelligence Using DAX 362
Interactive Dashboards with Power
View 365
18 Using What-lf, Scenario
Manager, Goal Seek, and
Solver 367
Using What-lf 367
Creating a Two-Variable What-lf
Table 368
Modeling a Random Scenario Using a
Data Table 370
Using Scenario Manager 372
Creating a Scenario Summary
Report 375
Adding Multiple Scenarios 375
Using Goal Seek 375
Using Solver 377
Installing Solver 377
Solving a Model Using Solver 377
19 Automating Repetitive
Functions Using VBA
Macros 381
Checking Security Settings Before Using
Macros 381
Recording a Macro 382
Case Study: Macro for Formatting for a Mail
Merge 383
How Not to Record a Macro: The Default
State of the Macro Recorder 384
Relative References in Macro
Recording 385
Starting the Macro Recorder 386
Running a Macro 388
Everyday-Use Macro Example: Formatting
an Invoice Register 389
Using the Ctrl+Down-Arrow Key to
Handle a Variable Number of Rows 389
Making Sure You Find the Last
Record 390
Recording the Macro in a Blank
Workbook 390
Editing a Macro 391
Understanding VBA Code—An
Analogy 392
Comparing Object.Method to Nouns and
Verbs 393
Comparing Collections to Plural
Nouns 393
Comparing Parameters to Adverbs 393
Comparing Adjectives to Properties 396
Using the Analogy While Examining
Recorded Code 396
Using Simple Variables and Object
Variables 397
Using R1 CI-Style Formulas 398
Fixing AutoSum Errors in Macros 399
Customizing the Everyday-Use Macro
Example: GETOPENFILENAME and
GETSAVEASFILENAME 400
From-Scratch Macro Example: Loops, Flow
Control, and Referring to Ranges 401
Finding the Last Row with Data 402
Looping Through All Rows 402
Referring to Ranges 403 ~~
Combining a Loop with FinalRow 404
Making Decisions by Using Flow
Control 404
Putting Together the From-Scratch
Example: Testing Each Record in a
Loop 406
A Special Case: Deleting Some
Records 407
Combination Macro Example: Creating a
Report for Each Customer 409
Using the Advanced Filter for Unique
Records 411
Using AutoFilter 413
Selecting Visible Cells Only 414
Combination Macro Example: Putting It
All Together 415
20 More Tips and Tricks for Excel
2016 417
Watching the Results of a Distant Cell 417
Comparing Documents Side by Side with
Synchronous Scrolling 418
Calculating a Formula in Slow Motion 419
Inserting a Symbol in a Cell 420
Editing an Equation 420
Protecting a Worksheet 421
Separating Text Based on a Delimiter 421
Auditing Worksheets Using Inquire 422
IV Excel Visuals
21 Formatting Worksheets 425
Why Format Worksheets? 425
Using Traditional Formatting 427
Changing Numeric Formats by Using the
Home Tab 429
Changing Numeric Formats by Using
Built-in Formats in the Format Cells
Dialog 431
Using Numeric Formatting with
Thousands Separators 431
Displaying Currency 432
Displaying Dates and Times 432
Displaying Fractions 433
Displaying ZIP Codes, Telephone
Numbers, and Social Security
Numbers 433
Changing Numeric Formats Using
Custom Formats 434
Using the Four Zones of a Custom
Number Format 435
Controlling Text and Spacing in a
Custom Number Format 436
Controlling Decimal Places in a Custom
Number Format 436
Using Conditions and Color in a Custom
Number Format 437
Using Dates and Times in a Custom
Number Format 437
Displaying Scientific Notation in Custom
Number Formats 438
Aligning Cells 438
Changing Font Size 439
Changing Font Typeface 440
Applying Bold, Italic, and Underline 440
Using Borders 441
Coloring Cells 442
Adjusting Column Widths and Row
Heights 443
Using Merge and Center 444
Rotating Text 446
Formatting with Styles 447
Understanding Themes 450
Choosing a New Theme 451
Creating a New Theme 451
Reusing Another Theme s Effects 452
Saving a Custom Theme 453
Using a Theme on a New
Document 453
Sharing a Theme with Others 453
Other Formatting Techniques 453
Formatting Individual Characters 453
Changing the Default Font 454
Wrapping Text in a Cell 455
Justifying Text in a Range 456
Adding Cell Comments 457
Copying Formats 459
Pasting Formats 459
Pasting Conditional Formats 460
Using the Format Painter 460
Copying Formats to a New
Worksheet 461
22 Using Data Visualizations and
Conditional Formatting 463
Using Data Bars to Create In-Cell Bar
Charts 464
Creating Data Bars 465
Customizing Data Bars 466
Showing Data Bars for a Subset of
Cells 468
Using Color Scales to Highlight
Extremes 468
Using Icon Sets to Segregate Data 470
Setting Up an Icon Set 471
Moving Numbers Closer to Icons 472
Mixing Icons or Hiding Icons 473
Using the Top/Bottom Rules 474
Using the Highlight Cells Rules 475
Highlighting Cells by Using Greater
Than and Similar Rules 476
Comparing Dates by Using Conditional
Formatting 478
Identifying Duplicate or Unique Values
by Using Conditional Formatting 479
Using Conditional Formatting for Text
Containing a Value 480
Tweaking Rules with Advanced
Formatting 481
Using a Formula for Rules 483
Getting to the Formula Box 483
Working with the Formula Box 483
Finding Cells Within Three Days of
Today 484
Finding Cells Containing Data from the
Past 30 Days 484
Highlighting Data from Specific Days of
the Week 485
Highlighting an Entire Row 485
Highlighting Every Other Row Without
Using a Table 485
Combining Rules 486
Extending the Reach of Conditional
Formats 488
Special Considerations for Pivot Tables 489
23 Graphing Data Using Excel
Charts 491
Choosing from Recommended Charts 492
Using the Paintbrush Icon for
Styles 493
Deleting Extraneous Data Using the
Funnel 494
Changing Chart Options Using the Plus
Icon 494
Easy Combo Charts 495
Using the New Hierarchy Charts 496
Creating a Frequency Distribution with a
Histogram Chart 497
Describe the Statistics of a Data Set with a
Box and Whisker Chart 499
Showing Financial Data with a Waterfall
Chart 500
Saving Time with Charting Tricks 500
Adding New Data to a Chart by
Pasting 500
Dealing with Small Pie Slices 501
Saving a Favorite Chart Style As a
Template 502
24 Using 3D Maps 503
Examples of 3D Maps 503
Adding Color Information for
Categories 505
Zooming In 506
Animating Over Time 508
Going Ultra-Local 509
Getting Your Data into 3D Map 512
3D Map Techniques 514
Tipping, Rotating, and Zooming the
Map 514
Adding a Photo to a Point 515
Combining Layers 515
Changing Column Size or Color 516
Resizing the Various Panes 516
Adding a Satellite Photograph 516
Showing the Whole Earth 616
Understanding the Time Choices 516
Animating a Line Between Two
Points 517
Controlling Map Labels 517
Building a Tour and Creating a Video 518
Using an Alternate Map 519
Preparing the Store Image 519
Specifying a Custom Map 519
25 Using Sparklines 523
Fitting a Chart into the Size of a Cell with
Sparklines 523
Understanding How Excel Maps Data to
Sparklines 524
Creating a Group of Sparklines 526
Built-in Choices for Customizing
Sparklines 528
Controlling Axis Values for
Sparklines 529
Setting Up Win/Loss Sparklines 531
Showing Detail by Enlarging the
Sparkline and Adding Labels 532
Other Sparkline Options 535
26 Decorating Spreadsheets 537
Using SmartArt 538
Elements Common in Most
SmartArt 539
Inserting SmartArt 539
Changing Existing SmartArt to a New
Style 540
Adding Images to SmartArt 541
Special Considerations for Organizational
Charts and Hierarchical SmartArt 542
Using Shapes to Display Cell Contents 543
Working with Shapes 545
Using WordArt for Interesting Titles and
Headlines 545
Using Text Boxes to Flow Long Text
Passages 546
Using Pictures and Clip Art 547
Getting Your Picture into Excel 547
Inserting a Picture from Your
Computer 548
Inserting Multiple Pictures at Once 548
Inserting a Picture or Clip Art from
Online 548
Adjusting the Picture Using the Ribbon
Tab 550
Resizing the Picture to Fit 550
Adjusting the Brightness and
Contrast 552
Adding Interesting Effects Using the
Picture Styles Gallery 553
Applying Artistic Effects 554
Removing the Background 555
Reducing a Picture s File Size 557
Inserting Screen Clippings 557
Selecting and Arranging Pictures 558
27 Printing 561
Printing in One Click 561
Finding Print Settings 562
Previewing the Printed Report 565
Using the Print Preview on the Print
Panel 565
Using Full Screen Print Preview 566
Making the Report Fit on the Page 566
Setting Worksheet Paper Size 566
Adjusting Worksheet Orientation 567
Adjusting Worksheet Margins 567
Repeating the Headings on Each
Page 567
Excluding Part of Your Worksheet from
the Print Range 568
Forcing More Data to Fit on a Page 569
Working with Page Breaks 569
Manually Adding Page Breaks 569
Manual Versus Automatic Page
Breaks 570
Using Page Break Preview to Make
Changes 570
Removing Manual Page Breaks 570
Adding Headers or Footers to the Printed
Report 571
Adding an Automatic Header 571
Adding a Custom Header 572
Inserting a Picture or a Watermark in a
Header 572
Using Different Headers and Footers in
the Same Document 573
Scaling Headers and Footers 574
Printing from the File Menu 574
Choosing a Printer 575
Choosing What to Print 575
Changing Printer Properties 576
Changing Some of the Page Setup
Settings 576
Using Page Layout View 576
Exploring Other Page Setup Options 577
Printing Gridlines and Headings 577
Centering a Small Report on a Page 577
Replacing Error Values When
Printing 577
Printing Comments 578
Controlling the First Page Number 578
28 Excel Online 579
Accessing Your OneDrive Workbooks from
Anywhere 580
Understanding the Limitations of Excel
Online 580
Group Editing Using Excel Online 583
Designing a Workbook as an Interactive
Web Page 584
Sharing a Link to Your Web
Workbook 586
Collecting Survey Data in Excel Online 586
Creating a PDF from a Worksheet 589
Index 591
|
| any_adam_object | 1 |
| author | Jelen, Bill |
| author_facet | Jelen, Bill |
| author_role | aut |
| author_sort | Jelen, Bill |
| author_variant | b j bj |
| building | Verbundindex |
| bvnumber | BV043377909 |
| ctrlnum | (OCoLC)957968295 (DE-599)BVBBV043377909 |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01218nam a2200337 c 4500</leader><controlfield tag="001">BV043377909</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20160415 </controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">160219s2016 xx a||| |||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB5B9906</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780789755841</subfield><subfield code="9">978-0-7897-5584-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)957968295</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043377909</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1102</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Jelen, Bill</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Excel 2016 in depth</subfield><subfield code="c">Bill Jelen</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Indianapolis, Indiana</subfield><subfield code="b">Que</subfield><subfield code="c">[2016]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Microsoft Excel (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Electronic spreadsheets / Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Electronic spreadsheets / Computer programs</subfield><subfield code="2">fast</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028796670&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028796670</subfield></datafield></record></collection> |
| id | DE-604.BV043377909 |
| illustrated | Illustrated |
| indexdate | 2024-12-24T04:53:00Z |
| institution | BVB |
| isbn | 9780789755841 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028796670 |
| oclc_num | 957968295 |
| open_access_boolean | |
| owner | DE-1102 |
| owner_facet | DE-1102 |
| physical | illustrations |
| publishDate | 2016 |
| publishDateSearch | 2016 |
| publishDateSort | 2016 |
| publisher | Que |
| record_format | marc |
| spellingShingle | Jelen, Bill Excel 2016 in depth Microsoft Excel (Computer file) Microsoft Excel (Computer file) fast Electronic spreadsheets / Computer programs Electronic spreadsheets / Computer programs fast |
| title | Excel 2016 in depth |
| title_auth | Excel 2016 in depth |
| title_exact_search | Excel 2016 in depth |
| title_full | Excel 2016 in depth Bill Jelen |
| title_fullStr | Excel 2016 in depth Bill Jelen |
| title_full_unstemmed | Excel 2016 in depth Bill Jelen |
| title_short | Excel 2016 in depth |
| title_sort | excel 2016 in depth |
| topic | Microsoft Excel (Computer file) Microsoft Excel (Computer file) fast Electronic spreadsheets / Computer programs Electronic spreadsheets / Computer programs fast |
| topic_facet | Microsoft Excel (Computer file) Electronic spreadsheets / Computer programs |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028796670&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT jelenbill excel2016indepth |