Details

Microsoft 365 Portable Genius


Microsoft 365 Portable Genius


Portable Genius 1. Aufl.

von: Lisa A. Bucki

12,99 €

Verlag: Wiley
Format: EPUB
Veröffentl.: 13.01.2021
ISBN/EAN: 9781119763734
Sprache: englisch
Anzahl Seiten: 272

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

Beschreibungen

<p><b>Power up your proficiency with this genius guide to popular Microsoft 365 apps</b></p> <p>Do you want to make your Microsoft 365 account a productivity behemoth? Do you want to squeeze every last bit of awesome from Word, Excel, and PowerPoint and learn a little more about Outlook, too? Microsoft 365 Portable Genius has got you covered. A seasoned tech expert and trainer, author Lisa A. Bucki shows you how to build Word documents, Excel workbooks, and PowerPoint presentations the right way, as well as how to use high-impact design techniques to make your documents pop.</p> <p>This book answers 11 key questions about how to make the most of Microsoft 365, providing genius tips as it leads you through the essentials. You’ll learn how to:</p> <ul> <li>Tackle common skills like creating files, adding basic content, navigating in a file, making selections, copying and moving content, and saving files</li> <li>Build a new Word document by using outlining, bullets and numbering, columns, and other features for creating and enhancing content</li> <li>Enhance Excel workbook files by organizing data on different sheets, filling entries, creating range names, and entering powerful, accurate formulas</li> <li>Develop a PowerPoint presentation by choosing the right layout for each slide and adding content to placeholders, and then transform it into an on-screen show with transitions and animations</li> <li>Add punchy design and branding by using text formatting, themes, and graphics in your files</li> <li>Use lists, tables, and charts to make data easier to interpret</li> <li>Create, send, reply to, and organize email in Outlook, as well as add contacts Share file contents on paper or digitally</li> <li>Check out the Online Bonus Appendix at Wiley for more genius coverage of topics including additional Excel formula review techniques, essential Excel functions, theme colors and fonts changes, and WordArt</li> </ul> <p>Whether you have used Office in the past or are new to its subscription successor Microsoft 365, Microsoft 365 Portable Genius provides the expert guidance you need to work smarter in Microsoft 365.</p>
<p>About the Author iii</p> <p>Acknowledgments v</p> <p>Introduction xi</p> <p><b>Chapter 1 How Do I Start Using Microsoft 365? 2</b></p> <p>Starting and Exiting an App 4</p> <p>Taking a Look Around 6</p> <p>Reviewing key screen features 6</p> <p>Changing views 8</p> <p>Zooming 10</p> <p>Working with Files 11</p> <p>Creating a blank file 11</p> <p>Exploring templates 12</p> <p>Opening an existing file 14</p> <p>Switching to another file 15</p> <p>Typing in a Word Document 17</p> <p>Making Your First Cell Entries in Excel 19</p> <p>Exploring the Excel screen 19</p> <p>Moving around the sheet 21</p> <p>Adding text and values 22</p> <p>Adding dates and times 23</p> <p>Number formatting on the fly 24</p> <p>Adding Slide Content in PowerPoint 26</p> <p>Making and Working with Selections 27</p> <p>Selecting content in Word 27</p> <p>Selecting content in Excel 28</p> <p>Selecting content in PowerPoint 30</p> <p>Copying or moving a selection 31</p> <p>Refining Your Content 33</p> <p>Spell checking your work 34</p> <p>Using Find and Replace 36</p> <p>Saving and Closing a File 37</p> <p><b>Chapter 2 How Do I Develop Document Content in Word? 40</b></p> <p>Using Outlining to Organize Your Thoughts 42</p> <p>More on Navigating, Selecting, and Editing in Word 44</p> <p>Creating Bulleted and Numbered Lists 47</p> <p>Working with Tabs and Indent Settings 49</p> <p>Setting tab stops 50</p> <p>Setting indents 52</p> <p>Working with Line, Page, and Section Breaks 54</p> <p>Creating Columns of Text 56</p> <p>Using Review Tools to Improve Your Writing 57</p> <p>Getting word suggestions from the Thesaurus 58</p> <p>Tracking changes and commenting 58</p> <p><b>Chapter 3 How Do I Make Changes in Excel? 62</b></p> <p>Working with Sheets 64</p> <p>Adding, renaming, and jumping to a sheet 64</p> <p>Moving or copying a sheet 65</p> <p>Cell Editing Basics 66</p> <p>Making changes 66</p> <p>Clearing cell contents 67</p> <p>Using Auto Fill and Filling Series 68</p> <p>Inserting and Deleting Rows, Columns, and Cells 71</p> <p>Working with Column Width and Row Height 73</p> <p>Creating Range Names 75</p> <p>Using the Name box 76</p> <p>Using the New Name dialog box 77</p> <p>Deleting a range name 78</p> <p>Freezing Rows and Columns On-Screen 79</p> <p><b>Chapter 4 How Do I Do Math with Excel Formulas and Functions? 82</b></p> <p>Entering a Basic Formula 84</p> <p>Typing the formula 84</p> <p>Cell and range references in formulas 85</p> <p>Using the mouse to save time 86</p> <p>Dealing with minor errors 88</p> <p>Learning More About Operators and Order of Precedence 88</p> <p>Reviewing operators in Excel 89</p> <p>Understanding how order of precedence works 91</p> <p>Using parentheses in formulas 93</p> <p>Making a Cell or Range Reference Absolute Rather Than Relative 94</p> <p>Changing the reference type in a formula 94</p> <p>How referencing works when filling, copying, or moving a formula 95</p> <p>Understanding and Using Functions 97</p> <p>Using AutoSum on the Home or Formulas tab 98</p> <p>Typing a function in a formula 101</p> <p>Using the Formulas tab to insert a function 103</p> <p>Using Range Names in Formulas 107</p> <p><b>Chapter 5 How Do I Create a PowerPoint Presentation? 110</b></p> <p>Understanding Slide Layouts 112</p> <p>Adding Slides 114</p> <p>Rearranging and Deleting Slides 116</p> <p>Working with Content Placeholders 117</p> <p>Regular content 117</p> <p>Speaker notes 119</p> <p>Editing Slide Content 120</p> <p>Changing Slide Size or Background 121</p> <p>Preparing and Playing the Slide Show 122</p> <p>Adding transitions 123</p> <p>Adding animations 124</p> <p>Playing the show 125</p> <p><b>Chapter 6 How Do I Use Formatting to Enhance My Documents? 128</b></p> <p>Changing the Number or Date Format in Excel 130</p> <p>Using number formats 132</p> <p>Using date and time formats 134</p> <p>Changing Text Formatting 134</p> <p>Applying font formatting 135</p> <p>Applying alignment formatting 139</p> <p>Changing Paragraph and Page</p> <p>Formatting in Word and PowerPoint 142</p> <p>Changing overall line spacing 143</p> <p>Changing spacing before and after paragraphs 143</p> <p>Working with Borders and Shading 146</p> <p>Using borders and shading in Word 146</p> <p>Adding a page border in Word 147</p> <p>Changing cell borders and shading in Excel 148</p> <p>Using Styles 149</p> <p>Understanding Themes 152</p> <p>Reviewing elements of a theme 152</p> <p>Changing themes 153</p> <p><b>Chapter 7 How Do I Use Graphics? 156</b></p> <p>Inserting Simple Graphics 158</p> <p>Shapes 158</p> <p>Pictures 160</p> <p>Icons 164</p> <p>Selecting and Formatting Graphics 165</p> <p>Adding text to shapes 165</p> <p>Changing styles 166</p> <p>Changing sizing and position 168</p> <p>Working with layering, alignment, and rotation 170</p> <p>Working with wrapping in Word 173</p> <p>Creating and Working with SmartArt 173</p> <p>Adding a SmartArt graphic 173</p> <p>Editing and rearranging shapes 176</p> <p>Changing the graphic type and formatting 177</p> <p>Deleting Graphics 177</p> <p><b>Chapter 8 How Do I Manage Lists of Information? 180</b></p> <p>Adding a Table in Word or PowerPoint 182</p> <p>Adding the table and making entries 182</p> <p>Adding and deleting rows or columns 183</p> <p>Arranging a List in Excel 184</p> <p>Understanding Excel’s Table Feature 187</p> <p>Converting a range to a table 187</p> <p>Importing or connecting to a list of data 189</p> <p>Resizing a table 192</p> <p>Adding a total row 192</p> <p>Sorting and Filtering Lists and Tables 193</p> <p>Changing Table Styles 197</p> <p>Converting a Table Back to Regular Content 198</p> <p><b>Chapter 9 How Do I Present My Data in Charts? 200</b></p> <p>Using Different Chart Types 202</p> <p>Creating a Chart in Excel 203</p> <p>Creating a Chart in Word or PowerPoint 207</p> <p>Changing the Chart Type and Layout 209</p> <p>Formatting Chart Elements 211</p> <p>Changing the Charted Data 213</p> <p>Deleting a Chart 215</p> <p><b>Chapter 10 How Do I Manage Emails and Contacts in Outlook? 216</b></p> <p>Adding Your Account 218</p> <p>Creating and Sending Messages 220</p> <p>Receiving, Reading, and Replying to Messages 224</p> <p>Organizing Messages 227</p> <p>Adding Contacts 229</p> <p><b>Chapter 11 How Do I Print and Share My Content? 232</b></p> <p>Creating Headers and Footers 234</p> <p>Changing Page Settings 238</p> <p>Margins 238</p> <p>Orientation and paper size 240</p> <p>Scaling an Excel printout 240</p> <p>Changing Sheet Settings in Excel 241</p> <p>Adding print titles 241</p> <p>Controlling whether gridlines and other features print 243</p> <p>Working with Page Breaks in Excel 243</p> <p>Setting a print area 243</p> <p>Viewing and moving breaks 245</p> <p>Previewing a Printout and Printing 246</p> <p>Sharing Information in Other Ways 247</p> <p>Exporting a PDF 247</p> <p>Using OneDrive 249</p> <p>Index 251</p>
<p><b>Lisa A. Bucki</b> is an author, trainer, and content creator who's been educating others about computers and software since 1990. She's written dozens of books, provided marketing and training services to her clients, and written online tutorials. She is the co-founder of 1x1 Media.<br />Fun, hip, and straightforward, the Portable Genius series gives forward-thinking technology users helpful information in handy, compact books that are easy to navigate and don't skimp on the essentials. Collect the whole series and make the most of your digital lifestyle.</p>
<p><b>THE GENIUS IS IN.</b> <p>You don't have to be a genius to use Microsoft 365. But to get the most out of your subscription, up your game with this savvy <i>Portable Genius</i> guide. Want to create a new Word document incorporating columns and graphics? Build powerful Excel formulas? Develop PowerPoint presentations with sleek slides and professional transitions? Handle email in Outlook? Whether you've used past versions of Office or you're brand new to Microsoft 365, you'll find cool and useful Genius tips, numerous screenshots, and pages of shortcuts and expert advice to save you loads of time and pump up your Microsoft 365 skills.

Diese Produkte könnten Sie auch interessieren:

AutoCAD 2013 For Dummies
AutoCAD 2013 For Dummies
von: Bill Fane, David Byrnes
PDF ebook
23,99 €
IBM Workplace Services Express For Dummies
IBM Workplace Services Express For Dummies
von: Stephen R. Londergan, Michael Loria
PDF ebook
16,99 €
Building Flash Web Sites For Dummies
Building Flash Web Sites For Dummies
von: Doug Sahlin
PDF ebook
18,99 €