Books.by / Holy Macro! Books

40 Best Excel Features

Excel At 40 - Color Edition

by Bill Jelen

About The Book

Discover the 40 Best Excel Tips—From AutoSum to AI Copilot—in One Fun, Insightful Guide!

Celebrate four decades of the world’s most powerful spreadsheet tool with Excel At 40, a playful yet practical tribute to Microsoft Excel. Whether you're a longtime power user or just spreadsheet-curious, this book delivers 40 of Excel’s most game-changing features—each explained with expert tips, fan stories, insider interviews, and even a few Excel-themed jokes and puzzles.

Explore timeless tools like PivotTables, Freeze Panes, and Goal Seek, then dive into cutting-edge updates like Copilot, Dynamic Arrays, and Python integration. Each chapter breaks down one essential Excel feature in a way that's easy to understand and immediately useful—perfect for analysts, students, entrepreneurs, or anyone who loves working smarter with data.

Inside you'll find:

Step-by-step tips for mastering Excel's most powerful functions

Real-life stories from Excel fans and insiders

Excel jokes and puzzles to test your spreadsheet wit

A unique mix of nostalgia and forward-thinking tools

Whether you're looking to sharpen your skills or enjoy the legacy of Excel in a whole new way, Excel At 40 is your ultimate guide to everything that makes Excel amazing.

Level up your spreadsheets—one tip at a time!

Holy Macro! Books

Books on Microsoft Excel, Power Query, Power BI, ChatGPT by Excel MVPs.

Holy Macro! Books is a niche publishing company dedicated to empowering Excel users worldwide with expert-level guides on Microsoft Excel, Power Query, Power BI, and more. Founded by Excel legend Bill Jelen, the company features books authored by Microsoft MVPs, former MVPs, and top industry experts who know their way around formulas, pivot tables, and data transformations. Whether you're a beginner or a power user, Holy Macro! delivers practical, straight-to-the-point content that turns spreadsheet struggles into spreadsheet superpowers.

More Books by Holy Macro! Books

Train Your Own GPT

How to Train ChatGPT to Think Like You

by Bill Jelen

Train Your GPT is a hands-on, no-code guide to creating AI assistants that actually work the way you do. Whether you're a content creator, consultant, or spreadsheet nerd, you'll learn how to train ChatGPT to follow your style, use your files, and save you serious time — all without needing to know a single line of code.

MrExcel 2025 - Full Color Edition

Navigating Excel

by Bill Jelen

The Transformative Magic of M Code in Power Query and Power BI

A beginners guide to mastering the art of Data Metamorphosis to Get Just the Data Structure Needed to Create Insightful Data Analysis Solutions

by Mike “excelisfun” Girvin

Programming Excel with Office Scripts

Straight to the Point

by Eduardo N. Sanchez

Unlock the Power of TypeScript to Automate Excel in the Modern Era

Visual Basic for Applications isn’t the only game in town anymore. With Programming Excel with Office Scripts: Straight to the Point, Eduardo N. Sanchez cuts through the noise and gives you a fast-paced, example-packed guide to automating Excel using Office Scripts and TypeScript.

Whether you're new to scripting or transitioning from VBA, this book shows you how to manipulate ranges, build pivot tables, generate charts, insert shapes, and even trigger scripts from Power Automate—all through clear, concise TypeScript examples.

You'll explore:

The essentials of TypeScript for Excel scripting

Advanced range, table, chart, and shape manipulation

Integration with Power Automate to build hands-free workflows

Real-world scripts, complete with visuals and step-by-step guidance

Perfect for Excel pros, analysts, and developers looking to modernize their automation toolkit, this book delivers exactly what the title promises: straight to the point.