Data Visualization in Excel
Become proficient in Excel's visualization tools to design compelling charts, dashboards, and interactive reports that effectively convey data insights.
Become proficient in Excel's visualization tools to design compelling charts, dashboards, and interactive reports that effectively convey data insights.
This course cannot be purchased separately - to access the complete learning experience, graded assignments, and earn certificates, you'll need to enroll in the full Excel Skills for Data Analytics and Visualization Specialization program. You can audit this specific course for free to explore the content, which includes access to course materials and lectures. This allows you to learn at your own pace without any financial commitment.
4.9
(1,152 ratings)
64,084 already enrolled
Instructors:
English
پښتو, বাংলা, اردو, 3 more
Powered by
What you'll learn
Create dynamic visualizations using conditional formatting and sparklines
Master various chart types and customization techniques
Develop specialized and custom charts for specific data needs
Build interactive dashboards with slicers and macros
Use pivot tables and pivot charts for data analysis
Create responsive and aesthetic reports
Skills you'll gain
This course includes:
4.5 Hours PreRecorded video
29 quizzes
Access on Mobile, Tablet, Desktop
FullTime access
Shareable certificate
Get a Completion Certificate
Share your certificate with prospective employers and your professional network on LinkedIn.
Created by
Provided by
Top companies offer this course to their employees
Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.
There are 7 modules in this course
This comprehensive course focuses on advanced data visualization techniques using Excel. Students learn to create dynamic visualizations using conditional formatting, sparklines, specialized charts, and interactive dashboards. The curriculum covers charting techniques, pivot tables, data summarization, and dashboard design. Through practical case studies, participants develop skills in creating effective visualizations for trend analysis, forecasting, and data storytelling. The course emphasizes both technical proficiency and design principles for creating impactful business intelligence solutions.
Welcome and critical information
Module 1 · 53 Minutes to complete
Data Visualizations using Conditional Formatting, Sparklines and Number Formats
Module 2 · 3 Hours to complete
Mastering charting techniques
Module 3 · 3 Hours to complete
Specialized charts
Module 4 · 2 Hours to complete
Create an Interactive Dashboard Using Pivot Charts and Slicers
Module 5 · 3 Hours to complete
Complete the Dashboard with Creative Visualisations and Dynamic Charts
Module 6 · 2 Hours to complete
Final assessment
Module 7 · 1 Hours to complete
Fee Structure
Instructors
Inspirational Lecturer in Commerce and Business Analytics with a Focus on Student Engagement
Dr. Prashan Karunaratne is an innovative lecturer in commerce, economics, and business analytics at Macquarie University, renowned for his catchphrase, #EveryoneSayWow. He is the course developer and instructor of the acclaimed Excel Skills for Business course, which received the Coursera Outstanding Educator Award for Student Transformation in 2018. Prashan has earned several teaching accolades, including the 2019 Outstanding Contribution to Student Learning award at the Australian Awards for University Teaching, recognizing his excellence in engaging and empowering students. In 2020, he was honored with the inaugural Australian Business Deans Council Award for Innovation and Excellence in Teaching and Learning. Prashan holds a PhD in Management – Learning & Teaching from Macquarie University and is the Course Director of the Bachelor of Commerce, the largest degree program at the university.
Innovative Educator and Excel Expert at Macquarie University
Nicky Bull is a Lecturer and Lead Content Designer at Macquarie University, where she leverages her extensive experience in technology and education to empower students in their learning journeys. With 15 years of commercial experience as a computer programmer and analyst, along with over a decade dedicated to designing and delivering educational programs, Nicky has established herself as a dynamic corporate trainer and consultant. She is particularly known for her role as the lead content designer for the highly acclaimed "Excel Skills for Business" course, which received the Coursera Outstanding Educator Award for Student Transformation in 2018. Nicky's passion lies in enabling individuals to confidently use technology to enhance their professional skills.In addition to her teaching responsibilities, Nicky offers a variety of courses on Excel, including "Data Visualization in Excel," "Excel Fundamentals for Data Analysis," and several levels of "Excel Skills for Business." She holds a BSc Hons in Computer Science, a BA in English Literature, and a Postgraduate Certificate in Education, all from the University of the Witwatersrand in South Africa. Her commitment to fostering effective learning environments makes her a valuable asset to both her students and the broader educational community.
Testimonials
Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.
4.9 course rating
1,152 ratings
Frequently asked questions
Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.