Mastering Excel

MSQuery

By:

Mark Moore

Format:

Paperback / softback

Series:

Mastering Excel

Show Hide Adult Content

$58.99 was ~~$72.99~~

Available from supplier

Usually ships in 3-4 weeks

0 in Trolley

Price Match

Wrap this item as a gift ($5.90) - add a free gift card on the next page

Buy Now, Pay Later with:

Afterpay is available on orders $100 to $2000 Learn more

Availability

Delivering to:

Estimated arrival:

Around 14-26 June using International Courier

Description

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

Release date Australia

May 23rd, 2017

Author

Mark Moore

Series

Mastering Excel

Pages

108

Audience

General (US: Trade)

Dimensions

152x229x6

ISBN-13

9781546906599

Product ID

37420857

Customer reviews

Nobody has reviewed this product yet. You could be the first!

Write a Review

Marketplace listings

There are no Marketplace listings available for this product currently.
Already own it? Create a free listing and pay just 9% commission when it sells!

Sell Yours Here