The objective of the program is to equip learners with the essential skills to manipulate, analyse, and visualize data effectively using Excel. Participants will explore various data analytics techniques, including data cleaning, sorting, filtering, and creating insightful visualizations. By the end of the program, attendees will have the proficiency to leverage Excel for data-driven decision-making, empowering them to extract valuable insights and drive informed business strategies.
| Target group: | Business professionals: Individuals working in various business roles, such as analysts, managers, consultants, and executives, who want to enhance their data analysis skills using Excel. |
| Duration: | 6 hours |
| Schedule: | 5th November, 2025 from 9.00 AM - 1.00PM |
| Medium: | English |
| Mode: | Online (4 hour Zoom workshop + 2 hour self learning material) |
| Fee: | Rs. 15,000.00 per participant |
A certificate will be offered after the successful completion of the program.
Program Outline
- Cleaning and transforming data
- Summarizing data
- Pivot tables
- Grouping, relationships
- What-if analysis
- Linear optimization with Solver
- Data models
- Visualizing data
- Charts and slicers
- Dashboards
How to Apply?
- Fill the online application form at: https://www.uomba.net/programs/24/apply
Payment Instructions
- The course fee of Rs. 15,000/- may be paid at any Bank of Ceylon branch in favor of University of Moratuwa, A/C No: 70993353, Bank of Ceylon, Katubedda..
- Online bank transfers are also accepted. But ATM/CDM machine payments are not accepted.
- For physical bank payments write the payment reference as: "Training Program on Business Data Analysis with SQL".
- For online payments put the payment reference as: "SC-Excel".
Contact
Phone: 011 264 0270 (office hours), 077 665 4482
Email: supungs@uom.lk
