ABSTRACT

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.

chapter 1|4 pages

Introduction

chapter 2|22 pages

Miscellaneous Operations in Excel and Word

chapter 3|32 pages

Charts and Graphs

chapter 5|30 pages

Solution of Equations

chapter 6|42 pages

Other Operations

chapter 7|12 pages

Financial Functions and Calculations

chapter 8|15 pages

Optimization Problems

chapter 9|24 pages

Pivot Tables

chapter 10|20 pages

Data Management Resources in Excel