Learn DAX to unlock Excel’s full power, transform data, and deliver impactful insights.
In today’s data-driven world, having a strong command of Excel is essential, and understanding the Data Analysis Expressions (DAX) formula language is the key to unlocking the true potential of Excel’s Power Pivot and Data Model features.This topic provides users with an introduction to the DAX formula language, providing you with the essential knowledge and skills to manipulate data, perform calculations, and gain valuable insights, making you a data superhero in your organization.
Learning Objectives
- You will be able to explain the fundamentals of creating and using DAX Measures.
- You will be able to identify how to manipulate text, perform lookups, and work with dates using DAX.
- You will be able to recognize how to distinguish between DAX Calculated Columns and Query Editor Calculated Columns.
- You will be able to review the crucial CALCULATE function and its role in DAX calculations.
Live Webinar Registration
ASAP PACE 0.1: This course is pre-approved through the American Society of Administrative Professionals (ASAP) for 0.1 CEU(s) towards your PACE Recertification.IAAP 1.0: All education that aligns with the CAP Body of Knowledge can be used toward recertification. The provider believes this course does align and should be counted toward recertification. Course Length: 1.0.
CPE 1.8 including Computer Software & Applications 1.8: The provider is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. CPE Credit: Maximum Credit Hours: 1.8 each session (based on a 50 minute credit hour). You must attend at least 50 minutes to obtain credit. Field of Study: Computer Software & Applications for 1.8 hours. Prerequisite: Level of Knowledge: Intermediate. Teaching Method: Seminar/Lecture. Advance Preparation: None. Delivery Method: Group Internet Based. Please refer to the information in this brochure for outline, course content and objectives. Upon completion of this course, you will receive a certificate of attendance. Final approval of a course for CPE credit belongs with each state's regulatory board.
Please note: In order to receive CPE credit for this course you MUST use the streaming audio option, as well as enable and complete the required progress checks.
Who should attend?
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers, and accountants.Faculty
Mike ThomasUK-based IT trainer with a career spanning over 30 years
- Has delivered thousands of courses and produced hundreds of written and video-based tutorials
- Subject matter expert in a range of technologies with a primary focus and passion for Microsoft Office®, especially Excel®, on both the Windows and Mac platforms, and Power BI®
- A fellow of The Learning and Performance Institute
- Has worked with, and for many global and UK-based companies, and organizations across a diverse range of industries which includes healthcare, pharmaceutical, and the public sector
- Designs and develops Microsoft Office-based solutions that automate key business tasks, and processes
