What Every Engineer Should Know About Excel, 2nd Edition

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.

Table of 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