Note: To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop, pre-installed with Basic Excel R Toolkit and either Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version. Please go to https://bert-toolkit.com/download-bert to download Basic Excel R Toolkit.
This course will be conducted via Zoom. The link will be sent to you 2 days prior to the course date.
Programme Objective
Data science and big data has now become a common terminology in many business circles from business intelligence to accounting and finance. Analytics, the practice of converting collected data into information, has become an essential skill needed to run your business successfully. Common applications of analytics include the study of business data using mathematical and statistical analysis to discover and understand patterns which will help predict and improve business performance in the future.
Excel has been the main working tool for many accounting and financial professionals. However occasionally it falls short, and that’s where R can kick in: Excel does not handle big data sets well. Excel does not offer robust statistical functionality. A simple statistical task like creating a histogram is surprisingly labor-intensive in Excel. More advanced procedures like multiple regression usually require paid add-on packages.
R like Python is a programming language designed for processing, analyzing and visualizing data. In recent years, R has become popular in business. It can now be found across industries (accounting and financial services, technology, retail, etc.) and job functions (marketing, operations, accounting and finance, etc.).
The focus of this course is on understanding and applying simple data manipulations from an Excel application perspective: importing, manipulating, transforming, combining and summarizing data for business analysis and reporting.
Programme Outline
1. Introduction to R & Setup
2. Storing of Values
3. Manipulation, Transformation, Combination and Summarizing Operations
4. Data Querying and Simple Statistics
5.Testing Conditions and Iterative Execution
6. Importing and Exporting Data
7. Generating Reports For Analysis
Prerequisite knowledge
Knowledge of Excel with some working knowledge of macros will be useful
Training Methodology
Lecture style, with computer hands-on Exercises
Closing Date for Registration
1 week before programme or until full enrolment
Intended For
Accounting professionals who wish to learn the R programming language and apply them to their work. Any participants who wish to gain introductory knowledge on R are welcome.
Schedule & Fees
Testimonial
Funding
No funding Available!
Programme Facilitator(s)
Note: To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop, pre-installed with Basic Excel R Toolkit and either Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version. Please go to https://bert-toolkit.com/download-bert to download Basic Excel R Toolkit.
This course will be conducted via Zoom. The link will be sent to you 2 days prior to the course date.
Programme Objective
Data science and big data has now become a common terminology in many business circles from business intelligence to accounting and finance. Analytics, the practice of converting collected data into information, has become an essential skill needed to run your business successfully. Common applications of analytics include the study of business data using mathematical and statistical analysis to discover and understand patterns which will help predict and improve business performance in the future.
Excel has been the main working tool for many accounting and financial professionals. However occasionally it falls short, and that’s where R can kick in: Excel does not handle big data sets well. Excel does not offer robust statistical functionality. A simple statistical task like creating a histogram is surprisingly labor-intensive in Excel. More advanced procedures like multiple regression usually require paid add-on packages.
R like Python is a programming language designed for processing, analyzing and visualizing data. In recent years, R has become popular in business. It can now be found across industries (accounting and financial services, technology, retail, etc.) and job functions (marketing, operations, accounting and finance, etc.).
The focus of this course is on understanding and applying simple data manipulations from an Excel application perspective: importing, manipulating, transforming, combining and summarizing data for business analysis and reporting.
Programme Outline
1. Introduction to R & Setup
2. Storing of Values
3. Manipulation, Transformation, Combination and Summarizing Operations
4. Data Querying and Simple Statistics
5.Testing Conditions and Iterative Execution
6. Importing and Exporting Data
7. Generating Reports For Analysis
Prerequisite knowledge
Knowledge of Excel with some working knowledge of macros will be useful
Training Methodology
Lecture style, with computer hands-on Exercises
Closing Date for Registration
1 week before programme or until full enrolment
Intended For
Accounting professionals who wish to learn the R programming language and apply them to their work. Any participants who wish to gain introductory knowledge on R are welcome.
Programme Facilitator(s)
