Master data analytics and visualization for accounting with Excel, Tableau, and VBA programming. Perfect for beginners.
Master data analytics and visualization for accounting with Excel, Tableau, and VBA programming. Perfect for beginners.
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 Accounting Data Analytics 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.8
(429 ratings)
28,708 already enrolled
Instructors:
English
پښتو, বাংলা, اردو, 3 more
What you'll learn
Learn fundamental principles of data visualization and analysis
Master Excel and Tableau for financial data analysis
Develop skills in predictive analytics and statistical modeling
Understand the FACT framework for data-driven decision making
Gain practical experience with VBA programming
Create effective data visualizations for financial reporting
Skills you'll gain
This course includes:
8.5 Hours PreRecorded video
28 quizzes
Access on Mobile, Tablet, Desktop
FullTime access
Shareable certificate
Closed caption
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 9 modules in this course
This comprehensive course bridges traditional accounting with modern data analytics. Students learn the FACT framework (Frame, Assemble, Calculate, Tell) for data-driven decision making, focusing on data visualization principles and analytical tools. The curriculum covers Excel and Tableau for data analysis, regression techniques, and introduces programming through VBA. Practical examples and hands-on exercises help develop skills in creating effective visualizations and performing advanced data analysis.
Course Introduction and Module 1: Introduction to Accountancy Analytics
Module 1 · 1 Hours to complete
Introduction to Accountancy Analytics
Module 2 · 1 Hours to complete
Accounting Analysis and an Analytics Mindset
Module 3 · 2 Hours to complete
Data and its Properties
Module 4 · 2 Hours to complete
Data Visualization 2
Module 6 · 1 Hours to complete
Analytic Tools in Excel 1
Module 7 · 3 Hours to complete
Analytic Tools in Excel 2
Module 8 · 2 Hours to complete
Automation in Excel
Module 9 · 2 Hours to complete
Fee Structure
Instructor
Senior Lecturer of Accountancy and Teaching and Learning Faculty Innovation Scholar
Ronald Guymon is a Senior Lecturer of Accountancy at the University of Illinois Urbana-Champaign, where he has been teaching since 2018. He holds a Ph.D. in Accounting from the University of Iowa, earned in 2008, as well as both a Bachelor’s and Master’s degree in Accounting from Brigham Young University. With a strong focus on data analytics within accounting, Professor Guymon teaches courses such as "Accounting Data Analytics with Python" and "Introduction to Accounting Data Analytics and Visualization," equipping students with the skills necessary to leverage data for informed decision-making in business contexts.In addition to his teaching role, Guymon is recognized as a Teaching and Learning Faculty Innovation Scholar, reflecting his commitment to enhancing educational practices. He has extensive experience in applying data analytics across various industries, having served in roles such as Chief Data Officer for multiple organizations. His research interests include the intersection of accounting and data analytics, with publications addressing topics like performance measurement and the impact of data on decision-making processes. Through his innovative teaching methods and practical insights, Ronald Guymon continues to influence the next generation of accountants and business leaders at UIUC.
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.
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.