1138306142
What Every Engineer Should Know About Excel,Second Edition
by 作者: J. P. Holman - Blake K. Holman
ISBN-10 书号: 1138306142
ISBN-13 书号: 9781138306141
Edition 版本: 2
Publisher Finelybook 出版日期: 2017-10-30
Pages: 192
Book Description
The update reflects the latest version of the software which includes; two new chapters and an extension of chapter one. The first chapter includes an introduction to the Ribbon Bar Navigation prevalent in Microsoft products beginning with the 2007 version of MS Office. A new chapter covers data management capabilities,including connectivity from MS Excel to external databases,organization of data,sorting,filtering and data lookup across worksheets using functions like VLOOKUP and HLOOKUP. The second new chapter covers Office 365 and integration with cloud resources. While aimed at engineers and scientists,the book is also relevant for professionals in IT,finance,and real estate.
Contents
Chapter 1. Introduction
Chapter 2. Miscellaneous Operations in Excel and Word
Chapter 3. Charts and Graphs
Chapter 4. Line Drawings,Embedded Objects,Equations,and Symbols in Excel
Chapter 5. Solution of Equations
Chapter 6. Other Operations
Chapter 7. Financial Functions and Calculations
Chapter 8. Optimization Problems
Chapter 9. Pivot Tables
Chapter 10. Data Management Resources in Excel
Chapter 11. Office 365 and Integration with Cloud Resources