Efnisyfirlit

• Cover
• Introduction
• About This Book
• How to Use This Book
• What You Can Safely Ignore
• Foolish Assumptions
• How This Book Is Organized
• Conventions Used in This Book
• Beyond the Book
• Where to Go from Here
• Part 1: Getting Started with Excel 2019
• Chapter 1: The Excel 2019 User Experience
• Excel’s Ribbon User Interface
• Launching and Quitting Excel
• Help Is on the Way
• Chapter 2: Creating a Spreadsheet from Scratch
• So What Ya Gonna Put in That New Workbook of Yours?
• Doing the Data-Entry Thing
• It Takes All Types
• Fixing Those Data Entry Flub-Ups
• Taking the Drudgery Out of Data Entry
• How to Make Your Formulas Function Even Better
• Making Sure That the Data Is Safe and Sound
• Saving the Workbook as a PDF File
• Document Recovery to the Rescue
• Part 2: Editing Without Tears
• Chapter 3: Making It All Look Pretty
• Choosing a Select Group of Cells
• Using the Format as Table Gallery
• Cell Formatting from the Home Tab
• Formatting Cells Close to the Source with the Mini-bar
• Using the Format Cells Dialog Box
• Calibrating Columns
• Futzing with the Fonts
• Altering the Alignment
• Doing It in Styles
• Fooling Around with the Format Painter
• Conditional Formatting
• Chapter 4: Going Through Changes
• Opening Your Workbooks for Editing
• Much Ado about Undo
• Doing the Old Drag-and-Drop Thing
• Copying Formulas with AutoFill
• Cut and Paste, Digital Style
• Let’s Be Clear About Deleting Stuff
• Staying in Step with Insert
• Stamping Out Your Spelling Errors
• Eliminating Errors with Text to Speech
• Chapter 5: Printing the Masterpiece
• Previewing Pages in Page Layout View
• Using the Backstage Print Screen
• Printing the Current Worksheet
• My Page Was Set Up!
• From Header to Footer
• Solving Page Break Problems
• Letting Your Formulas All Hang Out
• Part 3: Getting Organized and Staying That Way
• Chapter 6: Maintaining the Work sheet
• Zooming In and Out
• Splitting the Worksheet into Window Panes
• Fixed Headings with Freeze Panes
• Electronic Sticky Notes
• The Range Name Game
• Seek and Ye Shall Find …
• Replacing Cell Entries
• Doing Your Research with Smart Lookup
• Controlling Recalculation
• Putting on the Protection
• Chapter 7: Maintaining Multiple Worksheets
• Juggling Multiple Worksheets
• Don’t Short-Sheet Me!
• Opening Windows on Your Worksheets
• Comparing Worksheets Side by Side
• Shifting Sheets to Other Workbooks
• Summing Stuff on Different Worksheets
• Part 4: Digging Data Analysis
• Chapter 8: Doing What-If Analysis
• Playing What-If with Data Tables
• Playing What-If with Goal Seeking
• Making the Case with Scenario Manager
• Chapter 9: Playing with Pivot Tables
• Data Analysis with Pivot Tables
• Formatting Pivot Tables
• Sorting and Filtering Pivot Table Data
• Modifying Pivot Tables
• Creating Pivot Charts
• Part 5: Life Beyond the Spreadsheet
• Chapter 10: Charming Charts and Gorgeous Graphics
• Making Professional-Looking Charts
• Adding Great-Looking Graphics
• Controlling How Graphic Objects Overlap
• Printing Just the Charts
• Chapter 11: Getting on the Data List
• Creating Data Lists
• Sorting Data Lists
• Filtering Data Lists
• Importing External Data
• Chapter 12: Linking, Automating, and Sharing Spreadsheets
• Using Office Add-ins
• Using Excel Add-Ins
• Adding Hyperlinks to a Worksheet
• Automating Commands with Macros
• Sharing Your Worksheets
• Editing Worksheets in Excel Online
• Part 6: The Part of Tens
• Chapter 13: Top Ten Beginner Basics
• Chapter 14: The Ten Commandments of Excel 2019
• Chapter 15: Top Ten Ways to Manage Your Data
• Chapter 16: Top Ten Ways to Analyze Your Data
• Index
• About the Author
• Connect with Dummies
• End User License Agreement