Excel 2007 bible
This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhereFully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, an...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wiley
c2007.
|
| Edición: | 1st edition |
| Colección: | Bible
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626866706719 |
Tabla de Contenidos:
- Excel 2007 Bible; About the Author; Credits; Contents at a Glance; 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?; Understanding Workbooks and Worksheets; Moving Around a Worksheet; Introducing the Ribbon; Using the shortcut menus; Customizing your Quick Access Toolbar; Working with Dialog Boxes; Using the Taskbar
- Creating Your First Excel WorksheetChapter 2: What's New in Excel 2007?; A New User Interface; Larger Worksheets; New File Formats; Worksheet Tables; Styles and Themes; Better Looking Charts; Page Layout View; Enhanced Conditional Formatting; Consolidated Options; SmartArt; Formula AutoComplete; Collaboration Features; Compatibility Checker; Improved Pivot Tables; New Worksheet Functions; Other New Features; Chapter 3: Entering and Editing Worksheet Data; Exploring the Types of Data You Can Use; Entering T ext and Values into Y our Workshets; Entering Dates and Times into Y our Workshets
- Modifying Cel ContentsAplying Number Formating; Chapter 4: Essential Worksheet Operations; Learning the Fundamentals of Excel Worksheets; Controlling the Worksheet View; Working with Rows and Columns; Chapter 5: Working with Cells and Ranges; Understanding Cells and Ranges; Copying or Moving Ranges; Using Names to Work with Ranges; Adding Comments to Cells; Chapter 6: Introducing Tables; What Is a Table?; Creating a Table; Changing the Look of a Table; Working with Tables; Chapter 7: Worksheet Formatting; Getting to Know the Formatting Tools; Using Formatting in Your Worksheets
- Using Named Styles for Easier FormattingUnderstanding Document Themes; Chapter 8: Understanding Excel's Files; Excel File Operations; Excel File Compatibility; Chapter 9: Using and Creating Templates; Exploring Excel Templates; Understanding Custom Excel Templates; Chapter 10: Printing Your Work; Printing with One Click; Changing Your Page View; Adjusting Common Page Setup Settings; Adding a Header or Footer to Your Reports; Adjusting the Settings in the Print Dialog Box; Preventing Certain Cells from Being Printed; Preventing Objects from being Printed
- Creating Custom Views of Your WorksheetPart II: Working with Formulas and Functions; Chapter 11: 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 12: Creating Formulas That Manipulate Text; A Few Words About Text; Text Functions; Advanced Text Formulas; Chapter 13: Working with Dates and Times; How Excel Handles Dates and Times; Date-Related Functions
- Time-Related Functions
