• Skip to main content
  • Skip to secondary navigation

Mastering Excel

The best place to learn Excel

  • Contact Me
  • Mastering Excel
  • Mastering Excel Macros
  • Infographic
  • All Books

Mastering Excel: MS Query

By Mark Moore

Mastering Excel: MS Query
3.99
  • Available in: eBook, Paperback
  • ISBN: 1546906592
Amazon eBookAmazon Paperback

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.

 


Series: Mastering Excel