101 Ready-to-Use Excel FormulasThis is the sort of book that is well worth its space on the bookshelf. I recall using several of the formulas in this guide, but it has been long enough that most of them have slipped my mind. There are many interesting formulas that are new to me as well. This thin book is filled with practical excel formulas, presented in a concise manner. Introductory notes of sorts will precede a formula, with an explanation of how it works to follow. There are several alternatives offered, where applicable.
Early chapters provide formula fundamentals, and progressively move into more intricate formulas further in. There are basic formulas for totals, complex formulas that refer to other worksheets, lookup formulas, string concatenation formulas, conditional formulas, and all sorts of fun things to have within reach.
Excel Data Analysis: Modeling and Simulation
Microsoft Excel 2013 - CompleteIntroduce your students to the latest that Microsoft Office has to offer with the new generation of Shelly Cashman Series books! For the past three decades, the Shelly Cashman Series has effectively introduced computer skills to millions of students. With Microsoft Excel 2013, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In this text you'll find features that are specifically designed to engage students, improve retention, and prepare them for future success. Our trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of Microsoft Excel 2013 through experimentation, critical thought, and personalization. With these enhancements and more, the Shelly Cashman Series continues to deliver the most effective educational materials for you and your students.
Advanced Excel Essentials
* Covers advanced formula topics like array formulas and Boolean logic
* Shows you how to build correctly with hands-on examples
* Provides insight into better code and formulas development
* Builds on a foundation of industry best practices and the author's hard won real-world experience