Location
No.542/2, Peradeniya Road, Kandy
Call Us
0812239089
contact@lclcampus.com
IT Division
Advanced MS Excel
Master advanced Excel techniques to enhance your data management, reporting, and analysis skills. This course is tailored for professionals, students, and individuals looking to deepen their expertise in Excel for career advancement or personal use.
- Advanced Data Tables and Analysis (One-variable, Two-variable, Scenarios, Solver)
- Charting and Visualization (Charts, Sparklines, Data Markers)
- Advanced Functions and Formatting (Conditional Formatting, Statistical and Text Functions, Custom Number Formats)
- Macros and Automation (Recording Macros, VBA Basics, Assigning Macros)
- Data Management and Validation (Filtering, Sorting, Subtotals, Data Validation, Import/Export)
- PivotTables and Power View Reporting
- Security and Sharing (Password Protection, Sharing Workbooks, Named Ranges)
- Basic knowledge of MS Excel is required.
- Interactive, hands-on sessions with guided practice
- Real-world problem-solving exercises
- Personalized feedback and support
Entry Requirements
- Basic knowledge of MS Excel is required.
Teaching Methodology
- Interactive, hands-on sessions with guided practice
- Real-world problem-solving exercises
- Personalized feedback and support
Program Details
- Course Duration : 5 Day
Medium of Instruction
- English / Sinhala
- Advanced Data Tables and Analysis (One-variable, Two-variable, Scenarios, Solver)
- Charting and Visualization (Charts, Sparklines, Data Markers)
- Advanced Functions and Formatting (Conditional Formatting, Statistical and Text Functions, Custom Number Formats)
- Macros and Automation (Recording Macros, VBA Basics, Assigning Macros)
- Data Management and Validation (Filtering, Sorting, Subtotals, Data Validation, Import/Export)
- PivotTables and Power View Reporting
- Security and Sharing (Password Protection, Sharing Workbooks, Named Ranges)
Course outline
Program Details
Course Duration : 5 Day
Medium of Instruction : English / Sinhala
Schedule
Flexible schedule: Weekday or Weekend batches available)
Fees and Payment Plans
Rs. 12,000/=
Flexible payment options available upon request.
Assessments and Evaluation
- Practical exercises and real-world scenarios
- Feedback to strengthen learning outcomes
Recognition
Upon completion, students receive a certificate from LCL Campus, demonstrating their advanced Excel skills and expertise.
Frequently Asked Questions (FAQs)
Who can join this course?
Anyone with basic knowledge of MS Excel who wants to advance their skills, including professionals, students, and job seekers.
What are the key topics covered in this course?
Anyone with basic knowledge of MS Excel who wants to advance their skills, including professionals, students, and job seekers.
What is the duration of the course?
The course runs for 5 days, with flexible scheduling options for weekdays or weekends.
What is the course fee, and what does it include?
The course fee is Rs. 12,000, which includes all study materials and resources.
Will I receive a certificate upon completion?
Yes, a recognized certificate from LCL Campus will be awarded upon course completion.
What is the medium of instruction?
The course is conducted in both English and Sinhala to suit a diverse audience.
What teaching methods are used?
The course offers hands-on training, real-world problem-solving exercises, and personalized feedback.
Are there flexible payment options?
Yes, flexible payment plans are available upon request.
What career opportunities does this course offer?
Yes, flexible payment plans are available upon request.
How can I enroll?
Visit our campus, contact us via phone (081 22 39 314 / 077 38 38 136), email info@liveclass.lk, or register on our website at www.liveclass.lk.
Secure Your Spot Today !
Take the next step in mastering Excel and stand out in your professional or academic journey!
Latest News
Upcoming Events
Subcribe Our Newsletter
Stay updated on our latest work, upcoming events, and insider news
About Us
Welcome to LCL Campus, a premier educational institution that has been redefining learning and professional development since 2020.
Quick Links
Work Hours
- Monday :
- Tuesday :
- Wednesday :
- Thursday :
- Sunday :
- Friday :
- Saturday :
- Sunday :
- Closed
- 08.00 AM-05.00 PM
- 08.00 AM-05.00 PM
- 08.00 AM-05.00 PM
- 08.00 AM-05.00 PM
- 08.00 AM-05.00 PM
- 08.00 AM-05.00 PM
- 08.00 AM-05.00 PM
Copyright 2025 LCL Campus. All rights reserved
Copyright 2025 LCL Campus. All rights reserved
