120,000+ Books, Games & Puzzles in-stock πŸ‡³πŸ‡Ώ

Overnight NZ-wide delivery πŸš€ We’ve moved into our new bookstore and warehouse πŸŽ‰

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
AVAILABLE WITH SUPPLIER Ships from our Auckland warehouse within 3-4 weeks

Found a better price? Request a price match

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 customise 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 takes 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 maximise 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
    $1400
    Elsewhere:
    $1599
    In Stock
    Ships today
  • 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
    $8599
    Available
    Ships 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
    $7599
    Available
    Ships 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
    $7599
    Available
    Ships 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
    $11099
    Available
    Ships 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
    $10499
    Available
    Ships 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
    $11099
    Available
    Ships 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
    $10499
    Available
    Ships 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
    $3799
    Available
    Ships 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
    $10499
    Available
    Ships 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...
    Paperback
    Sold 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
    $2400
    Elsewhere:
    $2600
    In Stock
    Ships today
  • Minecraft Annual 2027
    New Release
    Minecraft Annual 2027
    The official Minecraft Annual 2027, full of updates, builds, activities, and more! Discover all there is to know about the past year of Minecraft in this exciting annual. Stuffed to the brim with updates, activities, step-by-step builds, and tips and tricks for the game, this book is a must-have for any minecrafter. This year’s annual includes: Mob guides on happy...
    Hardback
    $1999
    Elsewhere:
    $2499
    In Stock
    Ships today
  • Open 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
    $2999
    Elsewhere:
    $3799
    In Stock
    Ships today
  • 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
    $2800
    In Stock
    Ships today
  • Apple
    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
    $7999
    Elsewhere:
    $9000
    In Stock
    Ships today
  • kluge
    New Release
    kluge
    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
    $3299
    Elsewhere:
    $3800
    (1)
    In Stock
    Ships today
  • Empire 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
    $2899
    Elsewhere:
    $3700
    (1)
    In Stock
    Ships today
  • The Amazing Generation
    A children's version of the global bestseller The Anxious Generation How can we live a happy and exciting life without a smartphone? The Anxious Generation started a world-changing conversation about the effects of smartphones and social media on young people. Now bestselling authors Jonathan Haidt and Catherine Price have teamed up to talk directly to those young people about how...
    Paperback
    $2500
    Elsewhere:
    $3000
    In Stock
    Ships today
  • Pre-order
    End Times Fascism
    A blistering expose of the new far-right apocalyptic alliance that's on the move around the globe - and how we resist. The far right is on the march again - but this time it's different. A new, apocalyptic alliance of religious fundamentalists, billionaire Silicon Valley tech kings and ethno-nationalists is on the move. They're united in their belief that some...
    Paperback
    $3299
    Elsewhere:
    $4000
    Pre-order
    Out 29 Sep 2026
  • New Release
    Digital Freedom
    Australia's favourite parenting author joins forces with a top online safety expert to give Australian parents the tools to understand and manage their kids' and teens' use of screens. When it comes to children and screens, parents and educators face a genuine contradiction: so much of modern life happens online, yet it's also one of the leading causes of harm...
    Paperback
    $3199
    Elsewhere:
    $4000
    In Stock
    Ships today
  • On Sale
    13% off
    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
    $2800
    Elsewhere:
    $4000
    In Stock
    Ships today
  • Little 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
    $3400
    Elsewhere:
    $3799
    In Stock
    Ships today

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

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

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

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.