Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond.

Format:

Book

Author/Creator:

Scheck, Reinhold.

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Business--Computer programs.

Electronic spreadsheets--Computer programs.

Electronic spreadsheets.

Business.

Local Subjects:

Business--Computer programs.

Electronic spreadsheets--Computer programs.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (0 p.)

Edition:

1st edition

Other Title:

Create dynamic charts in Excel 2007 and beyond

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

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 practice and examples you need to produce your own, professional-quality results. No programming required! Maximize the impact of your ideas and data! Learn how your design decisions affect perception and comprehensionMatch the right chart type to your communication

Contents:

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

Notes:

Description based upon print version of record.

ISBN:

9780735636286

0735636281

OCLC:

609857153