user 545153

This comprehensive Microsoft Excel Course is designed to take learners from basic spreadsheet skills to advanced data analysis techniques. With a total of 30 hours of practical training, the program covers essential Excel functions, data handling, visualization, and automation tools used in modern workplaces.

Participants will begin by learning Excel fundamentals such as data entry, formatting, formulas, and charts. The course then progresses to advanced topics including lookup functions, PivotTables, dashboards, data cleaning, and basic automation using macros.

Through hands-on exercises and real-world examples, learners will gain the confidence to use Excel efficiently for academic, professional, and business purposes.

Course Structure (ADVANCED LEVEL – MICROSOFT EXCEL):

Module 1: Excel Basics & Interface (2 Hrs)
Module 2: Data Entry, Formatting & Validation (3 Hrs)
Module 3: Basic Formulas & Functions (4 Hrs)
Module 4: Conditional Formatting & Basic Charts (3 Hrs)
Module 5: Introduction to PivotTables & Data Handling (3 Hrs)
Module 6: Advanced Formulas & Functions (4 Hrs)
Module 7: Data Cleaning & Large Dataset Handling (3 Hrs)
Module 8: Advanced PivotTables & PivotCharts (3 Hrs)
Module 9: Charts, Dashboards & Reports (3 Hrs)
Module 10: What-If Analysis & Basic Automation (2 Hrs)
Final Assessment : Practical

Learning Outcomes:

Understand Excel interface, workbooks, worksheets, and navigation
Enter, edit, and format data professionally
Apply number formats and data validation tools
Use basic formulas and core functions (SUM, AVERAGE, COUNT, etc.)
Apply conditional formatting to highlight important data
Create and interpret basic charts
Sort, filter, and summarize data using simple PivotTables
Use advanced formulas including IF, AND, OR, VLOOKUP, XLOOKUP,
SUMIFS, and COUNTIFS
Apply text functions to clean and structure data
Handle large datasets efficiently
Clean and organize inconsistent data
Create advanced PivotTables and PivotCharts
Design interactive dashboards with slicers
Perform what-if analysis for decision making
Record and use simple macros for automation

Target Audience:

Beginners with little or no Excel experience
Students preparing for academic or professional work
Office staff and administrative professionals
HR, finance, and business professionals
Entrepreneurs and small business owners
Anyone who wants to improve productivity using Excel

Certification : Certificate provided upon completion of the Final Assessment and attendance. (70% attendance is a must to receive the certificate. Special permission must be taken if there are difficulties in joining.)

Customized sessions available:
Can book sessions for required topics or to clarify doubts.
Training per hour: 2500/=

Group Training: 15,000/=

Installments:

Reg Fee: LKR 5,000/=
End of first month: LKR 5,000/=
End of second month: LKR 5.000/=

This comprehensive Microsoft Excel Course is designed to take learners from basic spreadsheet skills to advanced data analysis techniques. With a total of 30 hours of practical training, the program covers essential Excel functions, data handling, visualization, and automation tools used in modern workplaces.

Participants will begin by learning Excel fundamentals such as data entry, formatting, formulas, and charts.

Course Structure (BEGINNER LEVEL – MICROSOFT EXCEL):

Module 1: Excel Basics & Interface (2 Hrs)
Module 2: Data Entry, Formatting & Validation (3 Hrs)
Module 3: Basic Formulas & Functions (4 Hrs)
Module 4: Conditional Formatting & Basic Charts (3 Hrs)
Module 5: Introduction to PivotTables & Data Handling (3 Hrs)

Learning Outcomes:

Understand Excel interface, workbooks, worksheets, and navigation
Enter, edit, and format data professionally
Apply number formats and data validation tools
Use basic formulas and core functions (SUM, AVERAGE, COUNT, etc.)
Apply conditional formatting to highlight important data
Create and interpret basic charts
Sort, filter, and summarize data using simple PivotTables

Target Audience:

Beginners with little or no Excel experience
Students preparing for academic or professional work
Office staff and administrative professionals
HR, finance, and business professionals
Entrepreneurs and small business owners
Anyone who wants to improve productivity using Excel

