Enroll Today and Catapult Your Online Success!
Ready to rise above the digital noise? Enroll now and let’s embark on a journey where you not only learn the intricacies of SEO but also master the art of online visibility and organic traffic generation.
IIT Professional Training Unit is established to offer innovative learning solutions in the fields of Business and Information Technology to enable individuals and organizations to face tomorrow’s challenges with confidence.
Navigate and customize Excel to create a personalized and efficient workspace.
Apply basic and advanced functions to perform complex calculations and automate routine tasks.
Utilize mathematical, text, and date/time functions for accurate and efficient data processing.
Format and proof spreadsheets to ensure clarity, consistency, and professionalism.
Use advanced Paste Special techniques to streamline data handling and manipulation.
Sort and filter data effectively for better data organization and analysis.
Implement logical and lookup functions (e.g., IF, VLOOKUP, HLOOKUP, INDEX & MATCH) to enhance data accuracy and relevance.
Set up data validation rules to control user input and maintain data integrity.
Create dynamic Pivot Tables and Pivot Charts to summarize, analyze, and visualize data insights.
Design professional dashboards using charts, slicers, and formatting tools for impactful reporting.
Gain a foundational understanding of Excel VBA, enabling automation of tasks through macros.
Develop interactive message and input boxes to enhance user interaction.
Apply control structures such as IF, SELECT CASE, and looping techniques within VBA for custom workflows.
Business Professionals
Finance and Accounting Staff
Data Analysts
Researchers
Project Managers
Administrative Staff
Operations Personnel
University Students and Graduates
Entrepreneurs and Small Business Owners
Individuals with Basic Excel Knowledge
Option 1: Instructor-led In classroom training
Option 2: Distance learning facility
For further details, please contact
IIT Professional Development Unit
077 056 6577 | pdu@iit.ac.lk
Navigate and customize Excel to create a personalized and efficient workspace.
Apply basic and advanced functions to perform complex calculations and automate routine tasks.
Utilize mathematical, text, and date/time functions for accurate and efficient data processing.
Format and proof spreadsheets to ensure clarity, consistency, and professionalism.
Use advanced Paste Special techniques to streamline data handling and manipulation.
Sort and filter data effectively for better data organization and analysis.
Implement logical and lookup functions (e.g., IF, VLOOKUP, HLOOKUP, INDEX & MATCH) to enhance data accuracy and relevance.
Set up data validation rules to control user input and maintain data integrity.
Create dynamic Pivot Tables and Pivot Charts to summarize, analyze, and visualize data insights.
Design professional dashboards using charts, slicers, and formatting tools for impactful reporting.
Gain a foundational understanding of Excel VBA, enabling automation of tasks through macros.
Develop interactive message and input boxes to enhance user interaction.
Apply control structures such as IF, SELECT CASE, and looping techniques within VBA for custom workflows.
Business Professionals
Finance and Accounting Staff
Data Analysts
Researchers
Project Managers
Administrative Staff
Operations Personnel
University Students and Graduates
Entrepreneurs and Small Business Owners
Individuals with Basic Excel Knowledge
Option 1: Instructor-led In classroom training
Option 2: Distance learning facility
For further details, please contact
IIT Professional Development Unit
077 056 6577 | pdu@iit.ac.lk
Share Now
