Course Detail(BAR2.0 : Business Analytics and Reporting (BAR) (Live Webinar))

BAR2.0 : Business Analytics and Reporting (BAR) (Live Webinar) NEW

21.00 CPE Hours (Others)
Blended


The course content has been revised and duration has been changed to 3 days. This programme will be delivered through blended learning and includes an e-learning module with self-practice exercises and 2.5 days live webinar with hands-on exercises. The AER e-learning module has to be completed before you attend the live webinar.

Programme Objective

Good action-oriented management reports are the basis for effective and successful businesses. Survey shows that 6 out of 10 CFOs in Singapore say their finance department devotes 50% or more of its time on grunt work of transaction processing and monthly closing activities, thereby hindering the generation of such action-oriented reports.
 
This course shows you how to improve your productivity in reporting and analytical work by combining the various tools and features of Microsoft Excel to fulfill your monthly financial reporting, financial analysis and budgeting tasks. With this, the participant will be able to deliver high quality and timely reports and dashboards to support organizational reporting for more effective organizational decision making.
 

To try it out yourself, you may download the Demo File here.


At the end of the course, participants will be able to:
 
•          Design an appropriate database to support all reporting requirements
•          Build sustainable excel-based reporting models
•          Develop interactive models for decision making
•          Create value-adding Excel reports through use of visual and graphical skills

Programme Outline


1-Day (AER2.0) Introduction to Excel for Reporting (E-learning & Live Webinar) -  7-Hour

The AER programme is a prelude to the Business Analytics & Reporting (BAR) programme, providing in-depth knowledge of Excel functions such as Hlookup, Vlookup, offset, Index, IF, etc., which is crucial in optimizing learning during the BAR programme.
 
The AER version 2.0 programme consists of 3.5-hour of e-learning module with self-practice exercises and 3.5-hour of live webinar (Virtual classroom) training, is complimentary to participants who enroll for the full BAR programme.
 
Participants who are interested to find out more about AER may click on "Introduction to Excel for Reporting (AER2.0)" for more details
.


2-Days Business Analytics & Reporting (BAR2.0) (Live Webinar) – 14 -Hour

The BAR programme will show participants how to combine the various advanced tools and features of Excel to automate and solve monthly financial reporting, financial analysis and budgeting tasks.

 

  • PART 1: Database creation, Advanced Excel Functions, Business Reporting Model
  • PART 2: Budgeting and Planning Cycle


Unlike other Excel driven courses, the BAR programme prides itself on being designed to be application-focused within an accounting context. This means that skills learnt can be readily deployed at the workplace and results can be immediate

 
If you wish to bundle BAR with our NEW IT078: 1-Day Enhancing your Business Analytics Capability with Power BI (Live Webinar) (7 CPE Hour) 
Please click here to enrol. 


This unique programme will show participants how to combine the various tools and features of Power BI to publish and share monthly financial reports.
 

  1. Getting Data, Shaping and Transforming Data
  2. Modeling and visualizations
  3. Publishing and Sharing

 
Unlike other Power BI courses, this 1-day Enhancing your Business Analytics Capability with Power BI, an extension of the BAR programme is designed to be application-focused within an accounting context.

This means that skills learnt can be readily deployed at the workplace and the results can be immediate. Please click here to find out more.

Training Methodology

This interactive workshop includes a 3.5-hour e-learning module with self-practice exercises and a 14-hour live webinar with computer hands-on exercises.

Closing Date for Registration

1 week before programme or until full enrolment.

Intended For

This programme is especially suitable for CFOs, Financial Controllers, Analysts, Accountants, Finance Managers, Bankers, Businessmen who find generating reports too time-consuming and rigid for analysis purposes. This programme will also suit Business leaders who want to achieve a higher level of expertise for management reporting.

Competency Mapping

Others = 21.00 Hours

Schedule & Fees

Date & Time

11 Dec 2020 (9:00 AM - 12:30 PM)
14 Dec 2020 (9:00 AM - 5:00 PM)
15 Dec 2020 (9:00 AM - 5:00 PM)

There are no seats available.

Fee (inclusive of GST)

For Members: $ 1,605.00   $ 1,284.00
For Non-Members: $ 1,926.00   $ 1,540.80
Discount till 31 Dec 2020

Programme Facilitator(s)

Jasmine Ng

Venue

Online Classroom in or outside of
Singapore

