SmartSellTM - The New Way to Sell Online

We won't be beaten by anyone. Guaranteed

Teach Yourself VISUALLY Excel 2013 (Teach Yourself VISUALLY


Product Description
Product Details

Table of Contents

Chapter 1 Working with Excel Getting to Know Excel 4 Start Excel 6 Tour the Excel Window 8 Work with the Excel Ribbon 9 Work with the Excel Galleries 10 Customize the Quick Access Toolbar 12 Customize the Ribbon 14 Change the View 16 Configure Excel Options 18 Add Excel to the Windows Taskbar 20 Quit Excel 21 Chapter 2 Entering Data Learning the Layout of a Worksheet 24 Understanding the Types of Data You Can Use 25 Enter Text into a Cell 26 Enter a Number into a Cell 28 Enter a Date or Time into a Cell 30 Insert a Symbol 32 Edit Cell Data 34 Delete Data from a Cell 36 Chapter 3 Working with Ranges Select a Range 40 Fill a Range with the Same Data 42 Fill a Range with a Series of Values 44 Flash Fill a Range 46 Move or Copy a Range 48 Insert a Row or Column 50 Insert a Cell or Range 52 Delete Data from a Range 54 Delete a Range 56 Hide a Row or Column 58 Freeze Rows or Columns 60 Merge Two or More Cells 62 Transpose Rows and Columns 64 Chapter 4 Working with Range Names Understanding the Benefits of Using Range Names 68 Define a Range Name 70 Use Worksheet Text to Define a Range Name 72 Navigate a Workbook Using Range Names 74 Change a Range Name 76 Delete a Range Name 78 Paste a List of Range Names 80 Chapter 5 Formatting Excel Ranges Change the Font and Font Size 84 Apply Font Effects 86 Change the Font Color 88 Align Text Within a Cell 90 Center Text Across Multiple Columns 92 Rotate Text Within a Cell 94 Add a Background Color to a Range 96 Apply a Number Format 98 Change the Number of Decimal Places Displayed 100 Apply an AutoFormat to a Range 102 Apply a Conditional Format to a Range 104 Apply a Style to a Range 106 Change the Column Width 108 Change the Row Height 110 Wrap Text Within a Cell 112 Add Borders to a Range 114 Copy Formatting from One Cell to Another 116 Chapter 6 Building Formulas Understanding Excel Formulas 120 Build a Formula 122 Understanding Excel Functions 124 Add a Function to a Formula 126 Add a Row or Column of Numbers 128 Build an AutoSum Formula 130 Add a Range Name to a Formula 132 Reference Another Worksheet Range in a Formula 134 Move or Copy a Formula 136 Switch to Absolute Cell References 138 Hide the Formula Bar or Ribbon 140 Troubleshoot Formula Errors 142 Chapter 7 Manipulating Worksheets Navigate a Worksheet 146 Rename a Worksheet 147 Create a New Worksheet 148 Move a Worksheet 150 Copy a Worksheet 152 Delete a Worksheet 154 Change the Gridline Color 156 Toggle Worksheet Gridlines On and Off 158 Toggle Worksheet Headings On and Off 159 Set the Worksheet Tab Color 160 Set the Worksheet Background 162 Zoom In on or Out of a Worksheet 164 Split a Worksheet into Two Panes 166 Hide and Unhide a Worksheet 168 Chapter 8 Dealing with Workbooks Create a New Blank Workbook 172 Create a New Workbook from a Template 174 Save a Workbook 176 Open a Workbook 177 Arrange Workbook Windows 178 Find Text in a Workbook 180 Replace Text in a Workbook 182 Check Spelling and Grammar 184 Close a Workbook 186 Chapter 9 Formatting Workbooks Modify the Workbook Colors 190 Set the Workbook Fonts 192 Choose Workbook Effects 194 Apply a Workbook Theme 196 Add a Workbook Header 198 Add a Workbook Footer 200 Chapter 10 Printing Workbooks Adjust the Workbook Margins 204 Change the Page Orientation 206 Insert a Page Break 207 Choose a Paper Size 208 Set the Print Area 210 Configure Titles to Print on Each Page 212 Preview the Printout 214 Print a Workbook 216 Chapter 11 Working with Tables Understanding Tables 220 Get to Know Table Features 221 Convert a Range to a Table 222 Select Table Data 224 Insert a Table Row 226 Insert a Table Column 227 Delete a Table Row 228 Delete a Table Column 229 Add a Column Subtotal 230 Convert a Table to a Range 232 Apply a Table Style 233 Build a Custom Table Style 234 Create a PivotTable 236 Chapter 12 Analyzing Data Sort a Range or Table 240 Filter a Range or Table 242 Set Data Validation Rules 244 Create a Data Table 246 Summarize Data with Subtotals 248 Group Related Data 250 Analyze Data with Goal Seek 252 Analyze Data with Scenarios 254 Remove Duplicate Values from a Range or Table 258 Load the Excel Analysis ToolPak 260 Chapter 13 Visualizing Data with Charts Examine Chart Elements 264 Understanding Chart Types 265 Create a Chart 266 Create a Recommended Chart 268 Add Chart Titles 270 Add Data Labels 271 Position the Chart Legend 272 Display Chart Gridlines 273 Display a Data Table 274 Change the Chart Layout and Style 275 Select a Different Chart Type 276 Change the Chart Source Data 278 Move or Resize a Chart 280 Add a Sparkline to a Cell .282 Chapter 14 Adding Worksheet Graphics Draw a Shape 286 Insert a Clip Art Image 288 Insert a Photo 290 Insert a WordArt Image 292 Insert a SmartArt Graphic 294 Move or Resize a Graphic 296 Crop a Picture 298 Format a Picture 300 Chapter 15 Collaborating with Others Add a Comment to a Cell 304 Protect a Worksheet?s Data 306 Protect a Workbook?s Structure 308 Share a Workbook with Other Users 310 Track Workbook Changes 312 Accept or Reject Workbook Changes 314 Save a Workbook to Your SkyDrive 316 Send a Workbook as an E-Mail Attachment 318 Save Excel Data as a Web Page 320 Make a Workbook Compatible with Earlier Versions of Excel 322 Mark Up a Worksheet with a Digital Pen 324 Collaborate on a Workbook Online 326 Chapter 15 Collaborating with Others Index 328

About the Author

Paul McFedries (Toronto, Ontario) is the president of Logophilia Limited, a technical writing company. He has been programming since he was a teenager in the mid-1970s and has programmed everything from mainframes to desktops to bar code scanners. He has worked with many different languages, including Fortran, assembly language, C++, and, JavaScript. Paul has written more than three dozen books that have sold more than three million copies worldwide, including: Windows Vista Simplified, Teach Yourself Visually Windows Vista, Macs Portable Genius, Office 2007 Visual Quick Tips, and Teach Yourself VISUALLY Macs. Paul encourages all readers to drop by his Web site,

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Teach Yourself VISUALLY Excel 2013 (Teach Yourself VISUALLY (Tech)) on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond World Ltd.
Back to top