On-Demand


1 CPE

Introduction to Data Analytics with Excel Power Query

On-Demand
1 CPE
  • View Bio

    Instructor

    Donald
    Tomoff

    View Bio

Learning Objectives

  • Import and transform basic data into Excel using Power Query
  • Understand and apply the data load capabilities of loading into Excel versus loading into the “data model”, and why it matters
  • Identify the basics of extracting and transforming data

Major Topics

  • Deep dive into Power Query (Excel 2016 Get & Transform)
  • Explore the basics of extracting and transforming data, which is the first necessary step to data analysis and reporting
  • Top 6 features most important to accountants (data source flexibility, appending queries, unpivot, etc.)
  • Exploration of real Power Query use cases, many of which accountants could implement immediately
  • A summary of top resources and experts to get you started on the journey of learning Power Query
  • Excel workbooks will be made available for all participants to use at their leisure and further explore the topics discussed

CPE Credits Available

1 CPE
1
Information Technology

Things to Know About This Course

Course Level

  • Advanced

Professional Area of Focus

  • Business & Industry
  • Emerging Professional

Prerequisites

  • Comfortable with Excel navigation and data related topics – LOOKUP, Pivot Tables, Data Tables, etc. would be helpful, but not required.

Advanced Preparation

None INSTRUCTOR BIO

Intended Audience

  • Any business professional responsible for managing and working with data.

Provider

Business Learning Institute

Purchase This Course

  • MACPA Member

    $ 35 35
    Join
  • MACPA Non-Member

    $ 45 45
    Your Price

Please login to register.