Flylib.com
Excel 2007[c] The Missing Manual
Excel 2007[c] The Missing Manual
ISBN: 596527594
EAN: N/A
Year: 2007
Pages: 173
BUY ON AMAZON
Excel 2007: The Missing Manual
Table of Contents
Copyright
The Missing Credits
Introduction
Part I: Worksheet Basics
Chapter 1. Creating and Navigating Worksheets
Section 1.1. Creating a Basic Worksheet
Section 1.2. Editing Data
Section 1.3. Navigating in Excel
Section 1.4. Saving Files
Section 1.5. Opening Files
Chapter 2. Adding Information to Worksheets
Section 2.1. Adding Different Types of Data
Section 2.2. Quick Ways to Add Data
Chapter 3. Moving Data Around a Worksheet
Section 3.1. Selecting Cells
Section 3.2. Moving Cells Around
Section 3.3. Adding and Moving Columns or Rows
Chapter 4. Managing Worksheets and Workbooks
Section 4.1. Worksheets and Workbooks
Section 4.2. Find and Replace
Section 4.3. Spell Check
Chapter 5. Formatting Cells
Section 5.1. Formatting Cell Values
Section 5.2. Formatting Cell Appearance
Chapter 6. Smart Formatting Tricks
Section 6.1. The Format Painter
Section 6.2. Styles and Themes
Section 6.3. Conditional Formatting
Chapter 7. Viewing and Printing Worksheets
Section 7.1. Controlling Your View
Section 7.2. Printing
Section 7.3. Controlling Pagination
Part II: Formulas and Functions
Chapter 8. Building Basic Formulas
Section 8.1. Creating a Basic Formula
Section 8.2. Formula Shortcuts
Section 8.3. Copying Formulas
Chapter 9. Math and Statistical Functions
Section 9.1. Rounding Numbers
Section 9.2. Groups of Numbers
Section 9.3. General Math Functions
Section 9.4. Trigonometry and Advanced Math
Section 9.5. Advanced Statistics
Chapter 10. Financial Functions
Section 10.1. The World of Finance
Section 10.2. Financial Functions
Section 10.3. Depreciation
Section 10.4. Other Financial Functions
Chapter 11. Manipulating Dates, Times, and Text
Section 11.1. Manipulating Text
Section 11.2. Manipulating Dates and Times
Section 11.3. Math with Dates and Times
Section 11.4. Date and Time Functions
Chapter 12. Lookup, Reference, and Information Functions
Section 12.1. The Basic Lookup
Section 12.2. Advanced Lookups
Section 12.3. Information Functions
Section 12.4. Tutorial: Quickly Generating Invoices from a Product Catalog
Chapter 13. Advanced Formula Writing and Troubleshooting
Section 13.1. Conditions in Formulas
Section 13.2. Descriptive Names for Cell References
Section 13.3. Variable Data Tables
Section 13.4. Controlling Recalculation
Section 13.5. Solving Formula Errors
Part III: Organizing Worksheets
Chapter 14. Tables: List Management Made Easy
Section 14.1. The Basics of tablesTables
Section 14.2. Sorting and Filtering a Table
Section 14.3. Dealing with Duplicate Rows
Section 14.4. Performing Table Calculations
Chapter 15. Grouping and Outlining Data
Section 15.1. Basic Data Grouping
Section 15.2. Grouping Timesavers
Chapter 16. Templates
Section 16.1. Understanding Templates
Section 16.2. Creating a New Workbook from a Template
Section 16.3. Creating Templates
Part IV: Charts and Graphics
Chapter 17. Creating Basic Charts
Section 17.1. Charting 101
Section 17.2. Basic Tasks with Charts
Section 17.3. Practical Charting
Section 17.4. Chart Types
Chapter 18. Formatting and Perfecting Charts
Section 18.1. Chart Styles and Layouts
Section 18.2. Adding Chart Elements
Section 18.3. Selecting Chart Elements
Section 18.4. Formatting Chart Elements
Section 18.5. Improving Your Charts
Section 18.6. Advanced Charting
Chapter 19. Inserting Graphics
Section 19.1. Adding Pictures to a Worksheet
Section 19.2. Excel s Clip Art Library
Section 19.3. Drawing Shapes
Part V: Advanced Data Analysis
Chapter 20. Scenarios and Goal Seeking
Section 20.1. Using Scenarios
Section 20.2. Using Goal Seek
Section 20.3. Solver
Chapter 21. Pivot Tables
Section 21.1. Summary Tables Revisited
Section 21.2. Building Pivot Tables
Section 21.3. Multi-Layered Pivot Tables
Section 21.4. Fine-Tuning Pivot Table Calculations
Section 21.5. Filtering a Pivot Table
Section 21.6. Pivot Charts
Part VI: Sharing Data with the Rest of the World
Chapter 22. Protecting Your Workbooks
Section 22.1. Understanding Excel s Safeguards
Section 22.2. Data Validation
Section 22.3. Locked and Hidden Cells
Chapter 23. Worksheet Collaboration
Section 23.1. Preparing Your Workbook
Section 23.2. Adding Comments
Section 23.3. Tracking Changes
Section 23.4. Sharing Your Workbook
Chapter 24. Querying Databases and XML Files
Section 24.1. Excel and Databases
Section 24.2. Understanding XML
Section 24.3. Excel and XML
Chapter 25. Exchanging Data with Other Programs
Section 25.1. Sharing Information in Windows
Section 25.2. Embedding and Linking Objects
Section 25.3. Transferring Data
Chapter 26. Connecting Worksheets to the Web
Section 26.1. Putting Worksheets on the Web
Section 26.2. Performing Web Queries
Section 26.3. Using Hyperlinks
Part VII: Programming Excel
Chapter 27. Automating Tasks with Macros
Section 27.1. Macros 101
Section 27.2. The Macro Recorder
Section 27.3. Macro Security
Section 27.4. Creating Practical Macros
Chapter 28. Programming Spreadsheets with VBA
Section 28.1. The Visual Basic Editor
Section 28.2. Understanding Macro Code
Section 28.3. Exploring the VBA Language
Part VIII: Appendix
Appendix A. Customizing the Quick Access Toolbar
Section A.1. The Quick Access Toolbar
Colophon
Index
SYMBOL
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
Excel 2007[c] The Missing Manual
ISBN: 596527594
EAN: N/A
Year: 2007
Pages: 173
BUY ON AMAZON
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
Changing the Type of an Existing Chart
Preparing Contour Plots
Deseasonalization of a Time Series
Solving Linear Systems
Achieving a Certain Future Value
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Individual change
Organizational change
Part II - The Applications
Cultural change
IT-based process change
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
Triggers
Table Security
Looping in SQL*Plus
SQL*Plus Settings You Can Control
Section A.1. The Command to Invoke SQL*Plus
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Getting Faster to Get Better Why You Need Both Lean and Six Sigma
Seeing Services Through Your Customers Eyes-Becoming a customer-centered organization
Executing Corporate Strategy with Lean Six Sigma
The Value in Conquering Complexity
Phase 4 Performance and Control
What is Lean Six Sigma
Key #3: Work Together for Maximum Gain
Beyond the Basics: The Five Laws of Lean Six Sigma
Making Improvements That Last: An Illustrated Guide to DMAIC and the Lean Six Sigma Toolkit
The Experience of Making Improvements: What Its Like to Work on Lean Six Sigma Projects
Six Things Managers Must Do: How to Support Lean Six Sigma
Extending and Embedding PHP
Compiling on Win32
PHP5 Objects
Advanced Embedding
Parameter Retrieval
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