Individual Training: 25,000/=

Group Training: 12,500/= (2 Students)

Group Training: 10,000/= (3+ Students)

One-day / Individual online training program
(Conversation practice)

Introducing yourself
Using S.T.A.R approach
Confidence & Politeness
Handling Difficult Questions

LKR 5,000/=

Designed for Entry-Level Job Seekers

Training: 6 Hours

Are you looking to start your career in HR, Accounts, or Administration but don’t have payroll experience?

This practical payroll training program is designed to give you job-ready skills that employers actually look for.

What You Will Learn:

🔹 System Introduction
▫️ Overview of payroll software
▫️ Understanding dashboard & menu structure
🔹 Master File Setup
▫️ Employee master file creation
▫️ Entering employee details (EPF/ETF, NIC, bank details, salary structure)
▫️ Department & designation setup
▫️ Earnings & Deductions setup
▫️ Basic salary, allowances, overtime
▫️ EPF, ETF, APIT/PAYE, loans, no-pay
▫️ Linking earnings & deductions to employees
🔹 Payroll Processing
▫️ Processing monthly payroll
▫️ Checking payroll calculations accurately
🔹 Report Generation
▫️ Pay Sheet
▫️ Item Summary
▫️ Payroll Summary
🔹 Final Practical Session
▫️ Full payroll cycle practice
▫️ Error checking & corrections

Why This Course Is Important for You:

Gain practical payroll system knowledge
Improve your CV with in-demand HR/Accounts skills
Increase your chances of getting shortlisted
Learn exactly what companies expect from payroll

Perfect for:

Fresh graduates
Entry-level job seekers
HR & Accounts beginners

Limited seats available.
Message us for more details & registration information.

https://forms.gle/qHRudhfYggKwFLNX9

LKR 5,000/= (6 Hours Training)

Workshop – 3 hrs training ( HR Expert )
HR interview questions | Answer structuring
Spoken English ( English Trainer ) practice: 10 sessions (30min)
Email writing
Recruiter advice ( Candidate pro tips )
ATS friendly CV template.

You will get:

Expert-led training by HR & English professionals
Real interview questions with smart answers
Improve fluency, clarity & confidence in English
Professional email communication skills

Outcome:

PASS INTERVIEWS WITH CONFIDENCE

LKR 5,000/=

Practical Online Training Program
Duration: 2 Months
Classes: Every Saturday
Time: 7.00 PM – 10.00 PM
Online Training
Recordings Provided

Topics Covered:

SUM, IF, SUMIFS, VLOOKUP/XLOOKUP Formulas
Payroll Calculations & Salary Sheets
Pivot Tables for Payroll Reports
Excel Tables for Dynamic Data Handling
Data Validation (Dropdown Lists & Input Controls)
Conditional Formatting to Identify Errors
Freeze Panes & Professional Formatting
Data Cleaning & Removing Duplicates
Workbook Protection for Sensitive Payroll Data

Designed for:

Students, Interns, Assistants,
Executives and HR Professionals.

ONLINE – SELF LEARN
Flexible training
Duration 1-month
Certificate provided upon completion
Medium : Sinhala
Extra trainer support : book 1 hr sessions (Optional)

Explainatory training videos
Screen recordings of Sales driven FB Ad boosting, Social media management (TikTok, Facebook ,Instagram)
Analyzing Analytics Google Analytics, Google Console, FB Ads
Email Marketing
Content Creation : Canva training (Sinhala and English) All about Canva
Branding, Personal branding
A- Z on how to market your product or business as a beginner

What You’ll Learn:

First Module – FREE: Try it before you pay. Start learning at no cost.
Learn at Your Own Pace: Watch videos anytime, anywhere. Perfect for busy students and professionals.
Workplace Ready: Learn the tools and skills used in real corporate jobs.
No Experience Needed: Prepare for internships and entry-level roles with a job-ready portfolio.
Entrepreneurship Skills: Learn how to start your own brand, run ads, and increase sales.

