Teach Yourself VISUALLY Excel 2016, 1 by McFedries, Paul -- Read -- Imperial Library of Trantor

Index

Cover Title Page Table of Contents Chapter 1: 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 Rows or Columns Merge Two or More Cells Transpose Rows and Columns Select and Enter Data Using Touch Gestures

Chapter 2: Working with Range Names

Understanding the Benefits of Using Range Names Define a Range Name Using 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

Chapter 3: Formatting Excel Ranges

Change the Font and 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

Chapter 4: Building Formulas

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 Troubleshoot Formula Errors

Chapter 5: 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 and Unhide a Worksheet

Chapter 6: Dealing with Workbooks

Create a New Blank Workbook Create a New Workbook from a Template Save a Workbook Open a Workbook Arrange Workbook Windows Find Text in a Workbook Replace Text in a Workbook Check Spelling and Grammar

Chapter 7: Formatting Workbooks

Modify the Workbook Colors Set the Workbook Fonts Choose Workbook Effects Apply a Workbook Theme Add a Workbook Header Add a Workbook Footer

Chapter 8: 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

Chapter 9: Printing Workbooks

Adjust the 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 the Printout Print a Workbook

Chapter 10: 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 Build a Custom Table Style Create a PivotTable

Chapter 11: Analyzing Data

Sort a Range or Table Filter a Range or Table Set Data Validation Rules 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 Excel Analysis ToolPak

Chapter 12: 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

Chapter 13: Adding Worksheet Graphics

Draw a Shape Insert a Clip Art Image Insert a Photo Insert a WordArt Image Insert a SmartArt Graphic Move or Resize a Graphic Crop a Picture Format a Picture

Chapter 14: 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 OneDrive 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

End User License Agreement