Module 8: Advanced Formulas – Array Formulas and DAX Formulas

Course Description
This one-hour data analytics course will introduce formula arrays and DAX formulas to users in Power BI and Excel. Users will learn the skills to create and evaluate array formulas and DAX formulas. An understanding of implicit for explicit intersections and measures within the formulas will be discussed. Users will apply the understanding to data and work alongside the instructor to create calculated columns in Power Pivot using DAX formulas and array formulas.
Learning Objectives
  • Understand the applicable Excel skills that will be required in making the transition to data analyst
  • Understand the basic requirements to create array and DAX formulas using Power BI and Excel
  • Understand how DAX formulas relate to calculated columns and how they can be created within calculated columns
  • Apply understanding of DAX formulas to create calculated columns using Power Pivot
  • Be able to create hierarchies in Excel with calculated columns
Who Should Take This Course?
Auditors: Staff Auditors, Senior Auditors, Internal Auditors, Government Auditors
Accountants: Staff Accountants, Senior Accountants, Supervisors, Managers, Management Accountants
Analysts: Business Analysts, Financial Analysts

Module 8: Advanced Formulas – Array Formulas and DAX Formulas

$39

What’s Included

1 hour of Instruction

Level: Intermediate

Full certificate Course

Interested in earning a professional certificate?

100% Online
and On-Demand

Mobile-Friendly
Video Lectures

Earn a Professional
Certificate

Top-Rated
Instructors

Prerequisites

2+ years of experience working with Excel

Advance Preparation

Install Power Pivot and Data Analysis ToolPak

Resume Skills
Data Analytics Power BI Microsoft Excel DAX Functions
Virginia Collins, CPA, CFE, CITP
Meet The Instructor

Virginia Collins is a former Manager in the Quality Control Department of Berdon LLP. With more than 35 years of experience in public accounting, she has advised clients across many industries. Leveraging broad experience in auditing, accounting, and internal controls, she has expertise in information technology including data analytics, Excel, and active data. Ms. Collins is a Certified Informational Technology Professional (CITP), which is a specialty designation awarded by the AICPA to CPAs with the unique ability to bridge business and technology. She was appointed a Committee Member of the AICPA Credential Committee where she has been actively involved in increasing the use of Computer Assisted Auditing Techniques (CAATs) by CPAs. Her experience extends to planning of engagements — applying CAATs techniques and training staff on their use, internal control I.T. review, quality control review of engagements, data analytics, continuous auditing and business intelligence, and advising on the requirements of Section 404 of the Sarbanes-Oxley Act.

Try Some of Our Classes for Free

Surgent IQ

ENTER YOUR INFORMATION BELOW TO RECEIVE SAMPLES
What’s the Benefit of a Professional Certificate?

Only Surgent has the 35+ year proven track record of educating professionals of all experience levels with an unmatched industry expertise and best-in-class learning technology to ensure you’re equipped with the skills you need for career success.

Surgent IQ’s professional certificate program explores topics in much greater detail than you’d typically find anywhere else, like in a classroom setting, and are meant to teach very specific, practical concepts that can be immediately applied in your day-to-day. And because our courses are designed to address the needs of specific job functions, you can be sure you’re choosing the exact course your career will benefit most from.

By earning a professional certification, you demonstrate to current employers and future hiring managers that you’ve got just the right skills to bring value to their organization.

Here’s how else you’ll benefit:

Future-proof your career

The accounting and finance industries may be going through a period of flux, but by acquiring the forward-looking skills that drive innovation for businesses, you can ensure you’re able to succeed in today’s and tomorrow’s climate.

Make the switch you’ve been thinking about

Adding a professional certification to your resume is a surefire way to demonstrate to hiring managers that you’ve got the skillset they’re looking for.

Take the next step in your profession

Build marketable expertise in the most in-demand areas of your industry, and take your career to the next level.