Eklas Hossain - Excel Crash Course for Engineers

This Springer imprint is published by the registered company Springer Nature Switzerland AG

The registered company address is: Gewerbestrasse 11, 6330 Cham, Switzerland

Microsoft Excel has become an integral tool for many people. It is used by people in all fields, from students, teachers, researchers to businessmen, finance analytics, and many more. Excel Crash Course for Engineers presents the uses of MS Excel in engineering applications, particularly for electrical engineers. In this book, MS Excel is used in a new manner in the field of engineering, especially in electrical engineering. It demonstrates how a problem can be formulated and solved, how VBA is used, and how data is processed, cleaned, analysed, and visualized. This book is for people in technical fields, students and professionals alike. Its aim is to show the usefulness of Microsoft Excel in solving a wide range of numerical problems. The book contains pictures of the step-by-step implementation of different functions of MS Excel that will help readers understand the concepts.The book is comprised five chapters. Chapter One, Introduction to Microsoft Excel, portrays the basics of MS Excel, starting with its background, purpose, and importance. The basic structure of Excel and its user interface is explained in detail, alongside discussing the basic keywords and terminologies used in Excel. Chapter Two, Graphing and Charting, addresses the numerous types of graphs and charts that can be created in MS Excel, and demonstrates practical examples for each type. Chapter Three, Microsoft Excel Functions and Formulae, clarifies the functions and formulae that Excel provides, and how they can be used to make tasks easier. Chapter Four, Microsoft Excel VBA, describes the creation and use of user-defined functions in Excel. The concepts of Visual Basic for Applications (VBA) and macros are explicitly explained in this chapter. The final chapter is Microsoft Excel in Engineering Data and Analysis, which highlights some very essential features in MS Excel and includes many handy techniques to make Excel more user-friendly. The five chapters neatly summarize the entire concept, usage, and applications of Microsoft Excel.The book has been written with engineers in mind and special focus has been made towards electrical engineers, with several electrical engineering problems being incorporated into the book. The book has been kept very simple and concise, careful not to confuse readers with technical jargon that might confuse readers. The author sincerely believes that Excel for Engineers will turn out to be a good read and a good investment of time and effort.

(M09, SM17) received his PhD from the College of Engineering and Applied Science at the University of Wisconsin Milwaukee (UWM). He received his MS in mechatronics and robotics engineering from the International Islamic University of Malaysia, Malaysia, in 2010 and BS in electrical and electronic engineering from Khulna University of Engineering and Technology, Bangladesh, in 2006. Dr. Hossain has been working in the area of distributed power systems and renewable energy integration for the last 10 years, and he has published a number of research papers and posters in this field. He is now involved with several research projects on renewable energy and grid tied microgrid systems at Oregon Tech as an associate professor in the Department of Electrical Engineering and Renewable Energy since 2015. He is the senior member of the Association of Energy Engineers (AEE). Dr. Hossain is currently serving as an associate editor of IEEE Access. He is working as an associate researcher at Oregon Renewable Energy Center (OREC). Dr. Hossain is a registered professional engineer (PE) in the state of Oregon, USA. He is also a certified energy manager (CEM) and renewable energy professional (REP). His research interests include modelling, analysis, design, and control of power electronic devices; energy storage systems; renewable energy sources; integration of distributed generation systems; microgrid and smart grid applications; robotics; and advanced control system. He is the winner of the Rising Faculty Scholar Award in 2019 from the Oregon Institute of Technology for his outstanding contribution in teaching. Dr. Hossain, with his dedicated research team, is looking forward to exploring methods to make electric power systems more sustainable, cost-effective, and secure through extensive research, and analysis on energy storage, microgrid system and renewable energy sources.