Excel Crash Course For Engineers

Excel Crash Course for Engineers is a reader-friendly introductory guide to the features, functions, and applications of Microsoft Excel in engineering. The book provides readers with real-world examples and exercises that are directly related to engineering, and offers highly illustrated, step-by-step demonstrations of techniques to solve and visualize engineering problems and situations. The book includes an introduction to MS Excel, along with in-depth coverage of graphing and charting, functions and formulae, Excel's Visual Basic for Applications (VBA) programming language, and engineering data analysis. This powerful tutorial is a great resource for students, engineers, and other busy technical professionals who need to quickly acquire a solid understanding of Excel.

​Machine Learning Crash Course for Engineers is a reader-friendly introductory guide to machine learning algorithms and techniques for students, engineers, and other busy technical professionals. The book focuses on the application aspects of machine learning, progressing from the basics to advanced topics systematically from theory to applications and worked-out Python programming examples. It offers highly illustrated, step-by-step demonstrations that allow readers to implement machine learning models to solve real-world problems. This powerful tutorial is an excellent resource for those who need to acquire a solid foundational understanding of machine learning quickly.

MATLAB and Simulink Crash Course for Engineers is a reader-friendly introductory guide to the features, functions, and applications of MATLAB and Simulink. The book provides readers with real-world examples, exercises, and applications, and offers highly illustrated, step-by-step demonstrations of techniques for the modelling and simulation of complex systems. MATLAB coverage includes vectors and matrices, programs and functions, complex numbers, visualization, solving equations, numerical methods, optimization problems, and graphical user interfaces. The Simulink coverage includes commonly used Simulink blocks, control system simulation, electrical circuit analysis, electric power systems, power electronics, and renewable energy technology. This powerful tutorial is a great resource for students, engineers, and other busy technical professionals who need to quickly acquire a solid understanding of MATLAB and Simulink.

The Sun, Energy, and Climate Change conveys one central idea – that we can utilize energy without continuing to harm the planet by increasing our reliance on energy from the sun. This accessible guide stresses the sun’s importance as our ultimate energy source by focusing on climate change from an energy perspective and explains the naturally balanced energy transfer from the sun to the earth and society’s consumption of this energy. This book is for anyone worried about environmental damage from our reliance on fossil fuels and the global fight against climate change. The key message being we do not have to accept the inevitable and can work to prevent the worst.

This textbook provides students with an introduction to the fundamentals and applications of solar photovoltaic systems, connecting the theory of solar photovoltaics and the practical applications of this very important source of energy. Chapters are written concisely in straightforward language that provides clear explanations of the concepts and principles, with an emphasis on humanitarian applications of photovoltaic systems and a focus on relatively small size systems that will make the book relatable to readers. It begins with an introduction and overview of the fundamentals of solar cell fabrication, module design, and performance along with an evaluation of solar resources. The book then moves on to address the details of individual components of photovoltaic systems, design of off-grid, hybrid, and distributed photovoltaic systems, and grid-tied photovoltaic systems based on the National Electrical Code (NEC). Coverage also includes a techno-economic analysis of solar photovoltaics, a discussion of the challenges and probable solutions of photovoltaic penetration into the utility grid, and an exploration of the potential of photovoltaic systems. Photovoltaic Systems: Fundamentals and Applications is designed to be used as an introductory textbook and professional training manual offering mathematical and conceptual insights that can be used to teach concepts, aid understanding of fundamentals, and act as a guide for sizing and designing practical systems.

Thirty clearly defined lessons take the reader from understanding the parts of an Excel application into building applications to work with data, formulas, charts, and the enhanced XML capabilities of the new Excel "X" Book is designed to teach the core concepts of Excel over a weekend or in just fifteen hours, with each session being thirty minutes Applicable to Excel 2000, Excel 2002, and the latest release, Excel 2003 Helps Excel power users in fields such as accounting, finance, operations management, and market research to begin automating data manipulation in Excel quickly, so they can handle real-world projects A how-to guide to using Excel's programmability to create custom data-processing and analysis solutions Covers security, debugging, and error handling Companion Web site includes sample files, projects, and test enginewith self-assessment exam

A complete tutorial on how to use all version of the excel spreadsheets including 3.0 for specific engineering and scientific functions.

Learn to fully harness the power of Microsoft Excel(r) to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's(r) capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's(r) capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: * Use worksheet functions to work with matrices * Find roots of equations and solve systems of simultaneous equations * Solve ordinary differential equations and partial differential equations * Perform linear and non-linear regression * Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: * All the spreadsheets, charts, and VBA code needed to perform the examples from the text * Solutions to most of the end-of-chapter problems * An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package.