Efnisyfirlit

• Cover
• Half Title
• Title Page
• Copyright Page
• Table of Contents
• Preface to the First Edition
• Preface to the Second Edition
• About the Authors
• 1. Introduction
• 1.1     Getting the Most from Microsoft Excel
• 1.2     Conventions
• 1.3     Introduction to the Microsoft Office Ribbon Bar
• 1.4     Outline of Contents
• 2. Miscellaneous Operations in Excel and Word
• 2.1     Introduction
• 2.2     Generating a Screenshot
• 2.3     Custom Keyboard Setup for Symbols in Word or Excel
• 2.4     Viewing or Printing Column and Row Headings and Gridlines in Excel
• 2.5     Miscellaneous Useful Tips and Shortcuts
• 2.6     Moving Objects in Small Increments (Nudging)
• 2.7     Formatting Objects in Word, Including Wrapping
• 2.8     Formatting Objects in Excel
• 2.9     Copying Formulas by Dragging the Fill Handle
• 2.10   Copying Cell Formulas: Effect of Relative and Absolute Addresses
• 2.11   Shortcut for Changing the Status of Cell Addresses
• 2.12   Switching and Copying Columns or Rows, and Changing Rows to Columns or Columns to Rows
• 2.13   Built-In Functions in Excel
• 2.14   Creating Single-Variable Tables
• 2.15   Creating Two-Variable Tables
• Problems
• 3. Charts and Graphs
• 3.1     Introduction
• 3.2     Moving Dialog Windows
• 3.3     Excel Choices of x–y Scatter Charts
• 3.4     Selecting and Adding Data for x–y Scatter Charts
• 3.5     Changing/Replacing Data for Charts
• 3.6     Adding Data to Charts
• 3.7     Adding Trend Lines and Correlation Equations to Scatter Charts
• 3.8     Equation for R2
• 3.9     Correlation of Experimental Data with Power Relation
• 3.10   Use of Logarithmic Scales
• 3.11   Correlation with Exponential Functions
• 3.12   Use of Different Scatter Graphs for the Same Data
• 3.12.1     Observations
• 3.13   Plot of a Function of Two Variables with Different Chart Types
• 3.13.1     Changes in Gap Width on 3-D Displays
• 3.14   Plots of Two Variables with and without Separate Scales
• 3.15   Charts Used for Calculation Purposes or G&A Format
• 3.15.1     G&A Chart
• 3.16   Stretching Out a Chart
• 3.17   Calculation and Graphing of Moving Averages
• 3.17.1     Standard Error
• 3.18   Bar and Column Charts
• 3.19   Chart Format and Cosmetics
• 3.20   Surface Charts
• 3.21   An Exercise in 3-D Visualization
• Problems
• 4. Line Drawings, Embedded Objects, Equations, and Symbols in Excel
• 4.1     Introduction
• 4.2     Constructing, Moving, and Inserting Straight Line Drawings
• 4.2.1     Drawing Line Segments in Precise Angular Increments
• 4.3     Inserting Equation Templates and Symbols Using Excel and Word
• 4.3.1     Symbol Insertion
• 4.3.2     Equation Template Insertion
• 4.4     Inserting Equations and Symbols in Excel Using Equation Editor
• 4.5     Construction of Line Drawings from Plotted Coordinates
• Problems
• 5. Solution of Equations
• 5.1     Introduction
• 5.2     Solutions to Nonlinear Equations Using Goal Seek
• 5.3     Solutions to Nonlinear Equations Using Solver
• 5.4     Iterative Solutions to Simultaneous Linear Equations
• 5.5     Solutions of Simultaneous Linear Equations Using Matrix Inversion
• 5.5.1     Error Messages
• 5.6     Solutions of Simultaneous Nonlinear Equations Using Solver
• 5.7     Solver Results Dialog Box
• 5.8     Comparison of Methods for Solution of Simultaneous Linear Equations
• 5.9     Copying Cell Equations for Repetitive Calculations
• 5.10   Creating and Running Macros
• Problems
• 6. Other Operations
• 6.1     Introduction
• 6.2     Numerical Evaluation of Integrals
• 6.3     Use of Logical IF Statement
• 6.4     Histograms and Cumulative Frequency Distributions
• 6.5     Normal Error Distributions
• 6.6     Calculation of Uncertainty Propagation in Experimental Results
• 6.7     Fractional Uncertainties for Product Functions of Primary Variables
• 6.8     Multivariable Linear Regression
• 6.9     Multivariable Exponential Regression
• Problems
• 7. Financial Functions and Calculations
• 7.1     Introduction
• 7.2     Nomenclature
• 7.3     Compound Interest Formulas
• 7.4     Investment Accumulation with Increasing Annual Payments
• 7.5     Payout at Variable Rates from an Initial Investment
• Problems
• 8. Optimization Problems
• 8.1     Introduction
• 8.2     Graphical Examples of Linear and Nonlinear Optimization Problems
• 8.3     Solutions Using Solver
• 8.4     Solver Answer Reports for Examples
• 8.5     Nomenclature for Sensitivity Reports
• 8.6     Nomenclature for Answer Reports
• 8.7     Nomenclature for Limits Reports
• Problems
• 9. Pivot Tables
• 9.1     Introduction
• 9.2     Other Summary Functions for Data Fields
• 9.3     Restrictions on Pivot Table Formulas
• 9.4     Calculating and Charting Single or Multiple Functions ∂(x) vs. x Using Pivot Tables
• 9.4.1     Working around Charting Limitations of Excel 2016—Scatter Charts
• 9.5     Calculating and Plotting Functions of Two Variables
• Problems
• 10. Data Management Resources in Excel
• 10.1   Introduction
• 10.2   Organizing Data in Excel Worksheets and Tables
• 10.3   Filtering, Sorting, and Using Subtotals
• 10.3.1     Filtering
• 10.3.2     Sorting
• 10.3.3     Subtotals
• 10.4   Useful Data Functions in Excel
• 10.5   Connecting Excel to External Data
• 10.5.1     General Concepts
• 10.5.2     Connecting to MS Access
• 10.5.3     Connecting to MS SQL Server
• 10.5.4     Connecting to MySQL
• 10.5.5     Connecting to Other Data Sources
• 10.6   Microsoft Power Query
• Problems
• 11. Office 365 and Integration with Cloud Resources
• 11.1   Introduction
• 11.2   What Is Office 365?
• 11.3   Leveraging MS Excel on Premise and in the Cloud
• 11.4   Integrating MS Excel with Cloud Resources
• 11.4.1     Microsoft Azure
• 11.4.2     Amazon Web Services
• 11.5   Excel and Microsoft Power BI
• References
• Index