Custom cover image
Excel 2010 bible / John Walkenbach
Resource type: Ressourcentyp: Buch (Online)Book (Online)Language: English Series: Bible Ser ; v.593Publisher: Indianapolis, IN : Wiley Publishing, c2010Copyright date: ©2010Edition: Online-AusgDescription: Online-Ressource (1 online resource (xliv, 1006 p.)) : illISBN:- 9781282685000
- 1282685007
- 9780470634745
- Nebent.: Umschlagt.: Microsoft Excel 2010 bible
- Microsoft Excel 2010 bible
- 005.54
- HF5548.4.M523
Contents:
Summary: John Walkenbach aka "Mr. Spreadsheet" is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at spreadsheetpage.com.Summary: Excel® 2010 Bible -- About the Author -- About the Technical Editor -- Credits -- Contents -- Acknowledgments -- Introduction -- Is This Book for You? -- Software Versions -- Conventions This Book Uses -- What the Icons Mean -- How This Book Is Organized -- How to Use This Book -- What's on the Companion CD -- Part I: Getting Started with Excel -- Chapter 1: Introducing Excel -- What Is Excel Good For? -- What's New in Excel 2010? -- Understanding Workbooks and Worksheets -- Moving around a Worksheet -- Introducing the Ribbon -- Using Shortcut Menus -- Customizing Your Quick Access Toolbar -- Working with Dialog Boxes -- Using the Task Pane -- Creating Your First Excel Worksheet -- Chapter 2: Entering and Editing Worksheet Data -- Exploring the Types of Data You Can Use -- Entering Text and Values into Your Worksheets -- Entering Dates and Times into Your Worksheets -- Modifying Cell Contents -- Applying Number Formatting -- Chapter 3: Essential Worksheet Operations -- Learning the Fundamentals of Excel Worksheets -- Controlling the Worksheet View -- Working with Rows and Columns -- Chapter 4: Working with Cells and Ranges -- Understanding Cells and Ranges -- Copying or Moving Ranges -- Using Names to Work with Ranges -- Adding Comments to Cells -- Chapter 5: Introducing Tables -- What Is a Table? -- Creating a Table -- Changing the Look of a Table -- Working with Tables -- Chapter 6: Worksheet Formatting -- Getting to Know the Formatting Tools -- Using Different Fonts to Format Your Worksheet -- Changing Text Alignment -- Using Colors and Shading -- Adding Borders and Lines -- Adding a Background Image to a Worksheet -- Using Named Styles for Easier Formatting -- Understanding Document Themes -- Chapter 7: Understanding Excel Files -- Creating a New Workbook -- Opening an Existing Workbook -- Saving a Workbook -- Using AutoRecover.PPN: PPN: 808944347Package identifier: Produktsigel: ZDB-26-MYL | ZDB-38-EBR | ZDB-30-PAD | ZDB-30-PBE | ZDB-30-PQE
Excel® 2010 Bible; About the Author; About the Technical Editor; Credits; Contents; Acknowledgments; Introduction; Is This Book for You?; Software Versions; Conventions This Book Uses; What the Icons Mean; How This Book Is Organized; How to Use This Book; What's on the Companion CD; Part I: Getting Started with Excel; Chapter 1: Introducing Excel; What Is Excel Good For?; What's New in Excel 2010?; Understanding Workbooks and Worksheets; Moving around a Worksheet; Introducing the Ribbon; Using Shortcut Menus; Customizing Your Quick Access Toolbar; Working with Dialog Boxes
Using the Task PaneCreating Your First Excel Worksheet; Chapter 2: Entering and Editing Worksheet Data; Exploring the Types of Data You Can Use; Entering Text and Values into Your Worksheets; Entering Dates and Times into Your Worksheets; Modifying Cell Contents; Applying Number Formatting; Chapter 3: Essential Worksheet Operations; Learning the Fundamentals of Excel Worksheets; Controlling the Worksheet View; Working with Rows and Columns; Chapter 4: Working with Cells and Ranges; Understanding Cells and Ranges; Copying or Moving Ranges; Using Names to Work with Ranges
Adding Comments to CellsChapter 5: Introducing Tables; What Is a Table?; Creating a Table; Changing the Look of a Table; Working with Tables; Chapter 6: Worksheet Formatting; Getting to Know the Formatting Tools; Using Different Fonts to Format Your Worksheet; Changing Text Alignment; Using Colors and Shading; Adding Borders and Lines; Adding a Background Image to a Worksheet; Using Named Styles for Easier Formatting; Understanding Document Themes; Chapter 7: Understanding Excel Files; Creating a New Workbook; Opening an Existing Workbook; Saving a Workbook; Using AutoRecover
Specifying a PasswordOrganizing Your Files; Other Workbook Info Options; Closing Workbooks; Safeguarding Your Work; Excel File Compatibility; Chapter 8: Using and Creating Templates; Exploring Excel Templates; Understanding Custom Excel Templates; Chapter 9: Printing Your Work; Printing with One Click; Changing Your Page View; Adjusting Common Page Setup Settings; Adding a Header or Footer to Your Reports; Copying Page Setup Settings across Sheets; Preventing Certain Cells from Being Printed; Preventing Objects from Being Printed; Creating Custom Views of Your Worksheet
Part II: Working with Formulas and FunctionsChapter 10: Introducing Formulas and Functions; Understanding Formula Basics; Entering Formulas into Your Worksheets; Editing Formulas; Using Cell References in Formulas; Using Formulas in Tables; Correcting Common Formula Errors; Using Advanced Naming Techniques; Tips for Working with Formulas; Chapter 11: Creating Formulas That Manipulate Text; A Few Words about Text; Text Functions; Advanced Text Formulas; Chapter 12: Working with Dates and Times; How Excel Handles Dates and Times; Date-Related Worksheet Functions; Time-Related Functions
Chapter 13: Creating Formulas That Count and Sum
No physical items for this record