Lýsing:
Understanding the powerful computational and graphics capabilities of Microsoft Excel is an enormous benefit to engineers and technical professionals in almost any field and at all levels of experience. What Every Engineer Should Know About Excel is a practical guide to unlocking the features and functions of this program, using examples and screenshots to walk readers through the steps to build a strong understanding of the material.
This second edition is updated to reflect the latest version of Excel (2016) and expands its scope to include data management, connectivity to external data sources, and integration with "the cloud" for optimal use of the Excel product. It also introduces the ribbon bar navigation prevalent in Microsoft products beginning with the 2007 version of MS Office. Covering a variety of topics in self-contained chapters, this handy guide will also prove useful for professionals in IT, finance, and real estate.
Annað
- Höfundar: J. P. Holman, Blake K. Holman
- Útgáfa:2
- Útgáfudagur: 12-10-2017
- Hægt að prenta út 2 bls.
- Hægt að afrita 2 bls.
- Format:ePub
- ISBN 13: 9781351976473
- Print ISBN: 9781138035300
- ISBN 10: 1351976478
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
UM RAFBÆKUR Á HEIMKAUP.IS
Bókahillan þín er þitt svæði og þar eru bækurnar þínar geymdar. Þú kemst í bókahilluna þína hvar og hvenær sem er í tölvu eða snjalltæki. Einfalt og þægilegt!Rafbók til eignar
Rafbók til eignar þarf að hlaða niður á þau tæki sem þú vilt nota innan eins árs frá því bókin er keypt.
Þú kemst í bækurnar hvar sem er
Þú getur nálgast allar raf(skóla)bækurnar þínar á einu augabragði, hvar og hvenær sem er í bókahillunni þinni. Engin taska, enginn kyndill og ekkert vesen (hvað þá yfirvigt).
Auðvelt að fletta og leita
Þú getur flakkað milli síðna og kafla eins og þér hentar best og farið beint í ákveðna kafla úr efnisyfirlitinu. Í leitinni finnur þú orð, kafla eða síður í einum smelli.
Glósur og yfirstrikanir
Þú getur auðkennt textabrot með mismunandi litum og skrifað glósur að vild í rafbókina. Þú getur jafnvel séð glósur og yfirstrikanir hjá bekkjarsystkinum og kennara ef þeir leyfa það. Allt á einum stað.
Hvað viltu sjá? / Þú ræður hvernig síðan lítur út
Þú lagar síðuna að þínum þörfum. Stækkaðu eða minnkaðu myndir og texta með multi-level zoom til að sjá síðuna eins og þér hentar best í þínu námi.
Fleiri góðir kostir
- Þú getur prentað síður úr bókinni (innan þeirra marka sem útgefandinn setur)
- Möguleiki á tengingu við annað stafrænt og gagnvirkt efni, svo sem myndbönd eða spurningar úr efninu
- Auðvelt að afrita og líma efni/texta fyrir t.d. heimaverkefni eða ritgerðir
- Styður tækni sem hjálpar nemendum með sjón- eða heyrnarskerðingu
- Gerð : 208
- Höfundur : 10289
- Útgáfuár : 2017
- Leyfi : 379