McFedries P. Teach Yourself VISUALLY Complete Excel 2013

Wiley, 2014. — 1174 p.in color. — ISBN: 1118653742, 9781118653746Get the basics of Excel and then go beyond with this new instructional visual guide
While many users need Excel just to create simple worksheets, many businesses and professionals rely on the advanced features of Excel to handle things like database creation and data analysis. Whatever project you have in mind, this visual guide takes you step by step through what each step should look like. Veteran author Paul McFedries first presents the basics and then gradually takes it further with his coverage of designing worksheets, collaborating between worksheets, working with visual data, database management and analysis, VBA, and more.Offers step-by-step instructions on a variety of tasks, some everyday and some more unique
Shows you how to create basic spreadsheets, insert functions and formulas, work with pivot tables, and more
Features a two-color interior features numerous screen shots to enhance your learning process for tasks such as creating and managing macros, generating and working with analytics, and using the advanced toolsOffering you a deep dive into Microsoft Excel, this book is the complete package for learning Excel with step-by-step, clear visual instructions.Working with Excel
Get to Know Excel
Start Excel
Tour the Excel Window
Work with the Excel Ribbon
Work with the Excel Galleries
Customize the Quick Access Toolbar
Customize the Ribbon
Change the View
Configure Excel Options
Add Excel to the Windows Taskbar
Quit Excel
Inputting and Editing Data
Learn the Layout of a Worksheet
Understanding the Types of Data You Can Use
Type Text in a Cell
Type a Number in a Cell
Type a Date or Time in a Cell
Insert a Symbol
Edit Cell Data
Delete Data from a Cell
Working with Ranges
Select a Range
Fill a Range with the Same Data
Fill a Range with a Series of Values
Flash Fill a Range
Move or Copy a Range
Insert a Row or Column
Insert a Cell or Range
Delete Data from a Range
Delete a Range
Hide a Row or Column
Freeze a Row or Column
Merge Two or More Cells
Transpose a Row or Column
Working with Range Names
Understanding the Benefits of Range Names
Define a Range Name
Use Worksheet Text to Define a Range Name
Navigate a Workbook Using Range Names
Change a Range Name
Delete a Range Name
Paste a List of Range Names
Formatting Excel Ranges
Change the Font or Font Size
Apply Font Effects
Change the Font Color
Align Text Within a Cell
Center Text Across Multiple Columns
Rotate Text Within a Cell
Add a Background Color to a Range
Apply a Number Format
Change the Number of Decimal Places Displayed
Apply an AutoFormat to a Range
Apply a Conditional Format to a Range
Apply a Style to a Range
Change the Column Width
Change the Row Height
Wrap Text Within a Cell
Add Borders to a Range
Copy Formatting from One Cell to Another
Maximizing Excel Customization
Create Custom Numeric Formats
Create Custom Date and Time Formats
Set the Default Width for All Columns
Create a Custom Fill List
Maximize Work Space by Turning Off Window Elements
Create a Custom Cell Style
Build a Custom Table Style
Create a Custom Color Scheme
Create a Custom Font Scheme
Save a Custom Workbook Theme
Customize the Excel Status Bar
Making Excel More Efficient
Export Ribbon Customizations to a File
Configure Excel to Use the Mouse Wheel for Zooming
Move in a Different Direction When You Press Enter
Automatically Insert a Decimal Point
Configure When Excel Warns You about Long Operations
Make a Workbook Faster by Saving It as Binary
Open a New Window for a Workbook
Allow Only Certain Values in a Cell
Apply Text or Formatting to Multiple Worksheets
Use Dialog Box Controls to Input Data
Check for Accessibility Problems
Building Formulas and Functions
Understanding Excel Formulas
Build a Formula
Understanding Excel Functions
Add a Function to a Formula
Add a Row or Column of Numbers
Build an AutoSum Formula
Add a Range Name to a Formula
Reference Another Worksheet Range in a Formula
Move or Copy a Formula
Switch to Absolute Cell References
Hide the Formula Bar or Ribbon
Getting More Out of Formulas
Paste a Formula Result
Show Formulas Instead of Results
Use a Watch Window to Monitor a Cell Value
Create an Array Formula
Combine Two Ranges Arithmetically
Skip Data Tables When Calculating Workbooks
Turn On Iterative Calculations
Troubleshoot a Formula by Stepping Through Each Part
Display Text Instead of Error Values
Check for Formula Errors in a Worksheet
Audit a Formula to Locate Errors
Manipulating Worksheets
Navigate a Worksheet
Rename a Worksheet
Create a New Worksheet
Move a Worksheet
Copy a Worksheet
Delete a Worksheet
Change the Gridline Color
Toggle Worksheet Gridlines On and Off
Toggle Worksheet Headings On and Off
Set the Worksheet Tab Color
Set the Worksheet Background
Zoom In on or Out of a Worksheet
Split a Worksheet into Two Panes
Hide or Unhide a Worksheet
Dealing with Workbooks
Create a New Blank Workbook
Create a New Workbook from a Template
Save a Workbook
Open a Workbook
Specify Workbook Properties
Find Text in a Workbook
Replace Text in a Workbook
Check Spelling and Grammar
Close a Workbook
Managing Workbooks
Increase the Number of Recent Documents
Open Workbooks Automatically at Start-up
Create a Workspace of Workbooks
Specify a New Default File Location
Set the Default Font and Font Size for New Workbooks
Set the Default Number of Worksheets for New Workbooks
Repair a Corrupted Workbook File
Convert a Workbook to a PDF File
Create a Workbook Template
Create a New Workbook from an Existing File
Compare Two Workbooks Side by Side
Check for Features Not Supported by Earlier Versions of Excel
Formatting Workbooks
Modify Workbook Colors
Set Workbook Fonts
Choose Workbook Effects
Apply a Workbook Theme
Add a Workbook Header
Add a Workbook Footer
Printing Workbooks
Adjust Workbook Margins
Change the Page Orientation
Insert a Page Break
Choose a Paper Size
Set the Print Area
Configure Titles to Print on Each Page
Preview a Printout
Print a Workbook
Working with Tables
Understanding Tables
Get to Know Table Features
Convert a Range to a Table
Select Table Data
Insert a Table Row
Insert a Table Column
Delete a Table Row
Delete a Table Column
Add a Column Subtotal
Convert a Table to a Range
Apply a Table Style
Resize a Table
Rename a Table
Analyzing Data
Sort a Range or Table
Filter a Range or Table
Calculate a Conditional Sum
Calculate a Conditional Count
Create a Data Table
Summarize Data with Subtotals
Group Related Data
Analyze Data with Goal Seek
Analyze Data with Scenarios
Remove Duplicate Values from a Range or Table
Highlight Cells That Meet Some Criteria
Highlight the Top or Bottom Values in a Range
Analyze Cell Values with Data Bars
Analyze Cell Values with Color Scales
Analyze Cell Values with Icon Sets
Create a Custom Conditional Formatting Rule
Consolidate Data from Multiple Worksheets
Load the Analysis ToolPak
Analyzing Data with PivotTables
Understanding PivotTables
Explore PivotTable Features
Build a PivotTable from an Excel Range or Table
Create a PivotTable from External Data
Refresh PivotTable Data
Add Multiple Fields to the Row or Column Area
Add Multiple Fields to the Data Area
Move a Field to a Different Area
Group PivotTable Values
Apply a PivotTable Filter
Filter a PivotTable with a Slicer
Apply a PivotTable Style
Change the PivotTable Summary Calculation
Customize the PivotTable Fields Pane
Create a PivotChart from a PivotTable
Visualizing Data with Charts
Examine Chart Elements
Understanding Chart Types
Create a Chart
Create a Recommended Chart
Add Chart Titles
Add Data Labels
Position the Chart Legend
Display Chart Gridlines
Display a Data Table
Change the Chart Layout and Style
Select a Different Chart Type
Change the Chart Source Data
Move or Resize a Chart
Add a Sparkline to a Cell
Working with Worksheet Graphics
Draw a Shape
Insert Clip Art
Insert a Photo
Insert WordArt
Insert SmartArt
Move or Resize a Graphic
Crop a Picture
Format a Picture
Importing Data into Excel
Understanding External Data
Import Data from a Data Source
Import Data from an Access Table
Import Data from a Word Table
Import Data from a Text File
Import Data from a Web Page
Import Data from an XML File
Refresh Imported Data
Separate Cell Text into Columns
Querying Data Sources
Understanding Microsoft Query
Define a Data Source
Start Microsoft Query
Tour the Microsoft Query Window
Add a Table to a Query
Add Fields to a Query
Filter the Records with Query Criteria
Sort Query Records
Return the Query Results
Collaborating with Others
Add a Comment to a Cell
Protect a Worksheet’s Data
Protect a Workbook’s Structure
Share a Workbook with Other Users
Track Workbook Changes
Accept or Reject Workbook Changes
Save a Workbook to Your SkyDrive
Send a Workbook as an E-Mail Attachment
Save Excel Data as a Web Page
Make a Workbook Compatible with Earlier Versions of Excel
Mark Up a Worksheet with a Digital Pen
Collaborate on a Workbook Online
Protecting Excel Data
Open a Read-Only Version of a Workbook
Mark a Workbook as Final to Avoid Accidental Editing
Protect Workbooks by Shortening the AutoRecover Interval
Specify Cells that Users Can Edit
Hide a Formula
Protect a Range with a Password
Protect Worksheet Data
Protect the Structure of a Workbook
Restore a Previous Version of a Workbook
Maximizing Security
Open a Workbook in Protected View
Block Dangerous Excel File Types
Set the Macro Security Level
Digitally Sign Your Excel Macros
Create a Trusted Location for Opening Files
Inspect a Workbook for Private Data
Assign a Password to a Workbook
Turn On Excel Parental Control
Disable External Data Connections and Links
Apply a Digital Signature to a Workbook
Learning VBA Basics
Record a Macro
Open the VBA Editor
Explore the Excel Object Model
Add a Macro to a Module
Run a Macro
Assign a Shortcut Key to a Macro
Assign a Macro to the Quick Access Toolbar
Assign a Macro to the Ribbon