This comprehensive Excel Data Analysis with DAX course equips you with the skills to transform raw data into actionable insights using powerful Excel functions and DAX formulas. Begin by mastering DAX fundamentals—understand how DAX works in Excel to build dynamic and interactive reports. Learn to enhance your spreadsheets by inserting checkboxes, PDFs, images, and PowerPoint content. Customize your reports with tick marks, barcodes, watermarks, and optimized cell formatting. Progress to advanced Excel features—use Flash Fill, Index Match, round-off, and statistical functions for efficient data processing. Organize and visualize data with precision using AutoSum, filters, slicers, and sorting techniques.
Excel Data Analysis and DAX Essentials Course
Excel Data Analysis and DAX Essentials Course
Instructor: Priyanka Mehta
Access provided by Orascom Construction
Gain insight into a topic and learn the fundamentals.
Beginner level
Recommended experience
4 hours to complete
Flexible schedule
Learn at your own pace
What you'll learn
Apply DAX formulas to perform advanced calculations in Excel
Integrate PDFs, images, and PowerPoint into your Excel reports
Use functions like Flash Fill, Index Match, and statistical tools for data processing
Organize and visualize data with filters, slicers, and formatting tools
Skills you'll gain
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
7 assignments
Taught in English
Recently updated!
June 2025
See how employees at top companies are mastering in-demand skills
There are 2 modules in this course
Master DAX fundamentals and enhance your Excel skills with this hands-on module. Learn how DAX works in Excel, use checkboxes for interactive data, and integrate external content like PDFs, images, and PowerPoint files. Explore advanced formatting techniques, insert tick marks, watermarks, resize cells, and generate barcodes. Ideal for professionals seeking advanced Excel capabilities.
What's included
10 videos1 reading4 assignments
Boost your Excel data analysis skills with DAX formulas and advanced data processing techniques. Learn to use Flash Fill, hyperlinks, round-off functions, standard deviation, and Index Match for efficient data transformation. Master sorting, AutoSum, slicers, and filters to streamline reporting and make your spreadsheets more dynamic and insightful.
What's included
10 videos3 assignments
Instructor
Offered by
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."