Power Query for Excel Users | A practical guide to cleaning, transforming, and automating Excel data with Power Query
Lingua: inglese
Editore: Packt Publishing, 2026
- Brossura
- Nuovo

Condizione: Nuovo
EUR 64,45
Quantità: 5 disponibili
Aggiungi al carrelloDescrizione dell’articolo da parte del venditore
Power Query for Excel Users | A practical guide to cleaning, transforming, and automating Excel data with Power Query | Oscar Martínez Valero | Taschenbuch | Englisch | 2026 | Packt Publishing | EAN 9781807427733 | Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, 36244 Bad Hersfeld, gpsr[at]libri[dot]de | Anbieter: preigu Print on Demand.
Codice articolo 136305571
- Titolo
- Power Query for Excel Users | A practical guide to cleaning, transforming, and automating Excel data with Power Query
- Autore
- Oscar Martínez Valero
- Editore
- Packt Publishing
- Anno di pubblicazione
- 2026
- Condizione
- Neu
- Rilegatura
- Taschenbuch
- Lingua
- inglese
- ISBN 10
- 1807427730
- ISBN 13
- 9781807427733
- Peso dell'articolo
- 784 grammi
- Dimensioni
- 235 x 191 x 23 mm
- Cataloghi dei venditori
- Bücher
Learn Power Query in Excel to clean and automate business data: repeatable workflows for business users, with tips for using AI tools. No coding required
Free with your book: DRM-free PDF version + access to Packt's next-gen Reader*
Key Features
- Learn Power Query step by step, starting from everyday Excel tasks and building up gradually
- Organize messy data and combine files from common business sources using repeatable workflows
- Get practical tips for using AI tools like ChatGPT alongside your Power Query workflows
Book Description
If you spend hours every week copying, cleaning, and combining spreadsheets, Power Query will improve how you work, permanently.
In Power Query for Excel and Business Users, you follow Quinn, a newly hired data analyst at Northbridge Office Group, through realistic business scenarios that any business user will recognize. This book uses Quinn’s journey to make Power Query accessible and relatable. With beginners in mind, a very basic Excel knowledge is all you need to start.
As you work through the book, you'll learn how to clean up messy data, combine files from different systems, and automate the recurring steps that eat up your time every week.
Beyond the basics, you’ll also learn how to use LLMs (like ChatGPT) to accelerate your data work through tested prompt templates without compromising data quality or trust.
By the end of the book, you’ll have a strong foundation in data preparation that not only improves your daily Excel work but also prepares you to move confidently toward tools like Power BI and Microsoft Fabric.
What you will learn
- Use Power Query's UI to import and clean data without coding
- Automate everyday tasks—split, merge, pivot, and reshape data
- Combine files from multiple sources reliably
- Use AI prompts safely to speed up transformations
- Create reusable workflows that your team can refresh themselves
- Build foundational concepts that transfer to Power BI and Microsoft Fabric
- Handle and fix messy organizational data
Who this book is for
This book is written for office managers, executive assistants, project/operations coordinators, and finance and HR professionals. Anyone who works with data, not just data specialists. It's perfect for those who spend hours cleaning and combining files, tracking KPIs, or making sense of complex spreadsheets. No coding experience required: if you know how to open Excel and use basic formulas, you're ready to start.
Table of Contents
- Power Query Basics in Excel (ETL + UI Tour)
- Transform Daily Excel Tasks with Power Query
- Connect and Standardize Common Business Sources
- Build Reliable Step Chains and Read M Passively
- Build Reusable Reports with PivotTables
- Combine and Clean Multiple Files into One Clean Table
- Combine and Reshape Multiple Files into a Tidy Long Table
- Merge Tables to Build an Enriched Master List
- Join and Lookup Data Safely Without a Data Model
- Automate Repetitive Processes
- Build Your First Events Data Model in Excel
- Answer Questions with Your First DAX Measures
"Riassunto" può appartenere a un’altra edizione di questo titolo.
Informazioni sull’autore
Oscar Martínez is a data professional focused on Microsoft technologies with over 15 years of experience bridging finance, technology, and analytics. He specialises in BI, AI, and automation solutions using Microsoft Fabric, Power BI, Power Query, and Azure services. Oscar has led enterprise-scale data projects and saved organisations significant costs through strategic implementations. He is a Microsoft Fabric Analytics Engineer Associate and Power BI Data Analyst Associate. Oscar founded BIBB Pro, creating the #1 global Power BI Theme Generator and writing educational blog posts. Passionate about teaching, he trains both beginners and advanced learners and has volunteered for several years, helping refugees integrate into the Swiss IT job market. When Oscar is not in front of the computer, he enjoys time with the family, cooking, gardening and doing handwork in his garage.
"Descrizione articolo" può appartenere a un’altra edizione di questo titolo.
preigu
Osnabrück, Germania
Venditore AbeBooks dal 5 agosto 2024
Tariffe di spedizione da Germania a U.S.A.
| Articolo | Da 60 a 60 giorni lavorativi | Da 60 a 60 giorni lavorativi |
|---|---|---|
| Primo articolo | EUR 70,00 | EUR 70,00 |
Metodi di pagamento
- PayPal
Descrizione dello Store
preigu betreibt einen Onlineversandhandel mit über 1 Mio. Produkten in verschiedenen Sortimenten. Das Kernsortiment besteht aus Büchern, Medien und Spielwaren. Ein gelungenes Einkaufserlebnis ist das Ziel einer jeden Bestellung bei preigu, denn der Kunde und seine Zufriedenheit stehen an erster Stelle. preigu setzt daher auf einen kompetenten Kundenservice, funktionierende Prozesse und schnelle Reaktion.
Specializzazione
Bücher, SpielwarenInformazioni sull’azienda del venditore
preigu GmbH & Co. KG
Lengericher Landstraße 19
Osnabrück, Germania 49078
Condizioni di vendita
About Us
Legal website operator identification:
preigu GmbH & Co. KG
Lengericher Landstr. 19
49078 Osnabrück
Germany
Telephone: +49 (0) 541 / 580 72 84
Email: mail@preigu.de
VAT No: DE 455 380 498
AG Osnabrück - HRA 209647
PhG: preigu Verwaltung GmbH
AG Osnabrück - HRB 221793
CEO: Ansas Meyer
We are neither willing nor obliged to participate in dispute resolution proceedings before consumer arbitration boards.
We are a member of the initiative "FairCommerce" since 30.11.2016.
For more information, see: https://www.haendlerbund.de/de/haendlerbund/interessenvertretung/faircommerce
Diritto di recesso
Instructions for revocation
Right of withdrawal for the sale of goods
Revocation right for consumers
(A ‘consumer' is any natural person who concludes a legal transaction which, to an overwhelming extent, cannot be attributed to either his commercial or independent professional activities.)
Instructions for revocation
Revocation right
You have the right to revoke this contract within 14 days without specifying any reasons.
The revocation period is 14 days with effect from the day,
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the products, provided you had ordered one or more products within the scope of a standard order and this/these product/products is/are delivered uniformly;
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the last product, provided you had ordered several products within the scope of a standard order and these products are delivered separately;
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the last part delivery or the last unit, provided you had ordered a product, which is delivered in several part deliveries or units;
To exercise your right of withdrawal, you must inform us (preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabrück, Telephone number: +49 (0) 541 / 580 72 84, E-Mail address: mail@preigu.de) by means of a clear declaration (e.g. a letter sent by post, or an e-mail) of your decision to withdraw from this contract. You can use the attached model withdrawal form for this purpose, which is, however, not mandatory.
You can also exercise your right of withdrawal online by clicking on a button labelled accordingly (such as ‘Withdraw from contract' or similar) on the AbeBooks/ZVAB website. If you use this online function, you will immediately receive a confirmation of receipt on a durable medium (e.g. via email) containing information on the content of the withdrawal notice, as well as the date and time of its receipt.
In order to safeguard the revocation period, it is sufficient that you send the notification about the exercise of the revocation right before the expiry of the revocation period.
Consequences of the revocation
If you revoke this contract, we shall repay all the payments, which we received from you, including the delivery costs (with the exception of additional costs, which arise from that fact that you selected a form of delivery other than the most reasonable standard delivery offered by us), immediately and at the latest within 14 days from the day on which we received the notification about the revocation of this contract from you. We use the same means of payment, which you had originally used during the original transaction, for this repayment unless expressly agreed otherwise with you; you will not be charged any fees owing to this repayment.
We can refuse the repayment until the products are returned to us or until you have furnished evidence that you have sent the products back to us, depending on whichever is earlier.
You must return or transfer the products to us immediately and, in any case, at the latest within 14 days with effect from the day on which you inform us of the revocation of this contract. The deadline is maintained if you send the products before the expiry of the 14 day deadline.
You bear the direct costs for returning the products.
You must pay for any depreciation of the products only if this depreciation can be attributed to any handling with you that was not necessary for checking the condition, features and functionality of the products.
Criteria for exclusion or expiry
The revocation right is not available for contracts
-
for delivery of products, which are not prefabricated and for whose manufacturing an individual selection or stipulation by the consumer is important or which are clearly tailored to the personal requirements of the consumer;
-
for delivery of products, which can spoil quickly or whose use-by date would be exceeded quickly;
-
for delivery of alcoholic drinks, whose price was agreed at the time of concluding the contract, which however can be delivered 30 days after the conclusion of the contract at the earliest and whose current value depends on the fluctuations in the market, on which the entrepreneur has no influence;
-
for delivery of newspapers, periodicals or magazines with the exception of subscription contracts. The revocation right expires prematurely in case of contracts
-
for delivery of sealed products, which are not suitable for return for reasons of health protection or hygiene if their seal has been removed after the delivery;
-
for delivery of products if they have been mixed inseparably with other goods after the delivery, owing to their condition;
-
for delivery of sound or video recording or computer software in a sealed package if the seal has been removed after the delivery.
Specimen - revocation form
(If you wish to revoke the contract, please fill up this form and send it back to us.)
-
To preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabrück, Email address: mail@preigu.de :
-
I/we () herewith revoke the contract concluded by me/ us () regarding the purchase of the following products ()/
the provision of the following service () -
Ordered on ()/ received on ()
-
Name of the consumer(s)
-
Address of the consumer(s)
-
Signature of the consumer(s) (only in case of a notification on paper)
-
Date
(*) Cross out the incorrect option.