LKR 10,000/=

Public Speaking and Presentation Skills are essential for personal and professional growth. Being able to speak confidently in front of an audience and present ideas clearly can open doors to many opportunities.

We offer a Public Speaking & Presentation Skills Course designed for flexible self-learning, focusing on practical techniques you can use immediately:

Overcome fear and build confidence
Structure and deliver effective presentations
Engage your audience with clarity and impact

Anyone who wants to improve their speaking and presentation skills can join.

Message us to get more details or enroll.
070-1293025

Planning to start a business in Sri Lanka but don’t know where to begin? Starting a business requires the right guidance on registration, documentation, banking, and tax requirements.

We offer Entrepreneurship Guidance Sessions designed to help you understand the practical steps to start a business in Sri Lanka.

How to start and register a business in Sri Lanka
Required documents and procedures
Bank account requirements for businesses
Basic IRD tax registration and calculations
Common challenges entrepreneurs face and how to overcome them

These sessions are ideal for anyone planning to start a business or exploring entrepreneurship.

Message us for more details or to book a session.
070-1293025

Interested in investing in Sri Lanka but not sure where to start? Understanding the right investment options and processes is important before making financial decisions.

We offer a Practical Guide to Investing in Sri Lanka, designed to help you understand the basic investment landscape and opportunities available.

Introduction to investment options in Sri Lanka
Basic understanding of the stock market and other investment avenues
How to start investing step by step
Understanding risks and smart investment decisions
Practical insights for beginners

Anyone interested in learning about investing and financial growth is welcome to join.

Message us for more details or to enroll.
070-1293025

Want to speak Korean confidently but don’t have anyone to practice with?
Start speaking from Day 1 with guided conversations!

Assessment before starting to check your Korean speaking level
Students are placed into levels and lessons are conducted level-wise
After completing one level, you can move to the next level

Class Details:

Rs. 800 per 30-minute session
One-to-one conversation with a professional trainer

Learning Method:

Lesson slides (vocabulary, phrases & basic grammar) shared via Google Drive
(LMS access will be provided later)
Use lesson content in real conversations
Clear your doubts directly with the trainer during class

100% Flexible

Classes conducted daily
Book your preferred days & times
Pay in installments as comfortable
No fixed duration – stop anytime

Perfect for:

Beginners & Intermediate learners
K-Drama & K-Pop lovers
Job seekers planning to work in Korea

Message us to book your FREE Assessment
070-1293925

Assessment before starting to check your speaking level
Students are placed into levels and lessons are done level-wise
After completing one level, you can move to the next level

Class Details:

Rs. 600 per 30-minute session
One-to-one conversation with a trainer

Learning Method:

Lesson slides (vocabulary, phrases & grammar) shared via Google Drive
Use lessons in conversation classes
Grammar and usage doubts can be cleared with the trainer during class

100% Flexible

Classes conducted daily
You can book preferred days & times
Pay in installments as you are comfortable
No fixed duration – stop anytime

Student-friendly • Fair • Result-focused

Message us to book your assessment session and get started!
070-1293025

Duration: 15 hours of hands-on training

The course covers everything from design fundamentals and Canva tools to advanced features such as brand kits, image editing, social media content creation, and document design. Learners will gain real-world experience by working on practical projects including CVs, presentations, and marketing materials.

By the end of the course, participants will be confident in using Canva Pro to design visually appealing, well-structured, and professional graphics for multiple purposes.

Modules

Module 1: Introduction to Canva & Design Fundamentals
Module 2: Templates, Layouts & Design Structure
Module 3: Text, Fonts & Brand Identity
Module 4: Images, Elements & Pro Media Tools
Module 5: CV / Resume & Cover Letter Design
Module 6: Social Media, Presentations & Exporting

Contact us for more information and application:
070 129 3025

Price: LKR 10,000

Apply Now

Duration: 2 months

Contact us for more information and application:
070 129 3025

Price: LKR 10,000

Apply Now

