Name: Mastering Excel: MSQuery - Paperback
Brand: Books by splitShops
SKU: 9781546906599
Price: 29.97 USD
Availability: InStock
ISBN: 9781546906599

Mastering Excel: MSQuery - Paperback

$29.97

Report copyright infringement

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

Made with care

Great value

Elegant design

Quality materials

This product is crafted with quality materials to ensure durability and performance. Designed with your convenience in mind, it seamlessly fits into your everyday life.

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.

We are committed to ensuring a positive shopping experience for all our customers. If for any reason you wish to return an item, we invite you to reach out to our team for assistance, and we will evaluate every return request with care and consideration.