Excel - Importing and Manipulating Big Data with Power Query

6 years ago Posted By : User Ref No: WURUR20944 0
  • Image
  • TypeWebinar
  • Image
  • Location Denver, Colorado, United States
  • Price
  • Date 24-05-2018
Excel - Importing and Manipulating Big Data with Power Query, Denver, Colorado, United States
Webinar Title
Excel - Importing and Manipulating Big Data with Power Query
Event Type
Webinar
Webinar Date
24-05-2018
Last Date for Applying
24-05-2018
Location
Denver, Colorado, United States
Organization Name / Organize By
Training Doyens
Organizing/Related Departments
Training Doyens
Organization Type
Organization/Company
WebinarCategory
Both (Technical & Non Technical)
WebinarLevel
All (State/Province/Region, National & International)
Related Industries

Education/Teaching/Training/Development

Business Development

Finance

Accounting/Financial/Banking/Insurance

Location
Denver, Colorado, United States

OVERVIEW

Do you work with "Big Data"? Do you import and manipulate large datasets in Excel? If so you’ll already be familiar with the limitations of Excel. Power Query, (known as Get and Transform in Excel 2016) is designed to get you past these limitations, allowing you to import and work with 1-million-plus-row datasets from virtually any source.

WHY SHOULD YOU ATTEND

If you work with, analyze and generate reports from large datasets, having a good understanding and working knowledge of Power Query / Get and Transform is a must!

AREAS COVERED

Session highlights include…

  • Importing data into Excel from external sources
  • Linking to external sources
  • Creating Pivot Tables from external data sources
  • Using the Query Editor to create calculated columns in pivot tables
  • Using the Query Editor to clean and transform data

LEARNING OBJECTIVES

Power Query / Get and Transform can save you a ton of time when working with imported data. In many cases when you get data from external sources, it needs work on it before it can be used. Although this can be done using Excel functionality, Power Query / Get and Transform is a lot faster, can handle much more data, and is repeatable with a couple of clicks.

WHO WILL BENEFIT

This event is aimed at users of Excel (2010, 2013 and 2016 for Windows) who wish to learn about Power Query / Get and Transform. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.

IMPORTANT NOTE: Power Query is only available for Excel 2010, Excel 2013 and 2016 for Windows in Office Professional Plus, Office 365 Professional Plus or the standalone editions of Excel 2013 & 2016. If in doubt whether this training is relevant for your version of Excel, please check with your IT department.

 

For more detail please click on this below link:

https://bit.ly/2EHJbT0

 

Email: [email protected]

Toll Free: +1-888-300-8494

Tel: +1-720-996-1616

Fax: +1-888-909-1882

Others Details

Learn Power Query, a tool that can save you a lot of time when working with imported data. Also learn how to analyze and generate reports from large datasets.

Registration Fees
Available
Registration Fees Details
Live Session for one participant $159 Corporate Live Session Group – Max 10 Participants from one location. $449 Recorded Session Get unlimited access to audio recording of the webinar for 6 months. $199 Training DVD or USB Flash Drive MP3 files, PDF presentation and reference manual will be delivered on a CD $379 Super Combo Offer 1 Live and Recorded webinar $289 Super Combo Offer 2 Live and Training CD $429
Registration Ways
Email
Phone
Website
Other
Address/Venue
  26468 E Walker Dr, Aurora, Colorado 80016  Pin/Zip Code : 80016
Landmark
CO
Official Email ID
Contact
Training Doyens

26468 E Walker Dr, Aurora, Colorado 80016

[email protected]

   8883008494
Michael smith

26468 E Walker Dr, Aurora, Colorado 80016

[email protected]

   8883008494    Fax No: Aurora