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

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

Excel All-in-One For Dummies

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
Excel All-in-One For Dummies by Greg Harvey and Paul McFedries is a comprehensive guide designed to help users master all aspects of Excel. It covers essential topics for absolute beginners, like spreadsheet basics and formulas, as well as advanced functions such as data analysis, charting, and macros. This book aims to provide a user-friendly approach, making it accessible and useful for anyone looking to enhance their Excel skills in a practical manner.
Read More
Format: Paperback / softback
$7800
Elsewhere:
$8599
AVAILABLE WITH SUPPLIER Ships from our Auckland warehouse within 3-4 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?

You might enjoy this book if you are looking to master Microsoft Excel, whether you're a beginner or someone seeking to expand your spreadsheet skills. This comprehensive guide covers everything from basic functions to advanced data analysis, making it an excellent resource for enhancing your productivity and proficiency in computing and technology.

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
Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel

Microsoft Excel offers unsurpassed functionality and accessibility for data exploration and analysis to millions of users around the world. Learning to unlock its full potential is easier than you can imagine with help from Excel All-in-One For Dummies.

Follow along with Excel expert and veteran author Paul McFedries as he walks you through every feature and technique you need to know to get the most out of this powerful software. You'll learn how to design worksheets, use formulas and functions, collaborate with colleagues and review their work, create charts and graphics, manage and analyse data, and create macros. Plus, you'll discover all the capabilities Microsoft has included in the newest versions of Excel, including dark mode and accessibility features.

This indispensable reference allows you to:

  • Get a firm grasp of Excel basics with the book's step-by-step guides before moving on to more advanced topics, like data analysis.
  • Access up-to-date information on all the new versions of Excel, including the ones bundled with Microsoft 365, Office 2021, and the LTSC/Enterprise Edition.
  • Enjoy the convenience of a single, comprehensive resource detailing everything you need to know about Excel.

Perfect for people coming to Excel for the very first time, Excel All-in-One For Dummies, Office 2021 Edition is also a must-read resource for anyone looking for a refresher on foundational or advanced Excel techniques.

Book Details

INFORMATION

ISBN: 9781119830726

Publisher: John Wiley & Sons Inc

Format: Paperback / softback

Date Published: 03 March 2022

Country: United States

Imprint: For Dummies

Audience: Professional and scholarly

DIMENSIONS

Spine width: 46.0mm

Width: 188.0mm

Height: 234.0mm

Weight: 1089g

Pages: 784

About the Author

Paul McFedries has written over 100 books with topics ranging from Windows 10 to Microsoft Office, Apple gadgets, and Amazon Alexa. His most recent For Dummies titles include Google’s G Suite, Cord Cutting, and Excel Data Analysis.

Greg Harvey, PhD was author of over 30 For Dummies titles covering Excel.

Also by Greg Harvey

View all
  • Excel 2010 For Dummies
    The bestselling Excel book on the market, updated for Excel 2010 As the world's leading spreadsheet application, Excel has a huge user base. The release of Office 2010 brings major changes to Excel, so Excel For Dummies comes to the rescue once more! In the friendly and non-threatening For Dummies style, this popular guide shows beginners how to get up...
    Paperback
    $4799
    Available
    Ships in 3-4 weeks
  • Adobe Acrobat 6 PDF For Dummies
    Share, review, print, and edit documents with Acrobat 6 PDFs. Let others view your documents accurately, even without the software that created them. When you get right down to it, PDF files are about bringing us all together. And this friendly book is about how to convert documents, distill files, make edits, extract elements, archive, and share your creations with...
    Paperback
    $5600
    Available
    Ships in 2-3 weeks
  • Excel 2016 All-in-One For Dummies
    Your one-stop guide to all things Excel 2016 Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros...
    Paperback
    $7599
    Available
    Ships in 3-4 weeks
  • Excel 2019 All-in-One For Dummies
    Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one! It is completely updated to reflect the major changes Microsoft has made to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad...
    Paperback
    $7599
    Available
    Ships in 3-4 weeks
  • Excel Workbook For Dummies
    Get practical walkthroughs for the most useful Excel features Looking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for. This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your...
    Paperback
    $6299
    Available
    Ships in 3-4 weeks
  • The Origins of Tolkien's Middle-earth For Dummies
    Demystifies key players, their relationships, and their motivations. Understand the mythology, characters, and themes of Middle-earth. Don't know Gollum from Gandalf? This plain-English guide helps you make sense of the creatures, language, geography, and richly detailed history of the fascinating world of Middle-earth. From the Shire to Mount Doom, from the hobbits to the Ringwraiths, you'll discover the varied sources...
    Paperback
    $4399
    Available
    Ships in 3-4 weeks
  • Excel 2010 All-in-One For Dummies
    A comprehensive, up-to-date, user-friendly guide to Excel 2010 Excel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyse data with Excel, and much more. Eight minibooks address Excel basics, worksheet design,...
    Paperback
    $8000
    Available
    Ships in 2-3 weeks
  • Excel 2019 For Dummies
    The bestselling Excel book on the market β€” now in a new edition covering the latest version of Excel! Excel is the spreadsheet and data analysis tool of choice for people across the globe who utilise the Microsoft Office suite to make their work and personal lives easier. It is estimated that 1 in 7 people on the planet use...
    Paperback
    Sold Out
  • Excel 2016 For Dummies
    Let your Excel skills soar to new heights with this bestselling guide. Updated to reflect the latest changes to the Microsoft Office suite, this new edition of Excel 2016 For Dummies quickly and painlessly gets you up to speed on mastering the world's most widely used spreadsheet tool. Written by bestselling author Greg Harvey, it has been completely revised and...
    Paperback
    Sold Out

