Vermont Society of Certified Public Accountants
Cart: 0 items

Courses

Surgent's Data Analytics Readiness Series: Data Modeling - On-Demand Webcast

« View All Courses

Register

Member Price: $59.00
Non-Member Price: $74.00

view cart

Developer:
SURGENT MCCOY SELF-STUDY CPE, LLC
CPE Credits:
Computer Science: 1.00
Fields of Study:
Computer / IT
Level:
Intermediate
This one-hour course will focus primarily on Power Query, Power Pivot, and VLOOKUP skills. Users will learn how to join tables using various techniques and add-ons in Excel. Users will understand how to utilize the tools while maintaining data integrity. The majority of the course will focus on hands-on data exercises. Users will apply skills to create relationships and analyze the data using Power Query.

This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.

Objective

  • Understand the applicable Excel skills that will be required in making the transition to data analyst
  • Understand types of data relationships that exist within the data (e.g., linear, normal, etc.)
  • Apply VLOOKUP and index match formulas in Excel
  • Append and merge multiple data sets into one
  • Create relationships in Power Pivot

Highlights

  • How to join tables using
    • VLOOKUP
    • Power Query- append queries and merge queries
    • Power Pivot- Creating a relationship via diagram view
  • Types of relationships
  • Data integrity
  • Normalization
  • Facts vs dimension tables
  • Exercises- data modeling
    • VLOOKUP and index match formula
    • Appending data in Power Query
    • Merging data in Power Query
    • Connection only queries
    • Creating a relationship in Power Pivot

Designed For

Accountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas

Prerequisite

Intermediate knowledge of Excel

Advanced Preparation

Install Power Pivot and Data Analysis ToolPak
back to list