AptFil offers Sri Lanka’s most focused and practice-oriented certification in Executive Communication, designed specifically for professionals seeking to enhance their business communication, presentation, and public speaking skills.

Duration: 02 Months
Sessions: 2–4 hours per module
Delivery Mode: Online

Modules

Module 1: Effective Communication Skills Development (2 hrs)
Module 2: Public Speaking Mastery (4 hrs)
Module 3: Business Presentation Excellence (4 hrs)
Module 4: Data Storytelling for Leaders (4 hrs)
Module 5: Advanced Negotiation Techniques (4 hrs)
Module 6: AI-Powered Executive Presentations (4 hrs)
Module 7: Nonverbal Cues in Dynamic Presentations (4 hrs)

Contact us for more information and application:
070 129 3025

Price: LKR 10,000

Apply Now

Startup Launchpad Program
Small Business Finance Bootcamp
Sales & Negotiation Mastery
Entrepreneurship with AI & Tech

Duration: 3 months

Contact us for more information and application:
070 129 3025

Price: LKR 15,000

Apply Now

This enhanced program equips entry-level professionals with advanced Artificial Intelligence literacy, practical execution capability, critical thinking, and professional identity development. The program extends learning depth through expanded modules and increased learning hours to ensure meaningful skill mastery.

Duration: 3 Months | 12 Sessions | 48 Learning Hours
Days: Sunday
Time: 6.00 – 10.00 PM
Mode: Online (Zoom)

Modules

Module 1: AI Foundations & Future of Work
Module 2: AI Systems & How Models Think
Module 3: AI Tools Ecosystem & Setup
Module 4: Prompt Engineering Fundamentals
Module 5: Advanced Prompt Engineering & Context Design
Module 6: AI Content Creation Systems
Module 7: AI Creative Production & Visual Communication
Module 8: AI Research & Insight Generation
Module 9: AI Decision Intelligence
Module 10: AI Personalization & Customer Experience
Module 11: AI Automation & Productivity Systems
Module 12: Ethics, Governance & Professional AI Identity (Capstone)

Installments :
Registration Fee: 6000/=
End of first month : 6000/=
End of second month : 6000/=

Certification upon completion of:
Weekly practical submissions (40%)
Participation and activities (20%)
Capstone project (40%)

Attendance: Minimum 70% attendance required. If you are unable to attend a session, special permission must be obtained. You may watch the recordings and complete the required assessments to receive the certificate

Contact us for more information and application:
070 129 3025

Price: LKR 18,000

Apply Now

Canva
AI tools
Video editing
And much more…

Contact us for more information and application:
070 129 3025

Price: LKR 8,000

Apply Now

Contact us for more information and application:
070 129 3025

Apply Now

AptFil offers one of Sri Lanka’s most comprehensive executive certifications in Full Cycle Recruitment, designed for individuals entering or growing within the private-sector talent acquisition field.

Delivery Mode: Online
Learning Platform: Self-Learn Recruitment
Trainer Support: Available on request (1,000/= per hour)

This course is ideal for:

Beginners who want to build a strong foundation in recruitment
Students preparing for HR or talent acquisition roles
Fresh graduates seeking practical, job-ready skills
HR interns or junior HR staff wanting to upskill
Freelance or part-time recruiters
Entrepreneurs or small business owners who hire on their own

Modules

Foundation
Sourcing & Attraction
Screening & Pre-Interview
Communication & Coordination
Hiring & Offer
Onboarding & Integration

Contact us for more information and application:
070 129 3025

Price: LKR 10,000

Apply Now

This program is designed to equip you with the knowledge, skills, and certification to become a successful study abroad consultant. Whether you’re new to the field or looking to build a career in education consultancy, this training will prepare you to guide students in university selection, applications, and visa processing.

Who can apply:

Fresh graduates
Professionals
Individuals passionate about guiding students

Contact us for more information and application:
070 129 3025

Price: LKR 10,000

Apply Now

Assessment before starting to check your speaking level
Students are placed into levels and lessons are done level-wise
After completing one level, you can move to the next level
CAN CUSTOMIZE LESSONS BASED ON YOUR REQUIREMENT