Also by Paul McFedries

View all
  • 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
  • Alexa For Dummies
    Make your every wish Alexa’s command with this in-depth guide to the wildly popular Amazon smart speaker You might be thinking, β€œAll I have to do is plug in my Echo device and start using it!” And you’d be right. But if you really want to explore what that compact little device can do, then Alexa For Dummies is your...
    Paperback
    $5000
    Elsewhere:
    $5299
    Available
    Ships in 3-4 weeks
  • Amazon Fire TV For Dummies
    Enjoy more entertainment with this friendly user guide to making the most of Amazon Fire TV! Find and watch more of the shows you enjoy with Amazon Fire TV For Dummies. This book guides you through Fire TV connections and setup and then shows you how to get the most out of your device. This guide is the convenient way...
    Paperback
    $5300
    Available
    Ships in 2-3 weeks
  • Data Analytics & Visualization All-in-One For Dummies
    Install data analytics into your brain with this comprehensive introduction Data Analytics & Visualization All-in-One For Dummies collects the essential information on mining, organising, and communicating data, all in one place. Clocking in at around 850 pages, this tome of a reference delivers eight books in one, so you can build a solid foundation of knowledge in data wrangling. Data...
    Paperback
    $9499
    Available
    Ships in 3-4 weeks
  • Excel Data Analysis For Dummies
    Turn jumbles of numbers into graphics, insights, and answers with Excel With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualising, and analysing data. PivotTables, charts, what-if analysis, statistical functionsβ€”it's all in here, with examples and ideas for Excel...
    Paperback
    $7999
    Available
    Ships in 3-4 weeks
  • Excel Workbook For Dummies
    Get practical walkthroughs for the most useful Excel features Looking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for. This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your...
    Paperback
    $6299
    Available
    Ships in 3-4 weeks
  • Google Workspace For Dummies
    Easy advice for getting the most out of Google Workspace for school, work, or personal use Google Workspace For Dummies is here to show you the tips and tricks for upping your productivity with Google's cloud-based software suite. This book includes jargon-free instructions on using Gmail, Calendar, Docs, Sheets, Drive, Chat, and Meet. You'll learn about the AI features, updated...
    Paperback
    $6699
    Available
    Ships in 3-4 weeks
  • G Suite For Dummies
    Get fast answers to your G Suite questions with this friendly resource G Suite For Dummies is the fun guide to the productivity suite that’s quickly winning over professional and personal users. This book shares the steps on how to collaborate in the cloud, create documents and spreadsheets, build presentations, and connect with chat or video. Written in the easy-to-follow...
    Paperback
    $6699
    Available
    Ships in 3-4 weeks
  • HTML & CSS Essentials For Dummies
    The easy way to brush up on your HTML & CSS programming skills HTML & CSS Essentials For Dummies is your quick and handy reference to all the core concepts of HTML & CSSβ€”the must-know markup and style languages that make the internet go. This no-nonsense book gets right to the point, eliminating review material, wordy explanations, and fluff. Understand...
    Paperback
    $3199
    Available
    Ships in 3-4 weeks
  • HTML, CSS, & JavaScript All-in-One For Dummies
    A thorough and helpful reference for aspiring website builders Looking to start an exciting new career in front-end web building and design? Or maybe you just want to develop a new skill and create websites for fun. Whatever your reasons, it’s never been easier to start learning how to build websites from scratch than with help from HTML, CSS, &...
    Paperback
    $7599
    Available
    Ships in 3-4 weeks
  • iPad and iPad Pro For Dummies
    Help for newcomers to Apple’s popular tablet computer Fully updated to cover the latest version of iPadOS and all the newest features, iPad & iPad Pro For Dummies is your fun, full-colour guide to the most popular tablet on the market. There are a lot of things you can do with an iPadβ€”browse the internet, take photos and videos, manage...
    Paperback
    $5699
    Available
    Ships in 3-4 weeks
  • Java Essentials For Dummies
    Swiftly brush up on the foundations of Java programming Java Essentials For Dummies is a reliable and succinct reference on the core components of Javaβ€”the multifaceted general-purpose language used for desktop, mobile, and web applications. This straightforward book gets right to the point, eliminating review material and wordy explanations, so you get what you need, fast. Strengthen your understanding of...
    Paperback
    $3199
    In Stock
    Ships tomorrow

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 tomorrow
  • 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 tomorrow
  • 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 tomorrow
  • 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 tomorrow
  • 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 tomorrow
  • 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 tomorrow
  • 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 tomorrow
  • 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 tomorrow
  • 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 tomorrow
  • 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 tomorrow
  • 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 tomorrow
  • 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 tomorrow

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.