Excel 2019 For Dummies, 1 by Harvey, Greg -- Read -- Imperial Library of Trantor

Index

Cover Table of Contents 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