Date & Time

15 Jan 2021 (9:00 AM - 12:30 PM)
20 Jan 2021 (9:00 AM - 5:00 PM)
21 Jan 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

16 Feb 2021 (9:00 AM - 12:30 PM)
22 Feb 2021 (9:00 AM - 5:00 PM)
23 Feb 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Jasmine Ng

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

18 Mar 2021 (9:00 AM - 12:30 PM)
24 Mar 2021 (9:00 AM - 5:00 PM)
25 Mar 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Wong Suet Yin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

16 Apr 2021 (9:00 AM - 12:30 PM)
19 Apr 2021 (9:00 AM - 5:00 PM)
20 Apr 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

12 May 2021 (9:00 AM - 12:30 PM)
19 May 2021 (9:00 AM - 5:00 PM)
20 May 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Jasmine Ng

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

09 Jun 2021 (9:00 AM - 12:30 PM)
14 Jun 2021 (9:00 AM - 5:00 PM)
15 Jun 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Wong Suet Yin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

09 Jul 2021 (9:00 AM - 12:30 PM)
12 Jul 2021 (9:00 AM - 5:00 PM)
13 Jul 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Wong Suet Yin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

11 Aug 2021 (9:00 AM - 12:30 PM)
16 Aug 2021 (9:00 AM - 5:00 PM)
17 Aug 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Jasmine Ng

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

10 Sep 2021 (9:00 AM - 12:30 PM)
15 Sep 2021 (9:00 AM - 5:00 PM)
16 Sep 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Wong Suet Yin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

13 Oct 2021 (9:00 AM - 12:30 PM)
18 Oct 2021 (9:00 AM - 5:00 PM)
19 Oct 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Jasmine Ng

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

12 Nov 2021 (9:00 AM - 12:30 PM)
15 Nov 2021 (9:00 AM - 5:00 PM)
16 Nov 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Wong Suet Yin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

07 Dec 2021 (9:00 AM - 12:30 PM)
13 Dec 2021 (9:00 AM - 5:00 PM)
14 Dec 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Jasmine Ng

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

20 Nov 2020 (9:00 AM - 12:30 PM)
23 Nov 2020 (9:00 AM - 5:00 PM)
24 Nov 2020 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Wong Suet Yin

Date & Time

09 Oct 2020 (9:00 AM - 12:30 PM)
14 Oct 2020 (9:00 AM - 5:00 PM)
15 Oct 2020 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Testimonial


This course is a very intensive course which covered a lot of excel functions which are useful for data analysis and presentation. I can now create awesome excel files to automate data analysis and aid decision making.


There are many reports that can be generated with just Excel alone which can be used for not only reporting but also in advertising and marketing collaterals.

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.

Wong Suet Yin
CA (Singapore) 

 
Suet Yin graduated from the National University of Singapore with an accounting degree and is a member of the Institute of Singapore Chartered Accountants (ISCA). 
 
She has more than 20 years of working experience in the area of accounting, tax, project management and training. She held several management positions with large MNCs. Suet Yin is very passionate in training and is always ready to share her knowledge with others. She adopts a pragmatic real world approach during training and believes in 'fun - have a good time'.

Jasmine Ng
CA (Singapore), FCCA, ACTA, DACE


Jasmine Ng is a Fellow member of the Association of Chartered Certified Accountants (ACCA) and a member of the Institute of Singapore Chartered Accountants (ISCA). She has over 18 years of extensive experience in the area of audit, accounting, financial analysis, business controlling, enterprise system implementation and training. She travelled extensively during the course of her work and gain exposure to different culture and work style.

She utilizes her creativity and real-world examples in conducting her training. Jasmine is passionately fond of training and always willing to share with others all that she knows. Her outgoing, pleasant personality and confident disposition have made her training all the more lively, fun and insightful.
 


The course content has been revised and duration has been changed to 3 days. This programme will be delivered through blended learning and includes an e-learning module with self-practice exercises and 2.5 days live webinar with hands-on exercises. The AER e-learning module has to be completed before you attend the live webinar.

Programme Objective

Good action-oriented management reports are the basis for effective and successful businesses. Survey shows that 6 out of 10 CFOs in Singapore say their finance department devotes 50% or more of its time on grunt work of transaction processing and monthly closing activities, thereby hindering the generation of such action-oriented reports.
 