Class Details:

Rs. 600 per 30-minute session
One-to-one conversation with a trainer

Learning Method:

Lesson slides (vocabulary, phrases & grammar) shared via Google Drive
Use lessons in conversation classes
Grammar doubts can be cleared with the trainer during class

100% Flexible

Classes conducted daily
You can book preferred days & times
Pay in installments as you are comfortable
No fixed duration – stop anytime

Student-friendly • Fair • Result-focused

If you want someone to talk with and practice, our trainers are here to help.

Message us to book your FREE assessment session and get started!
070-1293025

Personal Branding is a powerful skill for career growth and professional success. It helps you stand out, showcase your strengths, and create a strong professional presence online and offline.

We offer a Personal Branding Course designed for flexible self-learning, helping you build your brand step by step:

Learn how to present yourself effectively
Create a strong online presence
Develop career-boosting strategies

Anyone who wants to improve their personal brand and visibility can join.

Message us to get more details or enroll.
070-1293025

HAVING TROUBLE WITH AUDITS?

Do you lack knowledge in Labour Laws, health and safety regulations? Break into high-demand roles with expert training.

2 months only!

Online Sessions
Conducted by 10+ Year Industry Experts
Installments Available

IDEAL FOR

Compliance Officers
Executives
Trainers
Safety Officers
HR Assistant
HR Executives
HRMs
Factory owners/MD
GM
Production Managers
Supervisors

Stand out from 1,000+ HR professionals. Secure your spot to become a skilled and certified SMETA 7.0 professional.

Contact us for more information and application:
070 129 3025

Price: LKR 10,000

Apply Now

AptFil provides one of Sri Lanka’s most comprehensive Payroll Management Training Certificate Course (Basic) tailored for professionals in the private sector.

Available in English & Sinhala

This certification provides a comprehensive understanding of payroll management, covering legal compliance, payroll processing, software tools, reporting, and ethics specific to Sri Lanka.

READY TO STEP INTO PAYROLL WITH CONFIDENCE?

Duration: 03 Months
Sessions: 3hrs per week
Delivery Mode: Online

You’re in HR but lack payroll experience?

Modules

Module 1: Role of Payroll in Sri Lanka (3 hrs)
Module 2: Understanding Pay Structures(3 hrs)
Module 3: Sri Lankan Labor Law Basics(6 hrs)
Module 4: Statutory Deductions(6 hrs)
Module 5: Payroll Operations(3 hrs)
Module 6: Payroll Software & Tools(3 hrs)
Module 7: Payroll Compliance & Filing(3 hrs)
Module 8: Payroll Ethics & Data Security(3 hrs)
Module 9: Assessment & Certification

Final Assignment: End-of-month report + mock EPF/ ETF file submission

Break into high-demand roles with expert training. Learn the full payroll process.

Contact us for more information and application:
070 129 3025

Price: LKR 16,800

Apply Now

user 545153

About Candidate

Location

Be the first to review “user 545153”

Call us

+94 775 387 948

+94 70 129 3025

About Us

For Candidates

For Employers

Group Training: 15,000/=

Installments:

Individual Training: 25,000/=

Group Training: 12,500/= (2 Students)

Group Training: 10,000/= (3+ Students)

LKR 5,000/=

LKR 5,000/= (6 Hours Training)

LKR 5,000/=

LKR 10,000/=

Modules

Price: LKR 10,000

Price: LKR 10,000

Modules

Price: LKR 10,000

Price: LKR 15,000

Modules

Price: LKR 18,000

Price: LKR 8,000

Modules

Price: LKR 10,000

Price: LKR 10,000

Price: LKR 10,000

Modules

Final Assignment: End-of-month report + mock EPF/ ETF file submission

Price: LKR 16,800

user 545153

About Candidate

Share this post

Location

Be the first to review “user 545153”

Call us

+94 775 387 948 +94 70 129 3025

About Us

For Candidates

For Employers

+94 775 387 948

+94 70 129 3025