This open book was written for a community college introductory course in spreadsheets utilizing Microsoft Excel. While the figures shown utilize Excel 2019, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and is appropriate for students in any major who have not used Excel before. This textbook includes instructions for Excel for Mac also.
This open book is licensed under a Creative Commons License (CC BY). You can download Beginning Excel 2019 ebook for free in PDF format (28.4 MB).
Table of Contents
Formulas, Functions, Logical and Lookup Functions
Presenting Data with Charts
Multiple Sheet Files
Beginning Excel 2019
This book walks through all the most important and useful Excel functionalities that will advance your career in financial services. From logical functions such as IFERROR to calculating the yield of a bond, CFI's Excel book provides you with numerous examples and key shortcuts! We hope you find this book useful in reaching your future goals....
This book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-c...
The Excel VBA Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
This book presents a general multi-objective optimization framework for optimizing chemical processes by implementing a link between process simulators and metaheuristic techniques. The proposed approach is general and shows how to implement links between different process simulators such as Aspen Plus, HYSIS, Super Pro Designer linked to a variety...
EPPlus is a .NET library that reads and writes Excel files using the Office Open XML format (xlsx). It is an unofficial and free .NET EPPlus book created for educational purposes. All the content is extracted from Stack Overflow Documentation, which is written by many hardworking individuals at Stack Overflow....
This book examines the much-debated question of how to unleash the potential of young people with promising intellectual abilities and motivation. It looks at the increasingly important topic of excellence in education, and the shift in focus towards the provision of programs to support talented students in higher education. It provides a systemati...