Excel: Portable Genius

Cover
Title Page
Copyright Page
About the Author
Acknowledgments
Contents
Introduction
Chapter 1 How Do I Start Using Excel?
	Starting and Exiting Excel
	Taking a Look Around
		Reviewing key screen features
		Workbooks versus worksheets
		Changing views
		Zooming
	Working with Files
		Creating a blank file
		Exploring templates
		Opening an existing file
		Switching to another file
	Making Your First Cell Entries
		Moving around the sheet
		Text and values
		Dates and times
		Number formatting on the fly
	Making Selections
		Understanding cells and ranges
		Selecting a range
		Selecting a row or column
	Working with Sheets
		Adding, renaming, and jumping to a sheet
		Moving or copying a sheet
	Saving and Closing a File
Chapter 2 How Do I Make Changes to My Sheet?
	Cell Editing Basics
		Making changes
		Clearing cell contents
		Using Undo and Redo
		Spell-checking your work
	Copying or Moving a Range
	Using Paste Special
	Using Auto Fill and Filling Series
	Inserting and Deleting Rows, Columns, and Cells
	Creating Range Names
		Using the Name box
		Using the New Name dialog box
		Assigning multiple range names at once
		Deleting a range name
	Using Find and Replace
	Freezing Rows and Columns On-Screen
Chapter 3 How Do I Add Up the Numbers with Formulas?
	Entering a Basic Formula
		Typing the formula
		Cell and range references in formulas
		Using the mouse to save time
		Dealing with minor errors
	Learning More About Operators
	Understanding Order of Precedence
		How order of precedence works
		Using parentheses in formulas
	Making a Cell or Range Reference Absolute Rather Than Relative
		Changing the reference type in a formula
		How referencing works when filling, copying, or moving a formula
	Showing Formulas in Cells
	Using Other Formula Review Techniques
Chapter 4 When Do I Need to Include a Function?
	Understanding Functions
	Using AutoSum on the Home or Formulas Tab
	Typing a Function in a Formula
	Using the Formulas Tab to Insert a Function
		Choosing from the Function Library
		Using Insert Function to find a function
	Using Range Names in Formulas
	Reviewing Some Essential Functions
Chapter 5 How Do I Use Formatting to Enhance My Worksheet?
	Changing the Number or Date Format
		Using number formats
		Using date and time formats
		Using special and custom formats
	Changing Cell Formatting
		Applying font formatting
		Applying alignment formatting
	Working with Borders and Shading
	Using Styles
	Clearing Formatting
	Understanding Themes
		Reviewing elements of a theme
		Changing themes
		Changing theme colors, fonts, and effects
	Working with Column Width and Row Height
	Using Conditional Formatting to Highlight Information
Chapter 6 How Do I Use Graphics in Excel?
	Inserting Simple Graphics
		Shapes
		Pictures
		Icons
	Selecting and Formatting Graphics
		Adding text to shapes
		Changing styles
		Changing sizing and position
		Working with layering, alignment, and rotation
	Inserting WordArt
	Combining and Creating Your Own Graphics
	Creating and Working with SmartArt
		Adding a SmartArt graphic
		Editing and rearranging shapes
		Changing the graphic type and formatting
	Deleting a Graphic
	Adding a Background Image
Chapter 7 How Do I Manage Lists of Information?
	Arranging a List in Excel
	Cleaning Up Data
		Using Flash Fill
		Using Text to Columns
		Removing duplicates and consolidating
	Sorting, Filtering, and Subtotaling Lists of Information
		Sorting and filtering a list
		Subtotaling a sorted list
	Understanding Excel’s Table Feature
		Converting a range to a table
		Importing or connecting to a list of data
		Changing table styles
		Resizing a table
		Renaming a table
	Sorting and Filtering a Table
	Using Table Calculations
		Adding a calculated column
		Adding a total row
	Converting a Table Back to a Range of Regular Cells
Chapter 8 How Do I Present My Data in Charts?
	Charts and Their Role in Your Workbooks
	Chart Types
	Creating a Chart
	Changing the Chart Type and Layout
	Formatting Chart Elements
	Changing the Charted Data
	Moving a Chart to Its Own Sheet and Deleting a Chart
	Using Special Charts: Sparklines, PivotTables, and Maps
Chapter 9 How Do I Print and Share My Content?
	Creating Headers and Footers
	Changing Page Settings
		Margins
		Orientation and paper size
		Scaling
	Changing Sheet Settings
		Adding print titles
		Controlling whether gridlines and other features print
	Working with Page Breaks
		Setting a print area
		Viewing and moving breaks
	Previewing a Printout and Printing
	Other Ways to Share Information
		Exporting a PDF
		Using OneDrive
Index
EULA