Excel 2019 business basics & beyond

Introduction
	Features of the Book
	Structure of the Book
	Excel Version Notes
	About the Author
Chapter 1: Excel Basics
	Understanding Spreadsheets and Spreadsheet Terminology
	What Can You Do with Excel?
	The Excel Environment: Understanding the Ribbon Interface
	Ribbon Tabs
	Additional Ribbon Options
	Worksheet Tabs, the Status Bar, and View Buttons
	Navigating the Excel Environment
	Chapter Summary
Chapter 2: Understanding File Operations and Setting Up Excel
	The File Tab
	Changing Excel’s Default Settings So They’re Right for You
	Chapter Summary
Chapter 3: The Home Tab in Depth
	The Clipboard Group
	The Font Group
	The Alignment Group
	The Number Group
	The Styles Group
	The Cells Group
	The Editing Group
	Ideas
	Chapter Summary
Chapter 4: The Ribbon in Depth: The Main Tabs
	The Insert Tab
	The Page Layout Tab
	The Formulas Tab
	The Data Tab
	The Review Tab
	The View Tab
	Chapter Summary
Chapter 5: Entering and Manipulating Data
	Answering Important Questions
	Planning
	Understanding Design Rules
	Designing and Building Spreadsheets
	Entering and Editing Data
	Data Validation
	Inserting and Deleting Ranges, Rows and Columns, and Worksheets
	Chapter Summary
Chapter 6: Using Functions and Formulas
	Basic Terminology
	The Function Library Group
	Order of Operations
	Entering Functions
	Excel Function/Formula Errors
	Commonly Used Business Functions
	Chapter Summary
Chapter 7: Formatting, Printing, and Sharing
	Themes
	Text, Cell, Row, and Column Formatting
	Conditional Formatting
	Printing and Page Setup Options
	Sharing Your Workbook
	Comments and Notes
	Chapter Summary
Chapter 8: Graphics
	Pictures and Online Pictures
	Shapes
	Icons
	3D Models
	SmartArt
	WordArt
	Screenshot
	Chapter Summary
Chapter 9: Charts
	Planning to Use Charts
	Chart Terminology and Components
	Getting Started with Charts
	Column and Bar Charts
	Line Charts
	Area Charts
	Pie Charts
	Hierarchy Charts
	Statistic Charts
	Scatter and Bubble Charts
	Waterfall, Funnel, Stock, Surface, and Radar Charts
	Combo Charts
	Map Charts
	Using Default Charts and Templates
	Sparklines
	Dealing with Charting Problems
	Interactive Charts
	Chapter Summary
Chapter 10: Excel Tables and Subtotals
	Excel Table Basics
	The Table Design Tab
	Conditional Formatting with Tables
	Structured References
	Deleting Table Rows and Columns
	Subtotals
	Chapter Summary
Chapter 11: PivotTables, Power Pivot, & the Data Model
	What PivotTables Can Do
	Getting Started with PivotTables
	The PivotTable Analyze Tab
	The PivotTable Design Tab
	Setting PivotTable Default Options
	Power Pivot and the Data Model
	Chapter Summary
Chapter 12: External Data and Mail Merge
	The Get & Transform Group
	The Queries & Connections Group
	Unpivoting Data
	Putting Data to Work
	Mail Merges
	Chapter Summary
Index