3 Day Excel Workshop

• 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