1
of
1
Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
Series: Tech Today
Brief Description
Get more out of your data with step-by-step tutorials for the Excel features you need to know. Excel remains the most popular tool for organising and analysing data, and today's professionals are expected to have a high degree of fluency with it. Complex Excel tools such...
Read More
Format: Paperback / softback
$9499
Unit price
/
Unavailable
AVAILABLE WITH SUPPLIER
Ships from our Auckland warehouse within 3-4 weeks
Found a better price? Request a price match
Getting Great Results with Excel Pivot Tables, PowerQuery and Power...
$9499
Unit price
/
Unavailable
Latest News
Movie Review on Paw Patrol: The Dino Movie
Let’s get one thing straight: I didn’t walk into this expecting a cinematic masterpiece. But...
A Puzzle for Every Season: Why I Love Seasonal Puzzles
From spooky Halloween puzzles to floral spring scenes and Christmas favourites we bring out every...
The Book Briefing - September 16th
This week there are so many exciting new book announcements out and about with covers,...
Every crime/thriller Novel Lizzy has read this year (so far!)
Lizzy is sharing her crime and thriller reads for 2026 so far and giving you...
New Releases to add to your TBR this week (16th September)
We had some exciting new releases arrive with some huge names in fiction, a highly...
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
Get more out of your data with step-by-step tutorials for the Excel features you need to know.
Excel remains the most popular tool for organising and analysing data, and today's professionals are expected to have a high degree of fluency with it. Complex Excel tools such as Pivot Tables, PowerQuery, and PowerPivot can help you manage and report on data the way you need to. Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot offers a fresh look at how these tools can help you. Author and Microsoft Certified Trainer Thomas Fragale breaks down the topics into easy-to-use steps and screenshots, so you can put your advanced Excel skills into practice right away.
Using Pivot Tables, PowerQuery, and PowerPivot, you can import, sort, transform, summarise, and present your data, all without needing to be a programmer. This book takes the technical jargon out of using these features, so you can perform your job more efficiently, bring value to your teams, and advance your career. The plain-English instructions inside will help anyone learn to get quick, meaningful results from their data, without having a degree in computing.
- Get easy-to-understand walkthroughs for analysing data and creating dashboards in Microsoft Excel.
- Learn how to organise data in Excel and use advanced features to find patterns and insights.
- Summarise any kind of data faster and easier, leaving you more time for other tasks.
- Turn raw numbers into new knowledge, reports, and charts that inform coworkers and customers.
This book is ideal for anyone with vast amounts of raw data needing to make sense of it. Managers, salespeople, finance professionals, and marketers—along with anyone else dealing with large amounts of data—will appreciate this quick and easy guide to Pivot Tables, PowerQuery, and PowerPivot.
Series: Tech Today
View all-
Securing Cloud Containers
A practical and up-to-date roadmap to securing cloud containers on AWS, GCP, and Azure Securing Cloud Containers: Building and Running Secure Cloud-Native Applications is a hands-on guide that shows you how to secure containerised applications and cloud infrastructure, including Kubernetes. The authors address the most common obstacles and pain points that security professionals, DevOps engineers, and IT architects encounter in...Paperback$11999Unit price /UnavailableAvailableShips in 3-4 weeks -
Microsoft Copilot Studio Quick Start
A practical and accessible guide to Microsoft's Copilot Studio In Microsoft Copilot Studio Quick Start, author Jared Matfess delivers an easy-to-read and hands-on guide to navigating Microsoft's newest generative AI platform. From introductions to the Copilot ecosystem and Copilot Studio to building your first custom agent, publishing it across different environments, and measuring its results so you can optimise its...Paperback$11499Unit price /UnavailableAvailableShips in 3-4 weeks -
Running Windows Server 2025 on Microsoft Azure
Architect, migrate, and manage Windows Server on Azure In Running Windows Server 2025 on Microsoft Azure, 5-time Microsoft MVP, William Panek, walks you through the migration of business-critical Windows Server workloads to Azure while ensuring hybrid cloud agility and advanced security. You'll learn how to extend on-premises deployments of Windows Server to the Azure cloud using hybrid services that offer...Paperback$10499Unit price /UnavailableAvailableShips in 3-4 weeks -
Data Engineering for Beginners
A hands-on technical and industry roadmap for aspiring data engineers In Data Engineering for Beginners, big data expert Chisom Nwokwu delivers a beginner-friendly handbook for everyone interested in the fundamentals of data engineering. Whether you're interested in starting a rewarding, new career as a data analyst, data engineer, or data scientist, or seeking to expand your skillset in an existing...Paperback$11499Unit price /UnavailableAvailableShips in 3-4 weeks -
Using Amazon Bedrock
A from-scratch roadmap to building generative AI solutions on AWS with Amazon Bedrock In Using Amazon Bedrock: Learn to Architect, Secure and Optimize Generative AI Applications on AWS, accomplished Software Engineer, developer advocate, and AWS Community Builder, Renaldi Gondosubroto delivers an in-depth walkthrough of Amazon Bedrock, the keystone generative AI service on the Amazon Web Services cloud. Gondosubroto offers a...Paperback$11499Unit price /UnavailableAvailableShips in 3-4 weeks -
A Beginner's Guide To Web Application Penetration Testing
A hands-on, beginner-friendly intro to web application pentesting In A Beginner's Guide to Web Application Penetration Testing, seasoned cybersecurity veteran Ali Abdollahi delivers a startlingly insightful and up-to-date exploration of web app pentesting. In the book, Ali takes a dual approach—emphasising both theory and practical skills—equipping you to jumpstart a new career in web application security. You'll learn about common...Paperback$9499Unit price /UnavailableAvailableShips in 3-4 weeks -
Beginning Power BI for Business Users
Discover the utility of your organisation’s data with Microsoft Power BI In Beginning Power BI for Business Users: Learning to Turn Data into Insights, accomplished data professional and business intelligence expert Paul Fuller delivers an intuitive and accessible handbook for professionals seeking to use Microsoft’s Power BI to access, analyse, understand, report, and act on the data available to their...Paperback$10499Unit price /UnavailableAvailableShips in 3-4 weeks -
Enterprise AI in the Cloud
Embrace emerging AI trends and integrate your operations with cutting-edge solutions Enterprise AI in the Cloud: A Practical Guide to Deploying End-to-End Machine Learning and ChatGPT Solutions is an indispensable resource for professionals and companies who want to bring new AI technologies like generative AI, ChatGPT, and machine learning (ML) into their suite of cloud-based solutions. If you want to...Paperback$11499Unit price /UnavailableAvailableShips in 3-4 weeks -
GenAI on AWS
The definitive guide to leveraging AWS for generative AI GenAI on AWS: A Practical Approach to Building Generative AI Applications on AWS is an essential guide for anyone looking to dive into the world of generative AI with the power of Amazon Web Services (AWS). Crafted by a team of experienced cloud and software engineers, this book offers a direct...Paperback$11499Unit price /UnavailableAvailableShips in 3-4 weeks -
Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
Get more out of your data with step-by-step tutorials for the Excel features you need to know. Excel remains the most popular tool for organising and analysing data, and today's professionals are expected to have a high degree of fluency with it. Complex Excel tools such as Pivot Tables, PowerQuery, and PowerPivot can help you manage and report on data...Paperback$9499Unit price /UnavailableAvailableShips in 3-4 weeks -
Large Language Model-Based Solutions
Learn to build cost-effective apps using Large Language Models In Large Language Model-Based Solutions: How to Deliver Value with Cost-Effective Generative AI Applications, Principal Data Scientist at Amazon Web Services, Shreyas Subramanian delivers a practical guide for developers and data scientists who wish to build and deploy cost-effective large language model (LLM)-based solutions. In the book, you'll find coverage of...Paperback$9499Unit price /UnavailableAvailableShips in 3-4 weeks -
Microsoft 365 Copilot At Work
Learn to leverage Microsoft's new AI tool, Copilot, for enhanced productivity at work. In Microsoft 365 Copilot At Work: Using AI to Get the Most from Your Business Data and Favourite Apps, a team of software and AI experts delivers a comprehensive guide to unlocking the full potential of Microsoft's groundbreaking AI tool, Copilot. Written for people new to AI,...Paperback$11499Unit price /UnavailableAvailableShips in 3-4 weeks
Book Details
INFORMATION
ISBN: 9781394243051
Publisher: John Wiley & Sons Inc
Format: Paperback / softback
Date Published: 29 April 2024
Country: United States
Imprint: John Wiley & Sons Inc
Audience: Professional and scholarly
DIMENSIONS
Spine width: 18.0mm
Width: 185.0mm
Height: 234.0mm
Weight: 431g
Pages: 304
About the Author
THOMAS FRAGALE has four decades of professional experience in computing. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. He has trained over 50,000 people in online webinars, public seminars, and on-site training. Fragale’s passion is helping people get the most out of their computers. He has also taught at Fordham University.
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 today -
New ReleaseMinecraft 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$1999Elsewhere:$2499Unit price /UnavailableIn StockShips 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$2999Elsewhere:$3799Unit price /UnavailableIn StockShips today -
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 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$2899Elsewhere:$3700Unit price /UnavailableIn StockShips 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$7999Elsewhere:$9000Unit price /UnavailableIn StockShips 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$2800Unit price /UnavailableIn StockShips today -
Pre-orderEnd 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$3299Elsewhere:$4000Unit price /UnavailableOut 29 Sep 2026Pre-order -
18% offCo-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$2800Elsewhere:$4000Unit price /UnavailableIn StockShips today -
13% offIf 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$2800Elsewhere:$4000Unit price /UnavailableIn StockShips today -
New ReleaseDigital 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$3199Elsewhere:$4000Unit price /UnavailableIn StockShips today -
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 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
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.
