Name: Mastering Excel: MSQuery
SKU: 61693586
Price: 1125.00 TWD
Availability: InStock
Author: Moore, Mark
ISBN: 9781546906599

Select your country

Americas

Europe

Rest of the world

Type

Physical Book

Author

Mark Moore

Publisher

Createspace

Language

English

Pages

108

Format

Paperback

Dimensions

22.9x15.2x0.6 cm

Weight

0.15 kg.

ISBN13

9781546906599

Synopsis "Mastering Excel: MSQuery"

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

Customers reviews

Have you read this book? Login to add your review.

More customer reviews

0% (0)
0% (0)
0% (0)
0% (0)
0% (0)

Questions and Answers about the Book

Do you have a question about the book? Login to be able to add your own question.

Opinions about Bookdelivery

More customer reviews

Mastering Excel: MSQuery - Moore, Mark

Synopsis "Mastering Excel: MSQuery"

Customers reviews

Frequently Asked Questions about the Book

Is the book original?

In what language is the book written?

What is the format of this book?

Questions and Answers about the Book

Opinions about Bookdelivery