Teach Yourself VISUALLY Excel 365

Excel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY series In Teach Yourself VISUALLY: Excel 365, veteran tech educator and writer Paul McFedries delivers a practical, step-by-step guide to using the latest version of the world’s most popular spreadsheet app. The book is filled with easy two-page lessons containing large-size screenshots and walkthroughs demonstrating common and useful tasks in Excel 365. You’ll learn how to present, analyze, visualize, and organize your data, as well as how to: Create and fill spreadsheets, charts, tables, and PivotTables Filter and sort your data, use and create formulas, and organize your information Visualize your data with a variety of effective charts, graphs, and more A can’t-miss handbook perfect for anyone looking for straightforward and easy-to-follow tutorials on basic and advanced Excel techniques, Teach Yourself VISUALLY: Excel 365 offers users of previous Excel versions—and complete Excel newbies—a clear roadmap to mastering Excel.

Table of Contents:
Chapter 1 Getting Started with Excel Getting to Know Excel 4 Start Excel on the Desktop 6 Navigate to Excel for the Web 7 Tour the Excel Window 8 Work with the Excel Ribbon 9 Chapter 2 Entering Data Learning the Layout of a Worksheet 12 Understanding the Types of Data You Can Use 13 Enter Text into a Cell 14 Enter a Number into a Cell 16 Enter a Date or Time into a Cell 18 Edit Cell Data 20 Delete Data from a Cell 22 Chapter 3 Working with Ranges Select a Range 26 Fill a Range with the Same Data 28 Fill a Range with a Series of Values 30 Flash Fill a Range 32 Move or Copy a Range 34 Insert a Row or Column 36 Insert a Cell or Range 38 Delete Data from a Range 40 Delete a Range 42 Hide a Row or Column 44 Freeze Rows or Columns 46 Merge Two or More Cells 48 Chapter 4 Working with Range Names Understanding the Benefits of Using Range Names 52 Define a Range Name 54 Using Worksheet Text to Define a Range Name 56 Navigate a Workbook Using Range Names 58 Change a Range Name 60 Delete a Range Name 62 Chapter 5 Formatting Excel Ranges Change the Font and Font Size 66 Apply Font Effects 68 Change the Font Color 70 Align Text Within a Cell 72 Center Text Across Multiple Columns 74 Rotate Text Within a Cell 76 Add a Background Color to a Range 78 Apply a Number Format 80 Change the Number of Decimal Places Displayed 82 Apply a Conditional Format to a Range 84 Apply a Style to a Range 86 Change the Column Width 88 Change the Row Height 90 Wrap Text Within a Cell 92 Add Borders to a Range 94 Copy Formatting from One Cell to Another 96 Chapter 6 Building Formulas Understanding Excel Formulas 100 Build a Formula 102 Understanding Excel Functions 104 Add a Function to a Formula 106 Add a Range of Numbers 108 Build an AutoSum Formula 110 Add a Range Name to a Formula 112 Reference Another Worksheet Range in a Formula 114 Move or Copy a Formula 116 Switch to Absolute Cell References 118 Troubleshoot Formula Errors 120 Chapter 7 Manipulating Worksheets Navigate a Worksheet 124 Rename a Worksheet 125 Create a New Worksheet 126 Move a Worksheet 128 Copy a Worksheet 130 Delete a Worksheet 132 Zoom In on or Out of a Worksheet 134 Split a Worksheet into Two Panes 136 Hide and Unhide a Worksheet 138 Chapter 8 Dealing with Workbooks Create a New Blank Workbook 142 Create a New Workbook from a Template 144 Save a Workbook 146 Open a Workbook 147 Find Text in a Workbook 148 Replace Text in a Workbook 150 Chapter 9 Formatting Workbooks Modify the Workbook Colors 154 Set the Workbook Fonts 156 Choose Workbook Effects 158 Apply a Workbook Theme 160 Add a Workbook Header 162 Add a Workbook Footer 164 Chapter 10 Importing Data into Excel Understanding External Data 168 Import Data from an Access Table 170 Import Data from a Word Table 172 Import Data from a Text File 174 Import Data from a Web Page 176 Import Data from an XML File 178 Refresh Imported Data 180 Separate Cell Text into Columns 182 Chapter 11 Working with Tables Understanding Tables 186 Get to Know Table Features 187 Convert a Range to a Table 188 Select Table Data 190 Insert a Table Row 192 Insert a Table Column 193 Delete a Table Row 194 Delete a Table Column 195 Add a Column Subtotal 196 Convert a Table to a Range 198 Apply a Table Style 199 Chapter 12 Analyzing with PivotTables Understanding PivotTables 202 Explore PivotTable Features 203 Build a PivotTable from an Excel Range or Table 204 Refresh PivotTable Data 206 Add Multiple Fields to the Row or Column Area 208 Add Multiple Fields to the Data Area 210 Move a Field to a Different Area 212 Group PivotTable Values 214 Apply a PivotTable Filter 216 Chapter 13 Analyzing Data Sort a Range or Table 220 Filter a Range or Table 222 Set Data Validation Rules 224 Create a Data Table 226 Summarize Data with Subtotals 228 Group Related Data 230 Analyze Data with Goal Seek 232 Highlight Cells That Meet Some Criteria 234 Highlight the Top or Bottom Values in a Range 236 Analyze Cell Values with Data Bars 238 Analyze Cell Values with Color Scales 240 Analyze Cell Values with Icon Sets 242 Chapter 14 Visualizing Data with Charts Examine Chart Elements 246 Understanding Chart Types 247 Create a Chart 248 Create a Recommended Chart 250 Add Chart Titles 252 Add Data Labels 253 Position the Chart Legend 254 Display Chart Gridlines 255 Display a Data Table 256 Change the Chart Layout and Style 257 Select a Different Chart Type 258 Change the Chart Source Data 260 Move or Resize a Chart 262 Chapter 15 Adding Worksheet Graphics Draw a Shape 266 Insert an Online Image 268 Insert a Photo from Your PC 270 Insert a SmartArt Graphic 272 Move or Resize a Graphic 274 Format a Picture 276 Chapter 16 Collaborating with Others Add a Comment to a Cell 280 Protect a Worksheet’s Data 282 Protect a Workbook’s Structure 284 Save a Workbook to Your OneDrive 286 Send a Workbook as an Email Attachment 288 Save Excel Data as a Web Page 290 Make a Workbook Compatible with Earlier Versions of Excel 292 Mark Up a Worksheet with Digital Ink 294 Collaborate on a Workbook Online 296 Index 298