Mastering Excel
- MSQuery
- Indbinding:
- Paperback
- Sideantal:
- 108
- Udgivet:
- 23. maj 2017
- Størrelse:
- 152x229x6 mm.
- Vægt:
- 154 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.
- 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
Learn how to import data from text files and databases directly into Excel.MS Query is the precursor to Power Query (aka Get & Transform). Learn how to get data directly into Excel from: Text filesDatabasesWebpagesThis old dog can still do some things that Power Query can't. You will learn how to set up ODBC connections, parameters and automatic refreshes.What can MS query do that Power Query can't?Use SQL in a user-friendly built in interfaceSet up parameters. When a cell changes, the query executes automaticallyThis is a worthwhile skill to add to your Excel toolbox.Included in the lesson are several files (MS Access and text files) that you can use to follow along with the exercises.Please note, this is important!This lesson covers how to import data from an external database. The database we are using is Microsoft Access. You must have Microsoft Access available to work with the follow along files
Brugerbedømmelser af Mastering Excel
Giv din bedømmelse
For at bedømme denne bog, skal du være logget ind.Andre købte også..
Find lignende bøger
Bogen Mastering Excel findes i følgende kategorier:
© 2024 Pling BØGER Registered company number: DK43351621