| Description |
x, 291 pages : illustrations ; 23 cm + 1 computer laser optical disc (4 3/4 in.) |
| Series |
Visual read less, learn more |
|
Visual read less, learn more.
|
| Contents |
Machine derived contents note: How To Use This Book. -- 1. Getting Started With Excel. -- Excel Data Analysis Options. -- Excel Data Types. -- Locate a Value in a Worksheet. -- Select a Range of Cells. -- Name a Range. -- Create Label Ranges. -- Modify Named Ranges. -- Copy and Paste a Range of Cells. -- Create a Custom Number Format. -- Apply AutoFormat to a Worksheet. -- Create a Named Style. -- Create a Custom Template. -- Protect Worksheets. -- 2. Organize Worksheet Data. -- Create a List. -- Add a Series to a List. -- Sort a List. -- Create a Custom Sort. -- Consolidate Data. -- Outline Your Data. -- 3. Evaluate Worksheet Data. -- Apply Conditional Formatting. -- Summarize Data with Subtotals. -- Filter a List. -- Create a Custom Filter. -- Create an Advanced Filter. -- Create Scenarios. -- Validate Data. -- 4. Creating Formulas. -- Sum Cells with the AutoSum Button. -- Add a Function via the Insert Function Dialog Box. -- Edit Formulas. -- Evaluate a Formula. -- Using Solver to Produce Specific Values. -- Create a Conditional Formula. -- Solve a Formula with a Data Table. -- Trace a Formula Error. -- Lookup a Value in a Specific Row and Column. -- Determine the Location of a Value. -- Return a Value at a Specific Location in a Data List. -- Rank a Value within a Data List. -- Create an Amortization Table for a Loan. -- 5. Working With External Data. -- Link Data to Other Windows Programs. -- Import a Delimited Text File. -- Divide a Column into Multiple Columns. -- Create a Web Query. -- Import a Database Table. -- Using Queries to Screen External Databases. -- Find the Average of a Database Range. -- Save for Web. -- 6. Chart Data. -- Chart Basics. -- Modify a Chart Type. -- Explode Slices of a Pie Chart. -- Create a Custom Chart Type. -- Add a Trendline to a Chart. -- Add or Change New Data to a Chart. -- Create a Chart with Multiple Chart Types. -- 7. Working With Pivottable Reports. -- PivotTable Basics. -- A View of the PivotTable Report Fields. -- Create a PivotTable Report from an Excel List. -- Change the Layout of a PivotTable. -- Filter a Field. -- Change the Calculation of a Data Field. -- Group PivotTable Data Items. -- Add Another Data Area Calculation. -- Add a Calculated Field. -- Add a Calculated Item. -- Retrieve a Value from a PivotTable Report. -- 8. Creating Pivotcharts. -- Create a PivotChart from an External Database. -- Change the Layout of a PivotChart. -- Change the Chart Type of a PivotChart. -- Filter a PivotChart Field. -- Group Items in a PivotChart Field. -- Add a Data Table to a PivotChart. -- 9. Automating Actions With Macros. -- An Introduction to Macros. -- Record a Macro. -- Run a Macro. -- Activate the Visual Basic Editor. -- Create a Macro Using the Visual Basic Editor. -- Update a Recorded Macro. -- Set Macro Security. -- Create a Custom Function. -- Declare a Variable. -- Execute a Task a Specific Number of Times. -- Display a Message Box. -- Request User Input for a Macro. -- Assign a Macro to a Menu. -- Run a Macro As a Workbook Opens. -- Using an Excel Function in a Macro. -- 10. Using Forms And Dialog Boxes. -- An Introduction to Forms. -- The Forms Toolbar. -- VBA Dialog Box Basics. -- Add a Form Control to a Worksheet. -- Specify Values for a Form Control. -- Customize Form Controls with Macros. -- Create a Custom Dialog Box. -- Call a Custom Dialog Box from a Macro. -- Capture Input from a Custom Dialog Box. -- Validate Input from a Dialog Box. -- 11. Using The Analysis Toolpack Add-Ins. -- Install Excel Add-ins. -- Using the Conditional Sum Wizard. -- Analysis of Variance for Lists of Values (ANOVA). -- Find the Correlation between Two Sets of Data. -- Determine the Covariance of Two Sets of Data. -- Calculate Descriptive Statistics. -- Compare the Variances in Two Groups of Data. -- Calculate a Moving Average. -- Determine Rank and Percentile. -- Appendix A: Excel Keyboard Shortcuts. -- Excel Keyboard Shortcuts. -- Appendix B: Excel Function Quick Reference. -- Excel Function Quick Reference. -- Appendix C: Vba And Excel Events Quick Reference. -- VBA and Excel Events Quick Reference. -- Appendix D: Formula Basics In Excel. -- Formula Basics in Excel. -- Appendix E: What'S On The Cd-Rom. -- What?s on the CD-ROM. -- Using the E-Version of This Book. -- Wiley Publishing, Inc. End-User License Agreement. -- Index |
| Notes |
Includes index |
|
Systems requirements for accompanying CD-ROM: Microsoft Windows 98, ME, NT 4.0, 1000, or XP installed, as well as Microsoft Excel 2000 or 2002 |
| SUBJECT |
Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
|
| Subject |
Business -- Computer programs.
|
|
Electronic spreadsheets.
|
| LC no. |
2005924603 |
| ISBN |
0764597809 |
|
9780764597800 (paperback: alk. paper) |
|
