From the 1979 invention by two MIT students of the visible calculator to the war between Lotus and Microsoft for dominance in the spreadsheet market, this book is a fascinating look at the software application that helped spur the entire computer industry. This loving look back at the early computer and technology evolution will teach anyone interested in computer history about the MIT students, Bricklin and Frankston, and their unique vision; how Mitch Kapor and Lotus 1-2-3 trumped VisiCalc; how the spreadsheet gave businesses a reason to buy PCs; and how Microsoft came to dominate the market. The book also contains descriptions of 25 amazing spreadsheets that users can download from the book's web site.
What other reviewers say about ?Spreadsheet Check and Control??It is excellent. I am embarrassed when I think of the shortcuts I generally take with spreadsheets and I have often paid the price. I think it will become, and it should be, required reading for all young trainee accountants.? Ciaran Walsh, senior finance specialist, Irish Management Institute.?It's super. I kept saying to myself, ?Wow, I didn't know you could do that.? A great job.? Ray Panko, the most cited authority on spreadsheet error, University of Hawai?I.?Spreadsheet Check and Control does what no other book before has attempted to do; provide standards for designing spreadsheets that lend themselves to a logical review by management and internal auditors. Following this author?s guide and insight can help your organization minimize spreadsheet errors and facilitate audit review to prevent and detect those errors.? Jim Kaplan, AuditNet.org.?I thought I knew a lot about Excel, but in the course of teaching me to be Excel-careful, O'Beirne taught me some new tricks and methods that both helped me build better financial models and track down errors.? Simon Benninga, author of Financial Modeling, MIT Press 2000 and Principles of Finance with Excel, Oxford University Press, 2005.'Save red faces all round by buying, absorbing and passing-on this book, especially if you personally develop spreadsheets or if your organization is subject to Sarbanes Oxley and related regulations. Avoiding even a trivial spreadsheet mistake may well pay for the book. Avoiding a large one may save your career.' Dr. Gary Hinson, independent consultant in information security and computer auditing, editor of security awareness website NoticeBored.com.'Probably one of the most important spreadsheet books ever written. Your customers and boss will be delighted with the increased usability, accuracy and reliability his techniques encourage. Be aware that the pages are packed with useful and usable advice, so the 200 pages is probably equivalent to 500 pages in many other books.' Simon Murphy, Codematic.net, author of XLAnalyst.'An essential guide for serious spreadsheet users. This book goes a long way to help spreadsheet users adopt methods that will reduce errors and thereby improve the quality of the information vital to the success of all organisations.' P M Cleary, University of Wales Institute Cardiff, Wales'This is an excellent, easy to follow book containing the key practices that will arm the novice and self taught spreadsheet user so they can create well designed, reliable and error free spreadsheets.' CPA Ireland magazine review'Minimizing or eliminating spreadsheet errors is Patrick O'Beirne's focus in this visual 200-page book, which is geared toward software testers, business managers, or auditors sleuthing for fraud'. CA Magazine (Canada) review Summary of contents
The book and accompanying disk use the capabilities of electronic spreasheet programs to provide 19 spreadsheet models that can be used for a wide range of urban and regional analysis and planning applications. The models have been developed for Lotus 1-2-3, Version 1.00, for the IBM personal computer and compatible systems and can be adapted for use with other spreadsheet programs.
Third edition of this popular, easy-to-use textbook, updated for the revised Spreadsheet Methods Level 5 module [5N1977], which details fundamental spreadsheet methods and facilitates practical experience in spreadsheet design and implementation. New to this edition: Updated for the revised Spreadsheet Methods module [5N1977] and Excel 2010 (all assignments can be completed using Excel 2007) Includes new interactive assignments allowing students to test their spreadsheets. Details how to create formulas and functions, sort spreadsheet data, present data using a variety of charts, protect spreadsheets from unauthorised access and automate decision-making with IF functions. Presents in-depth explanations of spreadsheet concepts and of the different types of IF functions. Introduces useful Excel keyboard shortcuts in each chapter, with all images reflecting Microsoft's Ribbon system. Comprehensively deals with Excel's charting facility and introduces the use of macros and spreadsheet protection. Worked examples guide the learner through each task, while progress tests and chapter reviews support a 'learning through practice' approach. With no previous experience in spreadsheets required, the learner is brought from the basics to an advanced level. Written for: Spreadsheet Methods Level 5 module [5N1977]
Advanced Excel Essentials is the only book for experienced Excel developers who want to channel their skills into building spreadsheet applications and dashboards. This book starts from the assumption that you are well-versed in Excel and builds on your skills to take them to an advanced level. It provides the building blocks of advanced development and then takes you through the development of your own advanced spreadsheet application. For the seasoned analyst, accountant, financial professional, management consultant, or engineer—this is the book you’ve been waiting for! Author Jordan Goldmeier builds on a foundation of industry best practices, bringing his own forward-thinking approach to Excel and rich real-world experience, to distill a unique blend of advanced essentials. Among other topics, he covers advanced formula concepts like array formulas and Boolean logic and provides insight into better code and formulas development. He supports that insight by showing you how to build correctly with hands-on examples.
In this book, the authors build on RExcel, a free add-in for Excel that can be downloaded from the R distribution network. RExcel seamlessly integrates the entire set of R's statistical and graphical methods into Excel, allowing students to focus on statistical methods and concepts and minimizing the distraction of learning a new programming language.
This is the first edition of a textbook written for a community college introductory course in spreadsheets utilizing Microsoft Excel; second edition available: https://openoregon.pressbooks.pub/beginningexcel19/. While the figures shown utilize Excel 2016, 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.
Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions—including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources. Get familiar with Worksheet design Find out how to work with charts and graphics Use Excel for data management, analysis, modeling, and visualization Make sense of macros and VBA If you’re a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy!
