Course Detail(IT076 : Introduction to R for Excel Users)

IT076 : Introduction to R for Excel Users NEW

7.00 CPE Hours (Others)
Classroom

Please be informed that in view of the current COVID-19 situation, we will be changing the format of this course into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account. 


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.

Competency Mapping

Others = 7.00 Hours

Schedule & Fees

Date & Time

19 Mar 2020 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Date & Time

14 Aug 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Date & Time

29 May 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Testimonial

Funding

No funding Available!

Programme Facilitator(s)


Dr Lim Thou Tin
DBA, MKM, MInfSys, DipSA, DipIntelligentSys
DipMgtConsultancy, DipT&D, BBA, MFP (FAAFM)

 
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling. He is a fellow of the American Academy of Financial Management.
 
His work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia and Thailand.

Please be informed that in view of the current COVID-19 situation, we will be changing the format of this course into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account. 


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.

Competency Mapping

Others = 7.00 Hours

Programme Facilitator(s)

Dr Lim Thou Tin
DBA, MKM, MInfSys, DipSA, DipIntelligentSys
DipMgtConsultancy, DipT&D, BBA, MFP (FAAFM)

 
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling. He is a fellow of the American Academy of Financial Management.
 
His work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia and Thailand.

Upcoming Schedule

Registration is closed

Date & Time

19 Mar 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 348.28
For Non-Members: $ 450.68

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709