Aptfil
  • Home
  • About Us
  • Browse Jobs
  • Courses
  • Resume
  • Shop
  • Blog
  • Contact
Post Job

Call us

+94 775 387 948

+94 70 129 3025

374, Dellanga, Gelioya
Kandy 20620
info@aptfil.com
Aptfil
  • Home
  • About
  • Browse Jobs
  • Courses
  • Resume
  • Shop
  • Blog
  • Contact
Login / Register
Job Post

Data Analysis and Financial Modeling

  1. Home
  2. Candidates
  3. Accounting and FinanceFinancial Accounting
  4. Data Analysis and Financial Modeling
Show Sidebar
Close
Showing the single result
Udeshika Silva

Udeshika Silva

Accounting and Finance, Data Analysis and Financial Modeling, Financial Accounting, SAP
Kandy
Shortlist View Profile

Call us

+94 775 387 948

+94 70 129 3025

374, Dellanga, Gelioya,
Kandy
20620
info@aptfil.com

About Us

  • Home
  • About Us
  • Shop
  • Blog
  • Terms & Conditions
  • Contact Us

For Candidates

  • Browse Jobs
  • Candidate Dashboard
  • Job Alerts
  • My Bookmarks

For Employers

  • All Employers
  • Employer Dashboard
  • Job Packages
  • Submit Job

© 2024 Aptfil Recruitment & Consultants. All Right Reserved.

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