Full-color, step-by-step tasks walk you through everything you want to do with Excel 2013. Step-by-step instructions with callouts to Excel 2013 screenshots that show you exactly what to do. Help when you run into Excel 2013 problems or limitations. Tips and Notes to help you get the most from Excel 2013. • Quickly find and use the Excel 2013 features you’re looking for • Create, save, and organize your spreadsheets • Build custom formulas using Excel’s powerful built-in functions • Master time-saving techniques to find, replace, move, filter, and sort data • Find, fix, and avoid errors that break spreadsheets or cause inaccuracies • Create a unique look and feel for your spreadsheets with formatting • Generate powerful charts and visualizations with Excel’s new tools • Insert images, shapes, SmartArt, and even org charts • Precisely control what you print and how it looks • Secure your spreadsheets and control who can view or edit them • Use improved PivotTables to analyze huge amounts of data • Store and share workbooks on the Web with SkyDrive

Table of Contents:
Introduction     xi Chapter 1  Working with Excel’s Ribbon Menus     3 Familiarizing Yourself with the Ribbon Tabs     4 Understanding Workbooks and Worksheets     7    Explore Worksheets     7    Explore Columns, Rows, and Cells     8 Understanding Contextual Tabs     9    Work with Contextual Tabs     10 Customizing the Quick Access Toolbar     10    Add a Command to the Quick Access Toolbar     11    Add Other Commands to the Quick Access Toolbar     12    Add Hidden Commands to the Quick Access Toolbar     13 Chapter 2  Managing Workbooks and Worksheets     15 Opening an Excel Workbook     16 Closing an Excel Workbook     17 Saving a Workbook     17 Switching Between Open Workbooks     18 Switching Between Worksheets     20 Viewing Multiple Workbooks     20 Inserting and Deleting Worksheets     22 Renaming Worksheets     23 Coloring Worksheet Tabs     23 Moving Worksheets Within a Workbook     24 Copying Worksheets Between Workbooks     25 Password Protect a Workbook     26 Protecting a Worksheet     28 Chapter 3  Entering and Managing Data     31 Entering Data     32 Editing and Deleting Existing Data     33 Zooming into Your Data     34 Undoing and Redoing Changes     35 Copying and Pasting Data    36    Cut and Paste Data     37 Freezing Rows and Columns     38 Splitting a Worksheet     39 Inserting Cells     40 Deleting Cells     41 Inserting and Deleting Rows     42 Inserting and Deleting Columns     43 Moving Data     44 Finding Data     46 Replacing Data    47 Applying a Data Filter     48 Sorting Data     49 Adding and Managing Cell Comments     50 Chapter 4  Formatting Worksheet Data     53 Changing the Font and Font Size     54 Changing Column Width     55 Changing the Color of the Cell Background and Cell Text     57 Formatting the Display of Numeric Data     58    Use a General Format     60    Use a Number Format     61    Use a Currency Format     62    Use a Date Format     63    Use a Text Format    64 Applying Bold, Italic, and Underline     65 Using Merge and Center on Cells     66 Changing Horizontal Data Alignment     68 Changing Row Height     69 Changing Vertical Data Alignment    70 Changing Cell Orientation     71 Wrapping Data in a Cell     72 Changing Borders      72 Indenting Entries in a Cell      73 Clearing Formatting     74 Hiding and Unhiding Rows     76 Hiding and Unhiding Columns     78 Hiding and Unhiding a Worksheet     80 Using Format as Table     81 Copying Formatting     82 Creating and Applying a Formatting Style     84 Using Conditional Formatting     85 Chapter 5  Working with Formulas and Functions     89 Using AutoSum Calculations     89    Find a Cell Average (AVERAGE)     91    Find the Largest Cell Amount (MAX)     92    Find the Smallest Cell Amount (MIN)     93    Count the Number of Cells (COUNT)     94 Entering a Formula     95 Editing a Formula or Function     96 Copying a Formula     97 Assigning Names to a Cell or Range     99 Referencing Names in a Function     100 Using Functions Across Worksheets     101 Using Auto-Calculate     104 Finding and Using Excel Functions     105    Calculate a Loan Payment (PMT)     107    Perform a Logical Test Function (IF)     110    Conditionally Sum a Range (SUMIF)     113    Find the Future Value of an Investment (FV)     115 Recognizing and Fixing Errors     118    Fix the #DIV/0! Error     119    Fix the #NAME? Error     120    Fix the #VALUE! Error    122    Recognize the #REF! Error     124 Recognizing Circular References     126 Checking for Formula References (PRECEDENTS)     128 Checking for Cell References (DEPENDENTS)     130 Chapter 6  Working with Charts     133 Creating a Chart     134 Changing the Chart Type     136 Altering the Source Data Range     137 Altering Chart Options     138 Formatting the Plot Area     142 Formatting the Chart Area     144 Formatting the Axis Scale     146 Altering the Original Data     147 Adding Data to Charts     149 Adding a Legend     150 Chapter 7  Working with Graphics     153 Using Drawing Tools     153 Inserting Clip Art     156 Inserting a Picture from File     157 Using AutoShapes     158 Inserting WordArt     160 Using Smart Art in Excel     161 Inserting a Diagram     163 Inserting Objects     164 Working with Inserted Objects     166    Format an Object     167    Move an Object     168    Resize an Object     170    Delete an Object     171 Chapter 8  Printing in Excel     173 Using Print Preview     174 Setting the Print Area     175 Adjusting Page Margins     177 Inserting Page Breaks     178 Working in Page Break Preview Mode     181 Printing a Worksheet on One Page     182 Printing in Portrait or Landscape Orientation     184 Centering a Worksheet on a Page     185 Printing Gridlines and Row/Column Headers     186 Printing Cell Comments     187 Printing Cell Error Indicators     188 Printing Repeating Row and Column Titles     189 Adding Headers and Footers     190 Printing Your Worksheets     191 Chapter 9  Working with Pivot Tables     195 Creating a Pivot Table     196 Rearranging a Pivot Table     199 Adding a Report Filter     201 Refreshing Pivot Table Data     203 Adding Pivot Table Data    204 Customizing Field Names     206 Applying Numeric Formats to Data Fields     207 Changing Summary Calculations     209 Showing and Hiding Data Items     210 Sorting Your Pivot Table     211 Chapter 10  Using SkyDrive to Store and Share Excel Files     215 Signing Up For SkyDrive      215 Signing into SkyDrive     217 Saving a Workbook to SkyDrive     218 Opening a SkyDrive Workbook     220 Downloading a Workbook from SkyDrive     222 Sharing Your SkyDrive Workbooks with Others     223 Managing SkyDrive Workbooks     224 Appendix A  Excel Shortcut Keys     227 Using the Excel Shortcut Key Reference Table     227 Index    231