De Aller-Bedste Bøger - over 12 mio. danske og engelske bøger
Levering: 1 - 2 hverdage

Mastering Excel

- Power Query

Bag om Mastering Excel

Import data from text files, other Excel files, databases, web pages, Facebook, even entire folders of files using Power Query.Excel is the most accessible program for data analysis. Power Query (also known as Get & Transform) takes that one step further. The first step of any data analysis project is importing the data. Related to that, you must clean and standardize the data (aka ETL: Extract, Transform and Load)Power Query has all that covered. You will learn to set up Power Query for connecting Excel to all kinds of data sources, performing hundreds of ETL tasks and loading clean data into your worksheet. Power Query can extract data from columns, join columns, remove duplicates, skip errors, join tables, the list is almost endless.Additionally, Power Query is set up to remember all the steps you performed and it will redo them with a single click of a button.Learn to use Power Query and save yourself hours of work.

Vis mere
  • Sprog:
  • Engelsk
  • ISBN:
  • 9781546909071
  • Indbinding:
  • Paperback
  • Sideantal:
  • 68
  • Udgivet:
  • 23. maj 2017
  • Størrelse:
  • 152x229x4 mm.
  • Vægt:
  • 104 g.
  • 8-11 hverdage.
  • 9. december 2024
På lager

Normalpris

Abonnementspris

- Rabat på køb af fysiske bøger
- 1 valgfrit digitalt ugeblad
- 20 timers lytning og læsning
- Adgang til 70.000+ titler
- Ingen binding

Abonnementet koster 75 kr./md.
Ingen binding og kan opsiges når som helst.

Beskrivelse af Mastering Excel

Import data from text files, other Excel files, databases, web pages, Facebook, even entire folders of files using Power Query.Excel is the most accessible program for data analysis. Power Query (also known as Get & Transform) takes that one step further. The first step of any data analysis project is importing the data. Related to that, you must clean and standardize the data (aka ETL: Extract, Transform and Load)Power Query has all that covered. You will learn to set up Power Query for connecting Excel to all kinds of data sources, performing hundreds of ETL tasks and loading clean data into your worksheet. Power Query can extract data from columns, join columns, remove duplicates, skip errors, join tables, the list is almost endless.Additionally, Power Query is set up to remember all the steps you performed and it will redo them with a single click of a button.Learn to use Power Query and save yourself hours of work.

Brugerbedømmelser af Mastering Excel



Find lignende bøger
Bogen Mastering Excel findes i følgende kategorier: