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

Overnight NZ-wide delivery on in-stock orders πŸš€

MrExcel 2022

Boosting Excel
Book Hero Magic crafted this summary to help describe this book. While it's new and still learning, it may not be perfect - your feedback is welcome! Summary
MrExcel 2022 offers inspiring Excel tips designed to save users up to 100 hours per year. Originally crafted for Bill Jelen's live Power Excel seminars, this book targets users who work with Excel extensively, around 40 hours per week. It reveals "aha" moments by uncovering secret methods in Excel, covering core functions, pivot tables, and essential formulas like VLOOKUP and the new XLOOKUP. Readers will also learn modern tools such as the Power Pivot Data Model and data cleaning with Power Query. The 2022 edition includes updates on collaboration features, LET and LAMBDA functions, new data types, and dynamic array formulas.
Read More
Format: Paperback / softback
$7499
AVAILABLE WITH SUPPLIER Ships from our Auckland warehouse within 4-6 weeks

Found a better price? Request a price match

Book Hero Magic created this recommendation. While it's new and still learning, it may not be perfect - your feedback is welcome! IS THIS YOUR NEXT READ?

This book is ideal for experienced Excel users seeking to enhance efficiency and master advanced features in Excel 2022. It's perfect for professionals working extensively with data analysis and looking to deepen their Excel knowledge.

Book Hero thinking about your next read

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

Inspiring Excel tips designed to save 100 hours per year.

Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel.

The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query.

Updated annually, this edition for 2022 adds information on collaboration features, LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.

MrExcel 2022 is a valuable resource for anyone looking to maximise their efficiency and capability within Excel.

Book Details

INFORMATION

ISBN: 9781615470778

Publisher: Holy Macro! Books

Format: Paperback / softback

Date Published: 01 September 2022

Country: United States

Imprint: Holy Macro! Books

Edition: Sixth edition

Illustration: Illustrations

Audience: General / adult

DIMENSIONS

Spine width: 15.0mm

Width: 209.0mm

Height: 273.0mm

Weight: 680g

Pages: 298

About the Author

Bill Jelenis the host of www.MrExcel.com, a Microsoft MVP, and the author of 65 books about Excel. He lives in Merritt Island, Florida.

Also by Bill Jelen

View all
  • MrExcel 2025
    Excel tips to skyrocket white-collar productivity. Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as XLOOKUP. It introduces elements of modern Excel such as the Power...
    Paperback
    $7499
    Available
    Ships in 4-6 weeks
  • MrExcel 23
    Excel tips to skyrocket white-collar productivity. Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel...
    Paperback
    $7499
    Available
    Ships in 4-6 weeks

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
  • New Release
    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
  • 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
  • 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
  • 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
    $3200
    Elsewhere:
    $4000
    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
  • The Infinity Machine
    A revelatory portrait of the visionary behind Google DeepMind, the race to control the future - and what it means to win. Even in a tech world crowded with visionary leaders, Demis Hassabis is recognised as a special case. Born to working-class, immigrant parents in North London, a chess prodigy by five and wizard coder in his teens, he turned...
    Paperback
    $3499
    Elsewhere:
    $4500
    In Stock
    Ships today
  • 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
    $3400
    Elsewhere:
    $4000
    In Stock
    Ships today
  • The 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
    $2400
    Elsewhere:
    $2799
    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
    $3200
    Elsewhere:
    $3999
    (4)
    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
  • Don’t Burn Anyone at the Stake Today
    An electrifying, thought-provoking exploration of how the digital era is reshaping our world, by bestselling, Women's Prize-winning writer Naomi Alderman. What's the most useful thing you could know about your own life? In this era-defining book, developed from her groundbreaking Radio 4 essay series, Naomi Alderman turns her boundless curiosity and incisive thinking to a question that affects us allβ€”how...
    Hardback
    $3500
    Elsewhere:
    $4500
    (1)
    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.