×

Web Events

The New Power Query: Get and Transform your data in Excel 2016

Speakers: Jeff Lenning
DeliveryType:  Video Webcast
    Select Date & Time:
  • $99.00-$129.00
    The New Power Query: Get and Transform your data in Excel 2016 08:00 pm - 10:00 pm ET Product #: VCL2EXGT010
    Add to Calendar 11/14/2017 20:00:00 11/14/2017 22:00:00 America/New_York AICPA Webcast: The New Power Query: Get and Transform your data in Excel 2016
    In this webcast, we'll apply these excel tools in several typical scenarios, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several CSV exports.
    Register at http://www.aicpastore.com/InformationManagementTechnologyAssurance/PRDOVR~PC-VCL2EXGT/PC-VCL2EXGT.jsp AICPA noreply@aicpastore.com false MM/DD/YYYY AICPA WebEvent aiEQlNoFjzFNtMgVwmLn20911
    AICPA Member: $99.00
    Non-Member: $129.00
  • $99.00-$129.00
    The New Power Query: Get and Transform your data in Excel 2016 01:00 pm - 03:00 pm ET Product #: VCL2EXGT009
    Add to Calendar 12/18/2017 13:00:00 12/18/2017 15:00:00 America/New_York AICPA Webcast: The New Power Query: Get and Transform your data in Excel 2016
    In this webcast, we'll apply these excel tools in several typical scenarios, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several CSV exports.
    Register at http://www.aicpastore.com/InformationManagementTechnologyAssurance/PRDOVR~PC-VCL2EXGT/PC-VCL2EXGT.jsp AICPA noreply@aicpastore.com false MM/DD/YYYY AICPA WebEvent aiEQlNoFjzFNtMgVwmLn20911
    AICPA Member: $99.00
    Non-Member: $129.00

Excel 2016's new "Get & Transform" feature is an incredibly powerful new toolset that can simplify your work. Combining features used in the Power BI and Power Query add-ins, Get & Transform enables you to easily connect to data from a variety of sources and then prepare it for use or analysis.

These tools provide efficient new methods for accomplishing tasks that were previously manual and time-consuming. In this webcast, we'll apply these tools in several typical scenarios, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several CSV exports.

If you regularly import or export data from one system to another, you will definitely want to learn how to leverage a Get & Transform query to streamline your work.

Learning Objectives

Participants of this webcast will be able to:

  • Recall the steps to create a new query
  • Identify commands that transform data
  • State the process to return the transformed data to Excel

Important Information on Your CPE Credit

Discounts

Group Viewing Option

Gather the team together and attend this webcast as a group. Each attendee will earn CPE Credit. Enter the number of attendees in the quantity box above.

Number of Attendees Non-Member Member

1 - 4

$129 $99

5 - 9

$115 $89

10 - 20

$109 $85

21 +

$105 $79

Your order confirmation will include an instruction document for group viewing and earning CPE credit (please review prior to the start of the event) and information on how to access the webcast.

Included in:Annual Webcast Pass

Get year-round unrestricted access to this and more than 500 webcasts featuring top experts, regulators and agency representatives discussing topics of importance to you. Learn more...


Speaker Bio

Jeff Lenning
CPA CITP

Author of Excel University
In his live CPE training sessions, Jeff Lenning CPA CITP has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient. Several publications have featured his Excel articles, including the Journal of Accountancy and California CPA Magazine.

Highlights
After graduating from the University of Southern California, Jeff began his career in the audit practice at Arthur Andersen's Orange County office. He was a senior financial analyst at Gateway computers and the accounting manager at Interpore Cross International. In 2000, he founded Click Consulting Inc., a technology-consulting firm that specializes in Excel training, consulting, development, and personal coaching.

Professional Involvement
He is a past president of the CalCPA OCLB Chapter, the former chair of the California CPA State Technology Committee, co-chair of the California CPA OCLB Chapter Technology Committee, a board member of the California CPA OCLB Chapter, on the California Society of CPAs Council, and an instructor for the AICPA and the California CPA Education Foundation. A Microsoft Office Certified Excel Expert, he is a nationally recognized speaker and trainer. He was recently recognized with the California CPA Education Foundation's Award for Instructor Excellence.

System Requirements