Flylib.com
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
ISBN: 073562304X
EAN: 2147483647
Year: 2004
Pages: 143
Authors:
Curtis Frye
BUY ON AMAZON
Microsoft Office Excel 2007 Step by Step
Table of Contents
Copyright
About the Author
Acknowledgments
Features and Conventions
Using the Book s CD
Getting Help
The Microsoft Business Certification Program
Quick Reference
Chapter 1. What s New in Excel 2007?
Becoming Familiar with the New User Interface
Managing Larger Data Collections
Using the New Microsoft Office File Format
Formatting Cells and Worksheets
Managing Data Tables More Effectively
Creating Formulas More Easily by Using Formula AutoComplete
Summarizing Data Using New Functions
Creating Powerful Conditional Formats
Creating More Attractive Charts
Controlling Printouts More Carefully
Key Points
Chapter 2. Setting Up a Workbook
Creating Workbooks
Modifying Workbooks
Modifying Worksheets
Customizing the Excel 2007 Program Window
Key Points
Chapter 3. Working with Data and Data Tables
Entering and Revising Data
Moving Data Within a Workbook
Finding and Replacing Data
Correcting and Expanding Upon Worksheet Data
Defining a Table
Key Points
Chapter 4. Performing Calculations on Data
Naming Groups of Data
Creating Formulas to Calculate Values
Summarizing Data That Meets Specific Conditions
Finding and Correcting Errors in Calculations
Key Points
Chapter 5. Changing Document Appearance
Formatting Cells
Defining Styles
Applying Workbook Themes and Table Styles
Making Numbers Easier to Read
Changing the Appearance of Data Based on Its Value
Adding Images to a Document
Key Points
Chapter 6. Focusing on Specific Data Using Filters
Limiting Data That Appears on Your Screen
Manipulating List Data
Defining Valid Sets of Values for Ranges of Cells
Key Points
Chapter 7. Reordering and Summarizing Data
Sorting Data Lists
Organizing Data into Levels
Looking Up Information in a Data List
Key Points
Chapter 8. Combining Data from Multiple Sources
Using Data Lists as Templates for Other Lists
Linking to Data in Other Worksheets and Workbooks
Consolidating Multiple Sets of Data into a Single Workbook
Grouping Multiple Sets of Data
Key Points
Chapter 9. Analyzing Alternative Data Sets
Defining and Editing Alternative Data Sets
Defining Multiple Alternative Data Sets
Varying Your Data to Get a Desired Result Using Goal Seek
Finding Optimal Solutions with Solver
Analyzing Data with Descriptive Statistics
Key Points
Chapter 10. Creating Dynamic Lists with PivotTables
Analyzing Data Dynamically with PivotTables
Filtering, Showing, and Hiding PivotTable Data
Editing PivotTables
Formatting PivotTables
Creating PivotTables from External Data
Key Points
Chapter 11. Creating Charts and Graphics
Creating Charts
Customizing the Appearance of Charts
Finding Trends in Your Data
Creating Dynamic Charts Using PivotCharts
Creating Diagrams by Using SmartArt
Key Points
Chapter 12. Printing
Adding Headers and Footers to Printed Pages
Preparing Worksheets for Printing
Printing Data Lists
Printing Parts of Data Lists
Printing Charts
Key Points
Chapter 13. Automating Repetitive Tasks with Macros
Introducing Macros
Creating and Modifying Macros
Running Macros When a Button Is Clicked
Running Macros When a Workbook Is Opened
Key Points
Chapter 14. Working with Other Microsoft Office System Programs
Including Microsoft Office System Documents in Excel 2007 Worksheets
Storing Excel 2007 Documents as Parts of Other Microsoft Office System Documents
Creating Hyperlinks
Pasting Charts into Other Documents
Key Points
Chapter 15. Collaborating with Colleagues
Sharing Data Lists
Managing Comments
Tracking and Managing Colleagues Changes
Protecting Workbooks and Worksheets
Authenticating Workbooks
Saving Workbooks for the Web
Key Points
Glossary
Choose the Right Book for You
Published and Upcoming Titles
Index
SYMBOL
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
ISBN: 073562304X
EAN: 2147483647
Year: 2004
Pages: 143
Authors:
Curtis Frye
BUY ON AMAZON
Metrics and Models in Software Quality Engineering (2nd Edition)
The Iterative Development Process Model
Examples of Metrics Programs
Test Compression Factor
The Evaluation Phase
Data Quality Control
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Developing a Kanban Design
Training
Auditing the Kanban
Improving the Kanban
Appendix J Abbreviations and Acronyms
Introduction to 80x86 Assembly Language and Computer Architecture
Representing Data in a Computer
The Assembly Process
Floating-Point Arithmetic
Appendix B Useful MS-DOS Commands
Appendix E 80x86 Instructions (by Opcode)
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 240 Overcurrent Protection
Annex C. Conduit and Tubing Fill Tables for Conductors and Fixture Wires of the Same Size
Example D3(a) Industrial Feeders in a Common Raceway
Example No. D10 Feeder Ampacity Determination for Adjustable-Speed Drive Control [See 215.2, 430.24, 620.13, 620.14, 620.61, Tables 430.22(E), and 620.14]
Example No. D12 Park Trailer (See 552.47)
Sap Bw: a Step By Step Guide for Bw 2.0
Creating a Source System
Checking Loaded Characteristic Data
Aggregates and Multi-Cubes
Installing Business Content Objects and Loading R/3 Data
Appendix D. Bibliography
DNS & BIND Cookbook
Configuring a Name Server as a Slave for a Zone
Mapping Any Domain Name in a Zone to a Single IP Address
Limiting the Size of the IXFR Log File
Configuring DNS for Virtual Email Addresses
Introduction
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