Excel: Power Query Intro Courses, Excel Guide - 2020

  • 110.00 Dollar US$
  • Published date: February 26, 2020
    • 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 : https://www.traininng.com/webinar/excel:-power-query-intro--201243live?channel=marketplace-APR_2020_SEO
Contact Info
Traininng.com LLC
Email: traininngdotcom@gmail.com
Phone: US: (510) 962-8903
Phone: Zurich: +41 - 43 434 80 33
Website : https://www.traininng.com

Result 0 votes
Joseph Wilcox
0 votes

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"

Related listings

  • Multi-State Tax Issues, Payroll Issues,Employee Wellness  -2020

    Multi-State Tax Issues, Payroll Issues,Employee Wellness -2020

    Training and Teaching Fremont (California) January 6, 2020 110.00 Dollar US$

    Overview There are significant compliance issues for employers when employees cross state lines in the course of employment. Frequently, multi-state employment issues arise when the employer has business locations in more than one state. However, iss...

  • Ways To Positively Impacting Employee Behavior -  2020

    Ways To Positively Impacting Employee Behavior - 2020

    Training and Teaching Fremont (California) January 6, 2020 110.00 Dollar US$

    Overview One can easily argue that effective performance appraisals, coaching &counselling are more important in today’s business environment than ever due to: Escalating competition & enhanced customer expectations Technological changes requ...

  • Excel: Managing and Analyzing Data Hacks, Best Hacks About Excel -  2020

    Excel: Managing and Analyzing Data Hacks, Best Hacks About Excel - 2020

    Training and Teaching Fremont (California) January 6, 2020 110.00 Dollar US$

    Overview Learning how to efficiently use Excel is so critical in many of today's office jobs. Many people know the Excel basics. This webinar will show you how to use the tools sort and filter in Excel,and subtotals to really help get the most out of...