Chapter 1: Introduction
Getting the Most from Microsoft Excel
Conventions
Introduction to the Microsoft Office Ribbon Bar
Outline of Contents
Chapter 2: Miscellaneous Operations in Excel and Word
Introduction
Generating a Screen Shot
Custom Keyboard Setup for Symbols in Word or Excel
Viewing or Printing Column and Row Headings and Gridlines in Excel
Miscellaneous Useful Tips and Shortcuts
Moving Objects in Small Increments (Nudging)
Formatting Objects in Word, Including Wrapping
Formatting Objects in Excel
Copying Formulas by Dragging the Fill Handle
Copying Cell Formulas: Effect of Relative and Absolute Addresses
Shortcut for Changing the Status of Cell Addresses
Switching and Copying Columns or Rows, and Changing Rows to Columns or Columns to Rows
Built-In Functions in Excel
Creating Single-Variable Tables
Create Two-Variable Tables
Problems
Chapter 3: Charts and Graphs
Introduction
Moving Dialog Windows
Excel Choices of x-y Scatter Charts
Selecting and Adding Data for x-y Scatter Charts
Changing / Replacing Data for Charts
Adding Data to Charts
Adding Trend Lines and Correlation Equations to Scatter Charts
Equation for R2
Correlation of Experimental Data with Power Relation
Use of Logarithmic Scales
Correlation with Exponential Functions
Use of Different Scatter Graphs for the Same Data
Plot of a Function of Two Variables with Different Chart Types
Plots of Two Variables with and without Separate Scales
Charts Used for Calculation Purposes or G&A Format
Stretching out a Chart
Calculation and Graphing of Moving Averages
Bar and Column Charts
Chart Format and Cosmetics
Surface Charts
An Exercise in 3-D Visualization
Problems
Chapter 4: Line Drawings, Embedded Objects, Equations and Symbols in Excel
Introduction
Constructing, Moving and Inserting Straight Line Drawings
Drawing Line Segments in Precise Angular Increments
Inserting Equation Templates and Symbolsusing Excel and Word
Symbol Insertion
Equation Template Insertion
Inserting Equations and Symbols in Excel using Equation Editor
Construction of Line Drawings from Plotted Coordinates
Problems
Chapter 5: Solution of Equations
Introduction
Solutions to Nonlinear Equations Using Goal Seek
Solutions to Nonlinear Equations Using Solver
Iterative Solutions to Simultaneous Linear Equations
Solutions of Simultaneous Linear Equations Using Matrix Inversion
Error Messages
Solutions of Simultaneous Nonlinear Equations Using Solver
Solver Results Dialog Box
Comparison of Methods for Solution of Simultaneous Linear Equations
Copying Cell Equations for Repetitive Calculations
Creating and Running Macros
Problems
Chapter 6: Other Operations
Introduction
Numerical Evaluation of Integrals
Use of Logical IF Statement
Histograms and Cumulative Frequency Distributions
Normal Error Distributions
Calculation of Uncertainty Propagation in Experimental Results
Fractional Uncertainties for Product Functions of Primary Variables
Multivariable Linear Regression
Multivariable Exponential Regression
Problems
Chapter 7: Financial Functions and Calculations
Introduction
Nomenclature
Compound Interest Formulas
Investment Accumulation with Increasing Annual Payments
Payout at Variable Rates from an Initial Investment
Problems
Chapter 8: Optimization Problems
Introduction
Graphical Examples of Linear and Nonlinear Optimization Problems
Solutions Using Solver
Solver Answer Reports for Examples
Nomenclature for Sensitivity Reports
Nomenclature for Answer Reports
Nomenclature for Limits Reports
Problems
Chapter 9: Pivot Tables
Introduction
Other Summary Functions for Data Fields
Restrictions on Pivot Table Formulas
Calculating and Charting Single or Multiple Functions (x) vs. x Using Pivot Tables
Working around Charting Limitations of Excel 2016 - Scatter Charts
Calculation and Plotting Functions of Two Variables
Problems
Chapter 10: Data Management Resources in Excel
Introduction
Organizing Data in Excel Worksheets and Tables
Filtering, Sorting and Use of Subtotals
Filtering
Sorting
Subtotals
Useful Data Functions in Excel
Connecting Excel to External Data
General Concepts
Connecting to MS Access
Connecting to MS SQL Server
Connecting to MySQL
Connecting to Other Data Sources
Microsoft Power Query
Problems
Chapter 11: Office 365 and Integration with Cloud Resources
Introduction
What is Office 365
Leveraging Excel on Premise and in the Cloud
Integrating Excel with Cloud Resources
Microsoft Azure
Amazon Web Services
Excel and Microsoft Power BI
References
Index
