Bucki | Excel Portable Genius | Buch | sack.de

Bucki Excel Portable Genius



1. Auflage 2020, 240 Seiten, Kartoniert, Paperback, Format (B × H): 140 mm x 216 mm, Gewicht: 308 g Reihe: Portable Genius
ISBN: 978-1-119-76361-1
Verlag: Wiley


Bucki Excel Portable Genius

Your genius-level guide to Excel excellence

Excel Portable Genius 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.
* Build formulas to perform powerful calculations
* Format data to make it easy to find interpret and to highlight key results
* Sort and filter to organize or display specific information
* Chart data to pinpoint changes and identify trends
* Communicate results by printing and sharing

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.

Autoren/Hrsg.


Weitere Infos & Material


Acknowledgments viiIntroduction xivChapter 1 How Do I Start Using Excel? 2Starting and Exiting Excel 4Taking a Look Around 5Reviewing key screen features 5Workbooks versus worksheets 8Changing views 8Zooming 10Working with Files 11Creating a blank file 11Exploring templates 12Opening an existing file 13Switching to another file 14Making Your First Cell Entries 16Moving around the sheet 16Text and values 17Dates and times 19Number formatting on the fly 20Making Selections 21Understanding cells and ranges 22Selecting a range 22Selecting a row or column 23Working with Sheets 24Adding, renaming, and jumping to a sheet 25Moving or copying a sheet 26Saving and Closing a File 27Chapter 2 How Do I Make Changes to My Sheet? 30Cell Editing Basics 32Making changes 32Commenting when editing 33Clearing cell contents 33Using Undo and Redo 34Spell-checking your work 35Copying or Moving a Range 35Using Paste Special 37Using Auto Fill and Filling Series 38Inserting and Deleting Rows, Columns, and Cells 41Creating Range Names 44Using the Name box 45Using the New Name dialog box 46Assigning multiple range names at once 47Deleting a range name 48Using Find and Replace 50Freezing Rows and Columns On-Screen 51Chapter 3 How Do I Add Up the Numbers with Formulas? 54Entering a Basic Formula 56Typing the formula 56Cell and range references in formulas 57Using the mouse to save time 58Dealing with minor errors 60Learning More About Operators 60Understanding Order of Precedence 63How order of precedence works 63Using parentheses in formulas 64Making a Cell or Range Reference Absolute Rather Than Relative 66Changing the reference type in a formula 66How referencing works when filling, copying, or moving a formula 67Showing Formulas in Cells 69Using Other Formula Review Techniques 70Chapter 4 When Do I Need to Include a Function? 72Understanding Functions 74Using AutoSum on the Home or Formulas Tab 74Typing a Function in a Formula 77Using the Formulas Tab to Insert a Function 79Choosing from the Function Library 79Using Insert Function to find a function 82Using Range Names in Formulas 83Reviewing Some Essential Functions 84Chapter 5 How Do I Use Formatting to Enhance My Worksheet? 90Changing the Number or Date Format 92Using number formats 94Using date and time formats 96Using special and custom formats 96Changing Cell Formatting 99Applying font formatting 100Applying alignment formatting 103Working with Borders and Shading 105Using Styles 107Clearing Formatting 109Understanding Themes 109Reviewing elements of a theme 109Changing themes 110Changing theme colors, fonts, and effects 111Working with Column Width and Row Height 113Using Conditional Formatting to Highlight Information 115Chapter 6 How Do I Use Graphics in Excel? 118Inserting Simple Graphics 120Shapes 120Pictures 122Icons 126Selecting and Formatting Graphics 127Adding text to shapes 128Changing styles 129Changing sizing and position 132Working with layering, alignment, and rotation 134Inserting WordArt 136Combining and Creating Your Own Graphics 138Creating and Working with SmartArt 141Adding a SmartArt graphic 141Editing and rearranging shapes 143Changing the graphic type and formatting 144Deleting a Graphic 145Adding a Background Image 146Chapter 7 How Do I Manage Lists of Information? 148Arranging a List in Excel 150Cleaning Up Data 152Using Flash Fill 152Using Text to Columns 155Removing duplicates and consolidating 157Sorting, Filtering, and Subtotaling Lists of Information 159Sorting and filtering a list 160Subtotaling a sorted list 162Understanding Excel's Table Feature 163Converting a range to a table 164Importing or connecting to a list of data 166Changing table styles 168Resizing a table 169Renaming a table 170Sorting and Filtering a Table 170Using Table Calculations 170Adding a calculated column 171Adding a total row 173Converting a Table Back to a Range of Regular Cells 174Chapter 8 How Do I Present My Data in Charts? 176Charts and Their Role in Your Workbooks 178Chart Types 179Creating a Chart 180Changing the Chart Type and Layout 184Formatting Chart Elements 186Changing the Charted Data 189Moving a Chart to Its Own Sheet and Deleting a Chart 190Using Special Charts: Sparklines, PivotTables, and Maps 192Chapter 9 How Do I Print and Share My Content? 194Creating Headers and Footers 196Changing Page Settings 199Margins 199Orientation and paper size 200Scaling 201Changing Sheet Settings 201Adding print titles 201Controlling whether gridlines and other features print 203Working with Page Breaks 203Setting a print area 204Viewing and moving breaks 204Previewing a Printout and Printing 206Other Ways to Share Information 207Exporting a PDF 208Using OneDrive 209Index 212


Bucki, Lisa A.
Lisa A. Bucki 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.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.



Ihre Fragen, Wünsche oder Anmerkungen

Vorname*
Nachname*
Ihre E-Mail-Adresse*
Kundennr.
Ihre Nachricht*
Lediglich mit * gekennzeichnete Felder sind Pflichtfelder.
Wenn Sie die im Kontaktformular eingegebenen Daten durch Klick auf den nachfolgenden Button übersenden, erklären Sie sich damit einverstanden, dass wir Ihr Angaben für die Beantwortung Ihrer Anfrage verwenden. Selbstverständlich werden Ihre Daten vertraulich behandelt und nicht an Dritte weitergegeben. Sie können der Verwendung Ihrer Daten jederzeit widersprechen. Das Datenhandling bei Sack Fachmedien erklären wir Ihnen in unserer Datenschutzerklärung.