Flylib.com
List of Sidebars
Previous page
Table of content
Next page
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
Previous page
Table of content
Next page
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
The .NET Developers Guide to Directory Services Programming
System.DirectoryServices.ActiveDirectory Overview
DirectorySearcher Overview
Syntactic versus Semantic Conversion
Active Directory and ADAM Schema
Summary
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Planning for Risk Management
Identifying Project Resource Risk
Quantifying and Analyzing Activity Risks
Managing Activity Risks
Appendix A Selected Detail From the PERIL Database
Twisted Network Programming Essentials
Using the Twisted Documentation
Starting the Twisted Event Loop
Downloading a Web Page
Authentication
Providing IMAP Access to Mailboxes
InDesign Type: Professional Typography with Adobe InDesign CS2
Up Next
Apostrophes
Opticals
Mastering Tabs and Tables
A Typical Style Sheet
HTI+ Home Technology Integrator & CEDIA Installer I All-In-One Exam Guide
Planning a Structured Wiring Installation
Troubleshooting a Home Network
Troubleshooting Video Systems
Home Lighting Devices
Integrating the Connected Home
Cultural Imperative: Global Trends in the 21st Century
Cultural Black Holes
Conclusion
Epilogue After September 11
Appendix A Cultural Categorization Characteristics
Appendix B Leadership Test
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