Articoli correlati a Mastering Excel: MSQuery

Mastering Excel: MSQuery - Brossura

Libro 5 di 30: Mastering Excel

Moore, Mark

 
9781546906599: Mastering Excel: MSQuery
Brossura
ISBN 10: 1546906592 ISBN 13: 9781546906599
Casa editrice: CreateSpace Independent Publishing Platform, 2017

Sinossi

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 files
  • Databases
  • Webpages
This 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 interface
  • Set up parameters. When a cell changes, the query executes automatically
This 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.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Editore
CreateSpace Independent Publishing Platform
Data di pubblicazione
2017
Lingua
Inglese
ISBN 10 
1546906592
ISBN 13 
9781546906599
Rilegatura
Copertina flessibile
Numero di pagine
106
Contatto del produttore
Manufactured by Amazon on behalf of the author
https://www.amazon.it/hz/contact-us

c/o Amazon Media EU S.à.r.l., 38 Avenue John F. Kennedy
Luxembourg
L-1855
Lussemburgo