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.

Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's® 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® 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

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.

It's a Excel basics book that every civil engineer should have read by now. It addresses skills that may not be covered in most Excel for civil engineering texts, such as step by step guides to create an application program and how to convert the steps into VBA code, how to perform matrix operations (multiplication and inversion) using Excel-VBA, macro for creating an engineering chart, a brief and simple guide to become an instant Excel-VBA programmer, and more... Also to be presented the depiction in AutoCAD program. Yes! AutoCAD is chosen because one of its advantages that relies on high drawing accuracy. You will learn how to create a simple AutoCAD script file using Excel formulas and Excel-VBA. It is expected that you will be able to create simple Cartesian graph in AutoCAD, even you are an AutoCAD first time user! With the ease of working with Excel, coupled with benefit of the given examples in this book, it is expected to increase the interest of the reader to create new original application programs. Thus, each model or even a specific calculation will be an exciting challenge for a programming job is already enjoyable. Happy Excel programming!

For scientists and engineers tired of trying to learn Excel with examples from accounting, this self-paced tutorial is loaded with informative samples from the world of science and engineering. Techniques covered include creating a multifactorial or polynomial trendline, generating random samples with various characteristics, and tips on when to use PEARSON instead of CORREL. Other science- and engineering-related Excel features such as making columns touch each other for a histogram, unlinking a chart from its data, and pivoting tables to create frequency distributions are also covered.

For introductory courses in Engineering and Computing Based on Excel 2007, Engineering with Excel, 3e takes a comprehensive look at using Excel in engineering. This book focuses on applications and is intended to serve as both a textbook and a reference for students.