Calgary Public Library

Excel 2013 Bible

eng

no index present

non fiction

Excel 2013 Bible

electronic resource

dictionaries

828299334

Excel at Excel with the help of this bestselling spreadsheet guide John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as ""Mr. Spreadsheet, "" Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more. Whether you're an

Excel 2013 Bible; Contents; Introduction; Is This Book for You?; Software Versions; Conventions Used in This Book; How This Book Is Organized; How to Use This Book; What's on the Website; Part I: Getting Started with Excel; Chapter 1: Introducing Excel; Identifying What Excel Is Good For; Seeing What's New in Excel 2013; Understanding Workbooks and Worksheets; Moving Around a Worksheet; Using the Ribbon; Using Shortcut Menus; Customizing Your Quick Access Toolbar; Working with Dialog Boxes; Using Task Panes; Creating Your First Excel Workbook; Chapter 2: Entering and Editing Worksheet DataExploring Data TypesEntering 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 TablesChapter 6: Worksheet FormattingGetting 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; Password-Protecting a Workbook; Organizing Your Files; Other Workbook Info Options; Closing Workbooks; Safeguarding Your Work; Excel File CompatibilityChapter 8: Using and Creating TemplatesExploring Excel Templates; Understanding Custom Excel Templates; Chapter 9: Printing Your Work; Basic Printing; 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 Functions; Chapter 10: Introducing Formulas and Functions; Understanding Formula Basics; Entering Formulas into Your WorksheetsEditing FormulasUsing Cell References in Formulas; Using Formulas in Tables; Correcting Common Formula Errors; Using Advanced Naming Techniques; 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; Counting and Summing Worksheet Cells; Basic Counting Formulas; Advanced Counting Formulas; Summing Formulas