Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond
Extend your Excel 2007 skills-and create more-powerful and compelling charts in less time. Guided by an Excel expert, you'll learn how to turn flat, static charts into dynamic solutions-where you can visualize and manipulate data countless ways with a simple mouse click. Get the hands-on pract...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627607506719 |
Tabla de Contenidos:
- Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond; Version Restriction: Excel 2007 and beyond; Objectives-Approaches-Possibilities; How Successful Can I Hope to Be?; What Prior Knowledge Do I Require?; Use of the rS1.Method; Design and Materials; Examples and Materials; Hardware and Software Requirements; Support for This Book; 1. Basic Information-Basic Techniques; Formula Bar; Worksheets; Sheet Tabs and Status Bar; Options; Enable Live Preview; Show Developer tab in the Ribbon; ScreenTip Style; When creating new workbooks; Formulas Category; Working with Formulas
- Error CheckingProofing Category; Save Category; Advanced Category; Cut, Copy and, Paste; Display; Display Options for Selected Workbooks and Worksheets; Formulas; Calculation Options and General Information; Customize Category; Add-Ins Category; Trust Center Category; Resources Category; The Ribbon; Quick Access Toolbar; Using the Keyboard to Access the Ribbon; The Office Button; Overviews and Materials; Basic Concepts and Structures; Data Sources; Legend Entries; Axis Labels; Formattable Elements; Plot Area; Data Series; Data Point; Labels; Axis Title; Legend; Data Labels; Data Table; Axes
- GridlinesAnalysis Elements; Error Bars; Up/Down Bars; Basic Approach; Access Using the Ribbon Tabs; Access Using the Context Menu; Access Using Keys; 2. New Approaches-Getting Started; The Basic Model; Step B; Step C; Step D; Step E; Conceptualizing from E to A-Implementing from A to E; Problems and Their Solutions; Digression: important Functions and Formulas; The VLOOKUP Function; The OFFSET Function; Suggestions for Improvement; Model Structures-A Practical example; Structure of the Workbook; Structural Components in Detail; Parameters 1 Worksheet; Data 1 Worksheet; Lists 1 Worksheet
- Basis 1 WorksheetFocus 1 Worksheet; A Solution Emerges; What's This About-And How Do I Do It?; Is All the Groundwork Done?; Defining the Parameters 1 Worksheet; Assigning a Range Name; Defining the Data 1 Worksheet; Entering Formulas; Defining the Node; The Data 1 Worksheet: A Summary; Defining and Preparing the Lists 1 Worksheet; Entering Formulas; Generating and Using Controls; Defining and Preparing the Basis 1 Worksheet; A Dynamic Chart Emerges; Defining the Focus 1 Worksheet; Formatting the Variable Data Series; Formatting the Primary Vertical Axis
- Formatting the Static Data Series and GridlinesFormatting the Primary Horizontal Axis; Summary; 3. Perceiving, Interpreting, Understanding; 100 Million Years; How Does Visual Perception Work?; The Most Important Laws of Perception; Consequences of Designing your Charts; The Law of Simplicity or ""Good Figure""; Consequences of Designing your Charts; The Law of Proximity; Consequences of Designing Your Charts; The Law of Closure; Consequences of Designing Your Charts; The Law of Continuity; Consequences of Designing Your Charts; Summary; Which Charts for Which Purpose
- Essential Types, Their Symbolism and Applications
