What Every Engineer Should Know About Excel

The book reflects the latest version of Excel and introduces Ribbon Bar Navigation. It features 2 new chapters on data management capabilities (connectivity to external databases, organization of data, sorting, filtering and data lookup across worksheets using functions like VLOOKUP and HLOOKUP) and Office 365 and integration with cloud resources.

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.