Excel: Power Query Intro Courses, Excel Guide - 2020

Posted By : User Ref No: WURUR54473 0
  • Image
  • TypeWebinar
  • Image
  • Location Fremont, California, United States
  • Price
  • Date 23-04-2020
Excel: Power Query Intro Courses, Excel Guide - 2020, Fremont, California, United States
Webinar Title
Excel: Power Query Intro Courses, Excel Guide - 2020
Event Type
Webinar
Webinar Date
23-04-2020
Last Date for Applying
23-04-2020
Location
Fremont, California, United States
Organize and Presented By
Traininng .com
Sponsored By
Traininng .com
Organizing/Related Departments
Online Training
Organization Type
Training/Development
WebinarCategory
Both (Technical & Non Technical)
WebinarLevel
All (State/Province/Region, National & International)
Related Industries

Education/Teaching/Training/Development

Business Development

Employment/Jobs/Recruitment

OTHERS

Location
Fremont, California, United States

Overview

 

Power Query is a somewhat new feature, it first made its entrance in Excel 2010, and now is a standard part of Excel 2016 and 2019.

Power Query is a tool designed for Excel to handle repetitious steps specifically tied to data prep. We all know the drudgery of removing columns, shifting rows, correcting data formats all before we can actually do the work with the data!

The old alternative was to use macros for this redundant work; but even those were hard to edit and not everyone is comfortable with VBA code.

In this crash course, you will learn how to find Power Query in Excel, load data into it, begin the process of transforming your redundant tasks (one last time!), and then how to Save and Load the Query to Excel to finish your reports.

Take this course and benefit from Andy Lanning's 20+ years of experience. At the finish, you will realize how hard you have worked without Power Query helping you through your data prep, and soon rejoice at your new-found time savings!

 

Why you should Attend

 

When the daunting task of 'cleaning up data' comes across your desk, are you using the amazing features of Excel's Power Query?
It is surprisingly common to find oneself repeating a process daily or weekly simply because we didn't know there was a better way. This is true with prepping data for Excel.

Attend this webinar for a crash course in Power Query and you'll be amazed at the time you save by no longer redundantly cleaning data.

 

Areas Covered in the Session

 

  • How to begin a Power Query
  • How to Extract data from your Source files into the Power Query
  • How to Transform the data (clean it up)
  • View a few examples of the Transform process
  • Learn the power of the Query Settings and the Advanced Editor
  • How to Load the data and Save the Excel file
  • And finally, how to re-open and edit the Power Query Settings

 

Who Will Benefit

 

  • Accountants
  • Accounts
  • Audit
  • Aviation
  • Banking
  • CFOs
  • Controllers
  • CPAs
  • Education
  • Energy
  • FDA
  • Finance
  • Financial consultants
  • Human Resource
  • Insurance
  • Investments
  • IT
  • Logistics & Supply Chain
  • Marketing
  • Medical Devices
  • Pharmaceutical
  • Retail
  • Sales
  • Telecom

 

Event link : Traininng.com

Contact Info

Traininng.com LLC

Email: [email protected]

Phone: US: (510) 962-8903

Phone: Zurich: +41 - 43 434 80 33

Website : https://www.traininng.com

Others Details

Online

Registration Fees
Available
Registration Fees Details
$110.00
Registration Ways
Email
Phone
Website
Address/Venue
  Online  Pin/Zip Code : 94539
Landmark
CA
Official Email ID
Contact
Traininng.com

39658 Mission Boulevard, Fremont, CA 94539, USA.

[email protected]

   5109628903    Fax No: 94539