What Every Engineer Should Know about Excel

ISBN-13: 9781138035300 / Angielski / Miękka / 2017 / 229 str.

J. P. Holman; Blake K. Holman

Opis

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.

Spis treści

Introduction. Miscellaneous Operations in Excel and Word. Charts and Graphs. Line Drawings, Embedded Objects, Equations and Symbols in Excel. Solution of Equations. Other Operations. Financial Functions and Calculations. Optimization Problems. Pivot Tables. Data Management Resources in Excel. Office 365 and Integration with Cloud Resources. References. Index

O autorze

Blake Holman is Chief Information Officer at St. David’s Foundation in Austin, TX. Blake joined the Foundation in 2015 and is responsible for strategic and operational Information Technology (IT) activities, enhancing the Foundation’s ability to be efficient and effective in fulfilling its mission. Prior to St. David’s Foundation, Blake spent 10 years as the Chief Information Officer of Ryan, LLC, the largest independent Tax Consulting Firm in the world. Blake has over 25 years of experience leading Information Technology Strategy, Development and Operations for several public and private companies in the Consulting, Telecommunications and Financial Services industries.

Blake holds a Bachelor of Science degree in Mechanical Engineering from Southern Methodist University, and a Strategic IT Management Certificate from the Scandinavian International Management Institute in Copenhagen, Denmark. Blake is currently working on a Master of Science degree in Information Security and Assurance at Western Governor’s University.

In 2011 and 2012, under Blake's leadership, Ryan, LLC was ranked in the InformationWeek 500 listing of the most innovative business technology companies in the United States. In 2011, Ryan was ranked 130th, and in 2012, Ryan's ranking rose to 98th. In both cases, Ryan was the highest ranked corporate tax services firm on the list. In December 2012, Blake was named by Computerworld magazine as one of its 2013 "Premier 100 IT Leaders." The Computerworld Premier 100 IT recognition is an international lifetime award that shines a spotlight on technology.