categorías precio corporativa
Libro Electrónico de ámbito Profesional

# Excel: Power Query for Advanced

### A Step by Step Guide

80
Idioma:  English
This manual shows you the hidden functions in Power Query. Besides the alternative to the VLOOKUP() function you get an insight into the Power Query functions.
Descripción
Contenido
book.tabs.learning objectives

Compatible with Excel 2016 / 2019 / 2021 / 365 Power Query is integrated in Excel and is specialized in importing, transforming and cleansing all kinds of data. It offers you many other useful commands for data transformation. The chapter Many useful tools in Power Query teaches you how to detect and remove duplicates. You will find more than 400 functions in Power Query. Some of them are discussed in this manual. You will also learn about the better and faster alternative to the VLOOKUP() function.

I had my first contact with a computer in 1980 and I was immediately fascinated. This enthusiasm has never left me. In 1988 I wrote my first book on Framework II. Today, I have published over 140 books on many Microsoft Office topics in over 30 years. I have been teaching IT training on Office applications since 1989. In all these years I have taught thousands of users how to use computers. I know exactly where the shoe pinches and can communicate it verbally and in writing. I have been certified by Microsoft as a Microsoft Office Specialist Master.

• Preface
1. VLOOKUP in Power Query
1. Bringing data together
2. Create a pivot table from the data
2. Understanding and using Join types
1. Left Outer
2. Right Outer
3. Full Outer
4. Inner Join
5. Left Anti
6. Right Anti-Join
3. Unpivot data – convert results back to a list
1. Creating a List from a Pivot Result
2. Transferring the data to Excel
4. Many useful tools in Power Query
1. Recognizing duplicates
2. Recognize duplicate values in Excel
3. Deleting Duplicate Values in Power Query
4. Create cross table
5. Distinct Count - count unique values per month
5. Calculations and more
1. The Text Start function
2. The Function Text.Range
3. The Function Text.PositionOf
4. Nested functions
5. Changing the Data Type for the EAN Column
6. The If Function in Power Query
7. Evaluations with date values
6. Data from the Web
1. Analyzing the Wikipedia website
2. Transfer the list to Excel
7. Troubleshooting
1. Error Messages in Queries
• Index

Learn how to join tables in Excel using Power Query. Understand various join types in Power Query and their uses. Discover methods for converting pivot table results into lists for analysis. Explore Power Query tools for managing duplicates, creating cross tables, and counting unique values.

Sobre el Autor