MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
Conventions and Features Used in This Book
- Sidebars
Chapter 2: Exploring Excel Fundamentals
- Legacy of the Great Feature Wars
- The Porthole Window
- If You Have a Wheel Mouse
- The Omnipotent Excel Options Dialog Box
- Keyboard Command Activation Options
- Belly Up to the Mini-Bar
- Quick Totals on the Status Bar
- How Much Disk Space Do You Need?
- Linking Custom Properties to Cells
- Adjusting Date Values
- Before You Call Product Support
Chapter 3: Custom-Tailoring the Excel Workspace
- Displayed vs. Printed Gridlines and Headlines
- Changing the Standard Display Font
- Ease of Access in Windows Vista
Chapter 5: Planning Your Worksheet Design
- Databases, Fields, and Records
Chapter 6: How to Work a Worksheet
- Navigating Multiple Selections
- Go To Special Keyboard Shortcuts
- Smart Tags
- Dragging Worksheets Between Workbooks
Chapter 8: Worksheet Editing Techniques
- Hunting and Gathering
- Handy Keyboard Shortcuts
- Fixing Formula Problems
- Fill Handles and Cell Selection Rectangles
- Understanding Fixed and Floating Decimals
- The Expanding Dialog Box
Chapter 9: Worksheet Formatting Techniques
- Using the Decimal Buttons
- Using Acounting Underlines
- Create Custom Billing and Part Number Formats
- The Hidden Number Format
- A Cool Application of Angled Text
- An Angled Border Trick
- Tricks for Tailoring Cells
- Hiding a Column or Row
Chapter 10: Creating Spiffy Graphics
- Create Linked Objects
- A Dialog Apart
- Selecting Text or Shapes
- What Is Alt Text?
- Controlling the Display of Objects
Chapter 11: Printing and Presenting
- AutoLetter/A4 Paper Resizing
- Centering Your Work on the Page
- Create a Default Header and Footer
Chapter 12: Building Formulas
- Practical Concatenation
- Rules for Naming
- Selecting Cells While a Dialog Box Is Open
- No More Natural-Language Formulas
- Are Your References Qualified
- Multithreaded Calculation
- A Single-Cell Array Formula Application
Chapter 14: Everyday Functions
- Automatic Range Expansion
- A MOD Example
- Try Your Luck
- Using the Flexible MROUND Function
- AVERAGE vs. AVG
- An ISERR Example
- Creating Automated Lookup Formulas
Chapter 15: Formatting and Calculating Date and Time
- Using the 1904 Date System
Chapter 17: Functions for Analyzing Statistics
- The A Functions
- Regressing into the Future?
- Correlating Tables
Chapter 18: Performing What-If Analysis
- Use Scenario Summary Reports
- Determine Whether You Need Integer Constraints
- The Importance of Using Appropriate Starting Values
Chapter 19: Basic Charting Techniques
- Combining Two Chart Types
Chapter 20: Charting Beyond the Ribbon
- Selecting Individual Data Points, Labels, or Legend Entries
Chapter 21: Managing Information in Tables
- Selecting Rows and Columns Within a Table
- Understanding the Default Sorting Sequence in Excel
Chapter 23: Working with External Data
- Opening dBase Files
- Automatic Query vs. Manual Query
Chapter 24: Collaborating on a Network or by E-Mail
- What You Can and Can't Do with a Shared Workbook
Категории