Categories Pricing Corporate
home.libro.professionale_ebook

Excel: Power Query for Advanced

A Step by Step Guide

Saskia Gießen
0 Recensioni
80
Lingua:  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.
Abbonamento Professional Plus gratuito per i primi 30 giorni poi $8.99 /mese
Non ci sono pubblicità nel libro
Descrizione
Contenuto

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.

About the Author

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