Details

Teach Yourself VISUALLY Excel 365


Teach Yourself VISUALLY Excel 365


Teach Yourself VISUALLY (Tech) 1. Aufl.

von: Paul McFedries

19,99 €

Verlag: Wiley
Format: EPUB
Veröffentl.: 22.08.2022
ISBN/EAN: 9781119933649
Sprache: englisch
Anzahl Seiten: 320

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

Beschreibungen

<p><b>Excel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY series</b> <p>In <i>Teach Yourself VISUALLY: Excel 365</i>, veteran tech educator and writer Paul McFedries delivers a practical, step-by-step guide to using the latest version of the world’s most popular spreadsheet app. The book is filled with easy two-page lessons containing large-size screenshots and walkthroughs demonstrating common and useful tasks in Excel 365. You’ll learn how to present, analyze, visualize, and organize your data, as well as how to: <ul> <li>Create and fill spreadsheets, charts, tables, and PivotTables</li> <li>Filter and sort your data, use and create formulas, and organize your information</li> <li>Visualize your data with a variety of effective charts, graphs, and more</li></ul><p>A can’t-miss handbook perfect for anyone looking for straightforward and easy-to-follow tutorials on basic and advanced Excel techniques, <i>Teach Yourself VISUALLY: Excel 365</i> offers users of previous Excel versions—and complete Excel newbies—a clear roadmap to mastering Excel.
<p><b>Chapter 1 Getting Started with Excel</b></p> <p>Getting to Know Excel 4</p> <p>Start Excel on the Desktop 6</p> <p>Navigate to Excel for the Web 7</p> <p>Tour the Excel Window 8</p> <p>Work with the Excel Ribbon 9</p> <p><b>Chapter 2 Entering Data</b></p> <p>Learning the Layout of a Worksheet 12</p> <p>Understanding the Types of Data You Can Use 13</p> <p>Enter Text into a Cell 14</p> <p>Enter a Number into a Cell 16</p> <p>Enter a Date or Time into a Cell 18</p> <p>Edit Cell Data 20</p> <p>Delete Data from a Cell 22</p> <p><b>Chapter 3 Working with Ranges</b></p> <p>Select a Range 26</p> <p>Fill a Range with the Same Data 28</p> <p>Fill a Range with a Series of Values 30</p> <p>Flash Fill a Range 32</p> <p>Move or Copy a Range 34</p> <p>Insert a Row or Column 36</p> <p>Insert a Cell or Range 38</p> <p>Delete Data from a Range 40</p> <p>Delete a Range 42</p> <p>Hide a Row or Column 44</p> <p>Freeze Rows or Columns 46</p> <p>Merge Two or More Cells 48</p> <p><b>Chapter 4 Working with Range Names</b></p> <p>Understanding the Benefits of Using Range Names 52</p> <p>Define a Range Name 54</p> <p>Using Worksheet Text to Define a Range Name 56</p> <p>Navigate a Workbook Using Range Names 58</p> <p>Change a Range Name 60</p> <p>Delete a Range Name 62</p> <p><b>Chapter 5 Formatting Excel Ranges</b></p> <p>Change the Font and Font Size 66</p> <p>Apply Font Effects 68</p> <p>Change the Font Color 70</p> <p>Align Text Within a Cell 72</p> <p>Center Text Across Multiple Columns 74</p> <p>Rotate Text Within a Cell 76</p> <p>Add a Background Color to a Range 78</p> <p>Apply a Number Format 80</p> <p>Change the Number of Decimal Places Displayed 82</p> <p>Apply a Conditional Format to a Range 84</p> <p>Apply a Style to a Range 86</p> <p>Change the Column Width 88</p> <p>Change the Row Height 90</p> <p>Wrap Text Within a Cell 92</p> <p>Add Borders to a Range 94</p> <p>Copy Formatting from One Cell to Another 96</p> <p><b>Chapter 6 Building Formulas</b></p> <p>Understanding Excel Formulas 100</p> <p>Build a Formula 102</p> <p>Understanding Excel Functions 104</p> <p>Add a Function to a Formula 106</p> <p>Add a Range of Numbers 108</p> <p>Build an AutoSum Formula 110</p> <p>Add a Range Name to a Formula 112</p> <p>Reference Another Worksheet Range in a Formula 114</p> <p>Move or Copy a Formula 116</p> <p>Switch to Absolute Cell References 118</p> <p>Troubleshoot Formula Errors 120</p> <p><b>Chapter 7 Manipulating Worksheets</b></p> <p>Navigate a Worksheet 124</p> <p>Rename a Worksheet 125</p> <p>Create a New Worksheet 126</p> <p>Move a Worksheet 128</p> <p>Copy a Worksheet 130</p> <p>Delete a Worksheet 132</p> <p>Zoom In on or Out of a Worksheet 134</p> <p>Split a Worksheet into Two Panes 136</p> <p>Hide and Unhide a Worksheet 138</p> <p><b>Chapter 8 Dealing with Workbooks</b></p> <p>Create a New Blank Workbook 142</p> <p>Create a New Workbook from a Template 144</p> <p>Save a Workbook 146</p> <p>Open a Workbook 147</p> <p>Find Text in a Workbook 148</p> <p>Replace Text in a Workbook 150</p> <p><b>Chapter 9 Formatting Workbooks</b></p> <p>Modify the Workbook Colors 154</p> <p>Set the Workbook Fonts 156</p> <p>Choose Workbook Effects 158</p> <p>Apply a Workbook Theme 160</p> <p>Add a Workbook Header 162</p> <p>Add a Workbook Footer 164</p> <p><b>Chapter 10 Importing Data into Excel</b></p> <p>Understanding External Data 168</p> <p>Import Data from an Access Table 170</p> <p>Import Data from a Word Table 172</p> <p>Import Data from a Text File 174</p> <p>Import Data from a Web Page 176</p> <p>Import Data from an XML File 178</p> <p>Refresh Imported Data 180</p> <p>Separate Cell Text into Columns 182</p> <p><b>Chapter 11 Working with Tables</b></p> <p>Understanding Tables 186</p> <p>Get to Know Table Features 187</p> <p>Convert a Range to a Table 188</p> <p>Select Table Data 190</p> <p>Insert a Table Row 192</p> <p>Insert a Table Column 193</p> <p>Delete a Table Row 194</p> <p>Delete a Table Column 195</p> <p>Add a Column Subtotal 196</p> <p>Convert a Table to a Range 198</p> <p>Apply a Table Style 199</p> <p><b>Chapter 12 Analyzing with PivotTables</b></p> <p>Understanding PivotTables 202</p> <p>Explore PivotTable Features 203</p> <p>Build a PivotTable from an Excel Range or Table 204</p> <p>Refresh PivotTable Data 206</p> <p>Add Multiple Fields to the Row or Column Area 208</p> <p>Add Multiple Fields to the Data Area 210</p> <p>Move a Field to a Different Area 212</p> <p>Group PivotTable Values 214</p> <p>Apply a PivotTable Filter 216</p> <p><b>Chapter 13 Analyzing Data</b></p> <p>Sort a Range or Table 220</p> <p>Filter a Range or Table 222</p> <p>Set Data Validation Rules 224</p> <p>Create a Data Table 226</p> <p>Summarize Data with Subtotals 228</p> <p>Group Related Data 230</p> <p>Analyze Data with Goal Seek 232</p> <p>Highlight Cells That Meet Some Criteria 234</p> <p>Highlight the Top or Bottom Values in a Range 236</p> <p>Analyze Cell Values with Data Bars 238</p> <p>Analyze Cell Values with Color Scales 240</p> <p>Analyze Cell Values with Icon Sets 242</p> <p><b>Chapter 14 Visualizing Data with Charts</b></p> <p>Examine Chart Elements 246</p> <p>Understanding Chart Types 247</p> <p>Create a Chart 248</p> <p>Create a Recommended Chart 250</p> <p>Add Chart Titles 252</p> <p>Add Data Labels 253</p> <p>Position the Chart Legend 254</p> <p>Display Chart Gridlines 255</p> <p>Display a Data Table 256</p> <p>Change the Chart Layout and Style 257</p> <p>Select a Different Chart Type 258</p> <p>Change the Chart Source Data 260</p> <p>Move or Resize a Chart 262</p> <p><b>Chapter 15 Adding Worksheet Graphics</b></p> <p>Draw a Shape 266</p> <p>Insert an Online Image 268</p> <p>Insert a Photo from Your PC 270</p> <p>Insert a SmartArt Graphic 272</p> <p>Move or Resize a Graphic 274</p> <p>Format a Picture 276</p> <p><b>Chapter 16 Collaborating with Others</b></p> <p>Add a Comment to a Cell 280</p> <p>Protect a Worksheet’s Data 282</p> <p>Protect a Workbook’s Structure 284</p> <p>Save a Workbook to Your OneDrive 286</p> <p>Send a Workbook as an Email Attachment 288</p> <p>Save Excel Data as a Web Page 290</p> <p>Make a Workbook Compatible with Earlier Versions of Excel 292</p> <p>Mark Up a Worksheet with Digital Ink 294</p> <p>Collaborate on a Workbook Online 296</p> <p>Index 298</p>
<p><b><i>Teach yourself</i> VISUALLY<sup>™</sup></b> <p>Are you a visual learner? Do you prefer instructions that <i>show</i> you how to do something—and skip the long-winded explanations? If so, then this book is for you. Open it up and you’ll find clear, step-by-step screen shots that show you how to tackle hundreds of Excel 365 tasks. Each task-based spread covers a single technique, sure to help you get up and running on Excel 365 in no time. <p><b>You’ll learn to:</b> <ul><b><li>Master formulas and functions</li> <li>Use tables and charts</li> <li>Organize and analyze data</li> <li>Create informative visualizations</li> <li>Summarize data with PivotTables</li></b></ul> <p><b>Designed for visual learners</b> <ul><b><li>Two-page lessons break big topics into bite-sized modules</li> <li>Succinct explanations walk you through step by step</li> <li>Full-color screen shots demonstrate each task</li> <li>Helpful sidebars offer practical tips and tricks </li></b></ul>

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 €