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
CISSP Exam Cram 2
Taking a Certification Exam
Penetration Testing
Software-Development Methods
Database Management
Computer Crimes
MySQL Cookbook
Decomposing Dates or Times Using Component-Extraction Functions
Converting Between Date-and-Time Values and Seconds
Performing Calculations with TIMESTAMP Values
Using Patterns to Match Dates or Times
Performing Transactions from Within Programs
Information Dashboard Design: The Effective Visual Communication of Data
Clarifying the Vision
Cluttering the Display with Useless Decoration
Tapping into the Power of Visual Perception
Key Goals in the Visual Design Process
Make the Viewing Experience Aesthetically Pleasing
Ruby Cookbook (Cookbooks (OReilly))
Writing to a File
Blocks as Closures: Using Outside Variables Within a Code Block
Creating a Shared Whiteboard
Scripting an External Program
Running Code as Another User
Special Edition Using FileMaker 8
Developing for Multiuser Deployment
Audit Trails in FileMaker Pro
Troubleshooting in Specific Areas: Performance, Context, Connectivity, and Globals
Publishing FileMaker Data as XML
Automatically Updating Plug-ins
GDI+ Programming with C#
Graphics Class Properties
Working with Colors
Clipping Regions Example
Global, Local, and Composite Transformations
Understanding the Rendering Process
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