Details

Excel Portable Genius


Excel Portable Genius


Portable Genius 1. Aufl.

von: Lisa A. Bucki

12,99 €

Verlag: Wiley
Format: EPUB
Veröffentl.: 18.11.2020
ISBN/EAN: 9781119763598
Sprache: englisch
Anzahl Seiten: 240

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

Beschreibungen

<p><b>Your genius-level guide to Excel excellence</b></p> <p><i>Excel Portable Genius</i> covers the key features of Microsoft Excel in a concise, fast-paced, portable format that provides the perfect quick and easy-to-follow reference for novices and experienced users alike. Written by seasoned tech expert and trainer Lisa A. Bucki, it answers the nine key questions Excel users are most likely to face in their work and adds some hot tips and advice on this incredibly useful—but sometimes difficult-to-learn—program's lesser-known features.</p> <ul> <li>Build formulas to perform powerful calculations</li> <li>Format data to make it easy to find interpret and to highlight key results</li> <li>Sort and filter to organize or display specific information</li> <li>Chart data to pinpoint changes and identify trends</li> <li>Communicate results by printing and sharing</li> </ul> <p>Complete with a comprehensive index and extensive illustrations complementing straightforward instructions, this is the ideal guide to mastery of the world's most popular spreadsheet program.</p>
<p>Acknowledgments vii</p> <p>Introduction xiv</p> <p><b>Chapter 1 How Do I Start Using Excel? 2</b></p> <p>Starting and Exiting Excel 4</p> <p>Taking a Look Around 5</p> <p>Reviewing key screen features 5</p> <p>Workbooks versus worksheets 8</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 13</p> <p>Switching to another file 14</p> <p>Making Your First Cell Entries 16</p> <p>Moving around the sheet 16</p> <p>Text and values 17</p> <p>Dates and times 19</p> <p>Number formatting on the fly 20</p> <p>Making Selections 21</p> <p>Understanding cells and ranges 22</p> <p>Selecting a range 22</p> <p>Selecting a row or column 23</p> <p>Working with Sheets 24</p> <p>Adding, renaming, and jumping to a sheet 25</p> <p>Moving or copying a sheet 26</p> <p>Saving and Closing a File 27</p> <p><b>Chapter 2 How Do I Make Changes to My Sheet? 30</b></p> <p>Cell Editing Basics 32</p> <p>Making changes 32</p> <p>Commenting when editing 33</p> <p>Clearing cell contents 33</p> <p>Using Undo and Redo 34</p> <p>Spell-checking your work 35</p> <p>Copying or Moving a Range 35</p> <p>Using Paste Special 37</p> <p>Using Auto Fill and Filling Series 38</p> <p>Inserting and Deleting Rows, Columns, and Cells 41</p> <p>Creating Range Names 44</p> <p>Using the Name box 45</p> <p>Using the New Name dialog box 46</p> <p>Assigning multiple range names at once 47</p> <p>Deleting a range name 48</p> <p>Using Find and Replace 50</p> <p>Freezing Rows and Columns On-Screen 51</p> <p><b>Chapter 3 How Do I Add Up the Numbers with Formulas? 54</b></p> <p>Entering a Basic Formula 56</p> <p>Typing the formula 56</p> <p>Cell and range references in formulas 57</p> <p>Using the mouse to save time 58</p> <p>Dealing with minor errors 60</p> <p>Learning More About Operators 60</p> <p>Understanding Order of Precedence 63</p> <p>How order of precedence works 63</p> <p>Using parentheses in formulas 64</p> <p>Making a Cell or Range Reference Absolute Rather Than Relative 66</p> <p>Changing the reference type in a formula 66</p> <p>How referencing works when filling, copying, or moving a formula 67</p> <p>Showing Formulas in Cells 69</p> <p>Using Other Formula Review Techniques 70</p> <p><b>Chapter 4 When Do I Need to Include a Function? 72</b></p> <p>Understanding Functions 74</p> <p>Using AutoSum on the Home or Formulas Tab 74</p> <p>Typing a Function in a Formula 77</p> <p>Using the Formulas Tab to Insert a Function 79</p> <p>Choosing from the Function Library 79</p> <p>Using Insert Function to find a function 82</p> <p>Using Range Names in Formulas 83</p> <p>Reviewing Some Essential Functions 84</p> <p><b>Chapter 5 How Do I Use Formatting to Enhance My Worksheet? 90</b></p> <p>Changing the Number or Date Format 92</p> <p>Using number formats 94</p> <p>Using date and time formats 96</p> <p>Using special and custom formats 96</p> <p>Changing Cell Formatting 99</p> <p>Applying font formatting 100</p> <p>Applying alignment formatting 103</p> <p>Working with Borders and Shading 105</p> <p>Using Styles 107</p> <p>Clearing Formatting 109</p> <p>Understanding Themes 109</p> <p>Reviewing elements of a theme 109</p> <p>Changing themes 110</p> <p>Changing theme colors, fonts, and effects 111</p> <p>Working with Column Width and Row Height 113</p> <p>Using Conditional Formatting to Highlight Information 115</p> <p><b>Chapter 6 How Do I Use Graphics in Excel? 118</b></p> <p>Inserting Simple Graphics 120</p> <p>Shapes 120</p> <p>Pictures 122</p> <p>Icons 126</p> <p>Selecting and Formatting Graphics 127</p> <p>Adding text to shapes 128</p> <p>Changing styles 129</p> <p>Changing sizing and position 132</p> <p>Working with layering, alignment, and rotation 134</p> <p>Inserting WordArt 136</p> <p>Combining and Creating Your Own Graphics 138</p> <p>Creating and Working with SmartArt 141</p> <p>Adding a SmartArt graphic 141</p> <p>Editing and rearranging shapes 143</p> <p>Changing the graphic type and formatting 144</p> <p>Deleting a Graphic 145</p> <p>Adding a Background Image 146</p> <p><b>Chapter 7 How Do I Manage Lists of Information? 148</b></p> <p>Arranging a List in Excel 150</p> <p>Cleaning Up Data 152</p> <p>Using Flash Fill 152</p> <p>Using Text to Columns 155</p> <p>Removing duplicates and consolidating 157</p> <p>Sorting, Filtering, and Subtotaling Lists of Information 159</p> <p>Sorting and filtering a list 160</p> <p>Subtotaling a sorted list 162</p> <p>Understanding Excel’s Table Feature 163</p> <p>Converting a range to a table 164</p> <p>Importing or connecting to a list of data 166</p> <p>Changing table styles 168</p> <p>Resizing a table 169</p> <p>Renaming a table 170</p> <p>Sorting and Filtering a Table 170</p> <p>Using Table Calculations 170</p> <p>Adding a calculated column 171</p> <p>Adding a total row 173</p> <p>Converting a Table Back to a Range of Regular Cells 174</p> <p><b>Chapter 8 How Do I Present My Data in Charts? 176</b></p> <p>Charts and Their Role in Your Workbooks 178</p> <p>Chart Types 179</p> <p>Creating a Chart 180</p> <p>Changing the Chart Type and Layout 184</p> <p>Formatting Chart Elements 186</p> <p>Changing the Charted Data 189</p> <p>Moving a Chart to Its Own Sheet and Deleting a Chart 190</p> <p>Using Special Charts: Sparklines, PivotTables, and Maps 192</p> <p><b>Chapter 9 How Do I Print and Share My Content? 194</b></p> <p>Creating Headers and Footers 196</p> <p>Changing Page Settings 199</p> <p>Margins 199</p> <p>Orientation and paper size 200</p> <p>Scaling 201</p> <p>Changing Sheet Settings 201</p> <p>Adding print titles 201</p> <p>Controlling whether gridlines and other features print 203</p> <p>Working with Page Breaks 203</p> <p>Setting a print area 204</p> <p>Viewing and moving breaks 204</p> <p>Previewing a Printout and Printing 206</p> <p>Other Ways to Share Information 207</p> <p>Exporting a PDF 208</p> <p>Using OneDrive 209</p> <p>Index 212</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 computer users useful 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 Excel. But if you want to get the very most out of your worksheets, put this savvy <i>Portable Genius</i> guide to work and start ramping up the pace. Want to graph and chart data? Build powerful formulas? Import from databases? Sort and filter your data? You'll find cool and useful Genius tips, numerous screenshots, and pages of easy-to- access shortcuts and tools that will save you loads of time and let you enjoy Excel to the max.

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 €