{"product_id":"microsoft-office-home-and-student-edition-2013-all-in-one-for-dummies-isbn-9781118516379","title":"Microsoft Office Home and Student Edition 2013 All-in-One For Dummies","description":"\u003cp\u003e\u003cb\u003eThe go-to reference for the new Office Home \u0026amp; Student 2013\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Home \u0026amp; Student version of Microsoft Office targets the home and education markets, covering the four applications most used outside the workplace: Word, Excel, PowerPoint, and OneNote. The minibooks in this essential \u003ci\u003eAll-in-One\u003c\/i\u003e guide include real-world examples and projects that cover the new features and capabilities of Office 2013. Straightforward advice and beneficial projects help you to learn the basics of creating a resume in Word, establishing a home budget in Excel, developing a dynamic school presentation with PowerPoint, and taking notes in OneNote.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eTargets home and school users of Office 2013, who primarily use Word, Excel, PowerPoint, and OneNote\u003c\/li\u003e \u003cli\u003eWalks you through how to use Office 2013 for everyday projects, such as creating a cover letter in Word or reusable templates in Excel\u003c\/li\u003e \u003cli\u003eDemonstrates how to jazz up a school presentation with PowerPoint\u003c\/li\u003e \u003cli\u003eProvides you with straightforward instructions for taking notes in OneNote\u003c\/li\u003e \u003cli\u003eShares common Office 2010 tools and details the basics of the Office ribbon\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eOffice Home \u0026amp; Student 2013 All-in-One For Dummies\u003c\/i\u003e is an easy-to-understand guide to the essentials of Office 2013!\u003c\/p\u003e \u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003eWhat’s in This Book, Anyway? 1\u003c\/p\u003e \u003cp\u003eWhat Makes This Book Different 2\u003c\/p\u003e \u003cp\u003eEasy-to-look-up information 2\u003c\/p\u003e \u003cp\u003eA task-oriented approach 3\u003c\/p\u003e \u003cp\u003eMeaningful screen shots 3\u003c\/p\u003e \u003cp\u003eFoolish Assumptions 3\u003c\/p\u003e \u003cp\u003eConventions Used in This Book 3\u003c\/p\u003e \u003cp\u003eIcons Used in This Book 4\u003c\/p\u003e \u003cp\u003eBook I: Common Office Tasks 5\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Office Nuts and Bolts 7\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA Survey of Office Applications 7\u003c\/p\u003e \u003cp\u003eStarting an Office Program 9\u003c\/p\u003e \u003cp\u003eStarting an Office program in Windows 7 and Vista 9\u003c\/p\u003e \u003cp\u003eStarting an Office program in Windows 8 10\u003c\/p\u003e \u003cp\u003eFinding Your Way Around the Office Interface 12\u003c\/p\u003e \u003cp\u003eThe File tab and Backstage 13\u003c\/p\u003e \u003cp\u003eThe Quick Access toolbar 13\u003c\/p\u003e \u003cp\u003eThe Ribbon and its tabs 14\u003c\/p\u003e \u003cp\u003eContext-sensitive tabs 14\u003c\/p\u003e \u003cp\u003eThe anatomy of a tab 15\u003c\/p\u003e \u003cp\u003eLive previewing 16\u003c\/p\u003e \u003cp\u003eMini-toolbars and shortcut menus 17\u003c\/p\u003e \u003cp\u003eOffice 2013 for keyboard lovers 17\u003c\/p\u003e \u003cp\u003eSaving Your Files 18\u003c\/p\u003e \u003cp\u003eSaving a file 18\u003c\/p\u003e \u003cp\u003eSaving a file for the first time 18\u003c\/p\u003e \u003cp\u003eDeclaring where you like to save files 19\u003c\/p\u003e \u003cp\u003eSaving AutoRecovery information 20\u003c\/p\u003e \u003cp\u003eNavigating the Save As and Open Windows 21\u003c\/p\u003e \u003cp\u003eOpening and Closing Files 23\u003c\/p\u003e \u003cp\u003eOpening a file 23\u003c\/p\u003e \u003cp\u003eClosing a file 24\u003c\/p\u003e \u003cp\u003eReading and Recording File Properties 24\u003c\/p\u003e \u003cp\u003eLocking a File with a Password 25\u003c\/p\u003e \u003cp\u003ePassword-protecting a file 25\u003c\/p\u003e \u003cp\u003eRemoving a password from a file 26\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Wrestling with the Text 27\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eManipulating the Text 27\u003c\/p\u003e \u003cp\u003eSelecting text 27\u003c\/p\u003e \u003cp\u003eMoving and copying text 28\u003c\/p\u003e \u003cp\u003eTaking advantage of the Clipboard task pane 29\u003c\/p\u003e \u003cp\u003eDeleting text 30\u003c\/p\u003e \u003cp\u003eChanging the Look of Text 30\u003c\/p\u003e \u003cp\u003eChoosing fonts for text 31\u003c\/p\u003e \u003cp\u003eChanging the font size of text 32\u003c\/p\u003e \u003cp\u003eApplying font styles to text 33\u003c\/p\u003e \u003cp\u003eApplying text effects to text 34\u003c\/p\u003e \u003cp\u003eUnderlining text 35\u003c\/p\u003e \u003cp\u003eChanging the color of text 35\u003c\/p\u003e \u003cp\u003eQuick Ways to Handle Case, or Capitalization 36\u003c\/p\u003e \u003cp\u003eEntering Symbols and Foreign Characters 38\u003c\/p\u003e \u003cp\u003eCreating Hyperlinks 39\u003c\/p\u003e \u003cp\u003eLinking a hyperlink to a web page 39\u003c\/p\u003e \u003cp\u003eCreating a hyperlink to another place in your file 41\u003c\/p\u003e \u003cp\u003eCreating an e-mail hyperlink 42\u003c\/p\u003e \u003cp\u003eRepairing and removing hyperlinks 43\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Speed Techniques Worth Knowing About 45\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUndoing and Repeating Commands 45\u003c\/p\u003e \u003cp\u003eUndoing a mistake 45\u003c\/p\u003e \u003cp\u003eRepeating an action — and quicker this time 46\u003c\/p\u003e \u003cp\u003eZooming In, Zooming Out 47\u003c\/p\u003e \u003cp\u003eViewing a File Through More Than One Window 48\u003c\/p\u003e \u003cp\u003eCorrecting Typos on the Fly 48\u003c\/p\u003e \u003cp\u003eEntering Text Quickly with the AutoCorrect Command 50\u003c\/p\u003e \u003cp\u003eBook II: Word 2013 53\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Speed Techniques for Using Word 55\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing the Word Screen 55\u003c\/p\u003e \u003cp\u003eCreating a New Document 57\u003c\/p\u003e \u003cp\u003eGetting a Better Look at Your Documents 60\u003c\/p\u003e \u003cp\u003eViewing documents in different ways 60\u003c\/p\u003e \u003cp\u003eSplitting the screen 63\u003c\/p\u003e \u003cp\u003eSelecting Text in Speedy Ways 64\u003c\/p\u003e \u003cp\u003eMoving Around Quickly in Documents 65\u003c\/p\u003e \u003cp\u003eKeys for getting around quickly 65\u003c\/p\u003e \u003cp\u003eNavigating from page to page or heading to heading 66\u003c\/p\u003e \u003cp\u003eGoing there fast with the Go To command 66\u003c\/p\u003e \u003cp\u003eBookmarks for hopping around 68\u003c\/p\u003e \u003cp\u003eInserting a Whole File into a Document 69\u003c\/p\u003e \u003cp\u003eEntering Information Quickly in a Computerized Form 69\u003c\/p\u003e \u003cp\u003eCreating a computerized form 70\u003c\/p\u003e \u003cp\u003eEntering data in the form 72\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Laying Out Text and Pages 73\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eParagraphs and Formatting 73\u003c\/p\u003e \u003cp\u003eInserting a Section Break for Formatting Purposes 74\u003c\/p\u003e \u003cp\u003eBreaking a Line 76\u003c\/p\u003e \u003cp\u003eStarting a New Page 76\u003c\/p\u003e \u003cp\u003eSetting Up and Changing the Margins 77\u003c\/p\u003e \u003cp\u003eIndenting Paragraphs and First Lines 79\u003c\/p\u003e \u003cp\u003eClicking an Indent button (for left-indents) 79\u003c\/p\u003e \u003cp\u003e“Eyeballing it” with the ruler 80\u003c\/p\u003e \u003cp\u003eIndenting in the Paragraph dialog box 81\u003c\/p\u003e \u003cp\u003eNumbering the Pages 81\u003c\/p\u003e \u003cp\u003eNumbering with page numbers only 82\u003c\/p\u003e \u003cp\u003eIncluding a page number in a header or footer 83\u003c\/p\u003e \u003cp\u003eChanging page number formats 83\u003c\/p\u003e \u003cp\u003ePutting Headers and Footers on Pages 84\u003c\/p\u003e \u003cp\u003eCreating, editing, and removing headers and footers 85\u003c\/p\u003e \u003cp\u003eFine-tuning a header or footer 87\u003c\/p\u003e \u003cp\u003eAdjusting the Space between Lines 88\u003c\/p\u003e \u003cp\u003eAdjusting the Space Between Paragraphs 89\u003c\/p\u003e \u003cp\u003eCreating Numbered and Bulleted Lists 90\u003c\/p\u003e \u003cp\u003eSimple numbered and bulleted lists 90\u003c\/p\u003e \u003cp\u003eConstructing lists of your own 91\u003c\/p\u003e \u003cp\u003eManaging a multilevel list 92\u003c\/p\u003e \u003cp\u003eWorking with Tabs 93\u003c\/p\u003e \u003cp\u003eHyphenating Text 94\u003c\/p\u003e \u003cp\u003eAutomatically and manually hyphenating a document 95\u003c\/p\u003e \u003cp\u003eUnhyphenating and other hyphenation tasks 96\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Word Styles 97\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAll About Styles 97\u003c\/p\u003e \u003cp\u003eStyles and templates 97\u003c\/p\u003e \u003cp\u003eTypes of styles 98\u003c\/p\u003e \u003cp\u003eApplying Styles to Text and Paragraphs 99\u003c\/p\u003e \u003cp\u003eApplying a style 99\u003c\/p\u003e \u003cp\u003eExperimenting with style sets 100\u003c\/p\u003e \u003cp\u003eChoosing which style names appear on the Style menus 101\u003c\/p\u003e \u003cp\u003eCreating a New Style 103\u003c\/p\u003e \u003cp\u003eCreating a style from a paragraph 103\u003c\/p\u003e \u003cp\u003eCreating a style from the ground up 103\u003c\/p\u003e \u003cp\u003eModifying a Style 105\u003c\/p\u003e \u003cp\u003eCreating and Managing Templates 106\u003c\/p\u003e \u003cp\u003eCreating a new template 107\u003c\/p\u003e \u003cp\u003eOpening a template so that you can modify it 110\u003c\/p\u003e \u003cp\u003eModifying, deleting, and renaming styles in templates 111\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Constructing the Perfect Table 113\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTalking Table Jargon 113\u003c\/p\u003e \u003cp\u003eCreating a Table 114\u003c\/p\u003e \u003cp\u003eEntering the Text and Numbers 116\u003c\/p\u003e \u003cp\u003eSelecting Different Parts of a Table 117\u003c\/p\u003e \u003cp\u003eLaying Out Your Table 118\u003c\/p\u003e \u003cp\u003eChanging the size of a table, columns, and rows 118\u003c\/p\u003e \u003cp\u003eAdjusting column and row size 119\u003c\/p\u003e \u003cp\u003eInserting columns and rows 119\u003c\/p\u003e \u003cp\u003eDeleting columns and rows 121\u003c\/p\u003e \u003cp\u003eMoving columns and rows 122\u003c\/p\u003e \u003cp\u003eAligning Text in Columns and Rows 122\u003c\/p\u003e \u003cp\u003eMerging and Splitting Cells 123\u003c\/p\u003e \u003cp\u003eRepeating Header Rows on Subsequent Pages 124\u003c\/p\u003e \u003cp\u003eFormatting Your Table 125\u003c\/p\u003e \u003cp\u003eDesigning a table with a table style 125\u003c\/p\u003e \u003cp\u003eCalling attention to different rows and columns 127\u003c\/p\u003e \u003cp\u003eDecorating your table with borders and colors 127\u003c\/p\u003e \u003cp\u003eUsing Math Formulas in Tables 130\u003c\/p\u003e \u003cp\u003eNeat Table Tricks 131\u003c\/p\u003e \u003cp\u003eChanging the direction of header row text 131\u003c\/p\u003e \u003cp\u003eWrapping text around a table 132\u003c\/p\u003e \u003cp\u003eUsing a picture as the table background 133\u003c\/p\u003e \u003cp\u003eDrawing diagonal lines on tables 134\u003c\/p\u003e \u003cp\u003eDrawing on a table 135\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Taking Advantage of the Proofing Tools 137\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCorrecting Your Spelling Errors 137\u003c\/p\u003e \u003cp\u003eCorrecting misspellings one at a time 138\u003c\/p\u003e \u003cp\u003eRunning a spell-check 139\u003c\/p\u003e \u003cp\u003ePreventing text from being spell checked 140\u003c\/p\u003e \u003cp\u003eChecking for Grammatical Errors in Word 141\u003c\/p\u003e \u003cp\u003eGetting a Word Definition 142\u003c\/p\u003e \u003cp\u003eFinding and Replacing Text 142\u003c\/p\u003e \u003cp\u003eThe basics: Finding stray words and phrases 143\u003c\/p\u003e \u003cp\u003eNarrowing your search 144\u003c\/p\u003e \u003cp\u003eConducting a find-and-replace operation 149\u003c\/p\u003e \u003cp\u003eResearching a Topic Inside Word 150\u003c\/p\u003e \u003cp\u003eFinding the Right Word with the Thesaurus 152\u003c\/p\u003e \u003cp\u003eProofing Text Written in a Foreign Language 153\u003c\/p\u003e \u003cp\u003eTelling Office which languages you will use 153\u003c\/p\u003e \u003cp\u003eMarking text as foreign language text 154\u003c\/p\u003e \u003cp\u003eTranslating Foreign Language Text 155\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Desktop Publishing with Word 157\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExperimenting with Themes 157\u003c\/p\u003e \u003cp\u003eSprucing Up Your Pages 159\u003c\/p\u003e \u003cp\u003eDecorating a page with a border 159\u003c\/p\u003e \u003cp\u003ePutting a background color on pages 160\u003c\/p\u003e \u003cp\u003eGetting Word’s help with cover letters 160\u003c\/p\u003e \u003cp\u003eMaking Use of Charts, Diagrams, Shapes, Clip Art, and Photos 161\u003c\/p\u003e \u003cp\u003eWorking with the Drawing Canvas 162\u003c\/p\u003e \u003cp\u003ePositioning and Wrapping Objects Relative to the Page and Text 163\u003c\/p\u003e \u003cp\u003eWrapping text around an object 163\u003c\/p\u003e \u003cp\u003ePositioning an object on a page 165\u003c\/p\u003e \u003cp\u003eWorking with Text Boxes 167\u003c\/p\u003e \u003cp\u003eInserting a text box 167\u003c\/p\u003e \u003cp\u003eMaking text flow from text box to text box 168\u003c\/p\u003e \u003cp\u003eDropping In a Drop Cap 168\u003c\/p\u003e \u003cp\u003eWatermarking for the Elegant Effect 169\u003c\/p\u003e \u003cp\u003ePutting Newspaper-Style Columns in a Document 170\u003c\/p\u003e \u003cp\u003eDoing the preliminary work 170\u003c\/p\u003e \u003cp\u003eRunning text into columns 171\u003c\/p\u003e \u003cp\u003eLandscape Documents 172\u003c\/p\u003e \u003cp\u003ePrinting on Different Size Paper 173\u003c\/p\u003e \u003cp\u003eShowing Online Video in a Document 173\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7: Getting Word’s Help with Office Chores 175\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHighlighting Parts of a Document 175\u003c\/p\u003e \u003cp\u003eCommenting on a Document 176\u003c\/p\u003e \u003cp\u003eEntering a comment 176\u003c\/p\u003e \u003cp\u003eViewing and displaying comments 178\u003c\/p\u003e \u003cp\u003eCaring for and feeding comments 178\u003c\/p\u003e \u003cp\u003eTracking Changes to Documents 179\u003c\/p\u003e \u003cp\u003eTelling Word to start marking changes 180\u003c\/p\u003e \u003cp\u003eReading and reviewing a document with change marks 180\u003c\/p\u003e \u003cp\u003eMarking changes when you forgot to turn on change marks 182\u003c\/p\u003e \u003cp\u003eAccepting and rejecting changes to a document 184\u003c\/p\u003e \u003cp\u003ePrinting an Address on an Envelope 184\u003c\/p\u003e \u003cp\u003ePrinting a Single Address Label (Or a Page of the Same Label) 186\u003c\/p\u003e \u003cp\u003eChurning Out Letters, Envelopes, and Labels for Mass Mailings 187\u003c\/p\u003e \u003cp\u003ePreparing the source file 188\u003c\/p\u003e \u003cp\u003eMerging the document with the source file 189\u003c\/p\u003e \u003cp\u003ePrinting form letters, envelopes, and labels 193\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: Tools for Reports and Scholarly Papers 195\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAlphabetizing a List 195\u003c\/p\u003e \u003cp\u003eOutlines for Organizing Your Work 196\u003c\/p\u003e \u003cp\u003eViewing the outline in different ways 197\u003c\/p\u003e \u003cp\u003eRearranging document sections in Outline view 197\u003c\/p\u003e \u003cp\u003eCollapsing and Expanding Parts of a Document 198\u003c\/p\u003e \u003cp\u003eGenerating a Table of Contents 199\u003c\/p\u003e \u003cp\u003eCreating a TOC 199\u003c\/p\u003e \u003cp\u003eUpdating and removing a TOC 200\u003c\/p\u003e \u003cp\u003eCustomizing a TOC 200\u003c\/p\u003e \u003cp\u003eChanging the structure of a TOC 201\u003c\/p\u003e \u003cp\u003eIndexing a Document 203\u003c\/p\u003e \u003cp\u003eMarking index items in the document 203\u003c\/p\u003e \u003cp\u003eGenerating the index 205\u003c\/p\u003e \u003cp\u003eEditing an index 206\u003c\/p\u003e \u003cp\u003ePutting Cross-References in a Document 207\u003c\/p\u003e \u003cp\u003ePutting Footnotes and Endnotes in Documents 209\u003c\/p\u003e \u003cp\u003eEntering a footnote or endnote 209\u003c\/p\u003e \u003cp\u003eChoosing the numbering scheme and position of notes 210\u003c\/p\u003e \u003cp\u003eDeleting, moving, and editing notes 211\u003c\/p\u003e \u003cp\u003eCompiling a Bibliography 211\u003c\/p\u003e \u003cp\u003eInserting a citation for your bibliography 212\u003c\/p\u003e \u003cp\u003eEditing a citation 214\u003c\/p\u003e \u003cp\u003eChanging how citations appear in text 214\u003c\/p\u003e \u003cp\u003eGenerating the bibliography 214\u003c\/p\u003e \u003cp\u003eBook III: Excel 2013 217\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Up and Running with Excel 219\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating a New Excel Workbook 219\u003c\/p\u003e \u003cp\u003eGetting Acquainted with Excel 221\u003c\/p\u003e \u003cp\u003eRows, columns, and cell addresses 222\u003c\/p\u003e \u003cp\u003eWorkbooks and worksheets 223\u003c\/p\u003e \u003cp\u003eEntering Data in a Worksheet 223\u003c\/p\u003e \u003cp\u003eThe basics of entering data 223\u003c\/p\u003e \u003cp\u003eEntering text labels 224\u003c\/p\u003e \u003cp\u003eEntering numeric values 225\u003c\/p\u003e \u003cp\u003eEntering date and time values 225\u003c\/p\u003e \u003cp\u003eQuickly Entering Lists and Serial Data with the AutoFill Command 228\u003c\/p\u003e \u003cp\u003eFormatting Numbers, Dates, and Time Values 231\u003c\/p\u003e \u003cp\u003eConditional Formats for Calling Attention to Data 232\u003c\/p\u003e \u003cp\u003eEstablishing Data-Validation Rules 234\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Refining Your Worksheet 237\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEditing Worksheet Data 237\u003c\/p\u003e \u003cp\u003eMoving Around in a Worksheet 238\u003c\/p\u003e \u003cp\u003eGetting a Better Look at the Worksheet 239\u003c\/p\u003e \u003cp\u003eFreezing and splitting columns and rows 239\u003c\/p\u003e \u003cp\u003eHiding columns and rows 241\u003c\/p\u003e \u003cp\u003eComments for Documenting Your Worksheet 242\u003c\/p\u003e \u003cp\u003eSelecting Cells in a Worksheet 244\u003c\/p\u003e \u003cp\u003eDeleting, Copying, and Moving Data 245\u003c\/p\u003e \u003cp\u003eHandling the Worksheets in a Workbook 245\u003c\/p\u003e \u003cp\u003eKeeping Others from Tampering with Worksheets 247\u003c\/p\u003e \u003cp\u003eHiding a worksheet 248\u003c\/p\u003e \u003cp\u003eProtecting a worksheet 248\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Formulas and Functions for Crunching Numbers 251\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow Formulas Work 251\u003c\/p\u003e \u003cp\u003eReferring to cells in formulas 251\u003c\/p\u003e \u003cp\u003eReferring to formula results in formulas 254\u003c\/p\u003e \u003cp\u003eOperators in formulas 255\u003c\/p\u003e \u003cp\u003eThe Basics of Entering a Formula 257\u003c\/p\u003e \u003cp\u003eSpeed Techniques for Entering Formulas 257\u003c\/p\u003e \u003cp\u003eClicking cells to enter cell references 257\u003c\/p\u003e \u003cp\u003eEntering a cell range 258\u003c\/p\u003e \u003cp\u003eNaming cell ranges so that you can use them in formulas 259\u003c\/p\u003e \u003cp\u003eReferring to cells in different worksheets 262\u003c\/p\u003e \u003cp\u003eCopying Formulas from Cell to Cell 263\u003c\/p\u003e \u003cp\u003eDetecting and Correcting Errors in Formulas 264\u003c\/p\u003e \u003cp\u003eCorrecting errors one at a time 264\u003c\/p\u003e \u003cp\u003eRunning the error checker 265\u003c\/p\u003e \u003cp\u003eTracing cell references 266\u003c\/p\u003e \u003cp\u003eWorking with Functions 267\u003c\/p\u003e \u003cp\u003eUsing arguments in functions 268\u003c\/p\u003e \u003cp\u003eEntering a function in a formula 269\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Making a Worksheet Easier to Read and Understand 273\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLaying Out a Worksheet 273\u003c\/p\u003e \u003cp\u003eAligning numbers and text in columns and rows 273\u003c\/p\u003e \u003cp\u003eInserting and deleting rows and columns 275\u003c\/p\u003e \u003cp\u003eChanging the size of columns and rows 277\u003c\/p\u003e \u003cp\u003eDecorating a Worksheet with Borders and Colors 278\u003c\/p\u003e \u003cp\u003eCell styles for quickly formatting a worksheet 279\u003c\/p\u003e \u003cp\u003eFormatting cells with table styles 281\u003c\/p\u003e \u003cp\u003eSlapping borders on worksheet cells 281\u003c\/p\u003e \u003cp\u003eDecorating worksheets with colors 283\u003c\/p\u003e \u003cp\u003eGetting Ready to Print a Worksheet 283\u003c\/p\u003e \u003cp\u003eMaking a worksheet fit on a page 284\u003c\/p\u003e \u003cp\u003eMaking a worksheet more presentable 287\u003c\/p\u003e \u003cp\u003eRepeating row and column headings on each page 288\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Advanced Techniques for Analyzing Data 291\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSeeing What the Sparklines Say 291\u003c\/p\u003e \u003cp\u003eManaging Information in Lists 292\u003c\/p\u003e \u003cp\u003eSorting a list 293\u003c\/p\u003e \u003cp\u003eFiltering a list 293\u003c\/p\u003e \u003cp\u003eForecasting with the Goal Seek Command 295\u003c\/p\u003e \u003cp\u003ePerforming What-If Analyses with Data Tables 297\u003c\/p\u003e \u003cp\u003eUsing a one-input table for analysis 297\u003c\/p\u003e \u003cp\u003eUsing a two-input table for analysis 299\u003c\/p\u003e \u003cp\u003eAnalyzing Data with PivotTables 300\u003c\/p\u003e \u003cp\u003eCreating a PivotTable 301\u003c\/p\u003e \u003cp\u003ePutting the finishing touches on a PivotTable 302\u003c\/p\u003e \u003cp\u003eBook IV: PowerPoint 2013 303\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Getting Started in PowerPoint 305\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGetting Acquainted with PowerPoint 306\u003c\/p\u003e \u003cp\u003eA Brief Geography Lesson 307\u003c\/p\u003e \u003cp\u003eA Whirlwind Tour of PowerPoint 309\u003c\/p\u003e \u003cp\u003eCreating a New Presentation 310\u003c\/p\u003e \u003cp\u003eAdvice for Building Persuasive Presentations 312\u003c\/p\u003e \u003cp\u003eCreating New Slides for Your Presentation 315\u003c\/p\u003e \u003cp\u003eInserting a new slide 315\u003c\/p\u003e \u003cp\u003eSpeed techniques for inserting slides 317\u003c\/p\u003e \u003cp\u003eConjuring slides from Word document headings 318\u003c\/p\u003e \u003cp\u003eSelecting a different layout for a slide 318\u003c\/p\u003e \u003cp\u003eGetting a Better View of Your Work 319\u003c\/p\u003e \u003cp\u003eChanging views 319\u003c\/p\u003e \u003cp\u003eLooking at the different views 319\u003c\/p\u003e \u003cp\u003eHiding and Displaying the Slides Pane and Notes Pane 321\u003c\/p\u003e \u003cp\u003eSelecting, Moving, and Deleting Slides 321\u003c\/p\u003e \u003cp\u003eSelecting slides 321\u003c\/p\u003e \u003cp\u003eMoving slides 322\u003c\/p\u003e \u003cp\u003eDeleting slides 322\u003c\/p\u003e \u003cp\u003ePutting Together a Photo Album 322\u003c\/p\u003e \u003cp\u003eCreating your photo album 323\u003c\/p\u003e \u003cp\u003ePutting on the final touches 325\u003c\/p\u003e \u003cp\u003eEditing a photo album 325\u003c\/p\u003e \u003cp\u003eHidden Slides for All Contingencies 325\u003c\/p\u003e \u003cp\u003eHiding a slide 326\u003c\/p\u003e \u003cp\u003eShowing a hidden slide during a presentation 326\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Fashioning a Look for Your Presentation 327\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLooking at Themes and Slide Backgrounds 327\u003c\/p\u003e \u003cp\u003eChoosing a Theme for Your Presentation 329\u003c\/p\u003e \u003cp\u003eCreating Slide Backgrounds on Your Own 330\u003c\/p\u003e \u003cp\u003eUsing a solid (or transparent) color for the slide background 330\u003c\/p\u003e \u003cp\u003eCreating a gradient color blend for slide backgrounds 331\u003c\/p\u003e \u003cp\u003ePlacing a picture in the slide background 332\u003c\/p\u003e \u003cp\u003eUsing a photo of your own for a slide background 334\u003c\/p\u003e \u003cp\u003eUsing a texture for a slide background 335\u003c\/p\u003e \u003cp\u003eChanging the Background of a Single or Handful of Slides 336\u003c\/p\u003e \u003cp\u003eChoosing the Slide Size 337\u003c\/p\u003e \u003cp\u003eUsing Master Slides and Master Styles for a Consistent Design 337\u003c\/p\u003e \u003cp\u003eSwitching to Slide Master view 338\u003c\/p\u003e \u003cp\u003eUnderstanding master slides and master styles 338\u003c\/p\u003e \u003cp\u003eEditing a master slide 340\u003c\/p\u003e \u003cp\u003eChanging a master slide layout 340\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Entering the Text 341\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEntering Text 341\u003c\/p\u003e \u003cp\u003eChoosing fonts for text 342\u003c\/p\u003e \u003cp\u003eChanging the font size of text 342\u003c\/p\u003e \u003cp\u003eChanging the look of text 343\u003c\/p\u003e \u003cp\u003eFun with Text Boxes and Text Box Shapes 345\u003c\/p\u003e \u003cp\u003eControlling How Text Fits in Text Frames and Text Boxes 346\u003c\/p\u003e \u003cp\u003eChoosing how PowerPoint “AutoFits” text in text frames 346\u003c\/p\u003e \u003cp\u003eChoosing how PowerPoint “AutoFits” text in text boxes 349\u003c\/p\u003e \u003cp\u003ePositioning Text in Frames and Text Boxes 349\u003c\/p\u003e \u003cp\u003eHandling Bulleted and Numbered Lists 350\u003c\/p\u003e \u003cp\u003eCreating a standard bulleted or numbered list 350\u003c\/p\u003e \u003cp\u003eChoosing a different bullet character, size, and color 351\u003c\/p\u003e \u003cp\u003eChoosing a different list-numbering style, size, and color 352\u003c\/p\u003e \u003cp\u003ePutting Footers (and Headers) on Slides 353\u003c\/p\u003e \u003cp\u003eSome background on footers and headers 353\u003c\/p\u003e \u003cp\u003ePutting a standard footer on all your slides 354\u003c\/p\u003e \u003cp\u003eCreating a nonstandard footer 354\u003c\/p\u003e \u003cp\u003eRemoving a footer from a single slide 356\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Making Your Presentations Livelier 357\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSuggestions for Enlivening Your Presentation 357\u003c\/p\u003e \u003cp\u003ePresenting Information in a Table 358\u003c\/p\u003e \u003cp\u003eExploring Transitions and Animations 360\u003c\/p\u003e \u003cp\u003eShowing transitions between slides 361\u003c\/p\u003e \u003cp\u003eAnimating parts of a slide 362\u003c\/p\u003e \u003cp\u003eMaking Audio Part of Your Presentation 364\u003c\/p\u003e \u003cp\u003eInserting an audio file on a slide 365\u003c\/p\u003e \u003cp\u003eTelling PowerPoint when and how to play an audio file 366\u003c\/p\u003e \u003cp\u003ePlaying audio during a presentation 367\u003c\/p\u003e \u003cp\u003ePlaying Video on Slides 368\u003c\/p\u003e \u003cp\u003eInserting a video on a slide 368\u003c\/p\u003e \u003cp\u003eFine-tuning a video presentation 368\u003c\/p\u003e \u003cp\u003eExperimenting with the look of the video 370\u003c\/p\u003e \u003cp\u003eRecording a Voice Narration for Slides 371\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Delivering a Presentation 373\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAll about Notes 373\u003c\/p\u003e \u003cp\u003eRehearsing and Timing Your Presentation 374\u003c\/p\u003e \u003cp\u003eShowing Your Presentation 375\u003c\/p\u003e \u003cp\u003eStarting and ending a presentation 376\u003c\/p\u003e \u003cp\u003eGoing from slide to slide 377\u003c\/p\u003e \u003cp\u003eTricks for Making Presentations a Little Livelier 379\u003c\/p\u003e \u003cp\u003eWielding a pen or highlighter in a presentation 379\u003c\/p\u003e \u003cp\u003eBlanking the screen 381\u003c\/p\u003e \u003cp\u003eZooming In 381\u003c\/p\u003e \u003cp\u003eDelivering a Presentation When You Can’t Be There in Person 382\u003c\/p\u003e \u003cp\u003eProviding handouts for your audience 382\u003c\/p\u003e \u003cp\u003eCreating a self-running, kiosk-style presentation 383\u003c\/p\u003e \u003cp\u003eCreating a user-run presentation 385\u003c\/p\u003e \u003cp\u003ePresenting a Presentation Online 387\u003c\/p\u003e \u003cp\u003ePackaging your presentation on a CD 389\u003c\/p\u003e \u003cp\u003eCreating a presentation video 391\u003c\/p\u003e \u003cp\u003eBook V: OneNote 2013 395\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Up and Running with OneNote 397\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing OneNote 397\u003c\/p\u003e \u003cp\u003eFinding Your Way Around the OneNote Screen 398\u003c\/p\u003e \u003cp\u003eNotebook pane 399\u003c\/p\u003e \u003cp\u003eSection (and section group) tabs 399\u003c\/p\u003e \u003cp\u003ePage window 399\u003c\/p\u003e \u003cp\u003ePage pane 399\u003c\/p\u003e \u003cp\u003eUnits for Organizing Notes 399\u003c\/p\u003e \u003cp\u003eCreating a Notebook 400\u003c\/p\u003e \u003cp\u003eCreating Sections and Section Groups 402\u003c\/p\u003e \u003cp\u003eCreating a new section 402\u003c\/p\u003e \u003cp\u003eCreating a section group 403\u003c\/p\u003e \u003cp\u003eCreating Pages and Subpages 404\u003c\/p\u003e \u003cp\u003eCreating a new page 404\u003c\/p\u003e \u003cp\u003eCreating a new subpage 404\u003c\/p\u003e \u003cp\u003eRenaming and Deleting Groups and Pages 405\u003c\/p\u003e \u003cp\u003eGetting from Place to Place in OneNote 405\u003c\/p\u003e \u003cp\u003eChanging Your View of OneNote 406\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Taking Notes 409\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEntering a Typewritten Note 409\u003c\/p\u003e \u003cp\u003eNotes: The Basics 409\u003c\/p\u003e \u003cp\u003eMoving and resizing note containers 410\u003c\/p\u003e \u003cp\u003eFormatting the Text in Notes 410\u003c\/p\u003e \u003cp\u003eSelecting notes 411\u003c\/p\u003e \u003cp\u003eDeleting notes 412\u003c\/p\u003e \u003cp\u003eGetting more space for notes on a page 412\u003c\/p\u003e \u003cp\u003eDrawing on the Page 412\u003c\/p\u003e \u003cp\u003eDrawing with a pen or highlighter 413\u003c\/p\u003e \u003cp\u003eDrawing a shape 413\u003c\/p\u003e \u003cp\u003eChanging the size and appearance of drawings and shapes 415\u003c\/p\u003e \u003cp\u003eConverting a Handwritten Note to Text 416\u003c\/p\u003e \u003cp\u003eWriting a Math Expression in a Note 417\u003c\/p\u003e \u003cp\u003eTaking a Screen-Clipping Note 418\u003c\/p\u003e \u003cp\u003eRecording and Playing Audio Notes 419\u003c\/p\u003e \u003cp\u003eRecording an audio note 420\u003c\/p\u003e \u003cp\u003ePlaying an audio note 420\u003c\/p\u003e \u003cp\u003eAttaching, Copying, and Linking Files to Notes 421\u003c\/p\u003e \u003cp\u003eAttaching an Office file to a note 421\u003c\/p\u003e \u003cp\u003eCopying an Office file into OneNote 423\u003c\/p\u003e \u003cp\u003eLinking a Word or PowerPoint file to OneNote 423\u003c\/p\u003e \u003cp\u003eCopying a note into another Office program 424\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Finding and Organizing Your Notes 425\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFinding a Stray Note 425\u003c\/p\u003e \u003cp\u003eSearching by word or phrase 425\u003c\/p\u003e \u003cp\u003eSearching by author 426\u003c\/p\u003e \u003cp\u003eTagging Notes for Follow Up 427\u003c\/p\u003e \u003cp\u003eTagging a note 428\u003c\/p\u003e \u003cp\u003eArranging tagged notes in the task pane 428\u003c\/p\u003e \u003cp\u003eCreating and modifying tags 429\u003c\/p\u003e \u003cp\u003eColor-Coding Notebooks, Sections, and Pages 430\u003c\/p\u003e \u003cp\u003eMerging and Moving Sections, Pages, and Notes 431\u003c\/p\u003e \u003cp\u003eBook VI: Working with Charts and Graphics 433\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Creating a Chart 435\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Basics: Creating a Chart 435\u003c\/p\u003e \u003cp\u003eChoosing the Right Chart 437\u003c\/p\u003e \u003cp\u003eArea charts 438\u003c\/p\u003e \u003cp\u003eBar charts 439\u003c\/p\u003e \u003cp\u003eColumn charts 440\u003c\/p\u003e \u003cp\u003eCombo charts 442\u003c\/p\u003e \u003cp\u003eLine charts 442\u003c\/p\u003e \u003cp\u003ePie charts 443\u003c\/p\u003e \u003cp\u003eRadar charts 444\u003c\/p\u003e \u003cp\u003eStock charts 445\u003c\/p\u003e \u003cp\u003eSurface charts 446\u003c\/p\u003e \u003cp\u003eXY (scatter) charts 447\u003c\/p\u003e \u003cp\u003eProviding the Raw Data for Your Chart 448\u003c\/p\u003e \u003cp\u003ePositioning Your Chart in a Workbook, Page, or Slide 450\u003c\/p\u003e \u003cp\u003eChanging a Chart’s Appearance 450\u003c\/p\u003e \u003cp\u003eChanging the chart type 452\u003c\/p\u003e \u003cp\u003eChanging the size and shape of a chart 452\u003c\/p\u003e \u003cp\u003eChoosing a new look for your chart 452\u003c\/p\u003e \u003cp\u003eChanging the layout of a chart 453\u003c\/p\u003e \u003cp\u003eHandling the gridlines 454\u003c\/p\u003e \u003cp\u003eChanging a chart element’s color, font, or other particular 455\u003c\/p\u003e \u003cp\u003eSaving a Chart as a Template So That You Can Use It Again 456\u003c\/p\u003e \u003cp\u003eSaving a chart as a template 456\u003c\/p\u003e \u003cp\u003eCreating a chart from a template 457\u003c\/p\u003e \u003cp\u003eChart Tricks for the Daring and Heroic 457\u003c\/p\u003e \u003cp\u003eDecorating a chart with a picture 457\u003c\/p\u003e \u003cp\u003eAnnotating a chart 458\u003c\/p\u003e \u003cp\u003eDisplaying the raw data alongside the chart 459\u003c\/p\u003e \u003cp\u003ePlacing a trendline on a chart 460\u003c\/p\u003e \u003cp\u003eTroubleshooting a Chart 461\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Making a SmartArt Diagram 463\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Basics: Creating SmartArt Diagrams 463\u003c\/p\u003e \u003cp\u003eChoosing a diagram 464\u003c\/p\u003e \u003cp\u003eMaking the diagram your own 465\u003c\/p\u003e \u003cp\u003eCreating the Initial Diagram 465\u003c\/p\u003e \u003cp\u003eCreating a diagram 466\u003c\/p\u003e \u003cp\u003eSwapping one diagram for another 466\u003c\/p\u003e \u003cp\u003eChanging the Size and Position of a Diagram 467\u003c\/p\u003e \u003cp\u003eLaying Out the Diagram Shapes 467\u003c\/p\u003e \u003cp\u003eSelecting a diagram shape 468\u003c\/p\u003e \u003cp\u003eRemoving a shape from a diagram 468\u003c\/p\u003e \u003cp\u003eMoving diagram shapes to different positions 468\u003c\/p\u003e \u003cp\u003eAdding shapes to diagrams apart from hierarchy diagrams 469\u003c\/p\u003e \u003cp\u003eAdding shapes to hierarchy diagrams 470\u003c\/p\u003e \u003cp\u003eAdding shapes to Organization charts 471\u003c\/p\u003e \u003cp\u003ePromoting and demoting shapes in hierarchy diagrams 473\u003c\/p\u003e \u003cp\u003eHandling the Text on Diagram Shapes 474\u003c\/p\u003e \u003cp\u003eEntering text on a diagram shape 474\u003c\/p\u003e \u003cp\u003eEntering bulleted lists on diagram shapes 474\u003c\/p\u003e \u003cp\u003eChanging a Diagram’s Direction 475\u003c\/p\u003e \u003cp\u003eChoosing a Look for Your Diagram 476\u003c\/p\u003e \u003cp\u003eChanging the Appearance of Diagram Shapes 477\u003c\/p\u003e \u003cp\u003eChanging the size of a diagram shape 477\u003c\/p\u003e \u003cp\u003eExchanging one shape for another 478\u003c\/p\u003e \u003cp\u003eChanging a shape’s color, fill, or outline 478\u003c\/p\u003e \u003cp\u003eChanging fonts and font sizes on shapes 480\u003c\/p\u003e \u003cp\u003eCreating a Diagram from Scratch 480\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Handling Graphics, Photos, and Clip Art 481\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAll about Picture File Formats 481\u003c\/p\u003e \u003cp\u003eBitmap and vector graphics 481\u003c\/p\u003e \u003cp\u003eResolution 483\u003c\/p\u003e \u003cp\u003eCompression 484\u003c\/p\u003e \u003cp\u003eColor depth 484\u003c\/p\u003e \u003cp\u003eChoosing file formats for graphics 485\u003c\/p\u003e \u003cp\u003eInserting a Picture in an Office File 485\u003c\/p\u003e \u003cp\u003eInserting a picture of your own 486\u003c\/p\u003e \u003cp\u003eObtaining a picture online 487\u003c\/p\u003e \u003cp\u003eTouching Up a Picture 489\u003c\/p\u003e \u003cp\u003eSoftening and sharpening pictures 489\u003c\/p\u003e \u003cp\u003eCorrecting a picture’s brightness and contrast 490\u003c\/p\u003e \u003cp\u003eRecoloring a picture 491\u003c\/p\u003e \u003cp\u003eChoosing an artistic effect 492\u003c\/p\u003e \u003cp\u003eSelecting a picture style 493\u003c\/p\u003e \u003cp\u003eCropping off part of a picture 494\u003c\/p\u003e \u003cp\u003eRemoving the background 495\u003c\/p\u003e \u003cp\u003eCompressing Pictures to Save Disk Space 496\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 499\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Basics: Drawing Lines, Arrows, and Shapes 500\u003c\/p\u003e \u003cp\u003eHandling Lines, Arrows, and Connectors 501\u003c\/p\u003e \u003cp\u003eChanging the length and position of a line or arrow 502\u003c\/p\u003e \u003cp\u003eChanging the appearance of a line, arrow, or connector 502\u003c\/p\u003e \u003cp\u003eAttaching and handling arrowheads on lines and connectors 504\u003c\/p\u003e \u003cp\u003eConnecting shapes by using connectors 504\u003c\/p\u003e \u003cp\u003eHandling Rectangles, Ovals, Stars, and Other Shapes 506\u003c\/p\u003e \u003cp\u003eDrawing a shape 506\u003c\/p\u003e \u003cp\u003eChanging a shape’s symmetry 508\u003c\/p\u003e \u003cp\u003eUsing a shape as a text box 508\u003c\/p\u003e \u003cp\u003eWordArt for Embellishing Letters and Words 509\u003c\/p\u003e \u003cp\u003eCreating WordArt 510\u003c\/p\u003e \u003cp\u003eEditing WordArt 510\u003c\/p\u003e \u003cp\u003eManipulating Lines, Shapes, Art, Text Boxes, and Other Objects 511\u003c\/p\u003e \u003cp\u003eSelecting objects so that you can manipulate them 512\u003c\/p\u003e \u003cp\u003eHiding and displaying the rulers and grid 513\u003c\/p\u003e \u003cp\u003eChanging an Object’s Size and Shape 514\u003c\/p\u003e \u003cp\u003eChanging an Object’s Color, Outline Color, and Transparency 515\u003c\/p\u003e \u003cp\u003eFilling an object with color, a picture, or a texture 516\u003c\/p\u003e \u003cp\u003eMaking a color transparent 518\u003c\/p\u003e \u003cp\u003ePutting the outline around an object 518\u003c\/p\u003e \u003cp\u003eMoving and Positioning Objects 520\u003c\/p\u003e \u003cp\u003eTricks for aligning and distributing objects 520\u003c\/p\u003e \u003cp\u003eWhen objects overlap: Choosing which appears above the other 523\u003c\/p\u003e \u003cp\u003eRotating and flipping objects 525\u003c\/p\u003e \u003cp\u003eGrouping objects to make working with them easier 526\u003c\/p\u003e \u003cp\u003eBook VII: Office 2013 — One Step Beyond 529\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Customizing an Office Program 531\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCustomizing the Ribbon 531\u003c\/p\u003e \u003cp\u003eDisplaying and selecting tab, group, and command names 533\u003c\/p\u003e \u003cp\u003eMoving tabs and groups on the Ribbon 533\u003c\/p\u003e \u003cp\u003eAdding, removing, and renaming tabs, groups, and commands 534\u003c\/p\u003e \u003cp\u003eCreating new tabs and groups 535\u003c\/p\u003e \u003cp\u003eResetting your Ribbon customizations 536\u003c\/p\u003e \u003cp\u003eCustomizing the Quick Access Toolbar 537\u003c\/p\u003e \u003cp\u003eAdding buttons to the Quick Access toolbar 537\u003c\/p\u003e \u003cp\u003eChanging the order of buttons on the Quick Access toolbar 539\u003c\/p\u003e \u003cp\u003eRemoving buttons from the Quick Access toolbar 539\u003c\/p\u003e \u003cp\u003ePlacing the Quick Access toolbar above or below the Ribbon 539\u003c\/p\u003e \u003cp\u003eCustomizing the Status Bar 540\u003c\/p\u003e \u003cp\u003eChanging the Screen Background 541\u003c\/p\u003e \u003cp\u003eCustomizing Keyboard Shortcuts in Word 542\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Ways of Distributing Your Work 545\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePrinting — the Old Standby 545\u003c\/p\u003e \u003cp\u003eDistributing a File in PDF Format 546\u003c\/p\u003e \u003cp\u003eAbout PDF files 546\u003c\/p\u003e \u003cp\u003eSaving an Office file as a PDF 547\u003c\/p\u003e \u003cp\u003eSaving an Office File as a Web Page 548\u003c\/p\u003e \u003cp\u003eChoosing how to save the component parts 548\u003c\/p\u003e \u003cp\u003eTurning a file into a web page 549\u003c\/p\u003e \u003cp\u003eOpening a web page in your browser 550\u003c\/p\u003e \u003cp\u003eBlogging from inside Word 550\u003c\/p\u003e \u003cp\u003eDescribing a blog account to Word 550\u003c\/p\u003e \u003cp\u003ePosting an entry to your blog 552\u003c\/p\u003e \u003cp\u003eTaking advantage of the Blog Post tab 552\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Automating Tasks with Macros 553\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is a Macro? 553\u003c\/p\u003e \u003cp\u003eDisplaying the Developer Tab 554\u003c\/p\u003e \u003cp\u003eManaging the Macro Security Problem 554\u003c\/p\u003e \u003cp\u003eRecording a Macro 556\u003c\/p\u003e \u003cp\u003eEnabling your files for macros 556\u003c\/p\u003e \u003cp\u003eGround rules for recording macros 557\u003c\/p\u003e \u003cp\u003eRecording the macro 558\u003c\/p\u003e \u003cp\u003eRunning a Macro 560\u003c\/p\u003e \u003cp\u003eEditing a Macro 561\u003c\/p\u003e \u003cp\u003eOpening a macro in the Visual Basic Editor 561\u003c\/p\u003e \u003cp\u003eReading a macro in the Code window 562\u003c\/p\u003e \u003cp\u003eEditing the text that a macro enters 562\u003c\/p\u003e \u003cp\u003eDeleting parts of a macro 563\u003c\/p\u003e \u003cp\u003eRunning a Macro from a Button on the Quick Access Toolbar 563\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: Linking and Embedding in Compound Files 565\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is OLE, Anyway? 565\u003c\/p\u003e \u003cp\u003eLinking and embedding 566\u003c\/p\u003e \u003cp\u003eUses for object linking 566\u003c\/p\u003e \u003cp\u003eUses for object embedding 568\u003c\/p\u003e \u003cp\u003ePitfalls of object linking and embedding 568\u003c\/p\u003e \u003cp\u003eEmbedding Data from Other Programs 568\u003c\/p\u003e \u003cp\u003eEmbedding foreign data 569\u003c\/p\u003e \u003cp\u003eEditing an embedded object 571\u003c\/p\u003e \u003cp\u003eLinking to a Source File 571\u003c\/p\u003e \u003cp\u003eEstablishing the link 572\u003c\/p\u003e \u003cp\u003eUpdating a link 573\u003c\/p\u003e \u003cp\u003eEditing data in the source file 574\u003c\/p\u003e \u003cp\u003eConverting a linked object to an embedded object 574\u003c\/p\u003e \u003cp\u003eBook VIII: File Sharing and Collaborating 577\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Preparing to Use the Office Web Apps 579\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing the Office Web Apps 579\u003c\/p\u003e \u003cp\u003eStoring and Sharing Files on the Internet 580\u003c\/p\u003e \u003cp\u003eOffice Web Apps: The Big Picture 581\u003c\/p\u003e \u003cp\u003eCreating a Microsoft Account 582\u003c\/p\u003e \u003cp\u003eSigning In and Out of Your Microsoft Account 582\u003c\/p\u003e \u003cp\u003eNavigating in a Microsoft Account 583\u003c\/p\u003e \u003cp\u003eManaging Your Folders 583\u003c\/p\u003e \u003cp\u003eCreating a folder 584\u003c\/p\u003e \u003cp\u003eViewing and locating folders in the SkyDrive window 584\u003c\/p\u003e \u003cp\u003eGoing from folder to folder in SkyDrive 586\u003c\/p\u003e \u003cp\u003eDeleting, moving, and renaming folders 587\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: Using the Office Web Apps 589\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating an Office File in SkyDrive 589\u003c\/p\u003e \u003cp\u003eUploading Office Files to a Folder on SkyDrive 590\u003c\/p\u003e \u003cp\u003eSaving a File from Office 2013 to SkyDrive 591\u003c\/p\u003e \u003cp\u003eOpening Office Files Stored on SkyDrive 593\u003c\/p\u003e \u003cp\u003eOpening a file in an Office Web App 593\u003c\/p\u003e \u003cp\u003eOpening a file in an Office 2013 application 593\u003c\/p\u003e \u003cp\u003eDownloading Files from SkyDrive to Your Computer 595\u003c\/p\u003e \u003cp\u003eManaging Your Files on SkyDrive 596\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: Sharing and Collaborating 599\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSharing Files: The Big Picture 599\u003c\/p\u003e \u003cp\u003eFile access privileges 599\u003c\/p\u003e \u003cp\u003eLinks for sharing files 600\u003c\/p\u003e \u003cp\u003eSharing Your Files and Folders with Others 601\u003c\/p\u003e \u003cp\u003eSeeing Files and Folders Others Have Shared with You 603\u003c\/p\u003e \u003cp\u003eInvestigating and Changing How Files and Folders Are Shared 603\u003c\/p\u003e \u003cp\u003eCo-editing Shared Files on SkyDrive 605\u003c\/p\u003e \u003cp\u003eSoliciting Information with a Survey Form 605\u003c\/p\u003e \u003cp\u003eIndex 609\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePeter Weverka\u003c\/b\u003e is a veteran \u003ci\u003eFor Dummies\u003c\/i\u003e author who has written about a wide variety of applications. Along with two bestselling editions of \u003ci\u003eOffice All-in-One For Dummies\u003c\/i\u003e, Peter has written \u003ci\u003ePowerPoint All-in-One For Dummies\u003c\/i\u003e and \u003ci\u003eMicrosoft Money For Dummies\u003c\/i\u003e.\u003c\/p\u003e  \u003cp\u003e8 books in 1\u003c\/p\u003e \u003cul\u003e \u003cli\u003eCommon Office Tasks\u003c\/li\u003e \u003cli\u003eWord 2013\u003c\/li\u003e \u003cli\u003eExcel® 2013\u003c\/li\u003e \u003cli\u003ePowerPoint® 2013\u003c\/li\u003e \u003cli\u003eOneNote® 2013\u003c\/li\u003e \u003cli\u003eWorking with Charts and Graphics\u003c\/li\u003e \u003cli\u003eOffice 2013 — One Step Beyond\u003c\/li\u003e \u003cli\u003eFile Sharing and Collaborating\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eComplete home and school projects with the same tools business pros use\u003c\/p\u003e \u003cp\u003eWhether you're adding footnotes to a term paper, creating a household budget, or adding video to a presentation, \u003ci\u003eMicrosoft Office Home \u0026amp; Student\u003c\/i\u003e provides the tools you need to get the job done. This book offers the guidance to complete those tasks, along with many others, using Word, Excel, PowerPoint, and OneNote. It's the easy way to become an Office pro at home or school.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eThe Office family — explore the similarities among the Office programs, learn to use the interface, and pick up some handy speed techniques\u003c\/li\u003e \u003cli\u003eThe last Word — master Word basics and learn to lay out pages, build tables, use the proofing tools, and create scholarly papers\u003c\/li\u003e \u003cli\u003eExcel at Excel — create worksheets and workbooks, use formulas and functions, and discover how to analyze data\u003c\/li\u003e \u003cli\u003eMake your PowerPoint — put together a professional-looking slide show and learn to make your presentation perfect\u003c\/li\u003e \u003cli\u003eOne perfect note — see how OneNote can help you keep, find, and manage study notes\u003c\/li\u003e \u003cli\u003eChart-toppers — use data from Excel, Word, and PowerPoint to develop charts that communicate\u003c\/li\u003e \u003cli\u003eBeyond the basics — discover how to automate tasks with macros, add links, embed data, and collaborate online\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eOpen the book and find:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eThe common tools found in Office applications\u003c\/li\u003e \u003cli\u003eTricks for using Word Styles\u003c\/li\u003e \u003cli\u003eSecrets for creating mass mailings\u003c\/li\u003e \u003cli\u003eWays to forecast and analyze data\u003c\/li\u003e \u003cli\u003eHow to make your PowerPoint presentation memorable\u003c\/li\u003e \u003cli\u003eQuick ways to find missing notes\u003c\/li\u003e \u003cli\u003eSteps for creating a SmartArt diagram\u003c\/li\u003e \u003cli\u003eTips on using Office Web Apps and SkyDrive\u003c\/li\u003e \u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47989623390437,"sku":"NP9781118516379","price":29.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118516379.jpg?v=1761784850","url":"https:\/\/k12savings.com\/products\/microsoft-office-home-and-student-edition-2013-all-in-one-for-dummies-isbn-9781118516379","provider":"K12savings","version":"1.0","type":"link"}