Excel 2003: The Missing Manual. The Missing Manual

Kup polskie wydanie:

Spis treści książki

• Excel: The Missing Manual
  • SPECIAL OFFER: Upgrade this ebook with OReilly
  • A Note Regarding Supplemental Files
  • The Missing Credits
    • About the Author
    • About the Creative Team
    • Acknowledgements
    • The Missing Manual Series
  • Introduction
    • What Excel Is all About
    • About This Book
      • About the Outline
      • About These Arrows
      • The Very Basics
      • Examples
      • About MissingManuals.com
    • Safari-Enabled
  • I. Worksheet Basics
    • 1. Creating and Navigating Worksheets
      • 1.1. Creating a Basic Worksheet
        • 1.1.1. Starting a New Worksheet
        • 1.1.2. Adding the Column Titles
        • 1.1.3. Adding Data
      • 1.2. Editing Data
      • 1.3. Navigating in Excel
        • 1.3.1. The Menus
        • 1.3.2. The Task Pane
        • 1.3.3. The Toolbars
          • 1.3.3.1. Moving toolbars
          • 1.3.3.2. Toolbars with missing buttons
          • 1.3.3.3. Toolbar tricks
        • 1.3.4. The Formula Bar
        • 1.3.5. The Status Bar
      • 1.4. Saving Files
        • 1.4.1. Saving Your Spreadsheet in Other Formats
        • 1.4.2. Saving Your Spreadsheet with a Password
        • 1.4.3. Disaster Recovery
      • 1.5. Opening Files
        • 1.5.1. Searching for Files
    • 2. Adding Information to Worksheets
      • 2.1. Adding Different Types of Data
        • 2.1.1. Controlling Your Data Types
          • 2.1.1.1. How Excel decides your data is text
          • 2.1.1.2. How Excel decides your data is numeric
          • 2.1.1.3. How Excel decides your data is a date or time
      • 2.2. Quick Ways to Add Data
        • 2.2.1. AutoComplete
        • 2.2.2. AutoCorrect
        • 2.2.3. AutoFill
          • 2.2.3.1. Custom AutoFill Lists
        • 2.2.4. AutoFit
        • 2.2.5. Undo and Redo
          • 2.2.5.1. Undo quirks
    • 3. Moving Data Around a Worksheet
      • 3.1. Selecting Cells
        • 3.1.1. Making Continuous Range Selections
        • 3.1.2. Making Non-Contiguous Selections
        • 3.1.3. Automatically Selecting Your Data
        • 3.1.4. Making Selections with the Keyboard
      • 3.2. Moving Cells Around
        • 3.2.1. A Simple Cut-and-Paste or Copy-and-Paste
        • 3.2.2. A Fancy Cut-and-Paste or Copy-and-Paste
        • 3.2.3. The Clipboard
        • 3.2.4. Special Pasting
      • 3.3. Adding and Moving Columns or Rows
        • 3.3.1. Inserting Columns
        • 3.3.2. Inserting Rows
        • 3.3.3. Inserting Copied or Cut Cells
        • 3.3.4. Deleting Columns and Rows
    • 4. Formatting Worksheets
      • 4.1. Formatting Cell Values
        • 4.1.1. Formatting Numbers
          • 4.1.1.1. General
          • 4.1.1.2. Number
          • 4.1.1.3. Currency
          • 4.1.1.4. Accounting
          • 4.1.1.5. Percentage
          • 4.1.1.6. Fraction
          • 4.1.1.7. Scientific
          • 4.1.1.8. Text
        • 4.1.2. Formatting Dates and Times
        • 4.1.3. Special Formats for Special Numbers
        • 4.1.4. Custom Formats
          • 4.1.4.1. Creating a custom format
          • 4.1.4.2. Custom format string codes
          • 4.1.4.3. Date and time format strings
          • 4.1.4.4. Number format strings
          • 4.1.4.5. Text format strings
      • 4.2. Formatting Cell Appearance
        • 4.2.1. Alignment and Orientation
        • 4.2.2. Fonts and Color
          • 4.2.2.1. Special characters
        • 4.2.3. Borders and Patterns
      • 4.3. Smart Ways to Apply Formatting
        • 4.3.1. Shortcuts with the Toolbars
          • 4.3.1.1. Drawing borders
          • 4.3.1.2. Formatting individual characters
        • 4.3.2. AutoFormat
        • 4.3.3. The Format Painter
        • 4.3.4. Using Styles
          • 4.3.4.1. Creating a style
          • 4.3.4.2. Applying a style
          • 4.3.4.3. Transferring styles
        • 4.3.5. Conditional Formatting
    • 5. Managing Worksheets and Workbooks
      • 5.1. Worksheets and Workbooks
        • 5.1.1. Adding, Removing, and Hiding Worksheets
        • 5.1.2. Naming and Rearranging Worksheets
        • 5.1.3. Grouping Sheets
          • 5.1.3.1. Moving, copying, deleting, or hiding grouped worksheets
          • 5.1.3.2. Formatting cells, columns, and rows in grouped worksheets
          • 5.1.3.3. Entering data or changing cells in grouped worksheets
          • 5.1.3.4. Cutting, copying, and pasting cells in grouped worksheets
          • 5.1.3.5. Adjusting printing and display options in grouped worksheets
        • 5.1.4. Moving Worksheets from One Workbook to Another
      • 5.2. Find and Replace
        • 5.2.1. The Basic Find
        • 5.2.2. More Advanced Searches
        • 5.2.3. Finding Formatted Cells
        • 5.2.4. Finding and Replacing Values
      • 5.3. Spell Check
        • 5.3.1. Spell Checking Options
    • 6. Viewing and Printing Worksheets
      • 6.1. Controlling Your View
        • 6.1.1. Zooming
        • 6.1.2. Viewing Distant Parts of a Spreadsheet at Once
        • 6.1.3. Freezing Columns or Rows
        • 6.1.4. Hiding Data
        • 6.1.5. Saving View Settings
        • 6.1.6. Viewing Multiple Workbooks at Once
      • 6.2. Printing
        • 6.2.1. How to Print an Excel File
        • 6.2.2. Customizing Print Settings
          • 6.2.2.1. Page settings
          • 6.2.2.2. Margins settings
          • 6.2.2.3. Creating headers and footers
          • 6.2.2.4. Sheet settings
        • 6.2.3. Getting a Print Snapshot
        • 6.2.4. Page Break Preview: A Birds-Eye View of Your Worksheet
  • II. Formulas and Functions
    • 7. Building Basic Formulas
      • 7.1. Creating a Basic Formula
        • 7.1.1. Excel's Order of Operations
        • 7.1.2. Cell References
        • 7.1.3. How Excel Formats Cells that Contain Cell References
        • 7.1.4. Functions
        • 7.1.5. Specifying Cell Ranges
        • 7.1.6. Formula Errors
        • 7.1.7. Logical Operators
      • 7.2. Formula Shortcuts
        • 7.2.1. Point-and-Click Formula Creation
        • 7.2.2. Point-and-Click Formula Editing
        • 7.2.3. Using the Insert Function Button to Quickly Find and Use Functions
        • 7.2.4. The Analysis ToolPak
      • 7.3. Copying Formulas
        • 7.3.1. Absolute Cell References
        • 7.3.2. Partial Fixed References
        • 7.3.3. Referring to Other Worksheets and Workbooks
    • 8. Math and Statistical Functions
      • 8.1. Rounding Numbers
        • 8.1.1. ROUND( ), ROUNDDOWN( ), ROUNDUP( ): Rounding Numbers
        • 8.1.2. MROUND( ), CEILING( ), and FLOOR( ): More Rounding Functions
        • 8.1.3. INT( ) and TRUNC( ): Chopping Off Non-Whole Numbers
        • 8.1.4. EVEN( ) and ODD( ): Rounding Up to Even or Odd Values
      • 8.2. Groups of Numbers
        • 8.2.1. SUM( ): Summing Up Numbers
        • 8.2.2. COUNT( ), COUNTA( ), and COUNTBLANK( ): Counting Items in a List
        • 8.2.3. MAX( ) and MIN( ): Finding Maximum and Minimum Values
        • 8.2.4. LARGE( ), SMALL( ), and RANK( ): Ranking Your Numbers
        • 8.2.5. AVERAGE( ) and MEDIAN( ): Finding Average or Median Values
        • 8.2.6. MODE( ): Finding Numbers that Frequently Occur in a List
        • 8.2.7. PERCENTILE( ) and PERCENTRANK( ): Advanced Ranking Functions
        • 8.2.8. FREQUENCY( ): Identifying to Which Category a Number Belongs
      • 8.3. General Math Functions
        • 8.3.1. PRODUCT( ), FACT( ), POWER( ), and SQRT( ): Products, Factorials, Powers, and Square Roots
        • 8.3.2. QUOTIENT( ) and MOD( ): Higher Division
        • 8.3.3. ABS( ) and SIGN( ): Absolute Value and Determining a Number's Sign
        • 8.3.4. RAND( ) and RANDBETWEEN( ): Generating Random Numbers
        • 8.3.5. GCD( ) and LCM( ): Greatest and Least Common Denominator
        • 8.3.6. COMBIN( ) and PERMUT( ): Figuring Combinations and Permutations
      • 8.4. Trigonometry and Advanced Math
      • 8.5. Advanced Statistics
    • 9. Financial Functions
      • 9.1. The World of Finance
      • 9.2. Financial Functions
        • 9.2.1. FV( ): Future Value
        • 9.2.2. PV( ): Present Value
        • 9.2.3. PMT( ), PPMT( ), and IPMT( ): Calculating the Number of Payments You Need to Make
        • 9.2.4. NPER( ): Figuring Out How Much Time You'll Need to Pay Off a Loan or Meet an Investment Target
        • 9.2.5. RATE( ): Figuring the Interest Rate You Need to Achieve Future Value
        • 9.2.6. NPV( ) and IRR( ): Net Present Value and Internal Rate of Return
      • 9.3. Depreciation
      • 9.4. Other Financial Functions
    • 10. Manipulating Dates, Times, and Text
      • 10.1. Manipulating Text
        • 10.1.1. CONCATENATE( ): Joining Strings of Text Together
        • 10.1.2. LEFT( ), MID( ), and RIGHT( ): Copying Portions of a Text String
        • 10.1.3. LEN( ), FIND( ), and SEARCH( ): Counting Characters in a String
        • 10.1.4. UPPER( ), LOWER( ), and PROPER( ): Changing Capitalization
        • 10.1.5. TRIM( ) and CLEAN( ): Removing Unwanted Spaces and Non-Printing Characters
        • 10.1.6. SUBSTITUTE( ): Replacing One Sequence of Characters with Another
        • 10.1.7. TEXT( ), VALUE( ), FIXED( ), and DOLLAR( ): Converting Text to Numbers and Vice Versa
        • 10.1.8. Other Text Functions
      • 10.2. Manipulating Dates and Times
      • 10.3. Math with Dates and Times
      • 10.4. Date and Time Functions
        • 10.4.1. TODAY( ) and NOW( ): Inserting the Current Date and Time
        • 10.4.2. DATE( ) and TIME( ): Dates and Times in Calculations
        • 10.4.3. DAY( ), MONTH( ), and YEAR( ): More Date Calculations
        • 10.4.4. HOUR( ), MINUTE( ), SECOND( ): More Time Calculations
        • 10.4.5. WEEKDAY( ): Determining the Day of the Week
        • 10.4.6. DATEDIF( ): Calculating the Difference Between Dates
        • 10.4.7. DATEVALUE( ) and TIMEVALUE( ): Converting Dates and Times into Serial Numbers
        • 10.4.8. DAYS360( ): Finding Out the Number of Days Between Two Dates
      • 10.5. Analysis ToolPak Date Functions
        • 10.5.1. EDATE( ): Calculating Future Dates
        • 10.5.2. YEARFRAC( ): Calculating the Percentage of a Year Between Two Dates
        • 10.5.3. EOMONTH( )
        • 10.5.4. NETWORKDAYS( ): Counting the Number of Business Days
        • 10.5.5. WORKDAY( ): Figuring Out When Days Will Fall in the Future
        • 10.5.6. WEEKNUM( ): Figuring Out in Which Week a Date Falls
    • 11. Lookup, Reference, and Information Functions
      • 11.1. The Basic Lookup
        • 11.1.1. VLOOKUP( ): Vertical Lookups
        • 11.1.2. HLOOKUP( ): Horizontal Lookups
      • 11.2. Advanced Lookups
        • 11.2.1. MATCH( ): Finding the Position of Items in a Range
        • 11.2.2. INDEX( ): Retrieving the Value from a Cell
        • 11.2.3. Performing a "Left Lookup"
        • 11.2.4. Performing a Double Lookup
        • 11.2.5. The Lookup Wizard
        • 11.2.6. OFFSET( ): Moving Cell References to a New Location
        • 11.2.7. Other Reference and Lookup Functions
        • 11.2.8. INDIRECT( ) and ADDRESS( ): Working with Cell References Stored as Text
        • 11.2.9. TRANSPOSE( ): Changing Rows into Columns and Vice Versa
      • 11.3. Information Functions
        • 11.3.1. The "IS" Functions: Checking the Value Inside a Cell
        • 11.3.2. TYPE( ) and ERROR.TYPE( ): Finding a Value's Data Type or Error Type
        • 11.3.3. INFO( ) and CELL( ): Gathering Info About Your Computer and Your Worksheet's Cells
      • 11.4. Tutorial: Quickly Generating Invoices from a Product Catalog
    • 12. Advanced Formula Writing
      • 12.1. Conditions in Formulas
        • 12.1.1. IF( ): Building Conditional Formulas
        • 12.1.2. COUNTIF( ): Counting Only the Cells You Specify
        • 12.1.3. SUMIF( ): Adding Only the Cells You Specify
        • 12.1.4. SUMPRODUCT( ): Multiplying Two Ranges
      • 12.2. Descriptive Names for Cell References
        • 12.2.1. Creating and Using a Named Range
        • 12.2.2. Managing Named Ranges
        • 12.2.3. Naming Formulas and Constants
        • 12.2.4. Automatically Creating Named Ranges
        • 12.2.5. Applying Names to Existing Formulas
      • 12.3. Variable Data Tables
        • 12.3.1. Creating a One-Variable Data Table
        • 12.3.2. Creating a Two-Variable Data Table
      • 12.4. Controlling Recalculation
      • 12.5. Solving Formula Errors
        • 12.5.1. Step-by-Step Evaluation
        • 12.5.2. Tracing Precedents and Dependents
        • 12.5.3. Error Checking
  • III. Organizing Worksheets
    • 13. Data Lists
      • 13.1. The Basics of Data Lists
        • 13.1.1. Creating a List
        • 13.1.2. Editing a List
      • 13.2. The Data Form
        • 13.2.1. Editing with the Data Form
        • 13.2.2. Searching with the Data Form
        • 13.2.3. Advanced Searching
      • 13.3. Sorting and Filtering a List
        • 13.3.1. Applying a Simple Sort Order
        • 13.3.2. Sorting with Multiple Criteria
        • 13.3.3. Applying an Automatic Filter
        • 13.3.4. Creating a Custom Filter
      • 13.4. Performing List Calculations
        • 13.4.1. Dynamic Calculations
        • 13.4.2. The Total Row
        • 13.4.3. The SUBTOTAL( ) Function
        • 13.4.4. The Database Functions
    • 14. Grouping and Outlining Data
      • 14.1. Basic Data Grouping
        • 14.1.1. Creating a Group
        • 14.1.2. Nesting Groups Within Groups
        • 14.1.3. Summarizing Your Data
        • 14.1.4. Combining Data from Multiple Tables
      • 14.2. Grouping Timesavers
        • 14.2.1. AutoOutline
        • 14.2.2. Automatic Subtotaling
        • 14.2.3. Your Own Custom Grouping Toolbar
    • 15. Templates
      • 15.1. Understanding Templates
      • 15.2. Starting from a Template
        • 15.2.1. Spreadsheet Solutions Templates
        • 15.2.2. Discovering the Finer Points of Templates
        • 15.2.3. Office Online Templates
        • 15.2.4. Searching for Office Online Templates
      • 15.3. Creating Templates
        • 15.3.1. Understanding Custom Templates
        • 15.3.2. Building a Custom Template
        • 15.3.3. Sharing Templates with Others
      • 15.4. Fine-Tuning Templates
        • 15.4.1. Data Validation
          • 15.4.1.1. Settings
          • 15.4.1.2. Input Message
          • 15.4.1.3. Error Alert
        • 15.4.2. Data Validation with Formulas and Cell References
        • 15.4.3. Data Validation with Lists
        • 15.4.4. Locked and Hidden Cells
        • 15.4.5. Protecting the Entire Workbook
  • IV. Charts and Graphics
    • 16. Creating Basic Charts
      • 16.1. Charting 101
        • 16.1.1. Embedded and Standalone Charts
        • 16.1.2. The Chart Wizard
      • 16.2. Basic Tasks with Charts
        • 16.2.1. Moving and Resizing a Chart
        • 16.2.2. Changing Chart Options
        • 16.2.3. Editing and Adding to Chart Data
        • 16.2.4. Printing Charts
          • 16.2.4.1. Embedded charts
          • 16.2.4.2. Standalone charts
      • 16.3. Practical Charting
        • 16.3.1. Charts with Multiple Series of Numbers
        • 16.3.2. Controlling the Data Excel Plots on the X-Axis
        • 16.3.3. Data that Uses a Date or Time Scale
        • 16.3.4. Non-Contiguous Chart Ranges
      • 16.4. Chart Types
        • 16.4.1. Column
        • 16.4.2. Bar
        • 16.4.3. Line
        • 16.4.4. Pie
        • 16.4.5. XY (Scatter)
        • 16.4.6. Area
        • 16.4.7. Donut
        • 16.4.8. Radar
        • 16.4.9. Surface
        • 16.4.10. Bubble
        • 16.4.11. Stock
        • 16.4.12. Cylinder, Cone, and Pyramid
    • 17. Formatting and Perfecting Charts
      • 17.1. Formatting Chart Elements
        • 17.1.1. Manipulating Chart Elements
        • 17.1.2. The Chart Toolbar
        • 17.1.3. Coloring the Background
        • 17.1.4. Fancy Fills
        • 17.1.5. Adding Titles
        • 17.1.6. Adding a Legend
        • 17.1.7. Adding Data Labels to a Series
        • 17.1.8. Adding Individual Data Labels
        • 17.1.9. Formatting Data Series and Data Points
        • 17.1.10. Controlling a Chart's Scale
      • 17.2. Improving Your Charts
        • 17.2.1. Adding a Trendline
        • 17.2.2. Adding Error Bars to Scientific Data
        • 17.2.3. Adding a Data Table
        • 17.2.4. Formatting 3-D Charts
        • 17.2.5. Changing the Order of Your Data Series
        • 17.2.6. Changing the Shape of a 3-D Column
        • 17.2.7. Changing the Way Excel Plots Blank Values
      • 17.3. Advanced Charting
        • 17.3.1. Exploding Slices in a Pie
        • 17.3.2. Grouping Slices in a Pie
        • 17.3.3. Gaps, Widths, and Overlays in a Column Chart
        • 17.3.4. Creating Combination Charts
    • 18. Inserting Graphics
      • 18.1. Adding Pictures to a Worksheet
        • 18.1.1. Inserting a Picture
        • 18.1.2. Positioning and Resizing a Picture
        • 18.1.3. Picture Touch-Up
        • 18.1.4. Compressing Pictures
      • 18.2. Excel's Clip Art Library
      • 18.3. Drawing Shapes
        • 18.3.1. Drawing a Shape
        • 18.3.2. Adding Text to a Shape
        • 18.3.3. Layers
      • 18.4. Drawing Graphic Objects in Charts
  • V. Advanced Data Analysis
    • 19. Scenarios and Goal Seeking
      • 19.1. Using Scenarios
        • 19.1.1. Creating a New Scenario
        • 19.1.2. Managing Scenarios
        • 19.1.3. Creating a Summary Report
      • 19.2. Using Goal Seek
        • 19.2.1. Goal Seeking with Complex Equations
      • 19.3. Solver
        • 19.3.1. Understanding Solver
        • 19.3.2. Defining a Problem in Solver
        • 19.3.3. Advanced Solver Solutions
        • 19.3.4. Saving Solver Models
        • 19.3.5. Configuring Solver
    • 20. Pivot Tables
      • 20.1. Summary Tables Revisited
        • 20.1.1. Life Without Pivot Tables
        • 20.1.2. Life with Pivot Tables
      • 20.2. Building Pivot Tables
        • 20.2.1. Preparing a Pivot Table
        • 20.2.2. Understanding Pivot Table Regions
        • 20.2.3. Laying Out a Pivot Table
        • 20.2.4. Rearranging a Pivot Table
      • 20.3. Advanced Pivot Tables
        • 20.3.1. Creating Multi-Layered Pivot Tables
        • 20.3.2. Hiding and Showing Details
        • 20.3.3. Filtering Pivot Tables
        • 20.3.4. Formatting the Pivot Table
        • 20.3.5. Adding a Calculated Field
        • 20.3.6. Creating Pivot Charts
  • VI. Sharing Data with the Rest of the World
    • 21. Worksheet Collaboration
      • 21.1. Your Excel Identity
      • 21.2. Using Comments
        • 21.2.1. Inserting a Comment
        • 21.2.2. Fine-Tuning Comments
        • 21.2.3. Navigating Comments
        • 21.2.4. Printing Comments
      • 21.3. Using Change Tracking
        • 21.3.1. Switching On Change Tracking
        • 21.3.2. Understanding the Change Log
        • 21.3.3. Highlighting Changes
        • 21.3.4. Examining the Change Log
        • 21.3.5. Accepting and Rejecting Changes
        • 21.3.6. Merging Multiple Revisions into One Workbook
      • 21.4. Setting Up a Review Chain
        • 21.4.1. Sending a Workbook by Email with Excel
        • 21.4.2. Sending a Workbook for Review
        • 21.4.3. Routing a Workbook to Multiple People
      • 21.5. Workbook Sharing
        • 21.5.1. Multiple Users Without Workbook Sharing
        • 21.5.2. Turning On Workbook Sharing
        • 21.5.3. Understanding Workbook Sharing
    • 22. Exchanging Data with Other Programs
      • 22.1. Sharing Information in Windows
      • 22.2. Embedding and Linking Objects
        • 22.2.1. Exporting Charts
        • 22.2.2. Editing an Embedded Object
        • 22.2.3. Editing a Linked Object
        • 22.2.4. Importing Objects
      • 22.3. Transferring Data
        • 22.3.1. Exporting Tables of Data
        • 22.3.2. Importing Tables of Data
        • 22.3.3. Importing Text Files
      • 22.4. Excel and Databases
        • 22.4.1. Defining a Data Source
        • 22.4.2. Querying a Data Source
    • 23. XML
      • 23.1. XML 101
        • 23.1.1. What Is XML, Really?
        • 23.1.2. Three Rules of XML
          • 23.1.2.1. The prolog
          • 23.1.2.2. Elements
          • 23.1.2.3. Nesting
        • 23.1.3. XML Files and Schemas
      • 23.2. The Excel XML Story
      • 23.3. Linking Spreadsheets to XML
        • 23.3.1. Mapping a Simple Document
        • 23.3.2. Importing and Exporting XML
        • 23.3.3. Mapping Lists
        • 23.3.4. Gaining the Benefits of XML Mapping
    • 24. Connecting Worksheets to the Web
      • 24.1. Putting Worksheets on the Web
        • 24.1.1. Saving and Publishing HTML
        • 24.1.2. Saving a Simple Web Page
        • 24.1.3. Creating an Interactive Web Page
      • 24.2. Performing Web Queries
        • 24.2.1. The Limitations of Web Queries
        • 24.2.2. Creating a Web Query
        • 24.2.3. The Research Taska Web Query Alternative
      • 24.3. Using Hyperlinks
        • 24.3.1. Adding a Hyperlink to a Web Page or Document
        • 24.3.2. Adding a Hyperlink to a Worksheet Location
        • 24.3.3. The HYPERLINK( ) Function: Creating a Link on Your Own
  • VII. Programming Excel
    • 25. Automating Tasks with Macros
      • 25.1. Macros 101
      • 25.2. The Macro Recorder
        • 25.2.1. Relative and Absolute Recording
        • 25.2.2. Where Macros Live
        • 25.2.3. Recording a Macro
        • 25.2.4. Playing a Macro
      • 25.3. Creating Practical Macros
        • 25.3.1. Inserting a Header
        • 25.3.2. Alternating Row Formatting
        • 25.3.3. A Combined Task
        • 25.3.4. Security and Macros
        • 25.3.5. Attaching a Macro to a Toolbar or Menu
        • 25.3.6. Attaching a Macro to a Button Inside a Worksheet
    • 26. Programming Spreadsheets with VBA
      • 26.1. The Visual Basic Editor
        • 26.1.1. The Project Window
        • 26.1.2. Modules and Macros
        • 26.1.3. Finding and Moving Macros
        • 26.1.4. Debugging a Macro
      • 26.2. Understanding Macro Code
        • 26.2.1. The Anatomy of a Macro
        • 26.2.2. Objects 101
        • 26.2.3. Using Properties and Methods
        • 26.2.4. Hunting for Objects
      • 26.3. Exploring the VBA Language
        • 26.3.1. Entering Text in the Current Cell
        • 26.3.2. Moving to Other Cells
        • 26.3.3. Editing Specific Cells
        • 26.3.4. Formatting Cells
        • 26.3.5. Using Variables
        • 26.3.6. Making Decisions
        • 26.3.7. Repeating Actions with a Loop
        • 26.3.8. Creating Custom Functions
  • VII. Appendixes
    • A. Getting Help in Excel
      • A.1. Asking Questions
        • A.1.1. Searching Without the Web in Excel 2003
        • A.1.2. Browsing the Help System
      • A.2. The Office Assistant
      • A.3. Other Help Menu Options
    • B. Customizing Excel
      • B.1. The Customize Dialog Box
        • B.1.1. Managing Toolbars
        • B.1.2. Adding, Removing, and Rearranging Commands
        • B.1.3. Using Special Commands
        • B.1.4. Returning to Normal
        • B.1.5. Attaching Toolbars to a Workbook
    • C. Quick Menu Reference
      • C.1. File Menu
        • C.1.1. New
        • C.1.2. Open
        • C.1.3. Close
        • C.1.4. Save
        • C.1.5. Save As
        • C.1.6. Save as Web Page
        • C.1.7. Save Workspace
        • C.1.8. File Search
        • C.1.9. Permission
        • C.1.10. Web Page Preview
        • C.1.11. Page Setup
        • C.1.12. Print Area
        • C.1.13. Print Preview
        • C.1.14. Print
        • C.1.15. Send To
        • C.1.16. Properties
        • C.1.17. Exit
      • C.2. Edit Menu
        • C.2.1. Undo
        • C.2.2. Repeat
        • C.2.3. Cut
        • C.2.4. Copy
        • C.2.5. Office Clipboard
        • C.2.6. Paste
        • C.2.7. Paste Special
        • C.2.8. Paste as Hyperlink
        • C.2.9. Fill
        • C.2.10. Clear
        • C.2.11. Delete
        • C.2.12. Delete Sheet
        • C.2.13. Move or Copy Sheet
        • C.2.14. Find
        • C.2.15. Replace
        • C.2.16. Go To
        • C.2.17. Links
        • C.2.18. Object
      • C.3. View Menu
        • C.3.1. Normal
        • C.3.2. Page Break Preview
        • C.3.3. Task Pane
        • C.3.4. Toolbars
        • C.3.5. Formula Bar
        • C.3.6. Status Bar
        • C.3.7. Header and Footer
        • C.3.8. Comments
        • C.3.9. Custom Views
        • C.3.10. Full Screen
        • C.3.11. Zoom
      • C.4. Insert Menu
        • C.4.1. Cells
        • C.4.2. Rows
        • C.4.3. Columns
        • C.4.4. Worksheet
        • C.4.5. Chart
        • C.4.6. Symbol
        • C.4.7. Page Break
        • C.4.8. Function
        • C.4.9. Name
        • C.4.10. Comment
        • C.4.11. Picture
        • C.4.12. Diagram
        • C.4.13. Object
        • C.4.14. Hyperlink
      • C.5. Format Menu
        • C.5.1. Cells
        • C.5.2. Row
        • C.5.3. Column
        • C.5.4. Sheet
        • C.5.5. AutoFormat
        • C.5.6. Conditional Formatting
        • C.5.7. Style
      • C.6. Tools Menu
        • C.6.1. Spelling
        • C.6.2. Research
        • C.6.3. Error Checking
        • C.6.4. Speech
        • C.6.5. Shared Workspace
        • C.6.6. Share Workbook
        • C.6.7. Track Changes
        • C.6.8. Compare and Merge Workbooks
        • C.6.9. Protection
        • C.6.10. Online Collaboration
        • C.6.11. Goal Seek
        • C.6.12. Scenarios
        • C.6.13. Formula Auditing
        • C.6.14. Solver
        • C.6.15. Macro
        • C.6.16. Add-Ins
        • C.6.17. AutoCorrect Options
        • C.6.18. Customize
        • C.6.19. Options
        • C.6.20. Data Analysis
      • C.7. Data Menu
        • C.7.1. Sort
        • C.7.2. Filter
        • C.7.3. Form
        • C.7.4. Subtotals
        • C.7.5. Validation
        • C.7.6. Table
        • C.7.7. Text to Columns
        • C.7.8. Consolidate
        • C.7.9. Group and Outline
        • C.7.10. PivotTable and PivotChart Report
        • C.7.11. Import External Data
        • C.7.12. List
        • C.7.13. XML
        • C.7.14. Refresh Data
      • C.8. Chart Menu
        • C.8.1. Chart Type
        • C.8.2. Source Data
        • C.8.3. Chart Options
        • C.8.4. Location
        • C.8.5. Add Data
        • C.8.6. Add Trendline
        • C.8.7. 3-D View
      • C.9. Window Menu
        • C.9.1. New Window
        • C.9.2. Arrange
        • C.9.3. Compare Side by Side with
        • C.9.4. Hide
        • C.9.5. Unhide
        • C.9.6. Split
        • C.9.7. Freeze Panes
      • C.10. Help Menu
        • C.10.1. Microsoft Excel Help
        • C.10.2. Show the Office Assistant
        • C.10.3. Microsoft Office Online
        • C.10.4. Contact Us
        • C.10.5. Check for Updates
        • C.10.6. Detect and Repair
        • C.10.7. Activate Product
        • C.10.8. Customer Feedback Options
        • C.10.9. About Microsoft Office Excel
  • Index
  • About the Author
  • Colophon
  • SPECIAL OFFER: Upgrade this ebook with OReilly

pokaż cały spis treści

ukryj recenzje