MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 260
Pages: 260
Authors: Mark Dodge, Craig Stinson
- Table of Contents
- Back Cover
- Microsoft Office Excel 2007 Inside Out
- About the CD
- System Requirements
- Support Information
- Conventions and Features Used in This Book
- Design Conventions
- Part 1: Examining the Excel Environment
- Chapter 1: What s New in Microsoft Office Excel 2007
- New and Improved for 2007
- Retired in 2007
- If You Missed the Last Upgrade ...
- Onward ...
- Chapter 2: Exploring Excel Fundamentals
- Examining the Excel 2007 Workspace
- Exploring File Management Fundamentals
- Importing and Exporting Files
- Using the Online Help System
- Recovering from Crashes
- Chapter 3: Custom-Tailoring the Excel Workspace
- Controlling Other Elements of the Excel 2007 Interface
- Enhancing Accessibility
- Chapter 4: Security and Privacy
- File Security
- Other Security Features
- Part 2: Building Worksheets
- Chapter 5: Planning Your Worksheet Design
- Will You Need to Print the Worksheet?
- Who Is the Audience?
- Would Your Worksheet Survive Without You?
- Does the Worksheet Rely on Imported Data?
- Do You Need More Than One Worksheet?
- Have You Allowed Room for New Data?
- Chapter 6: How to Work a Worksheet
- Understanding Selection
- Techniques for Entering Data
- Managing Worksheets
- Viewing Worksheets
- Protecting Worksheets
- Chapter 7: How to Work a Workbook
- Opening Multiple Windows for the Same Workbook
- Hiding and Protecting Workbooks
- Part 3: Formatting and Editing Worksheets
- Chapter 8: Worksheet Editing Techniques
- Inserting and Deleting
- Undoing Previous Actions
- Editing Cell Contents
- Finding and Replacing Stuff
- Getting the Words Right
- Editing Multiple Worksheets
- Auditing and Documenting Worksheets
- Outlining Worksheets
- Consolidating Worksheets
- Chapter 9: Worksheet Formatting Techniques
- Formatting Fundamentals
- Using Themes and Cell Styles
- Formatting Conditionally
- Formatting in Depth
- Using Template Files to Store Formatting
- Part 4: Adding Graphics and Printing
- Chapter 10: Creating Spiffy Graphics
- Using the Shapes Tools
- Creating WordArt
- Creating SmartArt
- Inserting Graphics
- Formatting Graphics
- Working with Graphic Objects
- More Tricks with Graphic Objects
- Gallery of Spiffy Examples
- Chapter 11: Printing and Presenting
- Specifying What and Where to Print
- Adjusting Page Breaks
- Using Print Preview
- Setting Printer Driver Options
- Creating Portable Documents
- Part 5: Creating Formulas and Performing Data Analysis
- Chapter 12: Building Formulas
- Using Functions: A Preview
- Working with Formulas
- Worksheet Calculation
- Using Arrays
- Linking Workbooks
- Creating Conditional Tests
- Chapter 13: Using Functions
- Exploring the Syntax of Functions
- Inserting Functions
- Chapter 14: Everyday Functions
- Understanding Mathematical Functions
- Understanding Text Functions
- Understanding Logical Functions
- Understanding Information Functions
- Understanding Lookup and Reference Functions
- Chapter 15: Formatting and Calculating Date and Time
- Entering Dates and Times
- Formatting Dates and Times
- Calculating with Date and Time
- Working with Date and Time Functions
- Chapter 16: Functions for Financial Analysis
- Calculating Investments
- Calculating Depreciation
- Analyzing Securities
- Using the Euro Currency Tools Add-In
- Chapter 17: Functions for Analyzing Statistics
- Understanding Linear and Exponential Regression
- Using the Analysis Toolpak Data Analysis Tools
- Chapter 18: Performing What-If Analysis
- Using the Scenario Manager
- Using the Goal Seek Command
- Using the Solver
- Part 6: Creating Charts
- Chapter 19: Basic Charting Techniques
- Selecting Data for Your Chart
- Choosing a Chart Type
- Changing the Chart Type
- Switching Rows and Columns
- Choosing a Chart Layout
- Choosing a Chart Style
- Moving the Chart to a Separate Chart Sheet
- Adding, Editing, and Removing a Chart Title
- Adding, Editing, and Removing a Legend
- Adding and Positioning Data Labels
- Adding a Data Table
- Manipulating Axes
- Adding Axis Titles
- Changing the Rotation of Chart Text
- Displaying Gridlines
- Adding Text Annotations
- Changing the Font or Size of Chart Text
- Applying Shape Styles and WordArt Styles
- Saving Templates to Make Chart Formats Reusable
- Chapter 20: Charting Beyond the Ribbon
- Repositioning Chart Elements with the Mouse
- Formatting Lines and Borders
- Formatting Areas
- Formatting Text
- Working with Axes
- Working with Data Labels
- Formatting Data Series and Markers
- Modifying the Data Source for Your Chart
- Using Multilevel Categories
- Adding Moving Averages and Other Trendlines
- Adding Error Bars
- Adding High-Low Lines and Up and Down Bars
- Part 7: Managing Databases and Tables
- Chapter 21: Managing Information in Tables
- How to Organize a Table
- Creating a Table
- Adding Totals to a Table
- Sorting Tables and Other Ranges
- Filtering a List or Table
- Using Formulas with Tables
- Formatting Tables
- Chapter 22: Analyzing Data with PivotTable Reports
- Creating a PivotTable
- Rearranging PivotTable Fields
- Refreshing a PivotTable
- Changing the Numeric Format of PivotTable Data
- Choosing Report Layout Options
- Formatting a PivotTable
- Displaying Totals and Subtotals
- Sorting PivotTable Fields
- Filtering PivotTable Fields
- Changing PivotTable Calculations
- Grouping and Ungrouping Data
- Displaying the Details Behind a Data Value
- Creating PivotCharts
- Chapter 23: Working with External Data
- Opening an Entire Access Table in Excel
- Working with Data in Text Files
- Working with XML Files
- Using Microsoft Query to Import Data
- Using a Web Query to Return Internet Data
- Part 8: Collaborating
- Chapter 24: Collaborating on a Network or by E-Mail
- Sharing Workbooks on a Network
- Combining Changes Made to Multiple Workbooks
- Distributing Workbooks and Worksheets by E-Mail
- Controlling Document Access with Information Rights Management
- Chapter 25: Collaborating Using the Internet
- Exporting Excel Tables to SharePoint
- Using Excel Services
- Part 9: Automating Excel
- Chapter 26: Recording Macros
- Configuring Macro Security
- Using the Macro Recorder
- Introducing the Visual Basic Editor
- Learning the Basics of Visual Basic
- Adding Code to or Editing Recorded Macros
- Using Subroutines in Macros
- Using the Personal Macro Workbook
- Going On from Here
- Chapter 27: Creating Custom Functions
- Creating a Simple Custom Function
- Using Custom Functions
- Understanding Custom Function Rules
- Using VBA Keywords in Custom Functions
- Documenting Macros and Custom Functions
- Creating Custom Functions with Optional Arguments
- Making Your Custom Functions Available Anywhere
- Chapter 28: Debugging Macros and Custom Functions
- Using Design-Time Tools
- Dealing with Run-Time Errors
- Part 10: Integrating Excel with Other Applications
- Chapter 29: Using Hyperlinks
- Creating a Hyperlink in a Cell
- Assigning a Hyperlink to a Shape, Image, or Chart
- Selecting a Cell or Object Without Triggering the Hyperlink
- Using Formulas to Create Hyperlinks
- Chapter 30: Linking and Embedding
- Embedding vs. Linking
- Embedding vs. Static Pasting
- Embedding and Linking from the Clipboard
- Embedding and Linking with the Object Command
- Managing Links
- Linking vs. Hyperlinking
- Chapter 31: Using Excel Data in Word Documents
- Using Excel Tables in Word Documents
- Using Excel Charts in Word Documents
- Using Excel to Supply Mail-Merge Data to Word
- Part 11: Appendixes
- Appendix A: Menu to Ribbon Command Reference
- Appendix B: Keyboard Shortcuts
- Keyboard Shortcuts by Key
- Keyboard Shortcuts by Task
- Appendix C: Function Reference
- Index
- Symbols and Numbers
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z
- List of Figures
- List of Tables
- List of Examples
- List of Sidebars
- CD Content
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 260
Pages: 260
Authors: Mark Dodge, Craig Stinson