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, 3.5 hours live webinar and 2 days live webinar with hands-on exercises. The AER e-learning module has to be completed before you attend the live webinar.
For more information on how to access and use the E-Learning Course, please download a copy of the user guide here .
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
To view our Brochure, please click here.
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.
- Getting Data, Shaping and Transforming Data
- Modeling and visualizations
- 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.
Pre-requisites
Please take note of the following admission requirements:
- Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
- Mandatory for video camera to be turned on throughout the course
- Display your official name (as per NRIC) in Zoom, to facilitate attendance taking
Training Methodology
This interactive workshop includes a 3.5-hour e-learning module with self-practice exercises and a 14-hour Face-to-Face classroom 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.
Schedule & Fees
Testimonial
Funding
No funding Available!
Programme Facilitator(s)
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, 3.5 hours live webinar and 2 days live webinar with hands-on exercises. The AER e-learning module has to be completed before you attend the live webinar.
For more information on how to access and use the E-Learning Course, please download a copy of the user guide here .
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
To view our Brochure, please click here.
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.
- Getting Data, Shaping and Transforming Data
- Modeling and visualizations
- 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.
Pre-requisites
Please take note of the following admission requirements:
- Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
- Mandatory for video camera to be turned on throughout the course
- Display your official name (as per NRIC) in Zoom, to facilitate attendance taking
Training Methodology
This interactive workshop includes a 3.5-hour e-learning module with self-practice exercises and a 14-hour Face-to-Face classroom 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.
Programme Facilitator(s)
