Excel Accounting with R

Author

Jianyuan(Andy) Hu

Description

This seminar provides hands-on experience in completing a comprehensive data project and is designed by accountants for accountants. Participants will explore the powerful, popular open-source analytical solution R and even better, how to integrate R right into your Excel workbooks, inspiring you to enhance your accounting Life. We will delve into the mindset of analytics professionals and explore the synergy between analytics and accounting. The seminar will conclude with an overview of the current analytics and technology landscape, highlighting how accountants can capitalize on these trends. This course is designed to be welcoming for those new to analytics.

Length

8 hours.

Key Takeaways

Upon completion of this course, you will understand:

  • Introduction to R: Learn the fundamentals of R, an open-source data-focused programming language for beginners.

  • Super charge Excel with R: How to create and run R programs in Excel workbooks and supercharge your Excel productivity.

  • Data Management with R: Gain skills in importing, exporting, and processing data using R.

  • Advanced Data Visualization Techniques: Discover how to create impactful visualizations with R.

  • Automate Reporting with R: Build a practical department distribution workflows with R.

  • Data Management with R: Gain skills in importing, exporting, and processing data using R.

  • Navigating the Analytics Landscape: Understand the current trends in analytics and data technology, along with foundational concepts of cloud computing.

Target Audience

This course caters to several professionals, including the following groups:

  • Analysts: Ideal for those with access to detailed data who seek to automate professional reports and visualizations using free open-source tools.

  • Managers: Designed for managers looking for inspiration and strategies to boost team productivity in reporting, particularly within budget constraints, or those interested in enhancing their understanding of modern analytics processes.

Prerequisite(s)

No previous programming knowledge required. This is beginner friendly session.

To get the most out of this session, you should have a few years of experience using Microsoft Excel. You should be comfortable with concepts like Pivot Tables, lookups, and basic functions such as SUM and SUMIFS.