Details

Office 2019 For Dummies


Office 2019 For Dummies


1. Aufl.

von: Wallace Wang

20,99 €

Verlag: Wiley
Format: EPUB
Veröffentl.: 27.09.2018
ISBN/EAN: 9781119514022
Sprache: englisch
Anzahl Seiten: 432

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

<p><b>Now updated and revised to cover the latest features of Microsoft Office 2019</b></p> <p>The world’s leading suite of business productivity software, Microsoft Office helps users complete common business tasks, including word processing, email, presentations, data management and analysis, and much more. Whether you need accessible instruction on Word, Excel, PowerPoint, Outlook, or Access—or all of the above—this handy reference makes it easier. </p> <p>In <i>Office X For Dummies</i>, you’ll get help with typing and formatting text in Word, creating and navigating an Excel spreadsheet, creating a powerful PowerPoint presentation, adding color, pictures, and sound to a presentation, configuring email with Outlook, designing an Access database, and more. Information is presented in the straightforward but fun language that has defined the <i>Dummies</i> series for more than twenty years.</p> <ul> <li>Get insight into common tasks and advanced tools</li> <li>Find full coverage of each application in the suite</li> <li>Benefit from updated information based on the newest software release</li> <li>Make your work life easier and more efficiently</li> </ul> <p>If you need to make sense of Office X and don’t have time to waste, this is the trusted reference you’ll want to keep close at hand!</p>
<p><b>Introduction</b><b> 1</b></p> <p>Who Should Buy This Book 1</p> <p>Icons Used in This Book 3</p> <p>Beyond the Book 4</p> <p>Getting Started 4</p> <p><b>Part 1: Getting Started with Office 2019</b><b> 5</b></p> <p><b>Chapter 1: Introducing Microsoft Office 2019</b><b> 7</b></p> <p>Starting an Office 2019 Program 8</p> <p>Introducing the Microsoft Office Ribbon 9</p> <p>Using the File Tab 11</p> <p>Creating a file 12</p> <p>Opening an existing file 13</p> <p>Saving a file 14</p> <p>Using the Ribbon 17</p> <p>Deciphering Ribbon icons 18</p> <p>Identifying Ribbon icons 20</p> <p>Displaying dialog boxes 21</p> <p>Minimizing the Ribbon 22</p> <p>Using the Quick Access Toolbar 24</p> <p>Using the Quick Access icons 24</p> <p>Adding icons 25</p> <p>Removing icons 26</p> <p>Moving the Quick Access toolbar 27</p> <p>Customizing the Ribbon for Touch 27</p> <p>Customizing an Office 2019 Program 28</p> <p>Changing the file format and default location 28</p> <p>Customizing the Ribbon icons 29</p> <p>Exiting Office 2019 30</p> <p><b>Chapter 2: Selecting and Editing Data</b><b> 31</b></p> <p>Adding Data by Pointing 31</p> <p>Selecting Data 33</p> <p>Selecting data with the mouse 34</p> <p>Selecting data with the keyboard 35</p> <p>Selecting multiple chunks of data with the mouse and keyboard 35</p> <p>Editing Text with the Pop-Up Toolbar 36</p> <p>Deleting Data 36</p> <p>Cutting and Pasting (Moving) Data 37</p> <p>Copying and Pasting Data 38</p> <p>Using Paste Options 38</p> <p>Dragging with the Mouse to Cut, Copy, and Paste 40</p> <p>Undo and Redo 40</p> <p>Sharing Data with Other Office 2019 Programs 41</p> <p>Using the Office Clipboard 41</p> <p>Viewing and pasting items from the Office Clipboard 42</p> <p>Deleting items from the Office Clipboard 43</p> <p><b>Chapter 3: Modifying Pictures and Drawing on Documents</b><b> 45</b></p> <p>Adding and Deleting Pictures 46</p> <p>Getting pictures from the Internet 46</p> <p>Capturing screenshots 48</p> <p>Manipulating Pictures 49</p> <p>Moving a picture 49</p> <p>Resizing a picture 50</p> <p>Rotating a picture 50</p> <p>Enhancing Pictures 51</p> <p>Choosing visual effects 51</p> <p>Choosing a picture style 54</p> <p>Adding a border around a picture 55</p> <p>Drawing with the Draw Tab 57</p> <p>Drawing lines 57</p> <p>Moving lines 58</p> <p>Erasing lines 59</p> <p>Drawing Shapes 59</p> <p>Creating Math Equations 60</p> <p><b>Chapter 4: Getting Help from Office 2019</b><b> 63</b></p> <p>Searching in the Help Window 64</p> <p>Making the Help Window Easier to Read 66</p> <p>Moving the Help window 66</p> <p>Resizing the Help window 67</p> <p>Displaying Help text in a browser window 67</p> <p>Closing the Help window 68</p> <p>Finding the Right Commands to Use 68</p> <p><b>Part 2: Working with Word</b><b> 71</b></p> <p><b>Chapter 5: Typing Text in Word</b><b> 73</b></p> <p>Moving the Cursor with the Mouse 73</p> <p>Moving the Cursor with the Keyboard 75</p> <p>Navigating through a Document 76</p> <p>Navigating with the mouse 76</p> <p>Using the Go To command 77</p> <p>Finding and Replacing Text 78</p> <p>Using the Find command 78</p> <p>Customizing text searching 80</p> <p>Searching by headings 82</p> <p>Browsing through pages 83</p> <p>Using the Find and Replace command 84</p> <p>Checking Your Spelling 85</p> <p>Checking Your Grammar 87</p> <p>Viewing a Document 87</p> <p>Switching between views 88</p> <p>Using Read Mode view 89</p> <p>Using Outline view 89</p> <p><b>Chapter 6: Formatting Text</b><b> 95</b></p> <p>Finding Formatting Tools on the Home Tab 95</p> <p>Changing the Font 96</p> <p>Changing the Font Size 97</p> <p>Changing the Text Style 98</p> <p>Changing Colors 99</p> <p>Changing the color of text 99</p> <p>Highlighting text with color 100</p> <p>Using Text Effects 101</p> <p>Justifying Text Alignment 102</p> <p>Adjusting Line Spacing 103</p> <p>Making Lists 104</p> <p>Indenting list items 105</p> <p>Converting list items back to text 105</p> <p>Customizing a list 105</p> <p>Renumbering numbered lists 106</p> <p>Using the Ruler 107</p> <p>Adjusting left and right paragraph margins 108</p> <p>Defining indentation with the Ruler 109</p> <p>Using Format Painter 110</p> <p>Using Styles 111</p> <p>Using Templates 112</p> <p>Removing Formatting from Text 113</p> <p><b>Chapter 7: Designing Your Pages</b><b> 115</b></p> <p>Inserting New Pages 116</p> <p>Adding (and Deleting) a Cover Page 116</p> <p>Inserting Page Breaks 117</p> <p>Inserting Headers and Footers 118</p> <p>Creating a header or footer 118</p> <p>Defining which pages display a header or footer 119</p> <p>Deleting a header or footer 121</p> <p>Organizing Text in Tables 121</p> <p>Creating a table by highlighting rows and columns 121</p> <p>Creating a table with the Insert Table dialog box 122</p> <p>Creating a table with the mouse 123</p> <p>Creating a table from existing text 124</p> <p>Formatting and Coloring a Table 126</p> <p>Selecting all or part of a table 126</p> <p>Aligning text in a table cell 127</p> <p>Choosing a table style 128</p> <p>Resizing columns and rows 128</p> <p>Sorting a Table 130</p> <p>Deleting Tables 131</p> <p>Deleting an entire table 131</p> <p>Deleting rows and columns 132</p> <p>Deleting cells 132</p> <p>Deleting cell borders 133</p> <p>Making Text Look Artistic 133</p> <p>Creating drop caps 134</p> <p>Creating WordArt 134</p> <p>Dividing Text into Columns 135</p> <p>Editing columns 136</p> <p>Removing columns 137</p> <p>Previewing a Document before Printing 138</p> <p>Defining page size and orientation 138</p> <p>Using Print Preview 139</p> <p><b>Part 3: Playing the Numbers with Excel </b><b>141</b></p> <p><b>Chapter 8: The Basics of Spreadsheets: Numbers, Labels, and Formulas</b><b> 143</b></p> <p>Understanding Spreadsheets 144</p> <p>Storing Stuff in a Spreadsheet 145</p> <p>Typing data into a single cell 145</p> <p>Typing data in multiple cells 145</p> <p>Typing in sequences with AutoFill 146</p> <p>Formatting Numbers and Labels 147</p> <p>Formatting numbers 147</p> <p>Formatting cells 150</p> <p>Navigating a Spreadsheet 154</p> <p>Using the mouse to move around in a spreadsheet 154</p> <p>Using the keyboard to move around a spreadsheet 155</p> <p>Naming cells 156</p> <p>Searching a Spreadsheet 158</p> <p>Searching for text 158</p> <p>Searching for formulas 160</p> <p>Editing a Spreadsheet 161</p> <p>Editing data in a cell 161</p> <p>Changing the size of rows and columns with the mouse 161</p> <p>Typing the size of rows and columns 162</p> <p>Adding and deleting rows and columns 162</p> <p>Adding sheets 163</p> <p>Renaming sheets 164</p> <p>Rearranging sheets 164</p> <p>Deleting a sheet 164</p> <p>Clearing Data 165</p> <p>Printing Workbooks 166</p> <p>Using Page Layout view 166</p> <p>Adding a header or footer 167</p> <p>Printing gridlines 168</p> <p>Defining a print area 169</p> <p>Inserting and removing page breaks 170</p> <p>Printing row and column headings 171</p> <p>Defining printing margins 172</p> <p>Defining paper orientation and size 173</p> <p>Printing in Excel 174</p> <p><b>Chapter 9: Playing with Formulas</b><b> 175</b></p> <p>Creating a Formula 175</p> <p>Organizing formulas with parentheses 178</p> <p>Copying formulas 179</p> <p>Using Functions 180</p> <p>Using the AutoSum command 182</p> <p>Using recently used functions 183</p> <p>Editing a Formula 184</p> <p>Conditional Formatting 185</p> <p>Comparing data values 185</p> <p>Creating conditional formatting rules 186</p> <p>Data Validation 187</p> <p>Goal Seeking 190</p> <p>Creating Multiple Scenarios 192</p> <p>Creating a scenario 192</p> <p>Viewing a scenario 194</p> <p>Editing a scenario 195</p> <p>Viewing a scenario summary 195</p> <p>Auditing Your Formulas 197</p> <p>Finding where a formula gets its data 197</p> <p>Finding which formula(s) a cell can change 198</p> <p>Checking for Errors 199</p> <p><b>Chapter 10: Charting and Analyzing Data</b><b> 201</b></p> <p>Understanding the Parts of a Chart 201</p> <p>Creating a Chart 203</p> <p>Editing a Chart 205</p> <p>Moving a chart on a worksheet 205</p> <p>Moving a chart to a new sheet 206</p> <p>Resizing a chart 207</p> <p>Using the Chart Tools 207</p> <p>Changing the chart type 207</p> <p>Changing the data source 208</p> <p>Switching rows and columns 209</p> <p>Changing the parts of a chart 210</p> <p>Designing the layout of a chart 211</p> <p>Deleting a chart 212</p> <p>Using Sparklines 212</p> <p>Creating a Sparkline 213</p> <p>Customizing a Sparkline 213</p> <p>Deleting a Sparkline 214</p> <p>Organizing Lists in Pivot Tables 215</p> <p>Creating a pivot table 215</p> <p>Rearranging labels in a pivot table 217</p> <p>Modifying a pivot table 219</p> <p>Filtering a pivot table 220</p> <p>Summing a pivot table 221</p> <p>Slicing up a pivot table 222</p> <p>Creating a pivot chart 224</p> <p><b>Part 4: Making Presentations with Powerpoint</b><b> 227</b></p> <p><b>Chapter 11: Creating a PowerPoint Presentation</b><b> 229</b></p> <p>Defining the Purpose of Your Presentation 229</p> <p>Creating a PowerPoint Presentation 230</p> <p>Designing a presentation in Normal view 231</p> <p>Designing a presentation with Outline view 234</p> <p>Working with Text 237</p> <p>Creating a text box 238</p> <p>Formatting text 239</p> <p>Aligning text 239</p> <p>Adjusting line spacing 240</p> <p>Making numbered and bulleted lists 241</p> <p>Making columns 242</p> <p>Moving and resizing a text box 243</p> <p>Rotating a text box 244</p> <p><b>Chapter 12: Adding Color and Pictures to a Presentation</b><b> 245</b></p> <p>Applying a Theme 246</p> <p>Changing the Background 247</p> <p>Choosing a solid color background 248</p> <p>Choosing a gradient background 249</p> <p>Choosing a picture background 251</p> <p>Choosing a pattern background 252</p> <p>Adding Graphics to a Slide 252</p> <p>Placing picture files on a slide 253</p> <p>Placing clip art on a slide 253</p> <p>Creating WordArt 254</p> <p>Capturing screenshots 255</p> <p>Resizing, moving, and deleting graphic images 256</p> <p>Rotating graphics 257</p> <p>Layering objects 257</p> <p>Adding Movies to a Slide 258</p> <p>Searching for a video on the Internet 258</p> <p>Searching for video on your computer 259</p> <p>Trimming a video 260</p> <p>Coloring a video 261</p> <p>Formatting the shape of a video 262</p> <p>Adding Sound to a Slide 264</p> <p>Adding audio from a file 264</p> <p>Recording audio 265</p> <p><b>Chapter 13: Showing Off a Presentation</b><b> 267</b></p> <p>Spell-Checking Your Presentation 267</p> <p>Organizing Slides in Sections 269</p> <p>Adding a section 269</p> <p>Expanding and collapsing a section 270</p> <p>Deleting a section 271</p> <p>Adding Visual Transitions 272</p> <p>Adding slide transitions 273</p> <p>Text and graphic transitions 275</p> <p>Using Animation Painter 276</p> <p>Adding Hyperlinks 276</p> <p>Creating web page hyperlinks 277</p> <p>Creating hyperlinks to external files 278</p> <p>Running a program through a hyperlink 279</p> <p>Removing a hyperlink or action 279</p> <p>Viewing a Presentation 280</p> <p>Creating a custom slide show 281</p> <p>Hiding a slide 283</p> <p>Organizing with Slide Sorter view 283</p> <p>Creating Handouts 284</p> <p><b>Part 5: Getting Organized with Outlook</b><b> 287</b></p> <p><b>Chapter 14: Managing Email with Outlook</b><b> 289</b></p> <p>Configuring Email Settings 289</p> <p>Adding an email account 290</p> <p>Creating Email 291</p> <p>Creating an email message 291</p> <p>Replying to an email message 292</p> <p>Using a stored email address to create a new email message 293</p> <p>Attaching Files to Messages 295</p> <p>Reading and Organizing Email 297</p> <p>Grouping messages into categories 298</p> <p>Changing the appearance of the Reading Pane 298</p> <p>Retrieving a file attachment from a message 299</p> <p>Deleting Email Messages 301</p> <p>Creating Quick Steps 301</p> <p><b>Chapter 15: Calendars, Contacts, and Tasks</b><b> 305</b></p> <p>Setting Appointments 305</p> <p>Making an appointment 305</p> <p>Viewing appointments 308</p> <p>Deleting an appointment 309</p> <p>Storing Names and Addresses 310</p> <p>Adding a name 310</p> <p>Viewing names 311</p> <p>Searching names 312</p> <p>Managing Tasks 313</p> <p>Storing a task 315</p> <p>Searching tasks 316</p> <p>Viewing tasks 317</p> <p><b>Part 6: Storing Stuff in Access </b><b>319</b></p> <p><b>Chapter 16: Using a Database</b><b> 321</b></p> <p>Understanding the Basics of a Database 322</p> <p>Designing a Database 323</p> <p>Editing and Modifying a Database 326</p> <p>Naming a field 326</p> <p>Adding and deleting a field 327</p> <p>Defining the type and size of a field 328</p> <p>Typing Data into a Database 329</p> <p>Using Datasheet view 330</p> <p>Using Form view 330</p> <p>Creating a form 331</p> <p>Viewing and editing data in a form 332</p> <p>Editing a form 332</p> <p>Closing and Saving a Database 335</p> <p>Closing a database 335</p> <p>Exiting Access 336</p> <p><b>Chapter 17: Searching, Sorting, and Querying a Database</b> 337</p> <p>Searching a Database 338</p> <p>Searching for a specific record 338</p> <p>Filtering a database 339</p> <p>Sorting a Database 346</p> <p>Querying a Database 347</p> <p>Creating a simple query 347</p> <p>Creating a crosstab query 349</p> <p>Creating a query that finds duplicate field data 352</p> <p>Creating an unmatched query 354</p> <p>Viewing, renaming, closing, and deleting queries 355</p> <p><b>Chapter 18: Creating a Database Report</b> 357</p> <p>Using the Report Wizard 357</p> <p>Manipulating the Data in a Report 361</p> <p>Switching a report to Layout view 361</p> <p>Counting records or values 361</p> <p>Sorting a field 363</p> <p>Filtering a field 363</p> <p>Editing a Report 364</p> <p>Resizing fields 365</p> <p>Deleting fields 366</p> <p>Making Reports Look Pretty 366</p> <p>Applying themes 367</p> <p>Creating conditional formatting 367</p> <p>Deleting a Report 369</p> <p><b>Part 7: The Part of Tens</b><b> 371</b></p> <p><b>Chapter 19: Ten Tips for Using Office 2019</b><b> 373</b></p> <p>Saving Office 2019 Files 373</p> <p>Password-Protecting Your Files 375</p> <p>Guarding Against Macro Viruses 377</p> <p>Customizing the Ribbon 378</p> <p>Changing the Size of the Office Window 380</p> <p>Right-Clicking the Mouse 381</p> <p>Freezing Row and Column Headings in Excel 381</p> <p>Displaying Slides Out of Order in PowerPoint 382</p> <p>Reducing Spam in Outlook 382</p> <p>Setting up Outlook’s junk email filter 382</p> <p>Creating a Safe Senders list 384</p> <p>Creating a Blocked Senders list 385</p> <p>Using Office 365 and Office on Android and iOS 385</p> <p><b>Chapter 20: Ten Ways to Make Office 2019 Easier to Use</b> 387</p> <p>Build (and Use) Your Own Office Add-Ins 387</p> <p>Collaborating with the Review Tab 388</p> <p>Using Word’s References Tab 389</p> <p>Using Excel’s Data Tab 389</p> <p>Saving and Sending Files 390</p> <p>Encrypting a File 390</p> <p>Saving to the Cloud 391</p> <p>Ignoring the Silly Office Ribbon 392</p> <p>Find More Office Templates 392</p> <p>Use Microsoft Office Everywhere 393</p> <p>Index 395</p>
<p><b>Wallace Wang</b> is the bestselling author of more than 50 computer books, with over three million of his <i>For Dummies</i> books in print. They include numerous versions of <i>Office For Dummies</i> as well as <i>Beginning Programming For Dummies</i>. When not playing with computers, Wallace splits his time between teaching, writing, game designing, screenwriting, and stand-up comedy.
<ul> <li>Get up to speed with the new features in Office 2019</li> <li>Crunch numbers, create charts, and build spreadsheets</li> <li>Customize your email and calendar</li> </ul> <p><b>Move right into your new Office!</b> <p>More than 1.2 billion people use Microsoft Office. You'll be one of the happiest with this book as your guide! Here's the direct route to making the most of Word, Excel, PowerPoint, Outlook, and Access, with all the latest features. Begin creating documents, spreadsheets, and eye-popping presentations. Start maintaining and managing databases. Organize your life! Whether you're upgrading from a recent version, moving up from a 10-year-old Office incarnation, or meeting Office for the first time, this book is your shortcut to success. <ul> <li>Type and format text</li> <li>Create spreadsheets and charts</li> <li>Apply formulas</li> <li>Present your PowerPoint show</li> <li>Add sound to a presentation</li> <li>Design and modify a database</li> <li>Develop database reports</li> <li>Organize tasks and schedules</li> </ul>

Diese Produkte könnten Sie auch interessieren:

Netzkulturen
Netzkulturen
von: Josef Bairlein, Christopher Balme, Wolf-Dieter Ernst
PDF ebook
23,20 €
Mixed-Signal Layout Generation Concepts
Mixed-Signal Layout Generation Concepts
von: Chieh Lin, Arthur H.M. van Roermund, Domine Leenaerts
PDF ebook
96,29 €
System-Level Design Techniques for Energy-Efficient Embedded Systems
System-Level Design Techniques for Energy-Efficient Embedded Systems
von: Marcus T. Schmitz, Bashir M. Al-Hashimi, Petru Eles
PDF ebook
96,29 €