
Module 8: Advanced Formulas – Array Formulas and DAX Formulas
- 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
Accountants: Staff Accountants, Senior Accountants, Supervisors, Managers, Management Accountants
Analysts: Business Analysts, Financial Analysts
Module 8: Advanced Formulas – Array Formulas and DAX Formulas
1 hour of Instruction
Level: Intermediate
Full certificate Course
and On-Demand
Video Lectures
Certificate
Instructors
2+ years of experience working with Excel
Install Power Pivot and Data Analysis ToolPak

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.