38,06 €
42,29 €
-10% with code: EXTRA
Mastering Excel
Mastering Excel
38,06 €
42,29 €
  • We will send in 10–14 business days.
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 ex…
42.29
  • SAVE -10% with code: EXTRA

Mastering Excel (e-book) (used book) | Mark Moore | bookbook.eu

Reviews

There are no ratings.
Rate it too! All reviews

Description

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
FREE DELIVERY

EXTRA 10 % discount with code: EXTRA

38,06 €
42,29 €
We will send in 10–14 business days.

The promotion ends in 21d.10:34:27

The discount code is valid when purchasing from 10 €. Discounts do not stack.

Log in and for this item
you will receive 0,42 Book Euros!?

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

Reviews

  • No reviews
0 customers have rated this item.
5
0%
4
0%
3
0%
2
0%
1
0%
(will not be displayed)