Skip to content
  • Home
  • Shop
  • About Us
  • Search
  • Contact Us
  • Login
View cart
  • Login
Close
  • Home
  • Shop
  • About Us
  • Search
  • Contact Us
Home Mastering Excel: MSQuery - Paperback
Mastering Excel: MSQuery
  • Books,
  • Business & Productivity Software,
  • Computers,
  • Spreadsheets,

Mastering Excel: MSQuery - Paperback

Original price $38.17 - Original price $38.17
Original price
$38.17
$38.17 - $38.17
Current price $38.17
| /
Availability: In Stock
SKU 9781546906599
  • Description
  • Reviews ()

Additional information

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

You may also like

  • ! At Gun Point...: Whistle Blowers' Point of View

    ! At Gun Point...: Whistle Blowers' Point of View - Paperback

    In stock

    by Bradley J. Franks (Author), Robert C. Simpson (Author)Are you confused and irritated about the Legal System? Do you feel the Politicians' make ...

    View full details
    Original price $51.91 - Original price $51.91
    Original price
    $51.91
    $51.91 - $51.91
    Current price $51.91
    | /
    Original price $51.91 - Original price $51.91
    Original price
    $51.91
    $51.91 - $51.91
    Current price $51.91
    | /
  • ! I Like Colours!

    ! I Like Colours! - Hardcover

    In stock

    by Puti Nurhendrawaty Hasman (Author), Fauzia Najm (Illustrator)I Like Colours! is a bilingual Arabic English book. It aims at helping learners who...

    View full details
    Original price $62.62 - Original price $62.62
    Original price
    $62.62
    $62.62 - $62.62
    Current price $62.62
    | /
    Original price $62.62 - Original price $62.62
    Original price
    $62.62
    $62.62 - $62.62
    Current price $62.62
    | /
  • !!gloria Á Cervantes!!; Volume 2

    !!gloria Á Cervantes!!; Volume 2 - Paperback

    In stock

    by Luis Linares Becerra (Author), Javier De Burgos (Author), J. Candela Ardid (Author)!!gloria Á Cervantes!!, Volume 2, delves into the life and wo...

    View full details
    Original price $44.37 - Original price $44.37
    Original price
    $44.37
    $44.37 - $44.37
    Current price $44.37
    | /
    Original price $44.37 - Original price $44.37
    Original price
    $44.37
    $44.37 - $44.37
    Current price $44.37
    | /
  • !!la Próxima Guerra!!: Estudios Político-militares Sobre La Europa Contemporanea Y Reorganización Del Estado Militar De España...

    !!la Próxima Guerra!!: Estudios Político-militares Sobre La Europa Contemporanea Y Reorganización Del Estado Militar De España... - Paperback

    In stock

    by Felipe de Navascués (Author)!!la Próxima Guerra!! Estudios Político-militares Sobre La Europa Contemporanea Y Reorganización Del Estado Militar ...

    View full details
    Original price $51.86 - Original price $51.86
    Original price
    $51.86
    $51.86 - $51.86
    Current price $51.86
    | /
    Original price $51.86 - Original price $51.86
    Original price
    $51.86
    $51.86 - $51.86
    Current price $51.86
    | /
  • !Ah y Le Lo Lay, Le Lo Ley! Musica Tipica de Puerto Rico

    !Ah y Le Lo Lay, Le Lo Ley! Musica Tipica de Puerto Rico - Paperback

    In stock

    by Nereida Ayala-Guzman (Author)Pretendemos por medio de "Ahi Le Lo Lai Le Lo Lei, Música Típica de Puerto Rico", resaltar la importancia de la mús...

    View full details
    Original price $47.44 - Original price $47.44
    Original price
    $47.44
    $47.44 - $47.44
    Current price $47.44
    | /
    Original price $47.44 - Original price $47.44
    Original price
    $47.44
    $47.44 - $47.44
    Current price $47.44
    | /
Shop collection

#DiscoverGreatBooks


Discover books that inspire growth, creativity, and imagination for readers of all ages.

Main menu

  • Home
  • Shop
  • About Us
  • Search
  • Contact Us

Footer menu

  • Search

Follow us

Find us on Facebook Find us on Threads Find us on Telegram Find us on Instagram Find us on LinkedIn Find us on Twitter
  • Search

Copyright © 2026 Selloorium. All rights reserved.

  • Choosing a selection results in a full page refresh.
  • Opens in a new window.