This course shows you how to improve your productivity in reporting and analytical work by combining the various tools and features of Microsoft Excel to fulfill your monthly financial reporting, financial analysis and budgeting tasks. With this, the participant will be able to deliver high quality and timely reports and dashboards to support organizational reporting for more effective organizational decision making.
 

To try it out yourself, you may download the Demo File here.


At the end of the course, participants will be able to:
 
•          Design an appropriate database to support all reporting requirements
•          Build sustainable excel-based reporting models
•          Develop interactive models for decision making
•          Create value-adding Excel reports through use of visual and graphical skills

Programme Outline


1-Day (AER2.0) Introduction to Excel for Reporting (E-learning & Live Webinar) -  7-Hour

The AER programme is a prelude to the Business Analytics & Reporting (BAR) programme, providing in-depth knowledge of Excel functions such as Hlookup, Vlookup, offset, Index, IF, etc., which is crucial in optimizing learning during the BAR programme.
 
The AER version 2.0 programme consists of 3.5-hour of e-learning module with self-practice exercises and 3.5-hour of live webinar (Virtual classroom) training, is complimentary to participants who enroll for the full BAR programme.
 
Participants who are interested to find out more about AER may click on "Introduction to Excel for Reporting (AER2.0)" for more details
.


2-Days Business Analytics & Reporting (BAR2.0) (Live Webinar) – 14 -Hour

The BAR programme will show participants how to combine the various advanced tools and features of Excel to automate and solve monthly financial reporting, financial analysis and budgeting tasks.

 

  • PART 1: Database creation, Advanced Excel Functions, Business Reporting Model
  • PART 2: Budgeting and Planning Cycle


Unlike other Excel driven courses, the BAR programme prides itself on being designed to be application-focused within an accounting context. This means that skills learnt can be readily deployed at the workplace and results can be immediate

 
If you wish to bundle BAR with our NEW IT078: 1-Day Enhancing your Business Analytics Capability with Power BI (Live Webinar) (7 CPE Hour) 
Please click here to enrol. 


This unique programme will show participants how to combine the various tools and features of Power BI to publish and share monthly financial reports.
 

  1. Getting Data, Shaping and Transforming Data
  2. Modeling and visualizations
  3. Publishing and Sharing

 
Unlike other Power BI courses, this 1-day Enhancing your Business Analytics Capability with Power BI, an extension of the BAR programme is designed to be application-focused within an accounting context.

This means that skills learnt can be readily deployed at the workplace and the results can be immediate. Please click here to find out more.

Training Methodology

This interactive workshop includes a 3.5-hour e-learning module with self-practice exercises and a 14-hour live webinar with computer hands-on exercises.

Closing Date for Registration

1 week before programme or until full enrolment.

Intended For

This programme is especially suitable for CFOs, Financial Controllers, Analysts, Accountants, Finance Managers, Bankers, Businessmen who find generating reports too time-consuming and rigid for analysis purposes. This programme will also suit Business leaders who want to achieve a higher level of expertise for management reporting.

Competency Mapping

Others = 21.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.
Wong Suet Yin
CA (Singapore) 

 
Suet Yin graduated from the National University of Singapore with an accounting degree and is a member of the Institute of Singapore Chartered Accountants (ISCA). 
 
She has more than 20 years of working experience in the area of accounting, tax, project management and training. She held several management positions with large MNCs. Suet Yin is very passionate in training and is always ready to share her knowledge with others. She adopts a pragmatic real world approach during training and believes in 'fun - have a good time'.

Jasmine Ng
CA (Singapore), FCCA, ACTA, DACE


Jasmine Ng is a Fellow member of the Association of Chartered Certified Accountants (ACCA) and a member of the Institute of Singapore Chartered Accountants (ISCA). She has over 18 years of extensive experience in the area of audit, accounting, financial analysis, business controlling, enterprise system implementation and training. She travelled extensively during the course of her work and gain exposure to different culture and work style.

She utilizes her creativity and real-world examples in conducting her training. Jasmine is passionately fond of training and always willing to share with others all that she knows. Her outgoing, pleasant personality and confident disposition have made her training all the more lively, fun and insightful.
 


Upcoming Schedule

Date & Time

15 Jan 2021 (9:00 AM - 12:30 PM)
20 Jan 2021 (9:00 AM - 5:00 PM)
21 Jan 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 1,605.00
For Non-Members: $ 1,926.00

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709