<p style="MARGIN: 0px"></p> <p style="MARGIN: 0px" kfmtocchapttl=""> Introduction 1</p> <div style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 7pt; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in; mso-border-bottom-alt: solid black .5pt; mso-element: para-border-div"> <p style="MARGIN: 0px">I Introduction to the Office 2016 Application Suite</p> </div> <p style="MARGIN: 0px">1 Getting Oriented to the Office 2016 Applications 5</p> <p style="MARGIN: 0px"> Introducing Office 2016 5</p> <p style="MARGIN: 0px"> New Features and Tools in Office 2016 8</p> <p style="MARGIN: 0px"> Saving and Sharing Files in the Cloud 8</p> <p style="MARGIN: 0px"> Editing Adobe Acrobat Files 9</p> <p style="MARGIN: 0px"> Other Office 2016 Improvements and Updates 10</p> <p style="MARGIN: 0px"> The Office 2016 Suite Applications 11</p> <p style="MARGIN: 0px"> The Different Versions of the Office 2016 Suite 12</p> <p style="MARGIN: 0px"> Hardware and Software Requirements for Office 2016 13</p> <p style="MARGIN: 0px"> Installing Office 2016 14</p> <p style="MARGIN: 0px"> Getting Help in the Office Applications 16</p> <p style="MARGIN: 0px">2 Navigating and Customizing the Office Interface 19</p> <p style="MARGIN: 0px"> Getting Familiar with the Office Interface 19</p> <p style="MARGIN: 0px"> Galleries 20</p> <p style="MARGIN: 0px"> Contextual Tabs 21</p> <p style="MARGIN: 0px"> Overview of the Office Application Window 22</p> <p style="MARGIN: 0px"> Navigating the Office Applications 25</p> <p style="MARGIN: 0px"> Working with the Ribbon 25</p> <p style="MARGIN: 0px"> Working in the Backstage 28</p> <p style="MARGIN: 0px"> Customizing an Application Interface 30</p> <p style="MARGIN: 0px"> Customizing the Ribbon 31</p> <p style="MARGIN: 0px"> Customizing the Quick Access Toolbar 33</p> <p style="MARGIN: 0px"> Customizing the Status Bar 36</p> <p style="MARGIN: 0px"> Configuring Application Options 37</p> <p style="MARGIN: 0px"> Advanced Option Settings 39</p> <p style="MARGIN: 0px"> Add-Ins 39</p> <p style="MARGIN: 0px"> Using Office Add-ins 40</p> <p style="MARGIN: 0px"> Using the Trust Center 41</p> <p style="MARGIN: 0px"> Trusted Publishers 43</p> <p style="MARGIN: 0px"> Trusted Locations 44</p> <p style="MARGIN: 0px">3 Managing and Sharing Office Files 47</p> <p style="MARGIN: 0px"> Understanding Office File Formats 47</p> <p style="MARGIN: 0px"> Saving Files as Different File Types 50</p> <p style="MARGIN: 0px"> Converting Files to Different File Types 51</p> <p style="MARGIN: 0px"> Configuring Save File Options 52</p> <p style="MARGIN: 0px"> Creating and Managing Files 54</p> <p style="MARGIN: 0px"> Managing Files 56</p> <p style="MARGIN: 0px"> Creating a New Folder 57</p> <p style="MARGIN: 0px"> Creating a New Library 58</p> <p style="MARGIN: 0px"> Viewing File Versions in an Application 59</p> <p style="MARGIN: 0px"> Searching for Office Files 60</p> <p style="MARGIN: 0px"> Sharing Files Using Homegroup 61</p> <p style="MARGIN: 0px"> Protecting an Office File 63</p> <p style="MARGIN: 0px"> Prepare a File for Sharing 65</p> <p style="MARGIN: 0px">4 Using and Creating Graphics 67</p> <p style="MARGIN: 0px"> The Office 2016 Options for Graphics and Pictures 67</p> <p style="MARGIN: 0px"> Working with SmartArt Graphics 70</p> <p style="MARGIN: 0px"> Inserting SmartArt Graphics 72</p> <p style="MARGIN: 0px"> Modifying SmartArt Graphics 74</p> <p style="MARGIN: 0px"> Working with Your Digital Pictures 77</p> <p style="MARGIN: 0px"> Inserting Pictures 77</p> <p style="MARGIN: 0px"> Adjusting Pictures 78</p> <p style="MARGIN: 0px"> Cropping an Image 81</p> <p style="MARGIN: 0px"> Using the Background Removal Tool 81</p> <p style="MARGIN: 0px"> Inserting Online Pictures 83</p> <p style="MARGIN: 0px"> Inserting Bing Image Search Results 84</p> <p style="MARGIN: 0px"> Inserting Facebook Images 84</p> <p style="MARGIN: 0px"> Inserting Flickr.com Images 85</p> <p style="MARGIN: 0px"> Inserting Images from Your OneDrive 86</p> <p style="MARGIN: 0px"> Using Shapes and the Office Drawing Tools 87</p> <p style="MARGIN: 0px"> Adding and Combining Multiple Shapes 88</p> <p style="MARGIN: 0px"> Formatting a Shape with the Drawing Tools 90</p> <p style="MARGIN: 0px"> Using the Screenshot Feature 91</p> <p style="MARGIN: 0px"> Using WordArt 93</p> <p style="MARGIN: 0px">5 Using the Office Apps 95</p> <p style="MARGIN: 0px"> What the Online Apps Can Do 96</p> <p style="MARGIN: 0px"> Where the Online Apps Live 97</p> <p style="MARGIN: 0px"> Saving Office Application Files to the Cloud 99</p> <p style="MARGIN: 0px"> Saving a File to OneDrive or OneDrive for Business 101</p> <p style="MARGIN: 0px"> Sharing a File Saved to the Cloud 102</p> <p style="MARGIN: 0px"> Using the Word Online app 104</p> <p style="MARGIN: 0px"> The Word Online App’s File Tab 105</p> <p style="MARGIN: 0px"> The Word Online App’s Home Tab 106</p> <p style="MARGIN: 0px"> The Word Online App’s Insert Tab 107</p> <p style="MARGIN: 0px"> The Word Online App’s Review Tab 108</p> <p style="MARGIN: 0px"> The Word Online App’s View Tab 108</p> <p style="MARGIN: 0px"> Using Excel Online 109</p> <p style="MARGIN: 0px"> The Excel Online App’s File Tab 109</p> <p style="MARGIN: 0px"> Working in the Excel Online App 110</p> <p style="MARGIN: 0px"> Inserting Functions and Charts in the Excel Online App 110</p> <p style="MARGIN: 0px"> Using PowerPoint Online 113</p> <p style="MARGIN: 0px"> Working with Slides 114</p> <p style="MARGIN: 0px"> Adding Pictures and SmartArt 115</p> <p style="MARGIN: 0px"> The Windows 10 Mobile Office Apps 116</p> <p style="MARGIN: 0px"> The Word Mobile App 117</p> <p style="MARGIN: 0px"> The Excel Mobile App 120</p> <div style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 7pt; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in; mso-border-bottom-alt: solid black .5pt; mso-element: para-border-div"> <p style="MARGIN: 0px">II Word</p> </div> <p style="MARGIN: 0px">6 Requisite Word: Essential Features 123</p> <p style="MARGIN: 0px"> Introducing Word 2016 123</p> <p style="MARGIN: 0px"> The Word 2016 Interface 123</p> <p style="MARGIN: 0px"> New Features and Improvements 125</p> <p style="MARGIN: 0px"> Options for Creating a New Word Document 126</p> <p style="MARGIN: 0px"> Using Templates 128</p> <p style="MARGIN: 0px"> Creating a Template 131</p> <p style="MARGIN: 0px"> Attaching a Template 133</p> <p style="MARGIN: 0px"> Navigating a Word Document 134</p> <p style="MARGIN: 0px"> Moving Around a Document with the Mouse 134</p> <p style="MARGIN: 0px"> Moving Around a Document with the Keyboard 135</p> <p style="MARGIN: 0px"> Selecting Text 136</p> <p style="MARGIN: 0px"> Understanding Document Formatting 137</p> <p style="MARGIN: 0px"> Character Formatting Versus Paragraph Formatting 137</p> <p style="MARGIN: 0px"> Manual Formatting Versus Styles and Themes 138</p> <p style="MARGIN: 0px"> Working with Fonts and Text Formatting 138</p> <p style="MARGIN: 0px"> Formatting Text 139</p> <p style="MARGIN: 0px"> Working with Paragraph Formatting 142</p> <p style="MARGIN: 0px"> Setting Paragraph Alignment 143</p> <p style="MARGIN: 0px"> Changing Line Spacing 144</p> <p style="MARGIN: 0px"> Setting Line and Page Breaks 145</p> <p style="MARGIN: 0px"> Setting Indents 146</p> <p style="MARGIN: 0px"> Working with Tabs 148</p> <p style="MARGIN: 0px"> Page Layout: Margins and Page Options 150</p> <p style="MARGIN: 0px"> Changing Margins 151</p> <p style="MARGIN: 0px"> Changing Page Orientation and Paper Size 152</p> <p style="MARGIN: 0px"> Inserting Page Breaks 152</p> <p style="MARGIN: 0px"> Printing Documents 152</p> <p style="MARGIN: 0px">7 Enhancing Word Documents 155</p> <p style="MARGIN: 0px"> Creating Better Documents 155</p> <p style="MARGIN: 0px"> Creating Bulleted and Numbered Lists 156</p> <p style="MARGIN: 0px"> Bulleted Lists 156</p> <p style="MARGIN: 0px"> Numbered Lists 158</p> <p style="MARGIN: 0px"> Multilevel Lists 159</p> <p style="MARGIN: 0px"> Working with Borders and Shading 160</p> <p style="MARGIN: 0px"> Formatting with Themes 162</p> <p style="MARGIN: 0px"> Creating Headers and Footers 166</p> <p style="MARGIN: 0px"> Inserting Headers and Footers 167</p> <p style="MARGIN: 0px"> The Header and Footer Tools 168</p> <p style="MARGIN: 0px"> Working with Page Numbering 170</p> <p style="MARGIN: 0px"> Inserting Pictures, Clip Art, and Charts 171</p> <p style="MARGIN: 0px"> Inserting Pictures 172</p> <p style="MARGIN: 0px"> Inserting Online Pictures and Clip Art 173</p> <p style="MARGIN: 0px"> Inserting a Chart 175</p> <p style="MARGIN: 0px"> Integrating Text and Images 177</p> <p style="MARGIN: 0px"> Changing the Document Display 178</p> <p style="MARGIN: 0px"> Using the Navigation Pane 180</p> <p style="MARGIN: 0px"> Using the Outline View 181</p> <p style="MARGIN: 0px"> Splitting the Document Window 182</p> <p style="MARGIN: 0px"> Using the Review Tools 183</p> <p style="MARGIN: 0px"> Running Spelling and Grammar 183</p> <p style="MARGIN: 0px"> Using the Thesaurus 184</p> <p style="MARGIN: 0px"> Using the Insights Command 185</p> <p style="MARGIN: 0px"> Working with Quick Parts 186</p> <p style="MARGIN: 0px"> Creating and Inserting an AutoText Entry 186</p> <p style="MARGIN: 0px"> Creating and Inserting Building Blocks 187</p> <p style="MARGIN: 0px"> Configuring AutoCorrect 188</p> <p style="MARGIN: 0px"> Understanding Styles 189</p> <p style="MARGIN: 0px"> Using the Styles Gallery 190</p> <p style="MARGIN: 0px"> Creating Styles 191</p> <p style="MARGIN: 0px"> Editing Styles 192</p> <p style="MARGIN: 0px"> Managing Styles 193</p> <p style="MARGIN: 0px">8 Working with Tables, Columns, and Sections 197</p> <p style="MARGIN: 0px"> Options for Adding a Table 197</p> <p style="MARGIN: 0px"> Inserting a Table 199</p> <p style="MARGIN: 0px"> Drawing a Table 201</p> <p style="MARGIN: 0px"> Converting Text to a Table 201</p> <p style="MARGIN: 0px"> Entering and Deleting Text and Navigating a Table 202</p> <p style="MARGIN: 0px"> Selecting and Positioning a Table 203</p> <p style="MARGIN: 0px"> Formatting Tables 204</p> <p style="MARGIN: 0px"> Adjusting Columns and Rows 206</p> <p style="MARGIN: 0px"> Formatting Cells 207</p> <p style="MARGIN: 0px"> Using Table Styles 209</p> <p style="MARGIN: 0px"> Sorting Table Data 211</p> <p style="MARGIN: 0px"> Using Formulas in Tables 212</p> <p style="MARGIN: 0px"> Adding Columns to a Document 214</p> <p style="MARGIN: 0px"> Understanding Sections 215</p> <p style="MARGIN: 0px"> Adding and Removing Section Breaks 216</p> <p style="MARGIN: 0px"> Formatting Page Attributes in a Section 217</p> <p style="MARGIN: 0px">9 Managing Mailings and Forms 219</p> <p style="MARGIN: 0px"> Options for Mail-Related Documents 219</p> <p style="MARGIN: 0px"> Creating an Envelope 220</p> <p style="MARGIN: 0px"> Creating a Label or Labels 222</p> <p style="MARGIN: 0px"> Understanding Mass Mailings 223</p> <p style="MARGIN: 0px"> Performing a Mail Merge 223</p> <p style="MARGIN: 0px"> Using the Mail Merge Commands 225</p> <p style="MARGIN: 0px"> Understanding Recipient Lists 226</p> <p style="MARGIN: 0px"> Creating a Recipient List 227</p> <p style="MARGIN: 0px"> Editing and Manipulating a Recipient List 229</p> <p style="MARGIN: 0px"> Using Merge Fields 231</p> <p style="MARGIN: 0px"> Using Merge Rules 233</p> <p style="MARGIN: 0px"> Previewing Merge Results 234</p> <p style="MARGIN: 0px"> Completing the Merge 235</p> <p style="MARGIN: 0px"> Creating Merged Envelopes and Labels 235</p> <p style="MARGIN: 0px"> Understanding Word Fields 236</p> <p style="MARGIN: 0px"> Building a Form with Form Controls 238</p> <p style="MARGIN: 0px">10 Creating Special Documents 241</p> <p style="MARGIN: 0px"> Options for Large Documents 241</p> <p style="MARGIN: 0px"> Creating a Table of Contents 242</p> <p style="MARGIN: 0px"> Creating a Table of Contents with Built-in Styles 243</p> <p style="MARGIN: 0px"> Creating a Table of Contents with Your Own Styles 244</p> <p style="MARGIN: 0px"> Adding Entries and Updating the TOC 246</p> <p style="MARGIN: 0px"> Building a TOC with Field Codes 247</p> <p style="MARGIN: 0px"> Working with Captions and Tables of Figures 249</p> <p style="MARGIN: 0px"> Inserting a Caption 249</p> <p style="MARGIN: 0px"> Inserting a Table of Figures 250</p> <p style="MARGIN: 0px"> Using Cross-References 251</p> <p style="MARGIN: 0px"> Generating an Index 253</p> <p style="MARGIN: 0px"> Marking Index Entries 254</p> <p style="MARGIN: 0px"> Inserting the Index 255</p> <p style="MARGIN: 0px"> Working with Citations and Bibliographies 256</p> <p style="MARGIN: 0px"> Creating Citations 256</p> <p style="MARGIN: 0px"> Managing Citations 257</p> <p style="MARGIN: 0px"> Inserting the Bibliography 258</p> <p style="MARGIN: 0px"> Inserting Footnotes and Endnotes 260</p> <p style="MARGIN: 0px"> Tracking Document Changes 261</p> <p style="MARGIN: 0px"> Options for Viewing Changes 264</p> <p style="MARGIN: 0px"> Reviewing Changes 265</p> <p style="MARGIN: 0px"> Comparing Documents 266</p> <p style="MARGIN: 0px"> Building a Better “Big” Document 268</p> <p style="MARGIN: 0px"> Creating Bookmarks 268</p> <p style="MARGIN: 0px"> Inserting Comments 269</p> <p style="MARGIN: 0px"> Creating a Master Document 270</p> <p style="MARGIN: 0px"> Working in Outline View 271</p> <p style="MARGIN: 0px"> Creating Subdocuments from Scratch 272</p> <p style="MARGIN: 0px"> Inserting Existing Document Files into a Master Document Outline 273</p> <p style="MARGIN: 0px"> Manipulating the Master Document 274</p> <div style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 7pt; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in; mso-border-bottom-alt: solid black .5pt; mso-element: para-border-div"> <p style="MARGIN: 0px">III Excel</p> </div> <p style="MARGIN: 0px">11 Requisite Excel: Essential Features 275</p> <p style="MARGIN: 0px"> Introducing Excel 2016 275</p> <p style="MARGIN: 0px"> Navigating the Excel Workspace 277</p> <p style="MARGIN: 0px"> The Excel Ribbon 278</p> <p style="MARGIN: 0px"> Moving Around a Worksheet 280</p> <p style="MARGIN: 0px"> Creating Workbooks and Worksheets 281</p> <p style="MARGIN: 0px"> Using Office.com Templates 281</p> <p style="MARGIN: 0px"> Inserting and Rearranging Worksheets 283</p> <p style="MARGIN: 0px"> Managing Excel Workbooks 284</p> <p style="MARGIN: 0px"> Protecting Workbooks and Worksheets 286</p> <p style="MARGIN: 0px"> Locking Cells 286</p> <p style="MARGIN: 0px"> Specifying Edit Ranges 288</p> <p style="MARGIN: 0px"> Preparing a Workbook for Sharing 290</p> <p style="MARGIN: 0px"> Managing Versions 291</p> <p style="MARGIN: 0px"> Entering Data in a Worksheet 291</p> <p style="MARGIN: 0px"> Entering Labels 292</p> <p style="MARGIN: 0px"> Entering Values 292</p> <p style="MARGIN: 0px"> Using AutoComplete 293</p> <p style="MARGIN: 0px"> Filling and Entering Series 294</p> <p style="MARGIN: 0px"> Using the Fill Handle 295</p> <p style="MARGIN: 0px"> Creating Custom Fill Lists 297</p> <p style="MARGIN: 0px"> Creating Custom Series 298</p> <p style="MARGIN: 0px"> Using Flash Fill 299</p> <p style="MARGIN: 0px"> Copying, Moving, and Deleting Cell Contents 299</p> <p style="MARGIN: 0px"> Using the Paste Special Dialog Box 302</p> <p style="MARGIN: 0px"> Moving Cells and Ranges 304</p> <p style="MARGIN: 0px"> Clearing and Deleting Cells 304</p> <p style="MARGIN: 0px"> Editing Cell Content 305</p> <p style="MARGIN: 0px"> Viewing Worksheets 306</p> <p style="MARGIN: 0px"> Printing Worksheets 308</p> <p style="MARGIN: 0px"> Using the Page Layout Commands 308</p> <p style="MARGIN: 0px"> Setting a Print Area 310</p> <p style="MARGIN: 0px"> Inserting Page Breaks 310</p> <p style="MARGIN: 0px"> Setting Print Titles 311</p> <p style="MARGIN: 0px"> Working on the Print Page 311</p> <p style="MARGIN: 0px"> Inserting Headers and Footers 313</p> <p style="MARGIN: 0px">12 Worksheet Formatting and Management 315</p> <p style="MARGIN: 0px"> Formatting Text Entries 315</p> <p style="MARGIN: 0px"> Accessing the Format Cells Dialog Box 316</p> <p style="MARGIN: 0px"> Changing Text Orientation 317</p> <p style="MARGIN: 0px"> Formatting Values 318</p> <p style="MARGIN: 0px"> Using the Format Cells Dialog Box 320</p> <p style="MARGIN: 0px"> Creating Custom Number Formats 321</p> <p style="MARGIN: 0px"> Adding Comments to Cells 323</p> <p style="MARGIN: 0px"> Formatting Comment Text 324</p> <p style="MARGIN: 0px"> Deleting and Viewing Comments 324</p> <p style="MARGIN: 0px"> Using Themes 325</p> <p style="MARGIN: 0px"> Formatting Cells Using Borders and Color 326</p> <p style="MARGIN: 0px"> Adding Cell Borders 326</p> <p style="MARGIN: 0px"> Using Background Colors 328</p> <p style="MARGIN: 0px"> Using Cell Styles and the Format Painter 328</p> <p style="MARGIN: 0px"> Creating a Cell Style 329</p> <p style="MARGIN: 0px"> Using the Format Painter 330</p> <p style="MARGIN: 0px"> Using Conditional Formatting 330</p> <p style="MARGIN: 0px"> Using Highlight Cell Rules 331</p> <p style="MARGIN: 0px"> Using Top/Bottom Rules 332</p> <p style="MARGIN: 0px"> Using Data Bars 333</p> <p style="MARGIN: 0px"> Using Color Scales 334</p> <p style="MARGIN: 0px"> Using Icon Sets 334</p> <p style="MARGIN: 0px"> Creating Conditional Formatting Rules 334</p> <p style="MARGIN: 0px"> Manipulating Cells and Cell Content 336</p> <p style="MARGIN: 0px"> Inserting Cells 336</p> <p style="MARGIN: 0px"> Merging Cells and Wrapping Text 337</p> <p style="MARGIN: 0px"> Finding and Replacing Cell Items 337</p> <p style="MARGIN: 0px"> Working with Columns and Rows 339</p> <p style="MARGIN: 0px"> Changing Column Width and Row Height 339</p> <p style="MARGIN: 0px"> Inserting Columns and Rows 340</p> <p style="MARGIN: 0px"> Deleting Columns and Rows 340</p> <p style="MARGIN: 0px"> Hiding Columns and Rows 341</p> <p style="MARGIN: 0px"> Working with Worksheets 341</p> <p style="MARGIN: 0px"> Freezing Rows and Columns 341</p> <p style="MARGIN: 0px"> Splitting Worksheets 342</p> <p style="MARGIN: 0px"> Hiding Worksheets 343</p> <p style="MARGIN: 0px"> Naming Ranges 343</p> <p style="MARGIN: 0px"> Creating Range Names from Selections 345</p> <p style="MARGIN: 0px"> Managing Range Names 345</p> <p style="MARGIN: 0px"> Adding Images and Graphics to Worksheets 346</p> <p style="MARGIN: 0px">13 Getting the Most from Formulas and Functions 349</p> <p style="MARGIN: 0px"> Performing Calculations in Excel Worksheets 349</p> <p style="MARGIN: 0px"> Relative Versus Absolute Referencing 351</p> <p style="MARGIN: 0px"> Creating and Editing Formulas 354</p> <p style="MARGIN: 0px"> Understanding Operator Precedence 355</p> <p style="MARGIN: 0px"> Entering Formulas 356</p> <p style="MARGIN: 0px"> Editing Formulas 356</p> <p style="MARGIN: 0px"> Working with Excel Functions 357</p> <p style="MARGIN: 0px"> Entering a Function in a Cell 358</p> <p style="MARGIN: 0px"> Using AutoSum 358</p> <p style="MARGIN: 0px"> Using the Status Bar Statistical Functions 360</p> <p style="MARGIN: 0px"> Using the Insert Function Dialog Box 360</p> <p style="MARGIN: 0px"> Using the Function Library 361</p> <p style="MARGIN: 0px"> Using Range Names in Formulas and Functions 364</p> <p style="MARGIN: 0px"> Inserting a Range Name into a Formula 364</p> <p style="MARGIN: 0px"> Inserting a Range Name into a Function 365</p> <p style="MARGIN: 0px"> Referencing Cells or Ranges on Other Worksheets 366</p> <p style="MARGIN: 0px"> Copying and Moving Formulas and Functions 368</p> <p style="MARGIN: 0px"> Choosing the Right Function 368</p> <p style="MARGIN: 0px"> Financial Functions 369</p> <p style="MARGIN: 0px"> Logical Functions 370</p> <p style="MARGIN: 0px"> Statistical Functions 372</p> <p style="MARGIN: 0px"> Lookup & Reference Functions 373</p> <p style="MARGIN: 0px"> Date & Time Functions 374</p> <p style="MARGIN: 0px"> Text Functions 375</p> <p style="MARGIN: 0px"> Other Function Categories 376</p> <p style="MARGIN: 0px"> Proofing Your Formulas and Functions 377</p> <p style="MARGIN: 0px"> Common Error Messages 377</p> <p style="MARGIN: 0px"> Using the Auditing Tools 379</p> <p style="MARGIN: 0px"> Using the Watch Window 380</p> <p style="MARGIN: 0px">14 Enhancing Worksheets with Charts 383</p> <p style="MARGIN: 0px"> Understanding Excel Charts 383</p> <p style="MARGIN: 0px"> Chart Terminology 384</p> <p style="MARGIN: 0px"> Using Different Chart Types 387</p> <p style="MARGIN: 0px"> Creating Charts 393</p> <p style="MARGIN: 0px"> Inserting a Chart from the Ribbon 394</p> <p style="MARGIN: 0px"> Selecting a Recommended Chart 395</p> <p style="MARGIN: 0px"> Inserting Charts with the Quick Analysis Gallery 395</p> <p style="MARGIN: 0px"> Tools for Quickly Customizing a Chart 396</p> <p style="MARGIN: 0px"> Moving, Copying, or Deleting a Chart 397</p> <p style="MARGIN: 0px"> Modifying a Chart 398</p> <p style="MARGIN: 0px"> Changing Chart Type or Chart Data 398</p> <p style="MARGIN: 0px"> Selecting Chart Layouts and Styles 400</p> <p style="MARGIN: 0px"> Working with Chart Elements 402</p> <p style="MARGIN: 0px"> Modifying Titles and Data Labels 404</p> <p style="MARGIN: 0px"> Working with the Legend and Data Points 404</p> <p style="MARGIN: 0px"> Manipulating Axes and Gridlines 406</p> <p style="MARGIN: 0px"> Adding Trendlines, Drop Lines, and Bars to a Chart 406</p> <p style="MARGIN: 0px"> Creating a Combination Chart 410</p> <p style="MARGIN: 0px"> Working with a Pie of Pie Chart 411</p> <p style="MARGIN: 0px"> Creating a Custom Combination Chart 411</p> <p style="MARGIN: 0px"> Using Sparklines 413</p> <p style="MARGIN: 0px"> Creating Sparklines 413</p> <p style="MARGIN: 0px"> Modifying Sparklines 414</p> <p style="MARGIN: 0px">15 Using Excel Tables and Pivottables 417</p> <p style="MARGIN: 0px"> Excel and Databases 417</p> <p style="MARGIN: 0px"> Defining a Table Range 418</p> <p style="MARGIN: 0px"> Creating a Table Using Styles 419</p> <p style="MARGIN: 0px"> Using the Table Tools 420</p> <p style="MARGIN: 0px"> Sorting Table Data 421</p> <p style="MARGIN: 0px"> How Excel Sorts Data 422</p> <p style="MARGIN: 0px"> Using the Sort Dialog Box 422</p> <p style="MARGIN: 0px"> Filtering Table Data 424</p> <p style="MARGIN: 0px"> Using the AutoFilter Search Box 425</p> <p style="MARGIN: 0px"> Creating Custom AutoFilters 425</p> <p style="MARGIN: 0px"> Filtering Tables with Slicers 428</p> <p style="MARGIN: 0px"> Creating Advanced Filters 429</p> <p style="MARGIN: 0px"> Using the Data Form 431</p> <p style="MARGIN: 0px"> Creating Outlines and Subtotals 432</p> <p style="MARGIN: 0px"> Working with External Data 435</p> <p style="MARGIN: 0px"> Importing Data from Access 436</p> <p style="MARGIN: 0px"> Importing a Web Table 437</p> <p style="MARGIN: 0px"> Importing Text Files 438</p> <p style="MARGIN: 0px"> Connecting to Other Data Sources 439</p> <p style="MARGIN: 0px"> Using Microsoft Query 441</p> <p style="MARGIN: 0px"> Viewing and Refreshing Connections 444</p> <p style="MARGIN: 0px"> Working with PivotTables 445</p> <p style="MARGIN: 0px"> Using the Recommended PivotTables Command 447</p> <p style="MARGIN: 0px"> Creating a PivotTable 447</p> <p style="MARGIN: 0px"> Working with the PivotTable Tools 450</p> <p style="MARGIN: 0px"> Using Slicers 452</p> <p style="MARGIN: 0px">16 Validating and Analyzing Worksheet Data 453</p> <p style="MARGIN: 0px"> Taking Advantage of Data Validation 453</p> <p style="MARGIN: 0px"> Specifying Validation Criteria 454</p> <p style="MARGIN: 0px"> Configuring Input Messages and Error Alerts 456</p> <p style="MARGIN: 0px"> Circling Invalid Data 458</p> <p style="MARGIN: 0px"> Performing a What-If Analysis 459</p> <p style="MARGIN: 0px"> Creating a Data Table 460</p> <p style="MARGIN: 0px"> Creating Scenarios 462</p> <p style="MARGIN: 0px"> Viewing Scenarios and Creating Reports 464</p> <p style="MARGIN: 0px"> Using Goal Seek and Solver 466</p> <p style="MARGIN: 0px"> Working with Goal Seek 466</p> <p style="MARGIN: 0px"> Working with Solver 467</p> <div style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 7pt; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in; mso-border-bottom-alt: solid black .5pt; mso-element: para-border-div"> <p style="MARGIN: 0px">IV PowerPoint</p> </div> <p style="MARGIN: 0px">17 Requisite Powerpoint: Essential Features 471</p> <p style="MARGIN: 0px"> PowerPoint 2016 471</p> <p style="MARGIN: 0px"> Options for Creating a New Presentation 472</p> <p style="MARGIN: 0px"> Using Templates 473</p> <p style="MARGIN: 0px"> Using a Theme to Create a New Presentation 476</p> <p style="MARGIN: 0px"> Creating a Presentation from an Existing Presentation 477</p> <p style="MARGIN: 0px"> Inserting Slides from the Reuse Slides Task Pane 478</p> <p style="MARGIN: 0px"> Publishing Slides to a Library 479</p> <p style="MARGIN: 0px"> Creating a Template 480</p> <p style="MARGIN: 0px"> Inserting New Slides 481</p> <p style="MARGIN: 0px"> Entering Text 482</p> <p style="MARGIN: 0px"> Inserting Slides from a Word Outline 483</p> <p style="MARGIN: 0px"> Inserting Other Object Content 483</p> <p style="MARGIN: 0px"> Modifying a Slide’s Layout 484</p> <p style="MARGIN: 0px"> Working with Slides in Different Views 484</p> <p style="MARGIN: 0px"> Zooming In and Out 486</p> <p style="MARGIN: 0px"> Rulers, Gridlines, and Guides 487</p> <p style="MARGIN: 0px"> Color/Grayscale Commands 488</p> <p style="MARGIN: 0px"> Opening a New Presentation Window 489</p> <p style="MARGIN: 0px"> Rearranging and Deleting Slides 490</p> <p style="MARGIN: 0px"> Modifying Bulleted Lists 491</p> <p style="MARGIN: 0px"> Using Numbered Lists 493</p> <p style="MARGIN: 0px"> Viewing a Presentation During Editing 493</p> <p style="MARGIN: 0px">18 Advanced Presentation Formatting, Themes, and Masters 495</p> <p style="MARGIN: 0px"> Working with Text Boxes and Formatting 495</p> <p style="MARGIN: 0px"> Inserting a Text Box 496</p> <p style="MARGIN: 0px"> Basic Text Formatting 497</p> <p style="MARGIN: 0px"> Formatting a Text Box with the Drawing Tools 499</p> <p style="MARGIN: 0px"> Selecting Quick Styles and Shape Attributes 499</p> <p style="MARGIN: 0px"> Shape Fill, Outline, and Effects 500</p> <p style="MARGIN: 0px"> Using WordArt Styles and Text Settings 503</p> <p style="MARGIN: 0px"> Arranging Text in Tables 507</p> <p style="MARGIN: 0px"> Inserting a Table on an Existing Slide 507</p> <p style="MARGIN: 0px"> Formatting a Table 507</p> <p style="MARGIN: 0px"> Table Layout Commands 508</p> <p style="MARGIN: 0px"> Working with Themes 510</p> <p style="MARGIN: 0px"> Applying Themes 511</p> <p style="MARGIN: 0px"> Applying Theme Variants 512</p> <p style="MARGIN: 0px"> Creating a Custom Theme 517</p> <p style="MARGIN: 0px"> Using Headers and Footers 517</p> <p style="MARGIN: 0px"> Understanding Masters 518</p> <p style="MARGIN: 0px"> Altering and Creating Master Slides 520</p> <p style="MARGIN: 0px"> Creating Layout Masters 522</p> <p style="MARGIN: 0px"> Using Slide Sections 523</p> <p style="MARGIN: 0px">19 Better Slides with Clip Art, Pictures, and SmartArt 525</p> <p style="MARGIN: 0px"> Using Graphics to Enhance Slides 525</p> <p style="MARGIN: 0px"> Inserting a Picture 527</p> <p style="MARGIN: 0px"> Adding Online Images to Slides 529</p> <p style="MARGIN: 0px"> Creating a Photo Album 531</p> <p style="MARGIN: 0px"> Adjusting Picture Settings 532</p> <p style="MARGIN: 0px"> Configuring Album Layout Settings 533</p> <p style="MARGIN: 0px"> Working with Shapes 534</p> <p style="MARGIN: 0px"> Using SmartArt Graphics 535</p> <p style="MARGIN: 0px"> Inserting a SmartArt Graphic 538</p> <p style="MARGIN: 0px"> Converting Text to a SmartArt Graphic 539</p> <p style="MARGIN: 0px"> Using the SmartArt Tools 540</p> <p style="MARGIN: 0px"> Adding Charts to Slides 541</p> <p style="MARGIN: 0px"> Inserting a Chart onto a Slide 542</p> <p style="MARGIN: 0px"> Modifying and Formatting a Chart 544</p> <p style="MARGIN: 0px"> Working with Slide Objects 546</p> <p style="MARGIN: 0px"> Grouping Objects 546</p> <p style="MARGIN: 0px"> Layering Objects 546</p> <p style="MARGIN: 0px"> Adding Hyperlinks to Slides 547</p> <p style="MARGIN: 0px">20 Enhancing Slides with Animation, Transitions, and Multimedia 549</p> <p style="MARGIN: 0px"> Animations versus Transitions 549</p> <p style="MARGIN: 0px"> Assigning Animation to a Slide Object 551</p> <p style="MARGIN: 0px"> Accessing Additional Animation Effects 553</p> <p style="MARGIN: 0px"> Using Motion Paths 554</p> <p style="MARGIN: 0px"> Advanced Animation Techniques 559</p> <p style="MARGIN: 0px"> Changing Effect Options 560</p> <p style="MARGIN: 0px"> Adding Additional Animations 561</p> <p style="MARGIN: 0px"> Using the Animation Painter 562</p> <p style="MARGIN: 0px"> Including Sound Effects with Animations 562</p> <p style="MARGIN: 0px"> Setting Timings for Animations 564</p> <p style="MARGIN: 0px"> Managing Slide Animations 565</p> <p style="MARGIN: 0px"> Adding Transitions to Slides 566</p> <p style="MARGIN: 0px"> Modifying Transitions 567</p> <p style="MARGIN: 0px"> Adding Sound to a Slide 569</p> <p style="MARGIN: 0px"> Editing Sound Options 569</p> <p style="MARGIN: 0px"> Adding Video to a Slide 571</p> <p style="MARGIN: 0px"> Inserting Online Video 571</p> <p style="MARGIN: 0px"> Inserting a Video File 574</p> <p style="MARGIN: 0px"> Modifying Your Video Clips 575</p> <p style="MARGIN: 0px">21 Delivering a Presentation and Creating Support Materials 577</p> <p style="MARGIN: 0px"> Planning Your Presentation 578</p> <p style="MARGIN: 0px"> Checking the Presentation for Spelling and Grammar Errors 579</p> <p style="MARGIN: 0px"> Running Through a Completed Presentation 580</p> <p style="MARGIN: 0px"> Using the Presenter View 581</p> <p style="MARGIN: 0px"> Using Hidden Slides 583</p> <p style="MARGIN: 0px"> Creating a Custom Slide Show 585</p> <p style="MARGIN: 0px"> Creating a Self-Running Presentation 586</p> <p style="MARGIN: 0px"> Setting Up a Slide Show 586</p> <p style="MARGIN: 0px"> Rehearsing Timings 588</p> <p style="MARGIN: 0px"> Recording a Slide Show 589</p> <p style="MARGIN: 0px"> Creating an Interactive Presentation 590</p> <p style="MARGIN: 0px"> Presenting a Slide Show Online 592</p> <p style="MARGIN: 0px"> Presenting Online with Skype for Business 592</p> <p style="MARGIN: 0px"> Presenting Online with the Office Presentation Service 593</p> <p style="MARGIN: 0px"> Working with the Notes and Handout Masters 594</p> <p style="MARGIN: 0px"> Setting Handout Master Options 595</p> <p style="MARGIN: 0px"> Setting Notes Master Options 596</p> <p style="MARGIN: 0px"> Printing Presentations, Notes, and Handouts 596</p> <p style="MARGIN: 0px"> Exporting a Presentation 599</p> <p style="MARGIN: 0px"> Sharing Your Presentation 600</p> <div style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 7pt; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in; mso-border-bottom-alt: solid black .5pt; mso-element: para-border-div"> <p style="MARGIN: 0px">V Outlook</p> </div> <p style="MARGIN: 0px">22 Requisite Outlook: Configuration and Essential Features 603</p> <p style="MARGIN: 0px"> Introducing Outlook 2016 603</p> <p style="MARGIN: 0px"> Outlook and Email Accounts 604</p> <p style="MARGIN: 0px"> Exchange ActiveSync 605</p> <p style="MARGIN: 0px"> Outlook.com Email 606</p> <p style="MARGIN: 0px"> Internet Email 606</p> <p style="MARGIN: 0px"> Configuring Outlook at First Start 607</p> <p style="MARGIN: 0px"> Understanding Outlook Profiles 610</p> <p style="MARGIN: 0px"> Creating a New Profile 610</p> <p style="MARGIN: 0px"> Managing Profiles 611</p> <p style="MARGIN: 0px"> Loading Profiles 613</p> <p style="MARGIN: 0px"> Understanding Outlook Data Files 614</p> <p style="MARGIN: 0px"> Configuring Outlook for Microsoft Exchange Server 614</p> <p style="MARGIN: 0px"> Creating Personal Folders Files 616</p> <p style="MARGIN: 0px"> Repairing Outlook Data Files 617</p> <p style="MARGIN: 0px"> Importing and Exporting Data 619</p> <p style="MARGIN: 0px"> Importing Data 619</p> <p style="MARGIN: 0px"> Exporting Data 621</p> <p style="MARGIN: 0px"> Navigating the Outlook Workspace 621</p> <p style="MARGIN: 0px"> Accessing Outlook Items Using the Navigation Bar 623</p> <p style="MARGIN: 0px"> Working with Views in Outlook 624</p> <p style="MARGIN: 0px"> Categorizing Outlook Items 627</p> <p style="MARGIN: 0px"> Searching for Outlook Items 628</p> <p style="MARGIN: 0px"> Using Advanced Find 629</p> <p style="MARGIN: 0px"> Using Search Folders 629</p> <p style="MARGIN: 0px"> Printing Outlook Items 631</p> <p style="MARGIN: 0px">23 Managing Email in Outlook 633</p> <p style="MARGIN: 0px"> Working in the Mail Folder 633</p> <p style="MARGIN: 0px"> Creating an Email Message 635</p> <p style="MARGIN: 0px"> Using the Outlook Address Book 637</p> <p style="MARGIN: 0px"> Setting Message Options 639</p> <p style="MARGIN: 0px"> Specifying Email Format 640</p> <p style="MARGIN: 0px"> Setting Message Flags, Importance, and Sensitivity 640</p> <p style="MARGIN: 0px"> Configuring Voting Buttons, Receipts, and Delivery Options 642</p> <p style="MARGIN: 0px"> The Message Options/Properties Dialog Box 645</p> <p style="MARGIN: 0px"> Attaching Files and Items to a Message 647</p> <p style="MARGIN: 0px"> Attaching a Business Card 648</p> <p style="MARGIN: 0px"> Attaching a Calendar 648</p> <p style="MARGIN: 0px"> Using Themes and Email Stationery 650</p> <p style="MARGIN: 0px"> Adding a Signature 652</p> <p style="MARGIN: 0px"> Sending Mail 653</p> <p style="MARGIN: 0px"> Recalling a Message 653</p> <p style="MARGIN: 0px"> Working with Received Email 654</p> <p style="MARGIN: 0px"> Organizing Messages in the Inbox 655</p> <p style="MARGIN: 0px"> Showing Messages as Conversations 655</p> <p style="MARGIN: 0px"> Filtering Email 656</p> <p style="MARGIN: 0px"> Managing Email 657</p> <p style="MARGIN: 0px"> Using Quick Steps 658</p> <p style="MARGIN: 0px"> Answering a Message 660</p> <p style="MARGIN: 0px"> Forwarding a Message 660</p> <p style="MARGIN: 0px"> Saving an Attachment 660</p> <p style="MARGIN: 0px"> Deleting Messages 662</p> <p style="MARGIN: 0px"> Printing Mail 663</p> <p style="MARGIN: 0px"> Moving Email 663</p> <p style="MARGIN: 0px"> Managing Email Accounts 664</p> <p style="MARGIN: 0px"> Editing Email Account Settings 666</p> <p style="MARGIN: 0px"> Adding an Email Account 667</p> <p style="MARGIN: 0px"> Adding an Outlook.com Mail Account 669</p> <p style="MARGIN: 0px"> Setting Outlook Mail Options 669</p> <p style="MARGIN: 0px">24 Using the Calendar for Appointments and Tasks 673</p> <p style="MARGIN: 0px"> Navigating the Calendar 673</p> <p style="MARGIN: 0px"> Changing the Calendar View 675</p> <p style="MARGIN: 0px"> Change the Time Scale and Time Zone 677</p> <p style="MARGIN: 0px"> Scheduling an Appointment 678</p> <p style="MARGIN: 0px"> Scheduling a Recurring Appointment 680</p> <p style="MARGIN: 0px"> Scheduling an Event 681</p> <p style="MARGIN: 0px"> Editing and Managing Appointments 682</p> <p style="MARGIN: 0px"> Searching the Calendar 683</p> <p style="MARGIN: 0px"> Sharing Calendars 684</p> <p style="MARGIN: 0px"> Creating a Calendar Share Invitation 685</p> <p style="MARGIN: 0px"> Opening a Shared Calendar 686</p> <p style="MARGIN: 0px"> Viewing Multiple Calendars 686</p> <p style="MARGIN: 0px"> Emailing a Calendar 688</p> <p style="MARGIN: 0px"> Publishing a Calendar Online 689</p> <p style="MARGIN: 0px"> Setting Calendar Options 690</p> <p style="MARGIN: 0px"> Working with Tasks 692</p> <p style="MARGIN: 0px"> Using the Task Folder 693</p> <p style="MARGIN: 0px"> Creating a New Task from the Task Folder 694</p> <p style="MARGIN: 0px"> Creating a Recurring Task 694</p> <p style="MARGIN: 0px"> Assigning and Accepting Tasks 695</p> <p style="MARGIN: 0px"> Viewing and Managing Tasks 696</p> <p style="MARGIN: 0px"> Managing Tasks 699</p> <p style="MARGIN: 0px"> Setting Tasks Options 700</p> <p style="MARGIN: 0px">25 Working with Contacts and Planning Meetings 703</p> <p style="MARGIN: 0px"> Navigating the Contacts List 703</p> <p style="MARGIN: 0px"> Creating a New Contact 705</p> <p style="MARGIN: 0px"> Entering Contact Details 708</p> <p style="MARGIN: 0px"> Adding Fields for a Contact 709</p> <p style="MARGIN: 0px"> Editing Contact Information 709</p> <p style="MARGIN: 0px"> Editing a Business Card 711</p> <p style="MARGIN: 0px"> Tagging Contacts with Flags and Categories 712</p> <p style="MARGIN: 0px"> Mapping a Contact’s Address 713</p> <p style="MARGIN: 0px"> Searching the Contacts Folder 714</p> <p style="MARGIN: 0px"> Organizing Contacts with Groups 715</p> <p style="MARGIN: 0px"> Forwarding and Sharing Contacts 716</p> <p style="MARGIN: 0px"> Forwarding Contacts 717</p> <p style="MARGIN: 0px"> Sharing Contacts 718</p> <p style="MARGIN: 0px"> Accessing Contacts on Social Networks 720</p> <p style="MARGIN: 0px"> Communicating with Contacts 722</p> <p style="MARGIN: 0px"> Contact Actions 724</p> <p style="MARGIN: 0px"> Printing Contact Information 725</p> <p style="MARGIN: 0px"> Setting Contact Options 726</p> <p style="MARGIN: 0px"> Scheduling Meetings 726</p> <p style="MARGIN: 0px"> Selecting the Meeting Location 728</p> <p style="MARGIN: 0px"> Using the Scheduling Assistant 728</p> <p style="MARGIN: 0px"> Viewing and Editing Meeting Information 729</p> <p style="MARGIN: 0px"> Responding to Meeting Requests 730</p> <p style="MARGIN: 0px">26 Using the Journal and Notes 733</p> <p style="MARGIN: 0px"> Using the Outlook Journal 733</p> <p style="MARGIN: 0px"> Creating a New Journal Entry 734</p> <p style="MARGIN: 0px"> Using the Journal Timer 735</p> <p style="MARGIN: 0px"> Adding Tags and Names to a Journal Entry 736</p> <p style="MARGIN: 0px"> Adding Outlook Items and Inserting Files 737</p> <p style="MARGIN: 0px"> Journal Actions 739</p> <p style="MARGIN: 0px"> Viewing the Journal 740</p> <p style="MARGIN: 0px"> Manipulating the Journal View 741</p> <p style="MARGIN: 0px"> Using Search to Filter Journal Entries 742</p> <p style="MARGIN: 0px"> Working with Notes 742</p> <p style="MARGIN: 0px"> Viewing and Managing Notes 743</p> <p style="MARGIN: 0px"> Creating Appointments and Tasks from Notes 744</p> <p style="MARGIN: 0px">27 Securing and Maintaining Outlook 747</p> <p style="MARGIN: 0px"> Security Overview 747</p> <p style="MARGIN: 0px"> Malware and Antivirus Software 748</p> <p style="MARGIN: 0px"> Strong Password Protection 749</p> <p style="MARGIN: 0px"> Configuring Outlook Security Settings 751</p> <p style="MARGIN: 0px"> Encrypting Email and Using Digital Signatures 753</p> <p style="MARGIN: 0px"> Options for Encrypting Email 754</p> <p style="MARGIN: 0px"> Digitally Signing Emails 755</p> <p style="MARGIN: 0px"> The Perils of HTML Email 755</p> <p style="MARGIN: 0px"> Dealing with Message Attachments 756</p> <p style="MARGIN: 0px"> Coping with Junk Email 758</p> <p style="MARGIN: 0px"> Working with the Junk Email Commands 759</p> <p style="MARGIN: 0px"> Setting Junk Email Options 760</p> <p style="MARGIN: 0px"> Creating Email Rules 762</p> <p style="MARGIN: 0px"> Creating a Quick Rule for a Specific Sender 762</p> <p style="MARGIN: 0px"> Creating Complex Rules 763</p> <p style="MARGIN: 0px"> The Rule Wizard 764</p> <p style="MARGIN: 0px"> Managing Rules 767</p> <p style="MARGIN: 0px"> Archiving Outlook Items 768</p> <p style="MARGIN: 0px"> Configuring AutoArchive Settings 769</p> <p style="MARGIN: 0px"> Setting AutoArchive Options for a Folder 770</p> <p style="MARGIN: 0px"> Archiving Manually 771</p> <p style="MARGIN: 0px"> Configuring an Autoreply Message 772</p> <div style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: medium none; PADDING-BOTTOM: 7pt; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: medium none; BORDER-RIGHT: medium none; PADDING-TOP: 0in; mso-border-bottom-alt: solid black .5pt; mso-element: para-border-div"> <p style="MARGIN: 0px">VI Publisher</p> </div> <p style="MARGIN: 0px">28 Requisite Publisher: Essential Features 775</p> <p style="MARGIN: 0px"> Introducing Publisher 2016 775</p> <p style="MARGIN: 0px"> Planning Your Publication 776</p> <p style="MARGIN: 0px"> Working with Publication Templates 777</p> <p style="MARGIN: 0px"> Creating a New Publication 779</p> <p style="MARGIN: 0px"> Using a Template 779</p> <p style="MARGIN: 0px"> Using Blank Sizes 780</p> <p style="MARGIN: 0px"> Creating a New Template 781</p> <p style="MARGIN: 0px"> Navigating the Publisher Workspace 782</p> <p style="MARGIN: 0px"> Using the Rulers and Guides 783</p> <p style="MARGIN: 0px"> Options for Viewing the Publication 785</p> <p style="MARGIN: 0px"> Creating a Business Information Set 787</p> <p style="MARGIN: 0px"> Creating a New Business Information Set 787</p> <p style="MARGIN: 0px"> Creating Additional Business Information Sets 788</p> <p style="MARGIN: 0px"> Working with Text 789</p> <p style="MARGIN: 0px"> Editing Text in a Text Box 789</p> <p style="MARGIN: 0px"> Creating Your Own Text Boxes 790</p> <p style="MARGIN: 0px"> Formatting Text Boxes 791</p> <p style="MARGIN: 0px"> Linking Text Boxes 796</p> <p style="MARGIN: 0px"> Inserting a Text File 797</p> <p style="MARGIN: 0px"> Inserting Illustrations 798</p> <p style="MARGIN: 0px"> Options for Inserting Pictures 798</p> <p style="MARGIN: 0px"> Formatting a Picture 801</p> <p style="MARGIN: 0px"> Inserting Clip Art 802</p> <p style="MARGIN: 0px"> Inserting Shapes 802</p> <p style="MARGIN: 0px"> Using Building Blocks 802</p> <p style="MARGIN: 0px"> Printing Publications 803</p> <p style="MARGIN: 0px">29 Advanced Publisher Features 805</p> <p style="MARGIN: 0px"> Adding Pages to a Publication 805</p> <p style="MARGIN: 0px"> Configuring Page Settings 807</p> <p style="MARGIN: 0px"> Changing the Current Template 810</p> <p style="MARGIN: 0px"> Working with Master Pages 812</p> <p style="MARGIN: 0px"> Placing Objects on the Master Page 813</p> <p style="MARGIN: 0px"> Inserting Headers and Footers 814</p> <p style="MARGIN: 0px"> Creating Master Pages 815</p> <p style="MARGIN: 0px"> Using Tables in Publications 816</p> <p style="MARGIN: 0px"> Table Design Commands 816</p> <p style="MARGIN: 0px"> Table Layout Commands 817</p> <p style="MARGIN: 0px"> Manipulating Publication Objects 818</p> <p style="MARGIN: 0px"> Grouping Objects 818</p> <p style="MARGIN: 0px">