1
of
1
Microsoft 365 Excel Office Scripts For Dummies
Brief Description
Unlock the full potential of automation in the online version of Excel online with this easy-to-follow guide Microsoft 365 Excel Office Scripts For Dummies, by experienced Microsoft MVP Michael Alexander, explains how to use Office Scripts to unlock VBA-like capabilities in the online version of Excel....
Read More
Format: Paperback / softback
$7800
Unit price
/
Unavailable
AVAILABLE WITH SUPPLIER
Ships from our Auckland warehouse within 3-4 weeks
Found a better price? Request a price match
Microsoft 365 Excel Office Scripts For Dummies
$7800
Unit price
/
Unavailable
Latest News
Romance for Spring - Groundbreaking!
Lizzy is sharing her top picks for Spring reads in the romance and romantasy genre...
The ‘Fourth Wing’ graphic novel covers have been revealed
The covers for ‘Fourth Wing, The Graphic Novel: Volume One’ have officially been revealed, with...
Books about Bookshops (across almost every genre)
Books about books, bookshops, and booksellers - it's my favourite thing. Here's a small selection...
What the Book Hero team is excited for
With so many pre-orders coming in the last few months of the year, we asked...
Meet Reverie Puzzles: Puzzles Made for Book Lovers
Reverie Puzzles have arrived at Book Hero and they might just be the perfect puzzles...
See more
Book Hero Magic formatted this description to make it easier to read. While it's new and
still learning, it may not be perfect - your
feedback is welcome!
Description
Unlock the full potential of automation in the online version of Excel online with this easy-to-follow guide
Microsoft 365 Excel Office Scripts For Dummies, by experienced Microsoft MVP Michael Alexander, explains how to use Office Scripts to unlock VBA-like capabilities in the online version of Excel. Alexander demonstrates exactly how to automate repetitive tasks, streamline workflows, and customize your spreadsheet experience with the same power previously available only to users of Excel’s desktop version.
This comprehensive guide walks you through the practical application of Office Scripts using TypeScript. It walks you through basic automation scripts before moving on to advanced integration features you can access with Power Automate. The author’s hands-on approach helps you master the techniques you need to transform your Excel online experience from repetitive drudgery to automated efficiency, showing you how to maximize your productivity in a huge variety of settings.
Learn how to:
- Master TypeScript fundamentals specifically tailored for Excel automation and scripting
- Automate table formatting, data cleaning, and sorting processes to eliminate repetitive manual work
- Create dynamic charts and enhance PivotTables with custom scripts for professional reporting
- Integrate Power Automate features to build sophisticated workflows across Microsoft 365 applications
- Apply range definitions and advanced scripting techniques for complex data manipulation tasks
Perfect for business professionals, data analysts, and advanced Excel users who work mostly with the online version of Excel and who want to automate their workflows, Microsoft 365 Excel Office Scripts For Dummies is a must-read for everyone interested in managing large datasets, creating regular reports, and streamlining routine tasks.
Book Details
INFORMATION
ISBN: 9781394412693
Publisher: John Wiley & Sons Inc
Format: Paperback / softback
Date Published: 09 July 2026
Country: United States
Imprint: For Dummies
Audience: General / adult
DIMENSIONS
Spine width: 23.0mm
Width: 185.0mm
Height: 231.0mm
Weight: 476g
Pages: 336
About the Author
Michael Alexander is a senior consultant at Slalom Consulting and former Microsoft MVP. He is a recognized Excel trainer and the author of multiple Excel books, including Microsoft Excel 365 Bible and Excel Dashboards & Reports For Dummies. You can find Michael at Exceltopia.com, where he shares articles and training on Excel development.
Also by Michael Alexander
View all-
Beowulf: Popular Penguins
Beowulf tells the story of the heroic Beowulf and of his battles, first with the monster Grendel, then with Grendel's avenging mother, and finally with a dragon that threatens to devastate his homeland. Through its blend of myth and history, Beowulf vividly evokes a twilight world in which men and supernatural forces live side by side.Paperback$1400Elsewhere:$1599Unit price /UnavailableIn StockShips Monday -
Microsoft 365 Excel All-in-One For Dummies
Get into the nitty gritty of Excel, the all-important spreadsheet tool Microsoft 365 Excel All-in-One For Dummies offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organising data and work your way to pro techniques that help with any career field or reason for using the app. Gain the skills to apply...Paperback$8599Unit price /UnavailableAvailableShips in 3-4 weeks -
Excel Dashboards & Reports For Dummies
It’s time for some truly “Excel-lent” spreadsheet reporting Beneath the seemingly endless rows and columns of cells, the latest version of Microsoft Excel boasts an astonishing variety of features and capabilities. But how do you go about tapping into some of that power without spending all of your days becoming a spreadsheet guru? It’s easy. You grab a copy of...Paperback$7599Unit price /UnavailableAvailableShips in 3-4 weeks -
Excel Power Pivot & Power Query For Dummies
Learn to crunch huge amounts of data with PowerPivot and Power Query Do you have a ton of data you need to make sense of? Microsoft’s Excel program can handle amazingly large data sets, but you’ll need to get familiar with PowerPivot and Power Query to get started. And that’s where Dummies comes in. With step-by-step instructions—accompanied by ample screenshots—Excel...Paperback$7599Unit price /UnavailableAvailableShips in 3-4 weeks -
Access 2019 Bible
Master database creation and management Access 2019 Bible is your comprehensive reference to the world's most popular database management tool. With clear guidance covering everything from the basics to advanced topics, this go-to reference helps you take full advantage of what Access 2019 offers. Whether you're new to Access or starting with Access 2019, you'll find everything you need to...Paperback$11099Unit price /UnavailableAvailableShips in 3-4 weeks -
Excel 2016 Power Programming with VBA
Maximise your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all the techniques you need to develop both large and small Excel applications....Paperback$10499Unit price /UnavailableAvailableShips in 3-4 weeks -
Excel 2019 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel...Paperback$11099Unit price /UnavailableAvailableShips in 3-4 weeks -
Excel 2019 Bible
The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version...Paperback$10499Unit price /UnavailableAvailableShips in 3-4 weeks -
Excel Quick and Easy
A fast, up-to-date, and convenient desk reference for Excel users of any skill level Drawn from the most important tasks in the latest bestselling Excel Bible, Excel Quick and Easy is your ticket to data mastery. Excel veterans Michael Alexander and Dick Kusleika distil the most essential and useful tasks you need to understand about the world's most popular spreadsheet...Paperback$3799Unit price /UnavailableAvailableShips in 3-4 weeks -
Microsoft Excel 365 Bible
Your complete guide to Excel 365, written for newbies all the way to seasoned professionals Neatly organised and written using accessible language, Microsoft Excel 365 Bible contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains...Paperback$10499Unit price /UnavailableAvailableShips in 3-4 weeks -
Microsoft Excel 365 Bible
Your personal, hands-on guide to the latest and most useful features in Microsoft Excel 365 Excel 365 is Microsoft’s latest cloud-based version of its world-famous spreadsheet app. Powerful and user-friendly, it’s an ideal solution for businesses and people looking to make sense of—and draw intelligence from—their data. The Excel 365 Bible carries over the best content from the best-selling Excel...PaperbackSold Out
More from Computing & Technology
View all-
Digital Minimalism
Digital Minimalism by Cal Newport presents a revolutionary strategy for optimising your interaction with digital technology in a way that fosters productivity, focus, happiness, and creativity. Most of us recognise that our reliance on texting, Instagram, Facebook, and Twitter is not due to sheer lack of intelligence or depth, but because these platforms truly offer significant value in the form...Paperback$2400Elsewhere:$2600Unit price /UnavailableIn StockShips Monday -
Buy to WinEmpire of AI
An eye-opening account of the tech arms race shaping our planet, from an award-winning journalist and AI insider to the world of Sam Altman and OpenAI. When longtime AI expert and journalist Karen Hao first began covering OpenAI in 2019, she thought they were the good guys. Founded as a nonprofit with safety enshrined as its core mission, it was...Paperback$2899Elsewhere:$3700Unit price /UnavailableIn StockShips Monday -
17% offOpen to Work
‘Open To Work helps you stop fearing the future and start shaping it with purpose.’ Jay Shetty‘An instantly useful guide to futureproofing your career.’ Adam Grant‘Open to Work lays out a smart and clear path to the future of work’ Brené Brown In a world where AI is transforming work at a rapid pace, Open to Work is your essential...Paperback$2500Elsewhere:$3799Unit price /UnavailableIn StockShips Monday -
New Releasekluge
If you and I are in the same ='entertainment venue' for this ='stand-up comedy special' and I am ='my body' and you are ='my audience' I run to you and shout your name into the dark, in the hope you are there. Yes, you='dear reader'='attentive listener'. This is a story about the end days of a tech company and its...Paperback$3299Elsewhere:$3800Unit price /UnavailableIn StockShips Monday -
Careless People
Shocking and darkly funny, Careless People gives you a front-row seat to the decisions that are shaping our world and the people who make them. Welcome to Facebook. Sarah Wynn-Williams, a young diplomat from New Zealand, pitched for her dream job. She saw Facebook's potential and knew it could change the world for the better. But, when she got there...Paperback$2800Unit price /UnavailableIn StockShips Monday -
20% offApple
On April 1, 1976, two scruffy twentysomethings, both named Steve, founded a startup. Their goal: To bring the revolutionary power of computers to everyone. Over the next five decades, Apple reshaped the technology and cultural landscapes, introducing the public to breakthroughs like the mouse, laser printing, CD-ROM, WiFi, digital video, home networking, touchscreen phones, and tablets. Jobs’s obsessive eye for...Hardback$6400Elsewhere:$9000Unit price /UnavailableIn StockShips Monday -
If Anyone Builds It, Everyone Dies
The founder of the field of AI risk explains why superintelligent AI is a global suicide bomb and we must halt development immediately. AI is the greatest threat to our existence that we have ever faced. The technology may be complex but the facts are simple. We are currently on a path to build superintelligent AI. When we do, it...Paperback$3200Elsewhere:$4000Unit price /UnavailableIn StockShips Monday -
New ReleaseThe Reverse Centaur's Guide to Life After AI
Whether you want to criticise, kill, or use AI, you have to get through the hype and uncover the real story. Start with labour: in automation theory, a centaur is a person who chooses to use technology to help them do the things that matter to them. A reverse centaur is a person who has been conscripted to serve as...Paperback$3499Unit price /UnavailableIn StockShips Monday -
17% offThe Bullet Journal Method
The Bullet Journal Method by Ryder Carroll is an indispensable guide to gaining control over your chaotic life using the power of a simple pen and notebook. Whether you're a seasoned planner or a beginner, this book lays out a revolutionary system that provides structure, clarity, and purpose to your everyday activities. It's not just a method of organising your...Paperback$2000Elsewhere:$2799Unit price /UnavailableIn StockShips Monday -
How to Win At Chess
Learn chess from International Master and YouTube's top chess teacher Levy Rozman (aka GothamChess) in this refreshing and fun guide for beginner and intermediate players. How to Win at Chess teaches you everything you need to know about the game, including all the important moves and strategies to start off strong and keep you thinking several steps ahead. Full of...Hardback$4000Elsewhere:$5000Unit price /UnavailableIn StockShips Monday -
Co-Intelligence
From Wharton professor and author of the One Useful Thing Substack, comes an urgent and definitive playbook for working, learning and living in the new age of AI. For fans of Kevin Kelly, Ray Kurzweil, Cal Newport, and Martin Ford. A New York Times Bestseller Co-Intelligence is the very best book I know about the ins, outs, and ethics of...Paperback$3400Elsewhere:$4000Unit price /UnavailableIn StockShips Monday -
18% offLittle Book of Data
Data is not about number crunching. It’s about ideas. And when used properly (read: ethically), it is the problem solver of our time. Yet many savvy people seem to be in data denial: they don’t think they need to understand data, or it’s too complicated, or worse, using it is somehow unethical. As data and AI (just an accelerated way...Paperback$2800Elsewhere:$3799Unit price /UnavailableIn StockShips Monday
Why buy from us?
Book Hero is not a chain store or big box retailer. We're an independent 100% NZ-owned business on a mission to help more Kiwis rediscover a love of books and reading!
Service & Delivery
Our warehouse in Auckland holds over 100,000 books, toys, board games and puzzles in-stock so you're not waiting for your order to arrive from overseas.
Auckland Bookstore
We're primarily an online store, but for your convenience you can pick up your order for free from our bookstore, which is right next door to our warehouse in Hobsonville.
Our Gifting Service
Books make wonderful thoughtful gifts and we're here to help with gift-wrapping and cards. We can even send your gift directly to your loved one.
