Program Overview

This intensive workshop equips participants with the knowledge, skills, and practical experience required to master Advanced Excel. Participants explore essential functions, formulas, and data analysis tools, learn best practices for data management and visualization, and gain hands-on experience to streamline workflows, enhance productivity, and support data-driven decision-making.

Who this is for

Business Professionals
Finance and Accounting Staff
Data Analysts
Researchers
Project Managers
Administrative and Operations Staff
University Students and Graduates
Entrepreneurs and Small Business Owners
Individuals with basic Excel knowledge

How to apply

workshops@iit.ac.lk

Apply View Fees

Next / Start

2026-03-16

Time

Sat & Sun, 9:00 AM – 3:00 PM

Excel Introduction – Overview, interface, and navigation

Customizing Excel – Personalizing the workspace for efficiency

Using Basic Functions – SUM, AVERAGE, COUNT, etc.

Formatting and Proofing – Styles, conditional formatting, spell-check

Mathematical Functions – ROUND, INT, SUMPRODUCT, etc.

Text Functions – CONCAT, LEFT, RIGHT, MID, LEN, TRIM, etc.

Date and Time Functions – TODAY, NOW, DATE, TIME, NETWORKDAYS, etc.

Advanced Paste Special Techniques – Values, formulas, formatting, transpose

Sorting and Filtering – Custom sorts, auto-filter, advanced filter

Logical Functions – IF, AND, OR, NOT, nested logic

Data Validation – Restrict input, dropdown lists, error messages

Lookup Functions – VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP

Pivot Tables – Creating, customizing, and analyzing data

Charts and Slicers – Column, bar, line, pie charts, interactive slicers

Excel Dashboard – Designing dashboards for reporting and analysis

Introduction to VBA – Macros, automation fundamentals

Message Box and Input Box Functions – Interactive user prompts

IF and SELECT CASE Statements – Decision-making in VBA

Looping in VBA – For, For Each, Do While loops

Who this is for

Business Professionals
Finance and Accounting Staff
Data Analysts
Researchers
Project Managers
Administrative and Operations Staff
University Students and Graduates
Entrepreneurs and Small Business Owners
Individuals with basic Excel knowledge

How to apply

workshops@iit.ac.lk

Apply View Fees

Next / Start

2026-03-16

Time

Sat & Sun, 9:00 AM – 3:00 PM

Program Overview

Who this is for

Business Professionals
Finance and Accounting Staff
Data Analysts
Researchers
Project Managers
Administrative and Operations Staff
University Students and Graduates
Entrepreneurs and Small Business Owners
Individuals with basic Excel knowledge

How to apply

workshops@iit.ac.lk

+94 71 333 4455

Apply View Fees

Next Start

2026-03-16

Time

Sat & Sun, 9:00 AM – 3:00 PM

Excel Introduction – Overview, interface, and navigation

Customizing Excel – Personalizing the workspace for efficiency

Using Basic Functions – SUM, AVERAGE, COUNT, etc.

Formatting and Proofing – Styles, conditional formatting, spell-check

Mathematical Functions – ROUND, INT, SUMPRODUCT, etc.

Text Functions – CONCAT, LEFT, RIGHT, MID, LEN, TRIM, etc.

Date and Time Functions – TODAY, NOW, DATE, TIME, NETWORKDAYS, etc.

Advanced Paste Special Techniques – Values, formulas, formatting, transpose

Sorting and Filtering – Custom sorts, auto-filter, advanced filter

Logical Functions – IF, AND, OR, NOT, nested logic

Data Validation – Restrict input, dropdown lists, error messages

Lookup Functions – VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP

Pivot Tables – Creating, customizing, and analyzing data

Charts and Slicers – Column, bar, line, pie charts, interactive slicers

Excel Dashboard – Designing dashboards for reporting and analysis

Introduction to VBA – Macros, automation fundamentals

Message Box and Input Box Functions – Interactive user prompts

IF and SELECT CASE Statements – Decision-making in VBA

Looping in VBA – For, For Each, Do While loops

Who this is for

Business Professionals
Finance and Accounting Staff
Data Analysts
Researchers
Project Managers
Administrative and Operations Staff
University Students and Graduates
Entrepreneurs and Small Business Owners
Individuals with basic Excel knowledge

How to apply

workshops@iit.ac.lk

+94 71 333 4455

Apply View Fees

Next Start

2026-03-16

Time

Sat & Sun, 9:00 AM – 3:00 PM

Advanced Excel Workshop

Who this is for

Excel Introduction – Overview, interface, and navigation

Customizing Excel – Personalizing the workspace for efficiency

Using Basic Functions – SUM, AVERAGE, COUNT, etc.

Formatting and Proofing – Styles, conditional formatting, spell-check

Mathematical Functions – ROUND, INT, SUMPRODUCT, etc.

Text Functions – CONCAT, LEFT, RIGHT, MID, LEN, TRIM, etc.

Date and Time Functions – TODAY, NOW, DATE, TIME, NETWORKDAYS, etc.

Advanced Paste Special Techniques – Values, formulas, formatting, transpose

Sorting and Filtering – Custom sorts, auto-filter, advanced filter

Logical Functions – IF, AND, OR, NOT, nested logic

Data Validation – Restrict input, dropdown lists, error messages

Lookup Functions – VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP

Pivot Tables – Creating, customizing, and analyzing data

Charts and Slicers – Column, bar, line, pie charts, interactive slicers

Excel Dashboard – Designing dashboards for reporting and analysis

Introduction to VBA – Macros, automation fundamentals

Message Box and Input Box Functions – Interactive user prompts

IF and SELECT CASE Statements – Decision-making in VBA

Looping in VBA – For, For Each, Do While loops

—

Who this is for

Who this is for

Excel Introduction – Overview, interface, and navigation

Customizing Excel – Personalizing the workspace for efficiency

Using Basic Functions – SUM, AVERAGE, COUNT, etc.

Formatting and Proofing – Styles, conditional formatting, spell-check

Mathematical Functions – ROUND, INT, SUMPRODUCT, etc.

Text Functions – CONCAT, LEFT, RIGHT, MID, LEN, TRIM, etc.

Date and Time Functions – TODAY, NOW, DATE, TIME, NETWORKDAYS, etc.

Advanced Paste Special Techniques – Values, formulas, formatting, transpose

Sorting and Filtering – Custom sorts, auto-filter, advanced filter

Logical Functions – IF, AND, OR, NOT, nested logic

Data Validation – Restrict input, dropdown lists, error messages

Lookup Functions – VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP

Pivot Tables – Creating, customizing, and analyzing data

Charts and Slicers – Column, bar, line, pie charts, interactive slicers

Excel Dashboard – Designing dashboards for reporting and analysis

Introduction to VBA – Macros, automation fundamentals

Message Box and Input Box Functions – Interactive user prompts

IF and SELECT CASE Statements – Decision-making in VBA

Looping in VBA – For, For Each, Do While loops

—

Who this is for

Built for modern careers.

What learners say.

Program Gallery.

Apply to this Program

Personal Info

Course Interest

Frequently Asked Questions

IT Programs

Business Management

Cambridge English

Corporate Training

Workshops