What is your next education pathway?
Workshop on Advanced Excel for Professionals (English Medium) is tailored for professionals looking to master advanced Excel techniques to enhance productivity and data analysis skills. The course delves deep into Excel’s powerful features to optimize your workflow and improve decision-making.
Participants will start with a refresher on basic formulas, before progressing to more advanced tools like VLOOKUP, HLOOKUP, and INDEX functions. The course also covers essential Excel features such as filtering, working with forms, and date and time formulas. Students will learn how to perform statistical analysis, utilize advanced formulas, and create pivot tables for dynamic data analysis.
In addition, the workshop focuses on key business applications like trend analysis, scenario analysis, and financial functions, including IRR, to help participants make better financial decisions. Financial statement analysis will also be explored, providing the skills needed to assess and interpret company performance.
By the end of the workshop, participants will be proficient in using Excel’s advanced features to streamline tasks, perform complex analyses, and enhance their ability to present and interpret business data effectively. This course is ideal for professionals looking to sharpen their Excel expertise and drive better business outcomes.
Entry Requirements
Those who seek to learn Advanced Excel for use in a business environment
Commencement
- Pending
Programme Fees
Current Fee Structure
Course Fee: LKR 15,000 (Per Day)
Course Structure and Modules
Basic Formulas
Filtering
Vlookup, Hlookup, Index
Working with forms
Date and Time Formulas
Database Functions
Statistical Analysis
Advanced Formulas & other advanced features with pivot tables
Trend Analysis & Graphs
Scenario Analysis
Financial Functions (with IRR)
Financial Statement Analysis