Mastering Excel: MSQuery

Mastering Excel: MSQuery - Paperback

$34.57
Skip to product information
Mastering Excel: MSQuery
  • Mastering Excel: MSQuery
Mastering Excel: MSQuery - Paperback

Mastering Excel: MSQuery - Paperback

$34.57
Shipping calculated at checkout.
Details

by Mark Moore (Author)

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
Number of Pages: 108
Dimensions: 0.22 x 9 x 6 IN
Publication Date: May 23, 2017
Materials + Care

We prioritize quality in selecting the materials for our items, choosing premium fabrics and finishings that ensure durability, comfort, and timeless appeal.
Shipping + Returns

We strive to process and ship all orders in a timely manner, working diligently to ensure that your items are on their way to you as soon as possible.

You might also like...