Excel 2013 for dummies
by Greg Harvey
| Alternative title: | Microsoft Excel 2013 for dummies |
|---|---|
| Year of publication: |
2013 ; Online-Ausg.
|
| Authors: | Harvey, Greg |
| Publisher: |
Hoboken, N.J : John Wiley & Sons, Inc |
Online Resource
| Extent: | Online-Ressource (xii, 394 p.) ill. |
|---|---|
| Type of publication: | Book / Working Paper |
| Language: | English |
| Notes: | Includes index. - Electronic reproduction; Palo Alto, Calif; ebrary; 2013; Available via World Wide Web; Access may be limited to ebrary affiliated libraries Excel® 2013 For Dummies®; Contents at a Glance; Table of Contents; Introduction; About This Book; How to Use This Book; What You Can Safely Ignore; Foolish Assumptions; How This Book Is Organized; Conventions Used in This Book; Where to Go from Here; Part I: Getting Started with Excel 2013; Chapter 1: The Excel 2013 User Experience; Excel's Ribbon User Interface; Launching and Quitting Excel; Help Is on the Way; Chapter 2: Creating a Spreadsheet from Scratch; So What Ya Gonna Put in That New Workbook of Yours?; Doing the Data-Entry Thing; It Takes All Types; Fixing Those Data Entry Flub-Ups Taking the Drudgery out of Data EntryHow to Make Your Formulas Function Even Better; Making Sure That the Data Is Safe and Sound; Saving the Workbook as a PDF File; Document Recovery to the Rescue; Part II: Editing without Tears; Chapter 3: Making It All Look Pretty; Choosing a Select Group of Cells; Using the Format as Table Gallery; Cell Formatting from the Home Tab; Formatting Cells Close to the Source with the Mini-bar; Using the Format Cells Dialog Box; Calibrating Columns; Futzing with the Fonts; Altering the Alignment; Doing It in Styles; Fooling Around with the Format Painter Conditional FormattingChapter 4: Going Through Changes; Opening Your Workbooks for Editing; Much Ado about Undo; Doing the Old Drag-and-Drop Thing; Copying Formulas with AutoFill; Cut and Paste, Digital Style; Let's Be Clear about Deleting Stuff; Staying in Step with Insert; Stamping Out Your Spelling Errors; Eliminating Errors with Text to Speech; Chapter 5: Printing the Masterpiece; Previewing Pages in Page Layout View; Using the Backstage Print Screen; Printing the Current Worksheet; My Page Was Set Up!; From Header to Footer; Solving Page Break Problems; Letting Your Formulas All Hang Out Part III: Getting Organized and Staying That WayChapter 6: Maintaining the Worksheet; Zooming In and Out; Splitting the Worksheet into Windows; Fixed Headings with Freeze Panes; Electronic Sticky Notes; The Range Name Game; Seek and Ye Shall Find . . .; Replacing Cell Entries; Doing Your Research; Controlling Recalculation; Putting on the Protection; Chapter 7: Maintaining Multiple Worksheets; Juggling Multiple Worksheets; Don't Short-Sheet Me!; Opening Windows on Your Worksheets; Comparing Worksheets Side by Side; Shifting Sheets to Other Workbooks; Summing Stuff on Different Worksheets Part IV: Digging Data AnalysisChapter 8: Doing What-If Analysis; Playing What-If with Data Tables; Playing What-If with Goal Seeking; Making the Case with Scenario Manager; Chapter 9: Playing with Pivot Tables; Data Analysis with Pivot Tables; Formatting Pivot Tables; Sorting and Filtering Pivot Table Data; Modifying Pivot Tables; Creating Pivot Charts; Part V: Life beyond the Spreadsheet; Chapter 10: Charming Charts and Gorgeous Graphics; Making Professional-Looking Charts; Adding Great-Looking Graphics; Controlling How Graphic Objects Overlap; Printing Just the Charts Chapter 11: Getting on the Data List pt. I. Getting started with Excel 2013 -- pt. II. Editing without tears -- pt. III. Getting organized and staying that way -- pt. IV. Digging data analysis -- pt. V. Life beyond the spreadsheet -- pt. VI. The part of tens Microsoft Excel 2013 for dummies |
| ISBN: | 978-1-118-55012-0 ; 978-1-118-51012-4 |
| Source: | ECONIS - Online Catalogue of the ZBW |
Persistent link: https://www.econbiz.de/10012600474