Excel 2019 For Dummies

Title Page
Copyright Page
Table of Contents
Introduction
	About This Book
	How to Use This Book
	What You Can Safely Ignore
	Foolish Assumptions
	How This Book Is Organized
		Part 1: Getting Started with Excel 2019
		Part 2: Editing Without Tears
		Part 3: Getting Organized and Staying That Way
		Part 4: Digging Data Analysis
		Part 5: Life Beyond the Spreadsheet
		Part 6: The Part of Tens
	Conventions Used in This Book
		Selecting Ribbon commands
		Icons 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
			Going Backstage
			Using the Excel Ribbon
			Customizing the Quick Access toolbar
			Having fun with the Formula bar
			What to do in the Worksheet area
			Showing off the Status bar
		Launching and Quitting Excel
			Starting Excel from the Windows 10 Start menu
			Starting Excel from the Windows 10 Search text box
			Starting Excel from the Windows 10 Metro view in Tablet mode
			Exiting Excel
		Help Is on the Way
			Using the Tell Me help feature
	Chapter 2 Creating a Spreadsheet from Scratch
		So What Ya Gonna Put in That New Workbook of Yours?
			The ins and outs of data entry
			You must remember this . . .
		Doing the Data-Entry Thing
		It Takes All Types
			The telltale signs of text
			How Excel evaluates its values
			Fabricating those fabulous formulas!
			If you want it, just point it out
			Altering the natural order of operations
			Formula flub-ups
		Fixing Those Data Entry Flub-Ups
			You really AutoCorrect that for me
			Cell editing etiquette
		Taking the Drudgery Out of Data Entry
			I’m just not complete without you
			Fill ’er up with AutoFill
			Fill it in a flash
			Inserting special symbols
			Entries all around the block
			Data entry express
		How to Make Your Formulas Function Even Better
			Inserting a function into a formula with the Insert Function button
			Editing a function with the Insert Function button
			I’d be totally lost without AutoSum
			Sums via Quick Analysis Totals
		Making Sure That the Data Is Safe and Sound
			Changing the default file location
			The difference between the XLSX and XLS file formats
		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
			Point-and-click cell selections
			Keyboard cell selections
		Using the Format as Table Gallery
			Customizing table formats
			Creating a new custom Table Style
		Cell Formatting from the Home Tab
		Formatting Cells Close to the Source with the Mini-bar
		Using the Format Cells Dialog Box
			Understanding the number formats
			The values behind the formatting
			Make it a date!
			Ogling some of the other number formats
		Calibrating Columns
			Rambling rows
			Now you see it, now you don’t
		Futzing with the Fonts
		Altering the Alignment
			Intent on indents
			From top to bottom
			Tampering with how the text wraps
			Reorienting cell entries
			Shrink to fit
			Bring on the borders!
			Applying fill colors, patterns, and gradient effects to cells
		Doing It in Styles
			Creating a new style for the gallery
			Copying custom styles from one workbook into another
		Fooling Around with the Format Painter
		Conditional Formatting
			Formatting with scales and markers
			Highlighting cells ranges
			Formatting via the Quick Analysis tool
	Chapter 4 Going Through Changes
		Opening Your Workbooks for Editing
			Opening files in the Open screen
			Operating the Open dialog box
			Changing the Recent files settings
			Opening multiple workbooks
			Find workbook files
			Using the Open file options
		Much Ado about Undo
			Undo is Redo the second time around
			What to do when you can’t Undo?
		Doing the Old Drag-and-Drop Thing
			Copies, drag-and-drop style
			Insertions courtesy of drag and drop
		Copying Formulas with AutoFill
			Relatively speaking
			Some things are absolutes!
		Cut and Paste, Digital Style
			Paste it again, Sam . . .
			Keeping pace with Paste Options
			Paste it from the Clipboard task pane
			So what’s so special about Paste Special?
		Let’s Be Clear About Deleting Stuff
			Sounding the all clear!
			Get these cells outta here!
		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!
			Using the buttons in the Page Setup group
			Using the buttons in the Scale to Fit group
			Using the Print buttons in the Sheet Options group
		From Header to Footer
			Adding an Auto Header and Footer
			Creating a custom header or 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
			Adding a comment to a cell
			Comments in review
			Editing comments in a worksheet
			Getting your comments in print
		The Range Name Game
			If I only had a name . . .
			Name that formula!
			Naming constants
		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
			Sliding between the sheets
			Editing en masse
		Don’t Short-Sheet Me!
			A worksheet by any other name . . .
			A sheet tab by any other color . . .
			Getting your sheets in order
		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
			Creating a one-variable data table
			Creating a two-variable data table
		Playing What-If with Goal Seeking
		Making the Case with Scenario Manager
			Setting up the various scenarios
			Producing a summary report
	Chapter 9 Playing with Pivot Tables
		Data Analysis with Pivot Tables
			Pivot tables via the Quick Analysis tool
			Pivot tables by recommendation
			Manually producing pivot tables
		Formatting Pivot Tables
			Refining the Pivot Table style
			Formatting values in the pivot table
		Sorting and Filtering Pivot Table Data
			Filtering the report
			Filtering column and row fields
			Filtering with slicers
			Filtering with timelines
			Sorting the pivot table
		Modifying Pivot Tables
			Modifying the pivot table fields
			Pivoting the table’s fields
			Modifying the table’s summary function
		Creating Pivot Charts
			Moving pivot charts to separate sheets
			Filtering pivot charts
			Formatting pivot charts
Part 5 Life Beyond the Spreadsheet
	Chapter 10 Charming Charts and Gorgeous Graphics
		Making Professional-Looking Charts
			Charts thanks to Recommendation
			Charts from the Ribbon
			Charts via the Quick Analysis tool
			Charts on their own chart sheets
			Moving and resizing embedded charts
			Moving embedded charts to chart sheets
			Customizing charts from the Design tab
			Customizing chart elements
			Editing the generic titles in a chart
		Adding Great-Looking Graphics
			Sparking up the data with sparklines
			Telling all with a text box
			Inserting online images
			Inserting 3-D images
			Inserting local images
			Editing inserted pictures
			Formatting inserted 2-D images
			Formatting inserted 3-D images
			Adding graphic shapes
			Adding Icons
			Working with WordArt
			Make mine SmartArt
			Screenshots, anyone?
			Theme for a day
		Controlling How Graphic Objects Overlap
			Reordering the layering of graphic objects
			Grouping graphic objects
			Hiding graphic objects
		Printing Just the Charts
	Chapter 11 Getting on the Data List
		Creating Data Lists
			Adding records to data lists
			Moving through records in the data form
			Finding records with the data form
		Sorting Data Lists
			Sorting on a single field
			Sorting on multiple fields
		Filtering Data Lists
			Using ready-made number filters
			Using ready-made date filters
			Using custom filters
		Importing External Data
			Querying Access database tables
			Performing web queries
	Chapter 12 Linking, Automating, and Sharing Spreadsheets
		Using Office Add-ins
		Using Excel Add-Ins
		Adding Hyperlinks to a Worksheet
		Automating Commands with Macros
			Recording new macros
			Running macros
			Assigning macros to the Ribbon and the Quick Access toolbar
		Sharing Your Worksheets
			Sharing workbooks saved on OneDrive
			Getting a sharing link
			E-mailing workbooks
		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