UID:
almafu_9960074139202883
Umfang:
1 online resource (378 pages)
Ausgabe:
1st ed.
ISBN:
9780128028162
,
0128028165
,
9780128028179
,
0128028173
Anmerkung:
"MVP Microsoft Most Valuable Professional"--Title page.
,
Front Cover -- A Guide to Microsoft® Excel 2013 for Scientists and Engineers -- Copyright -- Contents -- Preface -- Conventions Used in this Book -- Chapter 1: Welcome to Microsoft® Excel 2013 -- Exercise 1: Customizing the QAT -- Exercise 2: Customizing the Ribbon Control -- The Worksheet -- Excel 2013 Specifications and Limits -- Compatibility with Other Versions -- Exercise 3: The Status Bar -- Chapter 2: Basic Operations -- Exercise 1: Simple Arithmetic -- Exercise 2: The Mathematical Operators -- Exercise 3: Formatting (Displayed and Stored Values) -- Exercise 4: Working with Fractions -- Exercise 5: A Practical Worksheet -- Copying Formulas: What Happens to References? -- What's in a Name? -- Exercise 6: Another Practical Example -- Exercise 7: The Evaluate Formula Tool -- Special Symbols, Subscripts, and Superscripts -- Mathematical Limitations of Excel -- Play It Again, Sam -- Chapter 3: Printing in Excel -- Exercise 1: Quick Print and Print Preview -- The Print Preview Dialog -- Exercise 2: The Page Layout Tab -- Exercise 3: Header/Footers and Page Breaks -- Exercise 4: Documentation and Printing Formulas -- Chapter 4: Using Functions -- Exercise 1: The AutoSum Tool -- The Insert Function Command -- Exercise 2: Computing a Weighted Average -- Exercise 3: Entering Formulas by Typing -- Exercise 4: Trigonometry Functions -- Exercise 5: Exponential Functions -- Exercise 6: The Round, Roundup, and Rounddown Functions -- Other Rounding Functions -- Some Other Mathematical Functions -- Array Formulas -- Exercise 7: Matrix Functions -- Volatility: Calculate Mode -- Exercise 8: Solving Systems of Equations -- Financial Functions -- Exercise 9: Borrower Beware -- Chapter 5: Conditional Functions -- Logical Comparison Operators -- Exercise 1: Boolean Functions -- Exercise 2: Practical Example -- The IF Function -- Nested Ifs.
,
IF Formulas with Boolean Functions -- The IFERROR Function -- Exercise 3: Resistors Revisited -- Exercise 4: Quadratic Equation Solver -- Exercise 5: Protecting a Worksheet -- Table Lookup Functions -- Exercise 6: A Simple Lookup -- Exercise 7: A Two-Valued Lookup -- Exercise 8: Conditional Arithmetic -- Exercise 9: Array Formulas -- Exercise10: The SUMPRODUCT function -- Exercise 11: Conditional Formatting -- Chapter 6: Data Mining -- Exercise 1: Importing TXT File -- Exercise 2: Counting and Summing with Criteria -- Exercise 3: FREQUENCY Distribution -- Exercise 4: Pivot Tables -- Exercise 5: Sorting -- Exercise 6: Filtering -- Exercise 7: The Excel Table -- Chapter 7: Charts -- Exercise 1: An XY Chart -- Exercise 2: Plotting Functions -- Changing the Position of Axes Crossing -- Filtering a Chart with Many Data Series -- Finding Roots -- Exercise 3: Adding and Deleting Data Series -- Exercise 4: XY Chart with Two Y-axes -- Exercise 5: Chart with Control Lines -- Exercise 6: Large Numbers and Log Scales -- Exercise 7: Error Bars -- Exercise 8: Plotting Parametric Equations -- Other Chart Types -- Exercise 9: Polar (Radar) Chart -- Exercise 10: Surface Charts -- Exercise 11: Combination Charts -- Exercise 12: Bar Charts -- Plotting Sine Curves -- URLs for Chart Websites -- Chapter 8: Regression Analysis -- Exercise 1: Trendline, Slope, and Intercept -- Exercise 2: Interpolation and Forecast -- Exercise 3: The Linest Function -- Exercise 4: Fixed Intercept -- Exercise 5: Multilinear Regression -- Exercise 6: A Polynomial Fit -- Exercise 7: A Logarithmic Fit (LOGEST) -- Exercise 8: The FORECAST and TREND, and Growth functions -- Residuals -- Exercise 9: Slope and Tangent -- Exercise 10: The Analysis ToolPak -- Chapter 9: VBA User-Defined Functions -- Exercise 1: The Visual Basic Editor -- Syntax of a Function -- Exercise 2: A Simple Function.
,
Naming Functions and Variables -- Worksheet and VBA Functions -- Exercise 3: When Things Go Wrong -- Programming Structures -- Exercise 4: The IF Structure -- Exercise 5: Boolean Operators -- The Select . . . Case Structure -- Exercise 6: Select Example -- The For Next Structure -- The Excel Object Model: An Introduction -- Exercise 7: For EachNext -- Exercise 8: The Do...Loop Structure -- Variables and Data Types -- Input-output of Arrays -- Exercise 9: An Array Function -- Using Functions from Other Workbooks -- Chapter 10: VBA Subroutines -- Exercise 1: Recording a Macro -- Subroutines That Compute -- Notes on the VB Editor -- Exercise 2: A Computing Macro -- Simple algorithm for this macro: -- Comments on the code: -- Name That Variable -- Exercise 3: Bolt Hole Positions -- Exercise 4: Finding Roots by Bisection -- Exercise 5: Using Arrays -- Exercise 6: Adding a Control -- Exercise 7: User Forms -- Chapter 11: Modeling I -- Exercise 1: Population Model -- Exercise 2: Vapor Pressure of Ammonia -- Exercise 3: Stress Analysis -- Exercise 4: Circuit Analysis -- Exercise 5: Ladder Down the Mine -- Exercise 6: Adding Waves -- Exercise 7: Centroid of a Polygon -- Exercise 8: Finding Roots by Iteration -- Chapter 12: Using Solver -- Exercise 1: Goal Seek -- Exercise 2: Solver as a Root Finder -- Solving Equations with Constraints -- Exercise 3: Finding Multiple Roots -- Exercise 4: Systems of Nonlinear Equations -- Exercise 5: Curve Fitting with Solver -- Exercise 6: Gaussian Curve Fit -- Exercise 7: Solver Versus Linearization -- Exercise 8: A Minimization Problem -- Exercise 9: An Optimization Problem -- Chapter 13: Numerical Integration -- Exercise 1: The Trapezoid Rule -- Exercise 2: Simpson's Rule -- Exercise 3: Adding Flexibility -- Exercise 4: Going Modular -- Exercise 5: Tabular Data -- Exercise 6: Gaussian Integration.
,
Exercise 7: Monte Carlo Techniques -- Chapter 14: Differential Equations -- Exercise 1: Euler´s Method -- Exercise 2: The Runge-Kutta Methods -- Exercise 3: Solving with a User-Defined Function -- Simultaneous and Second-Order Differential Equations -- Exercise 4: Solving a Second-Order Equation -- Exercise 5: The Simple Pendulum -- Chapter 15: Modeling II -- Exercise 1: The Four-Bar Crank -- Exercise 2: Temperature Profile Using Matrix Algebra -- Exercise 3: Temperature Profile Using Solver -- Exercise 4: Emptying the Tank -- Exercise 5: An Improved Tank Emptying Model -- Chapter 16: Statistics for Experimenters -- Exercise 1: Descriptive Statistics -- Exercise 2: Frequency Distribution -- Exercise 3: Confidence Limits -- Exercise 4: The Experimental and Expected Mean -- Exercise 5: Pooled Standard Deviation -- Exercise 6: Comparing Paired Arrays -- Exercise7: Comparing Repeated Measurements -- Exercise 8: The Calibration Curve Revisited -- Exercise 9: More on the Calibration Curve -- Appendix: Answers -- Chapter 2 -- Chapter 4 -- Chapter 5 -- Chapter 7 -- Chapter 8 -- Chapter 9 -- Chapter 10 -- Chapter 11 -- Chapter 12 -- Chapter 13 -- Chapter 14 -- Chapter 16 -- Index.
Sprache:
Englisch
Schlagwort(e):
Electronic books.
Bookmarklink
