The Art of the Spreadsheet: Writing, editing, and auditing

by John F. Raffensperger

Is your spreadsheet turning into the Great Bowl of Linguini? Are you worried that your model has errors, but your model is hard to check? Do you have to audit someone else’s spreadsheet, but don’t know where to start? Maybe you just need to write a personal budget and explain it to your future self. If you’re a careful thinker but a beginner with Excel, this book will help you organize a spreadsheet using writing and algebra skills that you already know. The Art of the Spreadsheet will teach you how to consolidate sheets, align blocks of related information, and edit away useless material. If you’re an expert or developer with Excel and you want some fresh ideas, this book will help you think about spreadsheets in a new way. The Art of the Spreadsheet will help you bring visual immediacy back to your spreadsheets, show you how to help your reader see your logic, and give you new auditing tools. The Art of the Spreadsheet draws on classical timeless ideas with profound consequences for how we write spreadsheets. Using rules from writing text, basic algebra, and good graphics, The Art of the Spreadsheet will show you how to organize your spreadsheet, how to edit away unneeded material from our spreadsheets, and how to format it professionally. Whether you’re writing a personal budget or creating an engineering simulation, get your copy and learn how to make your spreadsheets better.

192 pages, Paperback

Published May 3, 2023