Flylib.com
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260
Authors:
Mark Dodge
,
Craig Stinson
BUY ON AMAZON
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
Year: 2004
Pages: 260
Authors:
Mark Dodge
,
Craig Stinson
BUY ON AMAZON
CompTIA Project+ Study Guide: Exam PK0-003
IT Project+ Study Guide
Answers to Assessment Test
Cost Planning
Project Control
Appendix B Standard IT Project Documents
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Cisco UE Applications Architecture
Firmware Files for IP Phones
Integrating Cisco CME with Cisco CallManager
Cisco CME GUI Customization Via XML
Troubleshooting Cisco UE Integrated Voice Mail Features
C & Data Structures (Charles River Media Computer Engineering)
C Operators
Recursion
Structures
Union
Problems in Linked Lists
Information Dashboard Design: The Effective Visual Communication of Data
All That Glitters Is Not Gold
Categorizing Dashboards
Choosing a Deficient Measure
Understanding the Limits of Short-Term Memory
Design for Use as a Launch Pad
File System Forensic Analysis
Summary
Bibliography
Server-based Partitions
MFT Concepts
Superblock
Java Concurrency in Practice
Thread Safety
Instance Confinement
Shared Data Models
Other Forms of Single-threaded Subsystems
AQS in Java.util.concurrent Synchronizer Classes
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies